POSC Meta Model Specifications Version 2.3 Meta Data Relational Implementation

CREATE TABLE ATTRIBUTE
(
AGGR_NAMECHAR VARYING (15),
ATTRIBUTE_NMCHAR VARYING (40) NOT NULL,
ATTRIBUTE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
ENT_OR_TYPE_CODECHAR (3) NOT NULL REFERENCES REF_OBJECT (OBJ_TYPE),
ENT_OR_TYPE_NMCHAR VARYING (40) NOT NULL,
FIXED_LENGTHCHAR (1) NOT NULL,
FORWARD_SCHAR VARYING (19) REFERENCES ATTRIBUTE (ATTRIBUTE_S),
IS_ACTIVECHAR (1) NOT NULL,
MAX_CARDINTEGER,
MAX_LENGTHINTEGER,
MIN_CARDINTEGER,
OPTIONALITYCHAR (1) NOT NULL,
ORIG_CARDINTEGER,
PARENT_ENTCHAR VARYING (40) NOT NULL REFERENCES ENTITY_DEF (ENTITY_DEF_NM),
REDECL_ENT_SCHAR VARYING (19) REFERENCES ENTITY_DEF (ENTITY_DEF_S),
SOURCE_SCHAR VARYING (19) NOT NULL REFERENCES SOURCE (SOURCE_S),
VERB_PHRASECHAR VARYING (40)
)
ALTER TABLE ATTRIBUTE ADD (CONSTRAINT UNIQUE (parent_ent, attribute_nm))
CREATE INDEX index_attribute1 ON attribute (forward_s);


© Copyright 1997-2001 POSC. All rights reserved.