CREATE TABLE ec_shipments ( shipment_id integer PRIMARY KEY NOT NULL, order_id integer NOT NULL, address_id integer, shipment_date timestamptz NOT NULL, expected_arrival_date timestamptz, carrier varchar(50), tracking_number varchar(24), actual_arrival_date timestamptz, actual_arrival_detail varchar(4000), shippable_p bool DEFAULT true, last_modified timestamptz, last_modifying_user integer, modified_ip_address varchar(20), CONSTRAINT ec_shipments_address_id_fkey REFERENCES ec_addresses (), CONSTRAINT ec_shipments_order_id_fkey REFERENCES ec_addresses (), CONSTRAINT ec_shipments_pkey REFERENCES ec_addresses (), CONSTRAINT ec_shipments_pkey REFERENCES ec_orders (), CONSTRAINT ec_shipments_address_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_shipments_order_id_fkey REFERENCES ec_orders () ); CREATE INDEX ec_shipments_by_order_id ON ec_shipments (order_id); CREATE INDEX ec_shipments_by_shipment_date ON ec_shipments (shipment_date); CREATE TRIGGER ec_shipment_address_update_tr BEFORE INSERT FOR EACH ROW EXECUTE PROCEDURE ec_shipment_address_update_tr (disabled) CREATE TRIGGER ec_shipments_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_shipments_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341707 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341708 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341872 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341873 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341927 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341928 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342209 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342210 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342214 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342215 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_shipments: --ec_automatic_email_log(ec_shipments_address_id_fkey) --ec_automatic_email_log(ec_shipments_order_id_fkey) --ec_automatic_email_log(ec_shipments_pkey) --ec_financial_transactions(ec_shipments_address_id_fkey) --ec_financial_transactions(ec_shipments_order_id_fkey) --ec_financial_transactions(ec_shipments_pkey) --ec_items(ec_shipments_address_id_fkey) --ec_items(ec_shipments_order_id_fkey) --ec_items(ec_shipments_pkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
