Re: standard schemas for addresses, others?

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