-- -- Table cal_items maps the ownership relation between -- an cal_item_id to calendars. Each cal_item is owned -- by a calendar -- CREATE TABLE cal_items ( -- -- Primary Key -- cal_item_id integer PRIMARY KEY NOT NULL, -- -- Mapping to calendar. Each cal_item is owned -- by a calendar -- on_which_calendar integer, item_type_id integer, CONSTRAINT cal_item_cal_item_id_fk REFERENCES acs_events (), CONSTRAINT cal_item_cal_item_id_pk REFERENCES acs_events (), CONSTRAINT cal_item_which_cal_fk REFERENCES acs_events (), CONSTRAINT cal_items_type_fk REFERENCES acs_events () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cal_items_type_fk REFERENCES calendars (), CONSTRAINT cal_item_which_cal_fk REFERENCES calendars (), CONSTRAINT cal_item_cal_item_id_pk REFERENCES calendars (), CONSTRAINT cal_item_cal_item_id_fk REFERENCES calendars (), CONSTRAINT cal_items_type_fk REFERENCES cal_item_types (), CONSTRAINT cal_item_cal_item_id_fk REFERENCES cal_item_types (), CONSTRAINT cal_item_cal_item_id_pk REFERENCES cal_item_types (), CONSTRAINT cal_item_which_cal_fk REFERENCES cal_item_types () ); CREATE INDEX cal_items_on_which_calendar_idx ON cal_items (on_which_calendar); CREATE INDEX cal_items_on_which_calendar_item_type_id_idx ON cal_items (on_which_calendar, item_type_id); CREATE TRIGGER RI_ConstraintTrigger_c_341014 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341015 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341024 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341025 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341029 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341030 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 103
Begin main content
