I am downloading the SEPOMEX database to use it in one of my applications, the question is that they ask me to break down the structure of that database. In my first image I show the fields that I am going to take from the database (highlighted blue) and in the second image I show the structure that according to me has the database.
The truth is that I have doubts about how to relate City and Municipality with the State table since in each state the municipality code and city code are reset (that is, they start with 01, 02, 03 .., and so on) . Any suggestions you can give me, thanks in advance.
