zip

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.

zip

Column nameTypeNullDefaultDescription
zipvarchar(5)ZIP Code
statechar(2)State code (see codes for how to turn this into a full state name)
cityvarchar(100)City name
Key nameTypeColumn(s)
PRIMARYPRIMARY
stateINDEX