| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | "PostgreSQL-General-List (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | standard schemas for addresses, others? |
| Date: | 2003-01-22 22:18:47 |
| Message-ID: | DYT8396QLEBXDBNKGCNWTPKTP52K.3e2f18c7@cal-lab |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
entities
----------
Countries
States
Counties
Cities
street addresess.
Postal Codes
Some rules:
-------------
A/ Do duplicate countries
B/ No duplicate states in Countries
(states seem only to exist in 'Federal' governments)
C/ No duplicate postal codes in Countries
D/ Duplicate cities are allowed in Countries,
and in the world.
E/ Duplicate cities are allowed in States.
F/ Cities can have multiple postal codes
G/ Postal codes are assigned to only one city.
H/ Postal codes are assigned to counties.
I/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Medi Montaseri | 2003-01-22 22:20:43 | When to Vacuum |
| Previous Message | Eric B.Ridge | 2003-01-22 22:15:44 | Re: agregates |