CREATE TABLE notification_types ( type_id integer PRIMARY KEY NOT NULL, sc_impl_id integer NOT NULL, short_name varchar(100) NOT NULL, pretty_name varchar(200) NOT NULL, description varchar(2000), CONSTRAINT notif_deliv_meth_impl_id_fk REFERENCES acs_sc_impls (), CONSTRAINT notif_type_type_id_fk REFERENCES acs_sc_impls (), CONSTRAINT notif_type_type_id_pk REFERENCES acs_sc_impls (), CONSTRAINT notif_type_type_id_pk REFERENCES acs_objects (), CONSTRAINT notif_deliv_meth_impl_id_fk REFERENCES acs_objects (), CONSTRAINT notif_type_type_id_fk REFERENCES acs_objects () ); CREATE UNIQUE INDEX notif_type_short_name_un ON notification_types (short_name); CREATE TRIGGER RI_ConstraintTrigger_c_342619 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342620 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342652 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342653 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342677 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342678 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342697 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342698 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342702 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342703 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342712 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342713 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342719 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342720 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to notification_types: --notification_replies(notif_deliv_meth_impl_id_fk) --notification_replies(notif_type_type_id_fk) --notification_replies(notif_type_type_id_pk) --notification_requests(notif_deliv_meth_impl_id_fk) --notification_requests(notif_type_type_id_fk) --notification_requests(notif_type_type_id_pk) --notification_types_del_methods(notif_deliv_meth_impl_id_fk) --notification_types_del_methods(notif_type_type_id_fk) --notification_types_del_methods(notif_type_type_id_pk) --notification_types_intervals(notif_deliv_meth_impl_id_fk) --notification_types_intervals(notif_type_type_id_fk) --notification_types_intervals(notif_type_type_id_pk) --notifications(notif_deliv_meth_impl_id_fk) --notifications(notif_type_type_id_fk) --notifications(notif_type_type_id_pk) -- Table size: 8,192 bytes -- Table rows: 15
Begin main content
