DIC_MINE_DATA_SOURCE
Dictionary of data sources for Mine Entrances database (BGS.MINE_ENTRANCE).
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(5) |
Primary key
|
2 |
DESCRIPTION |
Varchar(68) |
|
3 |
TRANSLATION |
Varchar(50) |
|
4 |
STATUS |
Varchar(1) |
|
5 |
DATE_ENTERED |
Date |
|
6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 6 of 6)
CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
SOBI |
Single Onshore Borehole Index |
|
C |
10-DEC-02 |
|
MOD |
Mineral Occurrences Database |
|
C |
10-DEC-02 |
29-JAN-03 |
BRIT |
BRITPITS |
|
C |
10-DEC-02 |
|
MEF |
Mining in the Elland Flags: A Forgotten Yorskhire Industry |
Derived from the report by Godwin 1984 |
C |
10-DEC-02 |
10-DEC-02 |
ALGI |
Mines in Bath/Bristol area |
Excel spreadsheet |
C |
10-DEC-02 |
29-JAN-03 |
COL |
Collieries_New |
|
C |
10-DEC-02 |
|