City

[drewroberts]

Model & table migration for Cities. ZIP Codes #17 will have primary and multiple secondary options for Cities. Need to pull this list of unique US City names and store them in the https://github.com/tipoff/address database and API.

[arwaawan3]

So states have a one to many relationship with zip codes and cities also have a one to many relationship with zip codes. Little unclear on the "multiple secondary options for cities" part.

[drewroberts]

Let's just create a many-to-many relationship with Cities & ZIP's (#17) and on that pivot table, add a boolean field for primary so we can mark if a city name is the primary one for the ZIP Code.

[drewroberts]

I'm making a big change to this model. City will now include the State (#16) and be an actual list of every US City for Domestic Addresses (#19). It will no longer be a list of unique City names. We'll have to get a different solution for Cities when we add Foreign Addresses (#51) since this table will only be for US Cities.