DIC_CAVITY_TYPE
BGS Dictionary Table to hold various cavity types
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(6) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(500) |
|
| 3 |
TRANSLATION |
Varchar(50) |
|
| 4 |
STATUS |
Char(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 15 of 15)
| CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| OCAVE |
OPEN CAVE (NATURAL) |
OPEN CAVE (NATURAL) |
C |
10-JUN-04 |
|
| ICAVE |
INFILLED CAVE (NATURAL) |
INFILLED CAVE (NATURAL) |
C |
10-JUN-04 |
|
| GULCAM |
GULL (OR CAMBERING) |
GULL (OR CAMBERING) |
C |
10-JUN-04 |
|
| LAVATB |
LAVA TUBE |
LAVA TUBE |
C |
10-JUN-04 |
|
| BLDRCV |
BOULDER CAVE |
BOULDER CAVE |
C |
10-JUN-04 |
|
| PEATCV |
PEAT CAVE |
PEAT CAVE |
C |
10-JUN-04 |
|
| BOREHL |
BOREHOLE |
BOREHOLE |
C |
10-JUN-04 |
|
| SEACV |
SEA CAVE |
SEA CAVE |
C |
10-JUN-04 |
|
| STOPNG |
STOPING |
STOPING |
C |
10-JUN-04 |
|
| CAVITY |
CAVITY |
CAVITY |
C |
10-JUN-04 |
|
| PALKRT |
PALAEOKARST |
PALAEOKARST |
C |
10-JUN-04 |
|
| HYDTHR |
HYDROTHERMAL |
HYDROTHERMAL |
C |
10-JUN-04 |
|
| ! |
Not Available - Applicable but try as we might,we can't find a value. |
Not Available |
C |
09-FEB-06 |
|
| - |
Not Applicable |
Not Applicable |
C |
09-FEB-06 |
|
| ? |
Not Entered - We haven't assigned a value yet |
Not Entered |
C |
09-FEB-06 |
|
