CREATE TABLE notifications ( notification_id integer PRIMARY KEY NOT NULL, type_id integer, object_id integer, notif_date timestamptz NOT NULL, response_id integer, notif_subject varchar(200), notif_text text(-5), notif_html text(-5), notif_user integer, file_ids text(-5), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT notif_notif_id_pk REFERENCES acs_objects (), CONSTRAINT notif_response_id_fk REFERENCES acs_objects (), CONSTRAINT notif_user_id_fk REFERENCES acs_objects (), CONSTRAINT notif_notif_id_fk REFERENCES acs_objects (), CONSTRAINT notif_type_id_fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT notif_response_id_fk REFERENCES acs_objects (), CONSTRAINT notif_notif_id_fk REFERENCES acs_objects (), CONSTRAINT notif_notif_id_pk REFERENCES acs_objects (), CONSTRAINT notif_type_id_fk REFERENCES acs_objects (), CONSTRAINT notif_user_id_fk REFERENCES acs_objects (), CONSTRAINT notif_user_id_fk REFERENCES notification_types (), CONSTRAINT notif_type_id_fk REFERENCES notification_types (), CONSTRAINT notif_response_id_fk REFERENCES notification_types (), CONSTRAINT notif_notif_id_pk REFERENCES notification_types (), CONSTRAINT notif_notif_id_fk REFERENCES notification_types (), CONSTRAINT notif_user_id_fk REFERENCES users (), CONSTRAINT notif_notif_id_fk REFERENCES users (), CONSTRAINT notif_notif_id_pk REFERENCES users (), CONSTRAINT notif_response_id_fk REFERENCES users (), CONSTRAINT notif_type_id_fk REFERENCES users () ); CREATE INDEX notifications_object_id_idx ON notifications (object_id); CREATE INDEX notifications_object_idx ON notifications (object_id); CREATE INDEX notifications_response_id_idx ON notifications (response_id); CREATE INDEX notifications_type_id_idx ON notifications (type_id); CREATE INDEX t1 ON notifications (object_id, type_id); CREATE TRIGGER RI_ConstraintTrigger_c_342634 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342635 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342689 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342690 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342704 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342705 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342724 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342725 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342727 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342728 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to notifications: --notification_user_map(notif_notif_id_fk) --notification_user_map(notif_notif_id_pk) --notification_user_map(notif_response_id_fk) --notification_user_map(notif_type_id_fk) --notification_user_map(notif_user_id_fk) -- Table size: 16,384 bytes -- Table rows: 0
Begin main content
