[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