DIC_PROPERTY_TYPE
Dictionary which provides constraints on the property table, eg. grain shape, grain size, chronostratigraphy.
No. |
Column name |
Data type |
Notes |
1 |
PROPERTY_TYPE |
Varchar(15) |
Primary key
|
2 |
PROPERTY_DESCRIPTION |
Varchar(78) |
|
3 |
DATE_ENTERED |
Date |
|
4 |
CODE_STATUS |
Char(1) |
|
5 |
DATE_UPDATED |
Date |
|
6 |
CODE_TRANSFER |
Char(1) |
|
7 |
DICTIONARY_MAPPING |
Varchar(30) |
|
Sample data (rows 1 to 20 of 242)
PROPERTY_TYPE |
PROPERTY_DESCRIPTION |
DATE_ENTERED |
CODE_STATUS |
DATE_UPDATED |
CODE_TRANSFER |
DICTIONARY_MAPPING |
FOSS_ABUND_31 |
LITH 3 ABUNDANCE OF BODY FOSSIL 1 |
16-JAN-03 |
C |
05-JUN-03 |
|
BGS.DIC_ABUNDANCE |
FOSS_ABUND_32 |
LITH 3 ABUNDANCE OF BODY FOSSIL 2 |
16-JAN-03 |
C |
05-JUN-03 |
|
BGS.DIC_ABUNDANCE |
FOSSIL_31 |
LITH 3 BODY FOSSIL 1 |
16-JAN-03 |
C |
31-JUL-03 |
|
BGS.DIC_PAL_TAXON |
FOSSIL_33 |
LITH 3 BODY FOSSIL 3 |
16-JAN-03 |
C |
31-JUL-03 |
|
BGS.DIC_PAL_TAXON |
FOSSIL_42 |
LITH 4 BODY FOSSIL 2 |
16-JAN-03 |
C |
31-JUL-03 |
|
BGS.DIC_PAL_TAXON |
FOSSIL_43 |
LITH 4 BODY FOSSIL 3 |
16-JAN-03 |
C |
31-JUL-03 |
|
BGS.DIC_PAL_TAXON |
FOSS_ABUND_01 |
UNIT ABUNDANCE OF BODY FOSSIL 1 |
16-JAN-03 |
C |
05-JUN-03 |
|
BGS.DIC_ABUNDANCE |
FOSS_ABUND_03 |
UNIT ABUNDANCE OF BODY FOSSIL 3 |
16-JAN-03 |
C |
05-JUN-03 |
|
BGS.DIC_ABUNDANCE |
FOSS_ABUND_11 |
LITH 1 ABUNDANCE OF BODY FOSSIL 1 |
16-JAN-03 |
C |
05-JUN-03 |
|
BGS.DIC_ABUNDANCE |
FOSS_ABUND_13 |
LITH 1 ABUNDANCE OF BODY FOSSIL 3 |
16-JAN-03 |
C |
05-JUN-03 |
|
BGS.DIC_ABUNDANCE |
FOSS_ABUND_21 |
LITH 2 ABUNDANCE OF BODY FOSSIL 1 |
16-JAN-03 |
C |
05-JUN-03 |
|
BGS.DIC_ABUNDANCE |
FOSS_ABUND_22 |
LITH 2 ABUNDANCE OF BODY FOSSIL 2 |
16-JAN-03 |
C |
05-JUN-03 |
|
BGS.DIC_ABUNDANCE |
GRSHPE |
GRAIN SHAPE |
21-SEP-98 |
O |
|
I |
|
GRSIZE |
GRAIN SIZE |
21-SEP-98 |
O |
|
I |
|
GRTRND |
GRAIN TREND |
21-SEP-98 |
O |
|
I |
|
S_STRT |
SEDIMENTARY STRUCTURES |
21-SEP-98 |
O |
|
I |
|
SORT |
UNIT SORTING |
21-SEP-98 |
C |
31-JUL-03 |
I |
BGS.DIC_GRAIN_SORT |
VEIN_F |
VEIN FORM |
21-SEP-98 |
O |
|
I |
|
M_WORK |
MINERAL WORKINGS ENCOUNTERED |
21-SEP-98 |
C |
|
I |
BGS.DIC_WOBE |
WTR_ST |
WATER STRUCK |
21-SEP-98 |
C |
|
I |
BGS.DIC_WSTK |