CREATE TABLE ec_retailer_locations ( retailer_location_id integer PRIMARY KEY NOT NULL, retailer_id integer NOT NULL, location_name varchar(300), primary_contact_name varchar(100), secondary_contact_name varchar(100), primary_contact_info varchar(4000), secondary_contact_info varchar(4000), line1 varchar(100), line2 varchar(100), city varchar(100), usps_abbrev char(2), zip_code varchar(10), phone varchar(30), fax varchar(30), country_code char(2), url varchar(200), financing_policy varchar(4000), return_policy varchar(4000), price_guarantee_policy varchar(4000), delivery_policy varchar(4000), installation_policy varchar(4000), last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_retailer_locations_last_modifying_user_fkey REFERENCES countries (), CONSTRAINT ec_retailer_locations_pkey REFERENCES countries (), CONSTRAINT ec_retailer_locations_usps_abbrev_fkey REFERENCES countries (), CONSTRAINT ec_retailer_locations_country_code_fkey REFERENCES countries (), CONSTRAINT ec_retailer_locations_retailer_id_fkey REFERENCES countries (), CONSTRAINT ec_retailer_locations_pkey REFERENCES users (), CONSTRAINT ec_retailer_locations_country_code_fkey REFERENCES users (), CONSTRAINT ec_retailer_locations_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_retailer_locations_retailer_id_fkey REFERENCES users (), CONSTRAINT ec_retailer_locations_usps_abbrev_fkey REFERENCES users (), CONSTRAINT ec_retailer_locations_usps_abbrev_fkey REFERENCES ec_retailers (), CONSTRAINT ec_retailer_locations_retailer_id_fkey REFERENCES ec_retailers (), CONSTRAINT ec_retailer_locations_pkey REFERENCES ec_retailers (), CONSTRAINT ec_retailer_locations_last_modifying_user_fkey REFERENCES ec_retailers (), CONSTRAINT ec_retailer_locations_country_code_fkey REFERENCES ec_retailers (), CONSTRAINT ec_retailer_locations_usps_abbrev_fkey REFERENCES us_states (), CONSTRAINT ec_retailer_locations_country_code_fkey REFERENCES us_states (), CONSTRAINT ec_retailer_locations_last_modifying_user_fkey REFERENCES us_states (), CONSTRAINT ec_retailer_locations_pkey REFERENCES us_states (), CONSTRAINT ec_retailer_locations_retailer_id_fkey REFERENCES us_states () ); CREATE TRIGGER ec_retailer_locations_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_retailer_locations_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341947 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341948 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342154 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342155 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342159 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342160 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342164 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342165 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342169 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342170 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_retailer_locations: --ec_offers(ec_retailer_locations_country_code_fkey) --ec_offers(ec_retailer_locations_last_modifying_user_fkey) --ec_offers(ec_retailer_locations_pkey) --ec_offers(ec_retailer_locations_retailer_id_fkey) --ec_offers(ec_retailer_locations_usps_abbrev_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
