Re: standard schemas for addresses, others?
От | Dennis Gearon |
---|---|
Тема | Re: standard schemas for addresses, others? |
Дата | |
Msg-id | D42RQE9ICTRA7XWHEE0NTOPOUT9GA.3e3086d8@cal-lab обсуждение исходный текст |
Ответ на | Re: standard schemas for addresses, others? (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-general |
Oh, but I WANT customers everywhere, and .... my money for nothing and my chicks for free of course! Just trying to plan ahead for when I can hire everyone else on this list! I guess I've been spending too much time next to a monitor :-) 1/23/2003 3:30:49 PM, Peter Eisentraut <peter_e@gmx.net> wrote: >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 по дате отправления: