CREATE TABLE ec_problems_log (
problem_id integer PRIMARY KEY NOT NULL,
problem_date timestamptz,
problem_details varchar(4000),
order_id integer,
gift_certificate_id integer,
resolved_date timestamptz,
resolved_by integer,
CONSTRAINT ec_problems_log_gift_certificate_id_fkey REFERENCES ec_gift_certificates (),
CONSTRAINT ec_problems_log_order_id_fkey REFERENCES ec_gift_certificates (),
CONSTRAINT ec_problems_log_pkey REFERENCES ec_gift_certificates (),
CONSTRAINT ec_problems_log_resolved_by_fkey REFERENCES ec_gift_certificates (),
CONSTRAINT ec_problems_log_resolved_by_fkey REFERENCES ec_orders (),
CONSTRAINT ec_problems_log_pkey REFERENCES ec_orders (),
CONSTRAINT ec_problems_log_order_id_fkey REFERENCES ec_orders (),
CONSTRAINT ec_problems_log_gift_certificate_id_fkey REFERENCES ec_orders (),
CONSTRAINT ec_problems_log_resolved_by_fkey REFERENCES users (),
CONSTRAINT ec_problems_log_gift_certificate_id_fkey REFERENCES users (),
CONSTRAINT ec_problems_log_order_id_fkey REFERENCES users (),
CONSTRAINT ec_problems_log_pkey REFERENCES users ()
);
CREATE TRIGGER RI_ConstraintTrigger_c_341984 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341985 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341989 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341990 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341994 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341995 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 0 bytes
-- Table rows: 0
Tables: