| Name | R_Depositional_Environ |
|---|---|
| Entity Type | Table |
| Description | A reference table that stores valid environment of deposition classes. Depositional environments are specific for siliciclastic and carbonate rocks. Various classes also include subdivisions. Examples are, marine, slope, tidal flat, and marsh. |
| Submodel | Reference |
| 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) |
| Parent | R_Depositional_Environ |
|
Reference to the class of parent depositional environment | No |
VARCHAR2(64) |
| Remarks | REMARKS_STR | NA |
Remarks | No |
VARCHAR2(999) |
| 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) |
| 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 |
|---|---|---|---|---|
| Geologic_Facies | Environment_Of_Deposition | The depositional environment that controlled the formation of strata in this facies. | Restrict | No |
| Lithology | Depositional_Environment | A value that represents the environment of deposition of the rock sample. | Restrict | No |
| R_Depositional_Environ | Parent | Reference to the class of parent depositional environment | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Parent | R_Depositional_Environ | Reference to the class of parent depositional environment | Restrict | No |