CREATE TABLE ec_items ( item_id integer PRIMARY KEY NOT NULL, order_id integer NOT NULL, product_id integer NOT NULL, color_choice varchar(4000), size_choice varchar(4000), style_choice varchar(4000), shipment_id integer, in_cart_date timestamptz, voided_date timestamptz, voided_by integer, expired_date timestamptz, item_state varchar(50) DEFAULT 'in_basket'::character varying, received_back_date timestamptz, price_charged numeric(65535, 65531), price_refunded numeric(65535, 65531), shipping_charged numeric(65535, 65531), shipping_refunded numeric(65535, 65531), price_tax_charged numeric(65535, 65531), price_tax_refunded numeric(65535, 65531), shipping_tax_charged numeric(65535, 65531), shipping_tax_refunded numeric(65535, 65531), price_name varchar(30), refund_id integer, cs_comments varchar(4000), CONSTRAINT ec_items_order_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_items_voided_by_fkey REFERENCES ec_orders (), CONSTRAINT ec_items_shipment_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_items_pkey REFERENCES ec_orders (), CONSTRAINT ec_items_refund_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_items_product_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_items_voided_by_fkey REFERENCES ec_products (), CONSTRAINT ec_items_order_id_fkey REFERENCES ec_products (), CONSTRAINT ec_items_pkey REFERENCES ec_products (), CONSTRAINT ec_items_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_items_refund_id_fkey REFERENCES ec_products (), CONSTRAINT ec_items_shipment_id_fkey REFERENCES ec_products (), CONSTRAINT ec_items_product_id_fkey REFERENCES ec_refunds (), CONSTRAINT ec_items_voided_by_fkey REFERENCES ec_refunds (), CONSTRAINT ec_items_shipment_id_fkey REFERENCES ec_refunds (), CONSTRAINT ec_items_refund_id_fkey REFERENCES ec_refunds (), CONSTRAINT ec_items_pkey REFERENCES ec_refunds (), CONSTRAINT ec_items_order_id_fkey REFERENCES ec_refunds (), CONSTRAINT ec_items_voided_by_fkey REFERENCES ec_shipments (), CONSTRAINT ec_items_shipment_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_items_refund_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_items_product_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_items_pkey REFERENCES ec_shipments (), CONSTRAINT ec_items_order_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_items_voided_by_fkey REFERENCES users (), CONSTRAINT ec_items_shipment_id_fkey REFERENCES users (), CONSTRAINT ec_items_refund_id_fkey REFERENCES users (), CONSTRAINT ec_items_product_id_fkey REFERENCES users (), CONSTRAINT ec_items_pkey REFERENCES users (), CONSTRAINT ec_items_order_id_fkey REFERENCES users () ); CREATE INDEX ec_items_by_order ON ec_items (order_id); CREATE INDEX ec_items_by_product ON ec_items (product_id); CREATE INDEX ec_items_by_shipment ON ec_items (shipment_id); CREATE TRIGGER ec_order_state_after_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_order_state_after_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341914 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341915 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341919 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341920 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341924 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341925 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341929 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341930 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341934 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341935 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
