DIC_QUARTER
Dictionary; used as a foreign key constraint to control values input to the field QUARTER - meaning, the National Grid Quarter Sheet quadrant. This input was previously validated via trigger checks - these being removed as bad practice.
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(2) |
Primary key
|
2 |
DATA |
Varchar(20) |
|
3 |
DATE_ENTERED |
Date |
|
4 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 5 of 5)
CODE |
DATA |
DATE_ENTERED |
DATE_UPDATED |
FS |
FULL SHEET |
13-OCT-03 |
|
NE |
NORTH EAST |
13-OCT-03 |
|
NW |
NORTH WEST |
13-OCT-03 |
|
SW |
SOUTH WEST |
13-OCT-03 |
|
SE |
SOUTH EAST |
13-OCT-03 |
|