Re: [SQL] design resource

2008-06-06 Thread Craig Ringer
Steve Midgley wrote: However, normalizing country is generally pretty smart (as is normalizing state/admin region within countries where you do a lot of business). This can be generally handled on the front-end with a pull-down menu of choices, but you would probably be happiest enforcing thi

Re: [SQL] design resource

2008-06-06 Thread Steve Midgley
At 11:20 PM 6/5/2008, [EMAIL PROTECTED] wrote: Date: Thu, 5 Jun 2008 10:14:04 -0400 From: "Edward W. Rouse" <[EMAIL PROTECTED]> To: Subject: design resource Message-ID: <[EMAIL PROTECTED]> I was wondering if there were any resources that have some table designs for common problems. Since that

Re: [SQL] design resource

2008-06-05 Thread Craig Ringer
Edward W. Rouse wrote: I was wondering if there were any resources that have some table designs for common problems. Since that isn't very clear I will give an example. We have an internal app from years back that needs to be updated. One of the problems is that when it was originally created,

[SQL] design resource

2008-06-05 Thread Edward W. Rouse
I was wondering if there were any resources that have some table designs for common problems. Since that isn't very clear I will give an example. We have an internal app from years back that needs to be updated. One of the problems is that when it was originally created, the company only had US