-- -- Constrains the allowable object types to which a content type may -- relate (see above). -- CREATE TABLE cr_type_relations ( content_type varchar(1000) NOT NULL, target_type varchar(1000) NOT NULL, relation_tag varchar(100) NOT NULL, min_n integer, max_n integer, PRIMARY KEY (content_type,target_type,relation_tag), CONSTRAINT cr_type_relations_child_fk REFERENCES acs_object_types (), CONSTRAINT cr_type_relations_parent_fk REFERENCES acs_object_types (), CONSTRAINT cr_type_relations_pk REFERENCES acs_object_types (), CONSTRAINT cr_type_relations_pk REFERENCES acs_object_types (), CONSTRAINT cr_type_relations_child_fk REFERENCES acs_object_types (), CONSTRAINT cr_type_relations_parent_fk REFERENCES acs_object_types () ); CREATE INDEX cr_type_relations_tgt_typ_idx ON cr_type_relations (target_type); CREATE TRIGGER RI_ConstraintTrigger_c_1610616 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610617 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610621 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610622 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 1
Begin main content
