[thelist] DB Schema Design

[Christie Mason]

I like the single table idea as long as you have some type of field, sounds
like that may be class, to filter the entries for selects and validation by
its appropriate application.

Maintaining 17 different lookup tables would be an admin nightmare.

I know "name" is reserved for some types of dbs, I wonder if "class" is also
reserved.  You may want to check that out before you name your field/columns
using those terms.

Christie Mason

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org]On Behalf Of Hershel Robinson
Sent: Sunday, May 07, 2006 10:27 AM
To: Thelist
Subject: [thelist] DB Schema Design

Any opinions on which of the above approaches seems better? That is, to
use one large table for all statuses or 18 small tables, one for each
type of entity, each not then requiring a class field.

Thanks,
Hershel