POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE CORD_SYS_AXIS
(
CORD_SYS_AXIS_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
CORD_SYS_IDCHAR VARYING (40) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID),
CORD_SYS_ID_LINTEGER,
DESCRIPTIONCHAR VARYING (255),
ENTITY_TYPE_NMCHAR VARYING (40) NOT NULL CHECK (ENTITY_TYPE_NM IN ('GENERAL_COORDINATE_SYSTEM_AXIS', 'MEASURED_DEPTH_SYSTEM_AXIS', 'VERTICAL_DEPTH_SYSTEM_AXIS', 'VERTICAL_TIME_SYSTEM_AXIS')),
MEASUREMENT_DTM_SCHAR VARYING (19),
MEASUREMENT_DTM_TCHAR VARYING (16),
NORMAL_TO_DATUM_SCHAR VARYING (19),
NORMAL_TO_DATUM_TCHAR VARYING (16),
R_AXIS_ORNT_KINDCHAR VARYING (40) REFERENCES R_AXIS_ORNT (R_AXIS_ORNT_KIND),
R_PROPERTY_TYPE_NMCHAR VARYING (40) NOT NULL REFERENCES R_QUANTITY_PTY (R_PROPERTY_TYPE_NM),
R_VAXIS_ORNT_NAMECHAR VARYING (40) REFERENCES R_VAXIS_ORNT (R_VAXIS_ORNT_NAME),
SOURCECHAR VARYING (40) 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),
VERTICAL_DATUM_SCHAR VARYING (19),
VERTICAL_DATUM_TCHAR VARYING (16)
)


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