-- -- Maps categories to objects and thus categorizes and object. -- CREATE TABLE category_object_map ( -- -- ID of the mapped category (see categories). -- category_id integer NOT NULL, -- -- ID of the mapped object. -- object_id integer NOT NULL, PRIMARY KEY (category_id,object_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cat_object_map_category_id_fk REFERENCES categories (), CONSTRAINT cat_object_map_object_id_fk REFERENCES categories (), CONSTRAINT category_object_map_pkey REFERENCES categories () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT category_object_map_pkey REFERENCES acs_objects (), CONSTRAINT cat_object_map_category_id_fk REFERENCES acs_objects (), CONSTRAINT cat_object_map_object_id_fk REFERENCES acs_objects () ); CREATE UNIQUE INDEX cat_object_map_ix ON category_object_map (object_id, category_id); CREATE INDEX category_object_map_category_id_idx ON category_object_map (category_id); CREATE INDEX category_object_map_category_idx ON category_object_map (category_id); CREATE INDEX category_object_map_object_id_idx ON category_object_map (object_id); CREATE TRIGGER RI_ConstraintTrigger_c_341074 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341075 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341079 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341080 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 57,344 bytes -- Table rows: 1,186
Begin main content
