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 |
|
