An ALTERNATE DATA MODEL FOR ZIP CODES IN MEXICO
Back to the Data Model
When you look at the Tables for Cities, Counties, States and so on, you can see that they all have a similar structure.
Therefore they can be stored in the same Table, with just a 'Level' to differentiate them.
This diagram shows an alternate version which stores all details for everything except Settlements in one Table.
Settelements are different because they have Settlement Types.
© DataBaseAnswers.org 2008