-- -- This is the US states table. -- CREATE TABLE us_states ( -- -- This is the 2 letter abbreviation for states. -- abbrev char(2) PRIMARY KEY NOT NULL, state_name varchar(100) NOT NULL, -- -- The FIPS code used by the USPS for certain delivery types. -- fips_state_code char(2) ); CREATE UNIQUE INDEX us_states_fips_state_code_uq ON us_states (fips_state_code); CREATE UNIQUE INDEX us_states_state_name_uq ON us_states (state_name); CREATE TRIGGER RI_ConstraintTrigger_a_341677 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341678 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342167 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342168 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342182 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342183 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342202 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342203 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343022 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343023 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343027 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343028 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to us_states: --ec_addresses(us_states_abbrev_pk) --ec_retailer_locations(us_states_abbrev_pk) --ec_retailers(us_states_abbrev_pk) --ec_sales_tax_by_state(us_states_abbrev_pk) --us_counties(us_states_abbrev_pk) -- Table size: 8,192 bytes -- Table rows: 69
Begin main content
