DESCRIPTION | CHAR VARYING (2000) | , |
ENTITY_TYPE_NM | CHAR 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_S | CHAR VARYING (19) | REFERENCES COORDINATE_SYSTEM (INSTANCE_S), |
GEODETIC_DATUM_S | CHAR VARYING (19) | REFERENCES GEODETIC_DATUM (INSTANCE_S), |
GEOGRAPHIC_2D_COORD_SYSTEM_S | CHAR VARYING (19) | REFERENCES COORDINATE_SYSTEM (INSTANCE_S), |
IDENTIFIER | CHAR VARYING (80) | NOT NULL, |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
LOCAL_CONTEXT_S | CHAR VARYING (19) | , |
LOCAL_CONTEXT_T | CHAR VARYING (30) | , |
MAP_PROJECTION_S | CHAR VARYING (19) | REFERENCES COORDINATE_TRANSFORMATION (INSTANCE_S), |
NAMING_SYSTEM | CHAR VARYING (80) | REFERENCES NAMING_SYSTEM (IDENTIFIER), |
ORIGIN_LOCATION_1 | FLOAT | NOT NULL, |
ORIGIN_LOCATION_1_MA | INTEGER | , |
ORIGIN_LOCATION_1_SA | FLOAT | , |
ORIGIN_LOCATION_1_U | CHAR VARYING (15) | NOT NULL REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
ORIGIN_LOCATION_2 | FLOAT | , |
ORIGIN_LOCATION_2_MA | INTEGER | , |
ORIGIN_LOCATION_2_SA | FLOAT | , |
ORIGIN_LOCATION_2_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
ORIGIN_LOCATION_3 | FLOAT | , |
ORIGIN_LOCATION_3_MA | INTEGER | , |
ORIGIN_LOCATION_3_SA | FLOAT | , |
ORIGIN_LOCATION_3_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
ORIGIN_LOCATION_4 | FLOAT | , |
ORIGIN_LOCATION_4_MA | INTEGER | , |
ORIGIN_LOCATION_4_SA | FLOAT | , |
ORIGIN_LOCATION_4_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
ORIGIN_LOCATION_5 | FLOAT | , |
ORIGIN_LOCATION_5_MA | INTEGER | , |
ORIGIN_LOCATION_5_SA | FLOAT | , |
ORIGIN_LOCATION_5_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
ORIGIN_LOCATION_CS_S | CHAR VARYING (19) | NOT NULL REFERENCES COORDINATE_SYSTEM (INSTANCE_S), |
ORIGIN_LOCATION_O_S | CHAR VARYING (19) | REFERENCES SPATIAL_OBJECT (INSTANCE_S), |
R_COORDINATE_SYS_CONSTRAINT | CHAR VARYING (80) | NOT NULL REFERENCES R_COORDINATE_SYS_CONSTRAINT (IDENTIFIER), |
R_DISPLAY_ORIENTATION | CHAR VARYING (80) | REFERENCES R_DISPLAY_ORIENTATION (IDENTIFIER), |
SECOND_SYSTEM_S | CHAR VARYING (19) | REFERENCES COORDINATE_SYSTEM (INSTANCE_S), |
SOURCE | CHAR VARYING (80) | , |
SOURCE_CONTENT | CHAR VARYING (80) | , |
SOURCE_GEODETIC_SYSTEM_S | CHAR VARYING (19) | REFERENCES COORDINATE_SYSTEM (INSTANCE_S), |
SOURCE_REFERENCE | CHAR VARYING (2000) | , |
SPATIAL_REFERENCE_S | CHAR VARYING (19) | REFERENCES SPATIAL_OBJECT (INSTANCE_S), |
STATUS | CHAR VARYING (11) | , |
VERSION_S | CHAR VARYING (19) | REFERENCES R_VERSION (INSTANCE_S), |
VERTICAL_DATUM_S | CHAR VARYING (19) | REFERENCES VERTICAL_DATUM (INSTANCE_S) |
)