DIC_XYSOURCE
Dictionary table constraining the values entered into the XYSOURCE (source of spatial coordinates) field in the new BGS.BOREHOLE table.
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Char(1) |
Primary key
|
2 |
DESCRIPTION |
Varchar(68) |
|
3 |
TRANSLATION |
Varchar(50) |
|
4 |
STATUS |
Char(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 |
D |
DIGITISED |
|
C |
02-FEB-98 |
|
K |
KEYBOARD |
|
C |
02-FEB-98 |
|
M |
MICROWRITER |
|
C |
02-FEB-98 |
|
L |
LARGE SCALE PLAN |
|
C |
02-FEB-98 |
|
U |
UNKNOWN |
|
C |
02-FEB-98 |
|
. |
NOT ENTERED |
|
C |
02-FEB-98 |
|