CREATE TABLE ec_retailers ( retailer_id integer PRIMARY KEY NOT NULL, retailer_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), reach varchar(15), url varchar(200), nexus_states 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_retailers_country_code_fkey REFERENCES countries (), CONSTRAINT ec_retailers_last_modifying_user_fkey REFERENCES countries (), CONSTRAINT ec_retailers_pkey REFERENCES countries (), CONSTRAINT ec_retailers_reach REFERENCES countries (), CONSTRAINT ec_retailers_usps_abbrev_fkey REFERENCES countries (), CONSTRAINT ec_retailers_country_code_fkey REFERENCES users (), CONSTRAINT ec_retailers_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_retailers_pkey REFERENCES users (), CONSTRAINT ec_retailers_reach REFERENCES users (), CONSTRAINT ec_retailers_usps_abbrev_fkey REFERENCES users (), CONSTRAINT ec_retailers_usps_abbrev_fkey REFERENCES us_states (), CONSTRAINT ec_retailers_country_code_fkey REFERENCES us_states (), CONSTRAINT ec_retailers_last_modifying_user_fkey REFERENCES us_states (), CONSTRAINT ec_retailers_pkey REFERENCES us_states (), CONSTRAINT ec_retailers_reach REFERENCES us_states () ); CREATE TRIGGER ec_retailers_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_retailers_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342162 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342163 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342174 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342175 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342179 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342180 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342184 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342185 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_retailers: --ec_retailer_locations(ec_retailers_country_code_fkey) --ec_retailer_locations(ec_retailers_last_modifying_user_fkey) --ec_retailer_locations(ec_retailers_pkey) --ec_retailer_locations(ec_retailers_reach) --ec_retailer_locations(ec_retailers_usps_abbrev_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
