zip

zip — Global. ZIP Code table used to validate and auto-complete user-entered location data. More data can be found in the (redundant) table zips, which was imported later.

zip

Column name Type Null Default Description
zip varchar(5)   ZIP Code
state char(2)   State code (see codes for how to turn this into a full state name)
city varchar(100)   City name
Key name Type Column(s)
PRIMARY PRIMARY
state INDEX