| Name | Meta_View |
|---|---|
| Entity Type | External |
| Description | The definition of a database view. A view is a projection of one or more underlying database tables. Some views have logic applied to filter the rows and columns from the underlying tables. |
| Submodel | Meta |
| Entity Scope | Meta |
| Primary Key | Name , Scope_Name , Sub_Type |
| Natural Key | Name , Scope_Name , Sub_Type |
| Generalizations | Meta_Program_Text |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Name | STRING64 | NA |
The name of the program module. | Yes |
VARCHAR2(64) |
| Program_Text | CLOB | NA |
The text of the program module expressed in some programming language such as PL/SQL or TSQL. | No |
CLOB |
| Public_Flag | boolean | NA |
A flag that indicates if the object is public, i.e., a user-defined custom object (value = 1 (True)); or is defined and owned by Seabed (value = 0 (False)). The default value is 0 (False). | No 0 |
NUMBER(1) |
| Scope_Name | CODE | NA |
The name of the scope of the program module. The scope indicates the area of influence or coverage within which this entity operates. Examples of possible values for scope are: System - this entity lives at the system level, an example is a user: Data Dictionary - this entity lives at the data dictionary level, an example is a meta entity: Project - the scope of this entity is a single project - an example is a well or borehole: and Reference - this entity exists within the reference scope - an example is a well status lookup table. | Yes |
VARCHAR2(64) |
| Sub_Type | CODE | NA |
The sub type of program module. The valid values are: Trigger, View, Procedure, ObjectView, SpatialView, and Function. | Yes |
VARCHAR2(64) |