-- -- Describes all relations from one item to any number of other -- objects. -- CREATE TABLE cr_item_rels ( rel_id integer PRIMARY KEY NOT NULL, item_id integer, related_object_id integer, -- -- A token for lightweight classification of item relationships. -- If additional attributes are required, then a subtype of -- item_rel may be created. -- relation_tag varchar(100), -- -- Optional column for specifying a sort order. Note that the ordering -- method is application-dependent (it may be by relation type or -- across multiple relation types). -- order_n integer, CONSTRAINT cr_item_rels_fk REFERENCES acs_objects (), CONSTRAINT cr_item_rels_item_id_fk REFERENCES acs_objects (), CONSTRAINT cr_item_rels_pk REFERENCES acs_objects (), CONSTRAINT cr_item_rels_rel_obj__fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_item_rels_rel_obj__fk REFERENCES cr_items (), CONSTRAINT cr_item_rels_pk REFERENCES cr_items (), CONSTRAINT cr_item_rels_item_id_fk REFERENCES cr_items (), CONSTRAINT cr_item_rels_fk REFERENCES cr_items (), CONSTRAINT cr_item_rels_rel_obj__fk REFERENCES acs_objects (), CONSTRAINT cr_item_rels_fk REFERENCES acs_objects (), CONSTRAINT cr_item_rels_item_id_fk REFERENCES acs_objects (), CONSTRAINT cr_item_rels_pk REFERENCES acs_objects () ); CREATE UNIQUE INDEX cr_item_rel_unq ON cr_item_rels (item_id, related_object_id, relation_tag); CREATE INDEX cr_item_rels_rel_obj_id_idx ON cr_item_rels (related_object_id); CREATE TRIGGER RI_ConstraintTrigger_c_341319 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341320 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341329 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341330 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341334 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341335 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
