POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE COORDINATE_SYSTEM
(
DESCRIPTIONCHAR VARYING (2000),
ENTITY_TYPE_NMCHAR VARYING (30) NOT NULL CHECK (ENTITY_TYPE_NM IN ('COMPOUND_COORDINATE_SYSTEM', 'GENERAL_COORDINATE_SYSTEM', 'GEOCENTRIC_COORDINATE_SYSTEM', 'GEOGRAPHIC_2D_COORD_SYSTEM', 'GEOGRAPHIC_3D_COORD_SYSTEM', 'PROJECTED_2D_COORDINATE_SYSTEM', 'VERTICAL_COORDINATE_SYSTEM')),
FIRST_SYSTEM_SCHAR VARYING (19) REFERENCES COORDINATE_SYSTEM (INSTANCE_S),
GEODETIC_DATUM_SCHAR VARYING (19) REFERENCES GEODETIC_DATUM (INSTANCE_S),
GEOGRAPHIC_2D_COORD_SYSTEM_SCHAR VARYING (19) REFERENCES COORDINATE_SYSTEM (INSTANCE_S),
IDENTIFIERCHAR VARYING (80) NOT NULL,
INSTANCE_CREATE_DATETIMESTAMP ,
INSTANCE_CREATORCHAR VARYING (80),
INSTANCE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
LOCAL_CONTEXT_SCHAR VARYING (19),
LOCAL_CONTEXT_TCHAR VARYING (30),
MAP_PROJECTION_SCHAR VARYING (19) REFERENCES COORDINATE_TRANSFORMATION (INSTANCE_S),
NAMING_SYSTEMCHAR VARYING (80) REFERENCES NAMING_SYSTEM (IDENTIFIER),
ORIGIN_LOCATION_1FLOAT NOT NULL,
ORIGIN_LOCATION_1_MAINTEGER,
ORIGIN_LOCATION_1_SAFLOAT,
ORIGIN_LOCATION_1_UCHAR VARYING (15) NOT NULL REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
ORIGIN_LOCATION_2FLOAT,
ORIGIN_LOCATION_2_MAINTEGER,
ORIGIN_LOCATION_2_SAFLOAT,
ORIGIN_LOCATION_2_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
ORIGIN_LOCATION_3FLOAT,
ORIGIN_LOCATION_3_MAINTEGER,
ORIGIN_LOCATION_3_SAFLOAT,
ORIGIN_LOCATION_3_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
ORIGIN_LOCATION_4FLOAT,
ORIGIN_LOCATION_4_MAINTEGER,
ORIGIN_LOCATION_4_SAFLOAT,
ORIGIN_LOCATION_4_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
ORIGIN_LOCATION_5FLOAT,
ORIGIN_LOCATION_5_MAINTEGER,
ORIGIN_LOCATION_5_SAFLOAT,
ORIGIN_LOCATION_5_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
ORIGIN_LOCATION_CS_SCHAR VARYING (19) NOT NULL REFERENCES COORDINATE_SYSTEM (INSTANCE_S),
ORIGIN_LOCATION_O_SCHAR VARYING (19) REFERENCES SPATIAL_OBJECT (INSTANCE_S),
R_COORDINATE_SYS_CONSTRAINTCHAR VARYING (80) NOT NULL REFERENCES R_COORDINATE_SYS_CONSTRAINT (IDENTIFIER),
R_DISPLAY_ORIENTATIONCHAR VARYING (80) REFERENCES R_DISPLAY_ORIENTATION (IDENTIFIER),
SECOND_SYSTEM_SCHAR VARYING (19) REFERENCES COORDINATE_SYSTEM (INSTANCE_S),
SOURCECHAR VARYING (80),
SOURCE_CONTENTCHAR VARYING (80),
SOURCE_GEODETIC_SYSTEM_SCHAR VARYING (19) REFERENCES COORDINATE_SYSTEM (INSTANCE_S),
SOURCE_REFERENCECHAR VARYING (2000),
SPATIAL_REFERENCE_SCHAR VARYING (19) REFERENCES SPATIAL_OBJECT (INSTANCE_S),
STATUSCHAR VARYING (11),
VERSION_SCHAR VARYING (19) REFERENCES R_VERSION (INSTANCE_S),
VERTICAL_DATUM_SCHAR VARYING (19) REFERENCES VERTICAL_DATUM (INSTANCE_S)
)


Generated on Tue Jul 10 19:39:59 2001
© Copyright 2001 POSC. All rights reserved.