Vocabularies — details

DIC_PROPERTY_TYPE

Provides constraints on the property table.

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 10 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