CREATE TABLE cal_item_types ( item_type_id integer PRIMARY KEY NOT NULL, calendar_id integer NOT NULL, type varchar(100) NOT NULL, CONSTRAINT cal_item_type_cal_id_fk REFERENCES calendars (), CONSTRAINT cal_item_types_un REFERENCES calendars (), CONSTRAINT cal_item_type_id_pk REFERENCES calendars () ); CREATE UNIQUE INDEX cal_item_types_un ON cal_item_types (calendar_id, item_type_id); CREATE TRIGGER RI_ConstraintTrigger_c_341019 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341020 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341027 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341028 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to cal_item_types: --cal_items(cal_item_type_cal_id_fk) --cal_items(cal_item_type_id_pk) --cal_items(cal_item_types_un) -- Table size: 8,192 bytes -- Table rows: 3
Begin main content
