CREATE TABLE notification_intervals ( interval_id integer PRIMARY KEY NOT NULL, name varchar(200) NOT NULL, n_seconds integer NOT NULL, CONSTRAINT notif_interv_id_fk REFERENCES acs_objects (), CONSTRAINT notif_interv_id_pk REFERENCES acs_objects () ); CREATE UNIQUE INDEX notif_interv_name_un ON notification_intervals (name); CREATE TRIGGER RI_ConstraintTrigger_c_342629 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342630 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342707 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342708 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to notification_intervals: --notification_types_intervals(notif_interv_id_fk) --notification_types_intervals(notif_interv_id_pk) -- Table size: 8,192 bytes -- Table rows: 4
Begin main content
