[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