POSC Meta Model Specifications Version 2.3 Meta Data Relational Implementation

CREATE TABLE ENTITY_DEF
(
ENTITY_DEF_NMCHAR VARYING (40) NOT NULL,
ENTITY_DEF_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
IS_ABSTRACTCHAR (1) NOT NULL,
IS_ACTIVECHAR (1) NOT NULL,
REF_TYPE_CODECHAR (1),
SCHEMA_DEF_SCHAR VARYING (19) NOT NULL REFERENCES SCHEMA_DEF (SCHEMA_DEF_S),
SOURCE_SCHAR VARYING (19) NOT NULL REFERENCES SOURCE (SOURCE_S)
)
ALTER TABLE ENTITY_DEF ADD (CONSTRAINT UNIQUE (entity_def_nm))


© Copyright 1997-2001 POSC. All rights reserved.