| Name | R_Geochronology |
|---|---|
| Entity Type | Table |
| Description | Reference entity that names a span of continuous time in geologic history. A geochronologic unit refers to the time. A chronostratigraphic unit refers to rock. They may have the same name For example, the Cretaceous Period (Geochronology) is the time unit for the deposition of rocks of the Cretaceous System (Chronostratigraphy). |
| 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) |
| End_Time | double | Geologic_Time Ma |
The age of the end of this geologic time in millions of years ago. | No |
NUMBER |
| 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) |
| Interval_Type | CODE | NA |
The position in the unit of measure hierarchy for geochronology. An Age belongs to an Epoch which belongs to a Period and in turn an Era. | No |
VARCHAR2(64) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Parent_Unit | R_Geochronology |
|
The geologic time interval that contains this shorter time interval. | No |
VARCHAR2(64) |
| 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) |
| Start_Time | double | Geologic_Time Ma |
The age of the beginning of this geologic time in millions of years ago. | No |
NUMBER |
| 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 |
|---|---|---|---|---|
| Generic_Geol_Feature_Time | Geochronologic_Time | A geologic time interval for the primary event related to the formation of this generic geologic feature. | Restrict | Yes |
| Geologic_Layer_Time | Geochronologic_Time | A geologic time interval for the primary event related to the deposition of this geologic layer. | Restrict | Yes |
| Geologic_Surface_Time | Geochronologic_Time | A geologic time interval for the primary event related to the formation of this geologic surface. | Restrict | Yes |
| R_Geochronology | Parent_Unit | The geologic time interval that contains this shorter time interval. | Restrict | No |
| Rock_Fluid_Feature_Time | Geochronologic_Time | A geologic time interval for the primary event related to the formation of this Rock Fluid Feature. | Restrict | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Parent_Unit | R_Geochronology | The geologic time interval that contains this shorter time interval. | Restrict | No |