| Name | Fault_Boundary_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. A feature associated with the boundary, a horizon that intersects a fault. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Domain_Property | CODE | NA |
The property of the domain in which the boundary is defined. For example, a boundary defined in time domain property in time might be One_Way_Time or Two_Way_Time. Similarly, a boundary defined in depth might have a domain property of Measured_Depth or True_Vertical_Depth. | No |
VARCHAR2(64) |
| Fault_Name | CODE | NA |
A code for the standard or formal fault (geologic surface) name. | No |
VARCHAR2(64) |
| Horizon_Name | CODE | NA |
A code for the standard or formal horizon (geologic surface) name. | No |
VARCHAR2(64) |
| Id | ID | No_Unit |
Unique identifier for this entity. | Yes |
NUMBER(38) |
| Informal_Fault_Name | ENTITY_NAME | NA |
The name given to any object or data item, e.g. Name of Fault, etc. | No |
VARCHAR2(255) |
| Informal_Hor_Name | ENTITY_NAME | NA |
The name given to any object or data item, e.g. Name of Horizon, etc. | No |
VARCHAR2(255) |
| Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| Maximum_Throw | double | NA |
The maximum amount of vertical displacement on the fault at this fault boundary. | No |
NUMBER |
| Polygon_Id | Area |
|
READ ONLY: The polygon describing a boundary, used in cases where the boundary is closed. | No |
NUMBER(38) |
| Shape | GEOMETRY | NA |
Binary spatial representation of the polygon describing a boundary, used in cases where the boundary is closed. | No |
ST_GEOMETRY |
| Source | STRING64 | No_Unit |
Name of the person or organization responsible for this entity"s E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User. | No |
VARCHAR2(64) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Polygon | Area | READ ONLY: The polygon describing a boundary, used in cases where the boundary is closed. | Control | No |
CREATE OR REPLACE FORCE VIEW Fault_Boundary_DOV(ID, FAULT_NAME, INFORMAL_FAULT_NAME, HORIZON_NAME, INFORMAL_HOR_NAME, MAXIMUM_THROW, DOMAIN_PROPERTY, SOURCE, SHAPE, INSERT_DATE, INSERT_USER, POLYGON_ID) AS SELECT b.id Id,
f.Standard_Geologic_Surface Fault_Name,
f.name Informal_Fault_Name,
s.Standard_Geologic_Surface Horizon_Name,
s.name Informal_Hor_Name,
b.maximum_throw Maximum_Throw,
b.domain_property Domain_Property,
b.source Source,
a.shape Shape,
b.insert_date Insert_Date,
b.insert_user Insert_User,
b.polygon_id Polygon_Id
FROM Boundary b, Fault f, Stratigraphic_Surface s, Area a
WHERE b.primary_feature_id=f.id
AND b.secondary_feature_id=s.id
AND b.polygon_id=a.id (+)
AND b.existence_kind='Actual'
AND b.version='1'
|