|
![](/i/fill.gif) |
> 1 the main table contains the address itself, and pointers to the city,
> and the state tables.
>
> That's right, a row for every city, and a row for every state.
That seems fine to me, for one thing it avoids people making a typo on the
state, which makes doing things by state harder later on. Not so sure about
the city, I don't know how it works in the US, but in the UK you might not
officially be living in a city, and then your "city/town/village" table is
going to be HUGE with basically every little place in it, and there are
duplicates in different parts of the country!
Post a reply to this message
|
![](/i/fill.gif) |