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@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
>
>