I have a question regarding a db I am design for an ecomm application.
I just want to know if I am on the right lines really.
I need to display product with various options. e.g A desk in 4 different sizes with each size being a different price.
I have set up the following tables.
Products, product_options, prices and main.
Products holds the generic info ie name, description.
Product_options holds the sizes
Prices hold the different prices for each size
and main links all tables together (product_id,Product_options_id,price_id)
Have I done this right? or can you experts point me in the right direction or suggest a better way.
Many thanks in advance for your help and expertise.