DIC_COLOUR_RELATIONSHIP
A dictionary describing the relationships between colours as applied to a Borehole section property list where more than one colour property is entered. Egs: Laminations, lenses etc. (Note the close similarities with Sedimentary (micro) structures).
| No. |
Column name |
Data type |
Notes |
| 1 |
COL_RELATIONSHIP_CODE |
Varchar(2) |
Primary key
|
| 2 |
COL_RELATIONSHIP_DESC |
Varchar(30) |
|
| 3 |
STATUS |
Char(1) |
|
| 4 |
DATE_ENTERED |
Date |
|
| 5 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 10 of 10)
| COL_RELATIONSHIP_CODE |
COL_RELATIONSHIP_DESC |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| MO |
MOTTLED |
C |
07-NOV-01 |
|
| LA |
LAMINATED SEQUENCE |
C |
07-NOV-01 |
|
| NO |
NODULAR |
C |
07-NOV-01 |
|
| LE |
LENTICULAR |
C |
07-NOV-01 |
|
| BA |
BANDED |
C |
07-NOV-01 |
|
| * |
NOT APPLICABLE |
C |
04-JUN-03 |
|
| ! |
NOT AVAILABLE |
C |
04-JUN-03 |
|
| ? |
NOT ENTERED |
C |
04-JUN-03 |
|
| MC |
MULTI-COLOURED |
C |
15-JUL-04 |
|
| GR |
GRADATIONAL |
C |
01-SEP-04 |
03-SEP-04 |
