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 |
|
