basic geographic structure
От
Dario Borda
Тема
basic geographic structure
Дата
Msg-id
20060915182831.60841.qmail@web58402.mail.re3.yahoo.com
Список
Дерево обсуждения
basic geographic structure Dario Borda <gato_nemo@yahoo.com>
Re: basic geographic structure "Brandon Aiken" <BAiken@winemantech.com>
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
Stay in the know. Pulse on the new Yahoo.com. Check it out.
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
Stay in the know. Pulse on the new Yahoo.com. Check it out.
В списке pgsql-general по дате отправления
