zip — ZIP Code table used to validate and auto-complete data that users enter about their location. More information can be found in the redudant table zips, which was imported later.
| 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 |