-- -- Provides for richer parent-child relationships than the simple -- link encapsulated in the primary table. May be subclassed to provide -- additional attributes. -- CREATE TABLE cr_child_rels ( rel_id integer PRIMARY KEY NOT NULL, parent_id integer NOT NULL, child_id integer NOT NULL, relation_tag varchar(100), order_n integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_child_rels_child_id_fk REFERENCES cr_items (), CONSTRAINT cr_child_rels_parent_id_fk REFERENCES cr_items (), CONSTRAINT cr_child_rels_rel_fk REFERENCES cr_items (), CONSTRAINT cr_child_rels_rel_pk REFERENCES cr_items () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_child_rels_rel_pk REFERENCES acs_objects (), CONSTRAINT cr_child_rels_rel_fk REFERENCES acs_objects (), CONSTRAINT cr_child_rels_parent_id_fk REFERENCES acs_objects (), CONSTRAINT cr_child_rels_child_id_fk REFERENCES acs_objects (), CONSTRAINT cr_child_rels_rel_pk REFERENCES acs_objects (), CONSTRAINT cr_child_rels_child_id_fk REFERENCES acs_objects (), CONSTRAINT cr_child_rels_parent_id_fk REFERENCES acs_objects (), CONSTRAINT cr_child_rels_rel_fk REFERENCES acs_objects () ); CREATE INDEX cr_child_rels_by_parent ON cr_child_rels (parent_id); CREATE INDEX cr_child_rels_child_id_idx ON cr_child_rels (child_id); CREATE UNIQUE INDEX cr_child_rels_unq_id ON cr_child_rels (parent_id, child_id); CREATE TRIGGER RI_ConstraintTrigger_c_341224 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341225 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341229 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341230 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341234 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341235 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 147,456 bytes -- Table rows: 1,951
Begin main content
