Revision: 5864
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at April 9, 2008 07:51 by tclancy
Initial Code
CREATE TABLE /*!32312 IF NOT EXISTS*/ `raw_zips` ( `detail_cd` char(5) default NULL, `zip_code` varchar(10) NOT NULL, `city_st_key` varchar(20) default NULL, `zip_class` char(5) default NULL, `city_st_name` varchar(200) default NULL, `city_abbreviation` varchar(50) default NULL, `fac_cd` char(5) default NULL, `mail_name` varchar(50) default NULL, `ll_city_key` varchar(20) default NULL, `ll_city` varchar(200) default NULL, `city_delv` char(5) default NULL, `crrt_mail` char(5) default NULL, `unique_zip` varchar(10) default NULL, `fin_no` varchar(10) default NULL, `state` char(3) default NULL, `fips` tinyint(3) unsigned default NULL, `county` varchar(200) default NULL, `latitude` double default NULL, `longitude` double default NULL, `area_code` varchar(3) default NULL, `t_z` tinyint(4) default NULL, `elevation` int(11) default NULL, `perns_hous` varchar(50) default NULL, `population_2000` double unsigned default NULL, `area_square_miles` double unsigned default NULL, `households` int(10) unsigned default NULL, `white` int(10) unsigned default NULL, `black` int(10) unsigned default NULL, `hispanic` int(10) unsigned default NULL, `household_income` double unsigned default NULL, `house_value` varchar(50) default NULL, KEY `zip_code` (`zip_code`) ) TYPE=InnoDB /*!40100 DEFAULT CHARSET=latin1*/;
Initial URL
Initial Description
Initial Title
MySQL Zip Code Table Structure
Initial Tags
mysql
Initial Language
MySQL