DIC_SUBSIDENCE_CAUSE
Dictionary describing the cause of subsidence, eg. mining subsidence, landslip.
| 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 8 of 8)
| CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| NATSUB |
Natural Subsidence |
NATURAL SUBSIDENCE |
C |
10-JUN-04 |
|
| MINESB |
Mining Subsidence |
MINING SUBSIDENCE |
C |
10-JUN-04 |
|
| LNDSLP |
Landslip |
LANDSLIP |
C |
10-JUN-04 |
|
| COMPRS |
Compressible |
COMPRESSIBLE |
C |
10-JUN-04 |
|
| BUILDN |
Building |
BUILDING |
C |
10-JUN-04 |
|
| - |
Not Applicable |
Not Applicable |
C |
10-JUN-04 |
|
| ! |
Not Available |
Not Available |
C |
10-JUN-04 |
|
| ? |
Not Entered |
Not Entered |
C |
10-JUN-04 |
|
