while trying to design a database for shopping cart i encountered few problems which i am mentioning here.
I had hierarchical level of categories for products for which i designed table as:
Different products under different cateogries has different attributes ie for example products underid|title|parent_id
'Clothing' has different attributes than products under 'Music'. It means we cant have static form fields for attributes.I tried to
figure out this table for storing products attributes and values
I think this is bit tedious in retrieving and displaying the attribute name and its corrsponding form field type, and also tedious in dynamically inserting, updating etc operationsid|category_id|attribute_name|attribute_type
id|attribute_id|attribute_value
is there any effective methods for such case ??
I would really appreciate if there is alternative.
Thanks in advance for the comments and suggestions.