POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE COORDINATE_SYS
(
COORDINATE_SYS_IDCHAR VARYING (40) NOT NULL,
COORDINATE_SYS_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
DESCRIPTIONCHAR VARYING (255),
ENTITY_TYPE_NMCHAR VARYING (40) NOT NULL CHECK (ENTITY_TYPE_NM IN ('GEOCENTRIC_COORDINATE_SYSTEM', 'GEOGRAPHIC_COORDINATE_SYSTEM', 'LOCAL_SPATIAL_COORDINATE_SYSTEM', 'NONSPATIAL_COORDINATE_SYSTEM', 'PROJECTED_COORDINATE_SYSTEM')),
GEODETIC_DATUM_IDCHAR VARYING (80) REFERENCES GEODETIC_DATUM (GEODETIC_DATUM_ID),
PRIME_MERIDIAN_IDCHAR VARYING (40) REFERENCES PRIME_MERIDIAN (PRIME_MERIDIAN_ID),
R_AXIS_ORNT_KINDCHAR VARYING (40) REFERENCES R_AXIS_ORNT (R_AXIS_ORNT_KIND),
R_CORD_SYS_CSTR_NMCHAR VARYING (40) NOT NULL REFERENCES R_CORD_SYS_CSTR (R_CORD_SYS_CSTR_NM),
R_DISPLAY_ORNTCHAR VARYING (40) REFERENCES R_DISPLAY_ORNT (NAME),
R_MAP_PROJ_KINDCHAR VARYING (40) REFERENCES R_MAP_PROJ (R_MAP_PROJ_KIND),
R_NAMING_SYSTEM_KDCHAR VARYING (40) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD),
SOURCECHAR VARYING (40) NOT NULL REFERENCES R_SOURCE (R_SOURCE_NAME),
SOURCE_REFERENCE_SCHAR VARYING (19) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S),
STATUSCHAR VARYING (11),
VERSIONCHAR VARYING (40) REFERENCES R_EPCNT_VERSION (NAME),
VERTEX_SCHAR VARYING (19),
VERTEX_TCHAR VARYING (16)
)
ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT UNIQUE (coordinate_sys_id))


Generated on Sat Nov 15 15:33:03 1997
© Copyright 1997 POSC. All rights reserved.