CREATE TABLE ec_orders ( order_id integer PRIMARY KEY NOT NULL, user_id integer, user_session_id integer, order_state varchar(50) DEFAULT 'in_basket'::character varying NOT NULL, tax_exempt_p bool DEFAULT false, shipping_method varchar(20), shipping_address integer, creditcard_id integer, in_basket_date timestamptz, confirmed_date timestamptz, authorized_date timestamptz, voided_date timestamptz, expired_date timestamptz, shipping_charged numeric(65535, 65531), shipping_refunded numeric(65535, 65531), shipping_tax_charged numeric(65535, 65531), shipping_tax_refunded numeric(65535, 65531), cs_comments varchar(4000), reason_for_void varchar(4000), voided_by integer, saved_p bool, CONSTRAINT ec_orders_creditcard_id_fkey REFERENCES ec_creditcards (), CONSTRAINT ec_orders_voided_by_fkey REFERENCES ec_creditcards (), CONSTRAINT ec_orders_user_session_id_fkey REFERENCES ec_creditcards (), CONSTRAINT ec_orders_pkey REFERENCES ec_creditcards (), CONSTRAINT ec_orders_user_id_fkey REFERENCES ec_creditcards (), CONSTRAINT ec_orders_shipping_address_fkey REFERENCES ec_creditcards (), CONSTRAINT ec_orders_saved_p REFERENCES ec_creditcards (), CONSTRAINT ec_orders_voided_by_fkey REFERENCES ec_addresses (), CONSTRAINT ec_orders_creditcard_id_fkey REFERENCES ec_addresses (), CONSTRAINT ec_orders_pkey REFERENCES ec_addresses (), CONSTRAINT ec_orders_saved_p REFERENCES ec_addresses (), CONSTRAINT ec_orders_shipping_address_fkey REFERENCES ec_addresses (), CONSTRAINT ec_orders_user_id_fkey REFERENCES ec_addresses (), CONSTRAINT ec_orders_user_session_id_fkey REFERENCES ec_addresses (), CONSTRAINT ec_orders_shipping_address_fkey REFERENCES users (), CONSTRAINT ec_orders_voided_by_fkey REFERENCES users (), CONSTRAINT ec_orders_user_session_id_fkey REFERENCES users (), CONSTRAINT ec_orders_user_id_fkey REFERENCES users (), CONSTRAINT ec_orders_saved_p REFERENCES users (), CONSTRAINT ec_orders_pkey REFERENCES users (), CONSTRAINT ec_orders_creditcard_id_fkey REFERENCES users (), CONSTRAINT ec_orders_voided_by_fkey REFERENCES ec_user_sessions (), CONSTRAINT ec_orders_user_session_id_fkey REFERENCES ec_user_sessions (), CONSTRAINT ec_orders_user_id_fkey REFERENCES ec_user_sessions (), CONSTRAINT ec_orders_shipping_address_fkey REFERENCES ec_user_sessions (), CONSTRAINT ec_orders_saved_p REFERENCES ec_user_sessions (), CONSTRAINT ec_orders_pkey REFERENCES ec_user_sessions (), CONSTRAINT ec_orders_creditcard_id_fkey REFERENCES ec_user_sessions (), CONSTRAINT ec_orders_voided_by_fkey REFERENCES users (), CONSTRAINT ec_orders_user_session_id_fkey REFERENCES users (), CONSTRAINT ec_orders_user_id_fkey REFERENCES users (), CONSTRAINT ec_orders_shipping_address_fkey REFERENCES users (), CONSTRAINT ec_orders_saved_p REFERENCES users (), CONSTRAINT ec_orders_pkey REFERENCES users (), CONSTRAINT ec_orders_creditcard_id_fkey REFERENCES users () ); CREATE INDEX ec_orders_by_addr_idx ON ec_orders (shipping_address); CREATE INDEX ec_orders_by_conf_idx ON ec_orders (confirmed_date); CREATE INDEX ec_orders_by_credit_idx ON ec_orders (creditcard_id); CREATE INDEX ec_orders_by_state_idx ON ec_orders (order_state); CREATE INDEX ec_orders_by_user_idx ON ec_orders (user_id); CREATE INDEX ec_orders_by_user_sess_idx ON ec_orders (user_session_id); CREATE TRIGGER RI_ConstraintTrigger_a_341702 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341703 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341832 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341833 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341857 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341858 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341882 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341883 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341912 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341913 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341954 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341955 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341959 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341960 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341964 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341965 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341969 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341970 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341974 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341975 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341987 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341988 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342142 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342143 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342212 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342213 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to ec_orders: --ec_automatic_email_log(ec_orders_creditcard_id_fkey) --ec_automatic_email_log(ec_orders_pkey) --ec_automatic_email_log(ec_orders_saved_p) --ec_automatic_email_log(ec_orders_shipping_address_fkey) --ec_automatic_email_log(ec_orders_user_id_fkey) --ec_automatic_email_log(ec_orders_user_session_id_fkey) --ec_automatic_email_log(ec_orders_voided_by_fkey) --ec_customer_service_issues(ec_orders_creditcard_id_fkey) --ec_customer_service_issues(ec_orders_pkey) --ec_customer_service_issues(ec_orders_saved_p) --ec_customer_service_issues(ec_orders_shipping_address_fkey) --ec_customer_service_issues(ec_orders_user_id_fkey) --ec_customer_service_issues(ec_orders_user_session_id_fkey) --ec_customer_service_issues(ec_orders_voided_by_fkey) --ec_financial_transactions(ec_orders_creditcard_id_fkey) --ec_financial_transactions(ec_orders_pkey) --ec_financial_transactions(ec_orders_saved_p) --ec_financial_transactions(ec_orders_shipping_address_fkey) --ec_financial_transactions(ec_orders_user_id_fkey) --ec_financial_transactions(ec_orders_user_session_id_fkey) --ec_financial_transactions(ec_orders_voided_by_fkey) --ec_gift_certificate_usage(ec_orders_creditcard_id_fkey) --ec_gift_certificate_usage(ec_orders_pkey) --ec_gift_certificate_usage(ec_orders_saved_p) --ec_gift_certificate_usage(ec_orders_shipping_address_fkey) --ec_gift_certificate_usage(ec_orders_user_id_fkey) --ec_gift_certificate_usage(ec_orders_user_session_id_fkey) --ec_gift_certificate_usage(ec_orders_voided_by_fkey) --ec_items(ec_orders_creditcard_id_fkey) --ec_items(ec_orders_pkey) --ec_items(ec_orders_saved_p) --ec_items(ec_orders_shipping_address_fkey) --ec_items(ec_orders_user_id_fkey) --ec_items(ec_orders_user_session_id_fkey) --ec_items(ec_orders_voided_by_fkey) --ec_problems_log(ec_orders_creditcard_id_fkey) --ec_problems_log(ec_orders_pkey) --ec_problems_log(ec_orders_saved_p) --ec_problems_log(ec_orders_shipping_address_fkey) --ec_problems_log(ec_orders_user_id_fkey) --ec_problems_log(ec_orders_user_session_id_fkey) --ec_problems_log(ec_orders_voided_by_fkey) --ec_refunds(ec_orders_creditcard_id_fkey) --ec_refunds(ec_orders_pkey) --ec_refunds(ec_orders_saved_p) --ec_refunds(ec_orders_shipping_address_fkey) --ec_refunds(ec_orders_user_id_fkey) --ec_refunds(ec_orders_user_session_id_fkey) --ec_refunds(ec_orders_voided_by_fkey) --ec_shipments(ec_orders_creditcard_id_fkey) --ec_shipments(ec_orders_pkey) --ec_shipments(ec_orders_saved_p) --ec_shipments(ec_orders_shipping_address_fkey) --ec_shipments(ec_orders_user_id_fkey) --ec_shipments(ec_orders_user_session_id_fkey) --ec_shipments(ec_orders_voided_by_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
