Advanced Search

MySQL Zip Code Table Structure

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. CREATE TABLE /*!32312 IF NOT EXISTS*/ `raw_zips` (
  2.   `detail_cd` char(5) default NULL,
  3.   `zip_code` varchar(10) NOT NULL,
  4.   `city_st_key` varchar(20) default NULL,
  5.   `zip_class` char(5) default NULL,
  6.   `city_st_name` varchar(200) default NULL,
  7.   `city_abbreviation` varchar(50) default NULL,
  8.   `fac_cd` char(5) default NULL,
  9.   `mail_name` varchar(50) default NULL,
  10.   `ll_city_key` varchar(20) default NULL,
  11.   `ll_city` varchar(200) default NULL,
  12.   `city_delv` char(5) default NULL,
  13.   `crrt_mail` char(5) default NULL,
  14.   `unique_zip` varchar(10) default NULL,
  15.   `fin_no` varchar(10) default NULL,
  16.   `state` char(3) default NULL,
  17.   `fips` tinyint(3) unsigned default NULL,
  18.   `county` varchar(200) default NULL,
  19.   `latitude` double default NULL,
  20.   `longitude` double default NULL,
  21.   `area_code` varchar(3) default NULL,
  22.   `t_z` tinyint(4) default NULL,
  23.   `elevation` int(11) default NULL,
  24.   `perns_hous` varchar(50) default NULL,
  25.   `population_2000` double unsigned default NULL,
  26.   `area_square_miles` double unsigned default NULL,
  27.   `households` int(10) unsigned default NULL,
  28.   `white` int(10) unsigned default NULL,
  29.   `black` int(10) unsigned default NULL,
  30.   `hispanic` int(10) unsigned default NULL,
  31.   `household_income` double unsigned default NULL,
  32.   `house_value` varchar(50) default NULL,
  33.   KEY `zip_code` (`zip_code`)
  34. ) TYPE=InnoDB /*!40100 DEFAULT CHARSET=latin1*/;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.