-- -- This is the United States county code table from the US Census Bureau -- CREATE TABLE us_counties ( -- -- State FIPS code. -- fips_state_code char(2) NOT NULL, -- -- County FIPS code. -- fips_county_code char(6) NOT NULL, -- -- Name. Includes name of county. Counties don't nave a type, but do have -- the word "County" as part of the name. -- name varchar(100) NOT NULL, -- -- State abbreviations. -- state_abbrev char(2), -- -- Total population (1990). -- population numeric(65535, 65531), -- -- Housing units (1990). -- housing_units numeric(65535, 65531), -- -- Land are included (in thousandths of a square kilometer). -- land_area numeric(65535, 65531), -- -- Water area included (in thousandths of a square kilometer). -- water_area numeric(65535, 65531), -- -- Longitude (millionths of a degree, + or - denoting N or S, -- respectively. -- latitude numeric(65535, 65531), -- -- Latitude (millionths of a degree, + or - denoting N or S, -- respectively. -- longitude numeric(65535, 65531), PRIMARY KEY (fips_state_code,fips_county_code), CONSTRAINT us_counties_fips_fk REFERENCES us_states (), CONSTRAINT us_counties_state_abrrev_fk REFERENCES us_states (), CONSTRAINT us_counties_unique_fips_pk REFERENCES us_states (), CONSTRAINT us_counties_unique_fips_pk REFERENCES us_states (), CONSTRAINT us_counties_fips_fk REFERENCES us_states (), CONSTRAINT us_counties_state_abrrev_fk REFERENCES us_states () ); CREATE TRIGGER RI_ConstraintTrigger_c_343024 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343025 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343029 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343030 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 319,488 bytes -- Table rows: 3,141
Begin main content
