[thelist] Database schema

[Williams, Olwen - SAL]

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/ 
_____________________________________________________________________