Re: standard schemas for addresses, others?
От | Peter Eisentraut |
---|---|
Тема | Re: standard schemas for addresses, others? |
Дата | |
Msg-id | Pine.LNX.4.44.0301231943540.789-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | standard schemas for addresses, others? (Dennis Gearon <gearond@cvc.net>) |
Ответы |
Re: standard schemas for addresses, others?
|
Список | pgsql-general |
Dennis Gearon writes: > Are there any sites with 'standard schemas' for certain, repetitive > database needs? For example, addresses and their components. Does anyone > have a schema for addresses that will work for the USA *AND* internation > addresses? No chance. You need to cut a compromise between structure and flexibility. If you just want to save, say, shipping addresses, then make them free text -- person name, address information, country. (Possibly divide the address information into street'ish and city'ish, but that's already pushing it.) If you need the addresses to be structured so you can do data analysis then you need to define your actual needs. Probably you don't have customers *everywhere*. -- Peter Eisentraut peter_e@gmx.net
В списке pgsql-general по дате отправления: