POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE CORD_TRFM_VAL
(
COORDINATE_TRFM_IDCHAR VARYING (40) NOT NULL REFERENCES COORDINATE_TRFM (COORDINATE_TRFM_ID),
CORD_TRFM_PAR_SCHAR VARYING (19) NOT NULL REFERENCES CORD_TRFM_PAR (CORD_TRFM_PAR_S),
CORD_TRFM_VAL_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
DESCRIPTIONCHAR VARYING (255),
INTEGER_VALUEINTEGER,
LOCATION_VALUECHAR VARYING (16),
QUANTITY_VALUEFLOAT,
QUANTITY_VALUE_UCHAR VARYING (15) REFERENCES R_UOM (ACRONYM),
REAL_VALUEFLOAT (6),
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),
STRING_VALUECHAR VARYING (40),
VERSIONCHAR VARYING (40) REFERENCES R_EPCNT_VERSION (NAME)
)
ALTER TABLE CORD_TRFM_VAL ADD (CONSTRAINT UNIQUE (coordinate_trfm_id, cord_trfm_par_s))


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