| Name | R_Lithology |
|---|---|
| Entity Type | Table |
| Description | A reference table that stores valid lithology types. Lithology types describe the classification of rocks on the basis of key characteristics, generally including mineralogical composition and grain size. |
| Submodel | Reference |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain / Measurement | 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) |
| Classification | ROCK_CLASS NA |
The basis or organizing principle for the rock classification scheme. Some examples include, Chemical, Volcaniclastic, and Siliciclastic. | No |
VARCHAR2(32) |
| 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) |
| Genesis | ROCK_GENESIS NA |
The origin or rock formation process for this lithology. Examples are; Sedimentary, Igneous or Metamorphic. | No |
VARCHAR2(32) |
| Name | CODE NA |
The spelled-out name of the reference value. | 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) |
| Subclassification | ROCK_SUBCLASS NA |
A refinement of the rock classification scheme into a specific area or domain. Some examples include, Carbonate, Evaporite, and Silicate. | No |
VARCHAR2(32) |
| 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 |
|---|---|---|---|---|
| Borehole_Zone | Primary_Lithology | A value that represents the predominant lithology of the borehole zone. Examples include Sandstone, Shale, Limestone. | Restrict | No |
| Geologic_Layer | Primary_Lithology | The primary lithology that defines this Geologic Layer. An example is Chalk for the Austin Chalk Formation. | Restrict | No |
| Lithology | Lithology_Type | A value that represents the predominant lithology of the sample. Examples include Sandstone, Shale, Limestone. | Restrict | Yes |