CREATE TABLE ec_refunds ( refund_id integer PRIMARY KEY NOT NULL, order_id integer NOT NULL, refund_amount numeric(65535, 65531) NOT NULL, refund_date timestamptz NOT NULL, refunded_by integer NOT NULL, refund_reasons varchar(4000), CONSTRAINT ec_refunds_order_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_refunds_pkey REFERENCES ec_orders (), CONSTRAINT ec_refunds_refunded_by_fkey REFERENCES ec_orders (), CONSTRAINT ec_refunds_refunded_by_fkey REFERENCES users (), CONSTRAINT ec_refunds_order_id_fkey REFERENCES users (), CONSTRAINT ec_refunds_pkey REFERENCES users () ); CREATE INDEX ec_refunds_by_order_idx ON ec_refunds (order_id); CREATE TRIGGER RI_ConstraintTrigger_a_341862 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341863 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341922 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341923 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342144 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342145 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342149 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342150 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_refunds: --ec_financial_transactions(ec_refunds_order_id_fkey) --ec_financial_transactions(ec_refunds_pkey) --ec_financial_transactions(ec_refunds_refunded_by_fkey) --ec_items(ec_refunds_order_id_fkey) --ec_items(ec_refunds_pkey) --ec_items(ec_refunds_refunded_by_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
