POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE MATERIAL_CLASS
(
CLASSIFICATION_SYSCHAR VARYING (40) REFERENCES CLSN_SYS (CLSN_SYS_NAME),
CLSN_CLS_NAMECHAR VARYING (80) NOT NULL,
DESCRIPTIONCHAR VARYING (255),
END_DATEDATE,
MATERIAL_CLASS_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
ROCK_FEATURE_SCHAR VARYING (19) REFERENCES ROCK_FEATURE (ROCK_FEATURE_S),
SOURCECHAR VARYING (40) NOT NULL REFERENCES R_SOURCE (R_SOURCE_NAME),
SOURCE_REFERENCE_SCHAR VARYING (19) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S),
START_DATEDATE,
STATUSCHAR VARYING (11),
VERSIONCHAR VARYING (40) REFERENCES R_EPCNT_VERSION (NAME)
)


Generated on Sat Nov 15 15:35:03 1997
© Copyright 1997 POSC. All rights reserved.