Return to Snippet

Revision: 5864
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