Vocabularies — details

BH_GEOLOGY_COMMENT

A table within the BOREHOLE GEOLOGY databank that holds the approved comments for attaching to logs in BOREHOLE_GEOLOGY table.

No. Column name Data type Notes
1 COMMENT_CODE Varchar(6) Primary key
2 BOREHOLE_GEOLOGY_COMMENTS Varchar(2000)  
3 DATE_ENTERED Date  
4 CODE_TRANSFER Char(1)  
5 CODE_STATUS Char(1)  
6 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 13)

COMMENT_CODE BOREHOLE_GEOLOGY_COMMENTS DATE_ENTERED CODE_TRANSFER CODE_STATUS DATE_UPDATED
Poor core recovery  22-NOV-99     
Highly fractured core  22-NOV-99     
Hand specimen collected  22-NOV-99     
Fossil collected  22-NOV-99     
Obstruction terminated borehole  22-NOV-99     
Borehole diverted  22-NOV-99     
Caved material in borehole  22-NOV-99     
Loss of drilling fluid  22-NOV-99     
End of cased section  22-NOV-99     
10  Fault zone  22-NOV-99