so i been developing an e-commerce website and i been thinking about how to handle product option like color and size, so my approach is this!
Table Structure
Products Option Table ===> product_id / p_option_price / p_option_stock
Option Table ===> id / type(color-size)
Option Value Table ==> option_id / name(red,small,large) / image
Option Product Pivot table ==> product_id / option_value_id
Relationships
A product hasMany ProductOption
ProductOption hasMany OptionValues and OptionValues hasMany ProductOptions with Pivot table option products
Option hasMany OptionValues
My only issue is that the option value table will have a lot of duplicate value cause i will be adding each products values name and image into that table!
Is this a good structure for future flexibility?
I have done it into an my avored e commerce.
I have an attributes tables which contains just the attributes of an product. another tables based on attribute values. product_attribute_varchar, product_attribute_integer and etc.
take a look at my migration file i hope it helps to understand.
Please or to participate in this conversation.