CREATE TABLE ec_addresses ( address_id integer PRIMARY KEY NOT NULL, user_id integer NOT NULL, address_type varchar(20) NOT NULL, attn varchar(100), line1 varchar(100), line2 varchar(100), city varchar(100), usps_abbrev char(2), zip_code varchar(10), phone varchar(30), country_code char(2), full_state_name varchar(30), phone_time varchar(10), CONSTRAINT ec_addresses_country_code_fkey REFERENCES countries (), CONSTRAINT ec_addresses_pkey REFERENCES countries (), CONSTRAINT ec_addresses_user_id_fkey REFERENCES countries (), CONSTRAINT ec_addresses_usps_abbrev_fkey REFERENCES countries (), CONSTRAINT ec_addresses_usps_abbrev_fkey REFERENCES users (), CONSTRAINT ec_addresses_user_id_fkey REFERENCES users (), CONSTRAINT ec_addresses_pkey REFERENCES users (), CONSTRAINT ec_addresses_country_code_fkey REFERENCES users (), CONSTRAINT ec_addresses_usps_abbrev_fkey REFERENCES us_states (), CONSTRAINT ec_addresses_country_code_fkey REFERENCES us_states (), CONSTRAINT ec_addresses_pkey REFERENCES us_states (), CONSTRAINT ec_addresses_user_id_fkey REFERENCES us_states () ); CREATE INDEX ec_addresses_by_user_idx ON ec_addresses (user_id); CREATE TRIGGER RI_ConstraintTrigger_c_341669 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341670 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341674 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341675 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341679 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341680 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341767 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341768 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341957 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341958 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342207 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342208 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to ec_addresses: --ec_creditcards(ec_addresses_country_code_fkey) --ec_creditcards(ec_addresses_pkey) --ec_creditcards(ec_addresses_user_id_fkey) --ec_creditcards(ec_addresses_usps_abbrev_fkey) --ec_orders(ec_addresses_country_code_fkey) --ec_orders(ec_addresses_pkey) --ec_orders(ec_addresses_user_id_fkey) --ec_orders(ec_addresses_usps_abbrev_fkey) --ec_shipments(ec_addresses_country_code_fkey) --ec_shipments(ec_addresses_pkey) --ec_shipments(ec_addresses_user_id_fkey) --ec_shipments(ec_addresses_usps_abbrev_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
