Standard schemas
| From: | Dennis Gearon | Date: | Wed, 22 Jan 2003 19:12:01 +0000 |
| Subject: | Standard schemas | ||
| Groups: | php.smarty.dev | ||
| Request: | Send a blank email to php-smarty-dev+get-593@lists.php.net to get a copy of this message | ||
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/