-- -- Represents what happens during an event -- CREATE TABLE acs_activities ( activity_id integer PRIMARY KEY NOT NULL, name varchar(255) NOT NULL, description text(-5), html_p bool DEFAULT false, status_summary varchar(255), ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_activities_activity_id_fk REFERENCES acs_objects (), CONSTRAINT acs_activities_activity_id_pk REFERENCES acs_objects () ); CREATE TRIGGER RI_ConstraintTrigger_a_340242 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340243 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340254 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340255 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340307 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340308 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341047 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341048 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to acs_activities: --acs_activity_object_map(acs_activities_activity_id_fk) --acs_activity_object_map(acs_activities_activity_id_pk) --acs_events(acs_activities_activity_id_fk) --acs_events(acs_activities_activity_id_pk) --cal_uids(acs_activities_activity_id_fk) --cal_uids(acs_activities_activity_id_pk) -- Table size: 8,192 bytes -- Table rows: 9
Begin main content
