-- -- Table calendars maps the many to many relationship betweens -- calendar and its owners. -- CREATE TABLE calendars ( -- -- Primary Key -- calendar_id integer PRIMARY KEY NOT NULL, -- -- the name of the calendar. This would be unique to avoid confusion -- calendar_name varchar(200), -- -- the individual or party that owns the calendar -- owner_id integer, -- -- keep track of package instances -- package_id integer, private_p bool DEFAULT false, CONSTRAINT calendars_calendar_id_fk REFERENCES acs_objects (), CONSTRAINT calendars_calendar_id_pk REFERENCES acs_objects (), CONSTRAINT calendars_calendar_owner_id_fk REFERENCES acs_objects (), CONSTRAINT calendars_package_id_fk REFERENCES acs_objects (), CONSTRAINT calendars_private_p_ck REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT calendars_calendar_id_fk REFERENCES parties (), CONSTRAINT calendars_calendar_id_pk REFERENCES parties (), CONSTRAINT calendars_calendar_owner_id_fk REFERENCES parties (), CONSTRAINT calendars_package_id_fk REFERENCES parties (), CONSTRAINT calendars_private_p_ck REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT calendars_private_p_ck REFERENCES apm_packages (), CONSTRAINT calendars_calendar_id_fk REFERENCES apm_packages (), CONSTRAINT calendars_calendar_id_pk REFERENCES apm_packages (), CONSTRAINT calendars_calendar_owner_id_fk REFERENCES apm_packages (), CONSTRAINT calendars_package_id_fk REFERENCES apm_packages () ); CREATE INDEX calendars_package_id_pidx ON calendars (package_id); CREATE TRIGGER RI_ConstraintTrigger_a_341017 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341018 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341022 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341023 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341032 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341033 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341054 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341055 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341059 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341060 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341064 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341065 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to calendars: --cal_item_types(calendars_calendar_id_fk) --cal_item_types(calendars_calendar_id_pk) --cal_item_types(calendars_calendar_owner_id_fk) --cal_item_types(calendars_package_id_fk) --cal_item_types(calendars_private_p_ck) --cal_items(calendars_calendar_id_fk) --cal_items(calendars_calendar_id_pk) --cal_items(calendars_calendar_owner_id_fk) --cal_items(calendars_package_id_fk) --cal_items(calendars_private_p_ck) --cal_party_prefs(calendars_calendar_id_fk) --cal_party_prefs(calendars_calendar_id_pk) --cal_party_prefs(calendars_calendar_owner_id_fk) --cal_party_prefs(calendars_package_id_fk) --cal_party_prefs(calendars_private_p_ck) -- Table size: 8,192 bytes -- Table rows: 26
Begin main content
