-- -- Constrains the allowable content types which a content type may -- contain. -- CREATE TABLE cr_type_children ( parent_type varchar(1000) NOT NULL, child_type varchar(1000) NOT NULL, relation_tag varchar(100) NOT NULL, min_n integer, max_n integer, PRIMARY KEY (parent_type,child_type,relation_tag), CONSTRAINT cr_type_children_child_fk REFERENCES acs_object_types (), CONSTRAINT cr_type_children_parent_fk REFERENCES acs_object_types (), CONSTRAINT cr_type_children_pk REFERENCES acs_object_types (), CONSTRAINT cr_type_children_pk REFERENCES acs_object_types (), CONSTRAINT cr_type_children_child_fk REFERENCES acs_object_types (), CONSTRAINT cr_type_children_parent_fk REFERENCES acs_object_types () ); CREATE INDEX cr_type_children_chld_type_idx ON cr_type_children (child_type); CREATE TRIGGER RI_ConstraintTrigger_c_1610606 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610607 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610611 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610612 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 15
Begin main content
