[thelist] Database schema
Williams, Olwen - SAL
Olwen.Williams at safeair.co.nz
Tue Dec 9 19:40:39 CST 2003
I'd be inclined to use an attribute type matrix.
A one to may relationship of product type to attribute type, with the
corresponding structure of products to product attributes.
Olwen Williams
olwen.williams at safeair.co.nz
-----Original Message-----
From: Ed McCarroll [mailto:Ed at ComSimplicity.com]
Sent: Wednesday, December 10, 2003 10:16 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Database schema
> 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
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
____________________________________________________________________
CAUTION - This message may contain privileged and confidential
information intended only for the use of the addressee named above.
If you are not the intended recipient of this message you are hereby
notified that any use, dissemination, distribution or reproduction
of this message is prohibited. If you have received this message in
error please notify Safe Air Ltd immediately. Any views expressed
in this message are those of the individual sender and may not
necessarily reflect the views of Safe Air.
_____________________________________________________________________
For more information on the Safe Air Group, visit us online
at http://www.safeair.co.nz/
_____________________________________________________________________
More information about the thelist
mailing list