[thelist] Database schema

Ed McCarroll Ed at ComSimplicity.com
Tue Dec 9 15:16:04 CST 2003


> Right now I've stored all the product specific fields in the products
> table and prefixed them with the name of the category they refer to.
> Is this a good approach or should I put them in separate tables? The
> table is getting pretty unmanageable already.

It depends upon what you're doing with the data, but I'd be inclined to
set up one table for each category.  IMO, a good schema is one that
accurately models the real world, and CPUs and hard drives aren't
really the same kind of things.

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                               MailTo:Ed at ComSimplicity.com
ComSimplicity                                           (310) 838-4330
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



More information about the thelist mailing list