Vocabularies — details

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   
OpenGeoscience
Maps and viewers
Apps
Data collections
Data downloads
Scans and photos
Web services