DIC_ROCK_ALL_SOURCE
Dictionary for the source tables of entries in version 3 of the BGS Rock Classification Scheme
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(6) |
Primary key
|
2 |
DESCRIPTION |
Varchar(500) |
|
3 |
TRANSLATION |
Varchar(80) |
|
4 |
STATUS |
Char(1) |
|
5 |
USER_ENTERED |
Varchar(10) |
|
6 |
DATE_ENTERED |
Date |
|
7 |
USER_UPDATED |
Varchar(10) |
|
8 |
DATE_UPDATED |
Date |
|
9 |
TRANSFER |
Char(1) |
|
Sample data (rows 1 to 3 of 3)
CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
USER_ENTERED |
DATE_ENTERED |
USER_UPDATED |
DATE_UPDATED |
TRANSFER |
RC |
Rock Composite - The name refers to a mixture of more than one rock or sediment type. |
Rock Composite |
C |
PSG |
06-JAN-04 |
TMCM |
14-MAR-19 |
|
RD |
Rock Dummy - The name is a 'dummy' term, several of which have been created for pragmatic reasons. |
Rock Dummy |
C |
PSG |
06-JAN-04 |
TMCM |
14-MAR-19 |
|
RN |
Rock Name - The name refers to a single rock or sediment type. |
Rock Name |
C |
KAH |
22-DEC-03 |
TMCM |
14-MAR-19 |
|