DIC_GEOCHRON_SCHEME
Dictionary to constrain geochronological schemes used in GEOCHRON_JOIN. E.g. BGS approved geochronology; British onshore Quaternary chronostratigraphy; British offshore Quaternary chronostratigraphy.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(10) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(150) |
|
| 3 |
STATUS |
Char(1) |
|
| 4 |
TRANSLATION |
Varchar(150) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 7 of 7)
| CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
DATE_ENTERED |
DATE_UPDATED |
| BGS |
BGS APPROVED GEOCHRONOLOGY. SEE BGS GEOLOGICAL TIMECHART. |
C |
BGS Approved Geochronology |
18-FEB-04 |
|
| Q_ON |
BRITISH ONSHORE QUATERNARY CHRONOSTRATIGRAPHY |
C |
British Onshore Quaternary Chronostratigraphy |
18-FEB-04 |
|
| Q_OFF |
BRITISH OFFSHORE QUATERNARY CHRONOSTRATIGRAPHY |
C |
British Offshore Quaternary Chronostratigraphy |
18-FEB-04 |
|
| BGS_OLD |
OBSOLETE GEOCHRONOLOGY CODES |
C |
Obsolete Geochronology Codes |
18-FEB-04 |
|
| * |
NOT APPLICABLE |
C |
Not Applicable |
18-FEB-04 |
|
| ! |
NOT AVAILABLE |
C |
Not Available |
18-FEB-04 |
|
| ? |
NOT ENTERED |
C |
Not Entered |
18-FEB-04 |
|
