POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
CREATE TABLE OHIO_LEGAL_SURVEY_AREA
(
BLOCK | CHAR VARYING (15) | , |
CITY_ZIP_CODE | CHAR VARYING (15) | , |
DESCRIPTION | CHAR VARYING (2000) | , |
IDENTIFIER | CHAR VARYING (80) | NOT NULL, |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
KIND_S | CHAR VARYING (19) | REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S), |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
LOT | CHAR VARYING (15) | , |
NAMING_SYSTEM | CHAR VARYING (80) | REFERENCES NAMING_SYSTEM (IDENTIFIER), |
PRINCIPAL_MERIDIAN | CHAR VARYING (40) | , |
QUADRANGLE | CHAR VARYING (40) | , |
QUADRANGLE_MINUTES | FLOAT (6) | , |
SOURCE | CHAR VARYING (80) | , |
SOURCE_CONTENT | CHAR VARYING (80) | , |
SOURCE_REFERENCE | CHAR VARYING (2000) | , |
STATUS | CHAR VARYING (11) | , |
SUBDIVISION | CHAR VARYING (15) | , |
SURFACE_ONLY | CHAR (1) | , |
TOWNSHIP | CHAR VARYING (40) | , |
TOWNSHIP_LOT | CHAR VARYING (15) | , |
TOWNSHIP_SECTION | CHAR VARYING (15) | , |
UNIQUE_WITHIN_S | CHAR VARYING (19) | , |
UNIQUE_WITHIN_T | CHAR VARYING (30) | , |
VERSION_S | CHAR VARYING (19) | REFERENCES R_VERSION (INSTANCE_S) |