BH_GEOLOGY_COMMENT
A dictionary table within the BOREHOLE GEOLOGY database 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 13 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 |
|
|
| 11 |
Boundary based on geophysical interpretation |
22-NOV-99 |
I |
|
|
| 12 |
Interpretation of colloquial drillers term; e.g. CLUNCH |
22-NOV-99 |
I |
|
|
| 13 |
Open hole drilling; data from electric log |
03-MAY-01 |
I |
|
|
