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
1  Poor core recovery  22-NOV-99  I     
2  Highly fractured core  22-NOV-99  I     
3  Hand specimen collected  22-NOV-99  I     
4  Fossil collected  22-NOV-99  I     
5  Obstruction terminated borehole  22-NOV-99  I     
6  Borehole diverted  22-NOV-99  I     
7  Caved material in borehole  22-NOV-99  I     
8  Loss of drilling fluid  22-NOV-99  I     
9  End of cased section  22-NOV-99  I     
10  Fault zone  22-NOV-99  I