POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE ELLIPSOID
(
DESCRIPTIONCHAR VARYING (255),
ELLIPSOID_IDCHAR VARYING (40) NOT NULL,
ELLIPSOID_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
INVERSE_FLATTENINGFLOAT (6),
R_NAMING_SYSTEM_KDCHAR VARYING (40) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD),
SEMIMAJOR_AXISFLOAT,
SEMIMAJOR_AXIS_UCHAR VARYING (15) REFERENCES R_UOM (ACRONYM),
SEMIMINOR_AXISFLOAT,
SEMIMINOR_AXIS_UCHAR VARYING (15) REFERENCES R_UOM (ACRONYM),
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)
)
ALTER TABLE ELLIPSOID ADD (CONSTRAINT UNIQUE (ellipsoid_id))


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