POSC Meta Model Specifications Version 2.3 Meta Data Relational Implementation

CREATE TABLE RULES
(
ATTRIBUTE_SCHAR VARYING (19) REFERENCES ATTRIBUTE (ATTRIBUTE_S),
ENT_OR_TYPE_SCHAR VARYING (19) NOT NULL,
REF_RULE_TYPECHAR VARYING (40) REFERENCES REF_RULE_TYPE (REF_RULE_TYPE_NM),
RULES_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
RULE_LABELCHAR VARYING (40),
RULE_TEXTCHAR VARYING (255),
RULE_TYPECHAR (3) NOT NULL,
SOURCE_SCHAR VARYING (19) NOT NULL REFERENCES SOURCE (SOURCE_S),
SUBSET_CONSTRAINTCHAR (1) NOT NULL
)
CREATE INDEX index_rules1 ON rules (rule_type, ent_or_type_s)
CREATE INDEX index_rules2 ON rules (rule_type, attribute_s);


© Copyright 1997-2001 POSC. All rights reserved.