CREATE TABLE notification_types_intervals ( type_id integer NOT NULL, interval_id integer NOT NULL, PRIMARY KEY (type_id,interval_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT notif_type_int_int_id_fk REFERENCES notification_intervals (), CONSTRAINT notif_type_int_pk REFERENCES notification_intervals (), CONSTRAINT notif_type_int_type_id_fk REFERENCES notification_intervals () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT notif_type_int_type_id_fk REFERENCES notification_types (), CONSTRAINT notif_type_int_int_id_fk REFERENCES notification_types (), CONSTRAINT notif_type_int_pk REFERENCES notification_types () ); CREATE TRIGGER RI_ConstraintTrigger_a_342667 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342668 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342709 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342710 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342714 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342715 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to notification_types_intervals: --notification_requests(notif_type_int_int_id_fk) --notification_requests(notif_type_int_pk) --notification_requests(notif_type_int_type_id_fk) -- Table size: 8,192 bytes -- Table rows: 51
Begin main content
