Hello
I need help with the data model of a basic geographic structure
Country State/Region Sub-Region
Most of the countries have a 3 level, so i want to do this
_________
Country
contry_id
....
_________
Region
region_id
country_id
.....
__________
Sub-region
sub_region_id
region_id
_________
Client
client_id
sub_region_id
My Question:
Some countries do no have 3rd level (Sub-region) what is the best way to
manage this when normaly my Client table needs to be linked to the 3er
level data (sub_region_id)
Thank you, any tips will be appreciated
Dario