Vocabularies — details

DIC_BMD_COLLECTION_DIC

dictionary of BGS collections housed in the Keyworth tray Store in ndgc building

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


Sample data (rows 1 to 6 of 6)

CODE DESCRIPTION STATUS TRANSLATION DATE_ENTERED DATE_UPDATED
BORE  REGISTERED BOREHOLE SPECIMEN    29-JUL-03  20-MAR-06 
BPBO  borehole specimen or Paleo specimen or both.    29-JUL-03  05-FEB-04 
CUTT  registered cutting    29-JUL-03   
PAL  Paleo sample    29-JUL-03   
PET  Petrology collection    22-OCT-04   
RGSP  REGISTERED BOREHOLE SPECIMEN    22-MAR-06  20-MAR-06