Vocabularies — details

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