standard schemas for addresses, others?

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: Raw Message | Whole Thread | 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/

Responses

Browse pgsql-general by date

  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