-- -- A relationship between a time span and an activity. -- CREATE TABLE acs_events ( event_id integer PRIMARY KEY NOT NULL, -- -- The name of the event. -- name varchar(255), -- -- The description of the event. -- description text(-5), -- -- Whether or not the description is in HTML. -- html_p bool, -- -- Additional information to display along with the name. -- status_summary varchar(255), -- -- The activity associated with this event. -- activity_id integer, -- -- The time span associated with this event. -- timespan_id integer, -- -- A description of how this event recurs. If null, then this event does -- not recur. -- recurrence_id integer, related_link_url text(-5), related_link_text text(-5), redirect_to_rel_link_p bool, -- -- The location associated with this event. -- location varchar(255), ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT acs_events_activity_id_fk REFERENCES acs_activities (), CONSTRAINT acs_events_event_id_fk REFERENCES acs_activities (), CONSTRAINT acs_events_event_id_pk REFERENCES acs_activities (), CONSTRAINT acs_events_recurrence_id_fk REFERENCES acs_activities () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_events_recurrence_id_fk REFERENCES acs_objects (), CONSTRAINT acs_events_event_id_pk REFERENCES acs_objects (), CONSTRAINT acs_events_event_id_fk REFERENCES acs_objects (), CONSTRAINT acs_events_activity_id_fk REFERENCES acs_objects (), CONSTRAINT acs_events_recurrence_id_fk REFERENCES recurrences (), CONSTRAINT acs_events_activity_id_fk REFERENCES recurrences (), CONSTRAINT acs_events_event_id_fk REFERENCES recurrences (), CONSTRAINT acs_events_event_id_pk REFERENCES recurrences () ); CREATE INDEX acs_events_activity_id_idx ON acs_events (activity_id); CREATE INDEX acs_events_recurrence_id_idx ON acs_events (recurrence_id); CREATE INDEX acs_events_timespan_id_idx ON acs_events (timespan_id); CREATE TRIGGER RI_ConstraintTrigger_c_340309 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340310 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340314 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340315 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340319 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340320 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340322 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340323 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341012 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341013 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to acs_events: --acs_event_party_map(acs_events_activity_id_fk) --acs_event_party_map(acs_events_event_id_fk) --acs_event_party_map(acs_events_event_id_pk) --acs_event_party_map(acs_events_recurrence_id_fk) --cal_items(acs_events_activity_id_fk) --cal_items(acs_events_event_id_fk) --cal_items(acs_events_event_id_pk) --cal_items(acs_events_recurrence_id_fk) -- Table size: 8,192 bytes -- Table rows: 103
Begin main content
