-- -- A one-to-many mapping table of content folders to content types. -- Basically, this table restricts the content types a folder may contain. -- Future releases will add numeric and tagged constraints similar to -- thos available for content types. -- CREATE TABLE cr_folder_type_map ( folder_id integer NOT NULL, content_type varchar(1000) NOT NULL, PRIMARY KEY (folder_id,content_type), CONSTRAINT cr_folder_type_map_fldr_fk REFERENCES cr_folders (), CONSTRAINT cr_folder_type_map_pk REFERENCES cr_folders (), CONSTRAINT cr_folder_type_map_typ_fk REFERENCES cr_folders (), CONSTRAINT cr_folder_type_map_typ_fk REFERENCES acs_object_types (), CONSTRAINT cr_folder_type_map_fldr_fk REFERENCES acs_object_types (), CONSTRAINT cr_folder_type_map_pk REFERENCES acs_object_types () ); CREATE INDEX cr_folder_typ_map_cont_typ_idx ON cr_folder_type_map (content_type); CREATE TRIGGER RI_ConstraintTrigger_c_341269 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341270 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610596 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610597 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 139,264 bytes -- Table rows: 2,591
Begin main content
