Re: standard schemas for addresses, others?

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(at)gmx(dot)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(at)gmx(dot)net
>
>