[thelist] DB question: product attributes

Erik Mattheis gozz at gozz.com
Thu Apr 25 22:24:01 CDT 2002


At 10:45 PM -0400 4/25/02, Warden, Matt wrote:
>ProductAttr
>-------------
>ProductAttr_ID
>Product_ID
>Name
>
>
>ProductAttrValue
>-------------
>ProductAttrValue_ID
>ProductAttr_ID
>Value

>
>that help?

Yes. Exactly what I couldn't think of myself ... I had one table:

attributes
----------
attribute_id
attribute_name
attribute_value

and a lookup table:

product_attributes_lookup
-------------------------
lookup_id
product_id
attribute_id

I knew there was a simpler solution. Thanks.
--

__________________________________________
- Erik Mattheis

(612) 377 2272
http://goZz.com/

__________________________________________



More information about the thelist mailing list