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 |