advanced code snippet search

Posted By

tclancy on 04/09/08


Tagged

mysql db zipcodes


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

dantreacy
kubaitis
virendrakryadav


MySQL Zip Code Table Structure

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  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  

You need to login to post a comment.