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 | DATE_ENTERED | Date | |
| 6 | DATE_UPDATED | Date |
| CODE | DESCRIPTION | TRANSLATION | STATUS | DATE_ENTERED | DATE_UPDATED |
|---|---|---|---|---|---|
| RN | Rock Name | C | 22-DEC-03 | ||
| RC | Rock Composite | C | 06-JAN-04 | ||
| RD | Rock Dummy | C | 06-JAN-04 |