-- -- Maps between an activity and multiple ACS objects. -- CREATE TABLE acs_activity_object_map ( activity_id integer NOT NULL, object_id integer NOT NULL, PRIMARY KEY (activity_id,object_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_act_obj_mp_activity_id_fk REFERENCES acs_activities (), CONSTRAINT acs_act_obj_mp_object_id_fk REFERENCES acs_activities (), CONSTRAINT acs_act_obj_mp_pk REFERENCES acs_activities () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_act_obj_mp_pk REFERENCES acs_objects (), CONSTRAINT acs_act_obj_mp_activity_id_fk REFERENCES acs_objects (), CONSTRAINT acs_act_obj_mp_object_id_fk REFERENCES acs_objects () ); CREATE TRIGGER RI_ConstraintTrigger_c_340244 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340245 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340249 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340250 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
