Vocabularies — details

DIC_MGT

Dictionary table used to constrain the values entered into the DATA_MANAGEMENT field in the new BGS.BOREHOLE table.

No. Column name Data type Notes
1 CODE Char(1) Primary key
2 DESCRIPTION Varchar(68)  
3 TRANSLATION Varchar(50)  
4 STATUS Char(1)  
5 DATE_ENTERED Date  
6 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 25)

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
LAND SURVEY (NORTH) PDA_BINDEX DATABASE    02-FEB-98   
LAND SURVEY (SOUTH) PDB_BINDEX DATABASE    02-FEB-98   
KEYWORTH NGDC_BORES DATABASE    02-FEB-98   
DIGITISING TABLES    02-FEB-98   
(E)X_FORM CODING FORM    02-FEB-98   
NON-SPECIFIC FORM    02-FEB-98   
GSM_REGISTER CODING FORM    02-FEB-98   
MARINE GEOLOGY INDEX    02-FEB-98   
INDEX CODING FORM    02-FEB-98   
LEEDS PROJECT    02-FEB-98