MySQL Zip Code Table Structure


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



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. `county` varchar(200) default NULL,
  18. `latitude` double default NULL,
  19. `longitude` double default NULL,
  20. `area_code` varchar(3) default NULL,
  21. `t_z` tinyint(4) default NULL,
  22. `elevation` int(11) default NULL,
  23. `perns_hous` varchar(50) default NULL,
  24. `population_2000` double unsigned default NULL,
  25. `area_square_miles` double unsigned default NULL,
  26. `households` int(10) unsigned default NULL,
  27. `white` int(10) unsigned default NULL,
  28. `black` int(10) unsigned default NULL,
  29. `hispanic` int(10) unsigned default NULL,
  30. `household_income` double unsigned default NULL,
  31. `house_value` varchar(50) default NULL,
  32. KEY `zip_code` (`zip_code`)
  33. ) TYPE=InnoDB /*!40100 DEFAULT CHARSET=latin1*/;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.