| Name | R_Strat_Surface |
|---|---|
| Entity Type | Table |
| Description | Reference entity that contains the valid stratigraphic boundary classifications. For unconformity surfaces, examples include Angular Unconformity, Diastem, Disconformity and Nonconformity. For conformable surfaces, examples include Chronostrat Contact, Lithostrat Contact, Biostrat Contact, and Facies Contact. |
| Submodel | Geology |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Active_Flag | boolean | NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes 1 |
NUMBER(1) |
| Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | Yes |
VARCHAR2(64) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| 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) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Source | CODE | NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |
| Surface_Character | CODE | NA |
A classification that contains two valid surface categories. Unconformities categorize boundaries with a substantial nonstructural break or gap in deposition while conformities characterize surfaces with continuous deposition. | No |
VARCHAR2(64) |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Lithology_Sed_Structures | Strat_Surface_Type | The boundary type e.g. unconformable. | Restrict | No |
| Stratigraphic_Surface | Strat_Surface_Type | The classification system for this stratigraphic surface. For example, Bio, Chrono, Facies and Litho. | Restrict | No |