CREATE TABLE notification_user_map ( notification_id integer NOT NULL, user_id integer NOT NULL, sent_date timestamptz, PRIMARY KEY (notification_id,user_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT notif_user_map_notif_id_fk REFERENCES notifications (), CONSTRAINT notif_user_map_pk REFERENCES notifications (), CONSTRAINT notif_user_map_user_id_fk REFERENCES notifications () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT notif_user_map_user_id_fk REFERENCES users (), CONSTRAINT notif_user_map_notif_id_fk REFERENCES users (), CONSTRAINT notif_user_map_pk REFERENCES users () ); CREATE INDEX notification_user_map_n_u_idx ON notification_user_map (notification_id, user_id); CREATE INDEX notification_user_map_user_idx ON notification_user_map (user_id); CREATE TRIGGER RI_ConstraintTrigger_c_342729 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342730 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342734 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342735 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 57
Begin main content
