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,