CREATE TABLE notification_replies ( reply_id integer PRIMARY KEY NOT NULL, object_id integer NOT NULL, type_id integer NOT NULL, from_user integer NOT NULL, subject varchar(100), content text(-5), reply_date timestamptz, CONSTRAINT notif_repl_obj_id_fk REFERENCES users (), CONSTRAINT notif_repl_repl_id_fk REFERENCES users (), CONSTRAINT notif_repl_type_id_fk REFERENCES users (), CONSTRAINT notif_repl_from_fk REFERENCES users (), CONSTRAINT notif_repl_repl_id_pk REFERENCES users (), CONSTRAINT notif_repl_repl_id_fk REFERENCES acs_objects (), CONSTRAINT notif_repl_from_fk REFERENCES acs_objects (), CONSTRAINT notif_repl_obj_id_fk REFERENCES acs_objects (), CONSTRAINT notif_repl_repl_id_pk REFERENCES acs_objects (), CONSTRAINT notif_repl_type_id_fk REFERENCES acs_objects (), CONSTRAINT notif_repl_type_id_fk REFERENCES acs_objects (), CONSTRAINT notif_repl_repl_id_pk REFERENCES acs_objects (), CONSTRAINT notif_repl_repl_id_fk REFERENCES acs_objects (), CONSTRAINT notif_repl_obj_id_fk REFERENCES acs_objects (), CONSTRAINT notif_repl_from_fk REFERENCES acs_objects (), CONSTRAINT notif_repl_type_id_fk REFERENCES notification_types (), CONSTRAINT notif_repl_from_fk REFERENCES notification_types (), CONSTRAINT notif_repl_obj_id_fk REFERENCES notification_types (), CONSTRAINT notif_repl_repl_id_fk REFERENCES notification_types (), CONSTRAINT notif_repl_repl_id_pk REFERENCES notification_types () ); CREATE TRIGGER RI_ConstraintTrigger_a_342622 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342623 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342639 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342640 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342644 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342645 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342649 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342650 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342654 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342655 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to notification_replies: --notification_email_hold(notif_repl_from_fk) --notification_email_hold(notif_repl_obj_id_fk) --notification_email_hold(notif_repl_repl_id_fk) --notification_email_hold(notif_repl_repl_id_pk) --notification_email_hold(notif_repl_type_id_fk) -- Table size: 0 bytes -- Table rows: 0
Begin main content
