Hi Everyone,

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.

Based on the information given I'd say you have twice as many tables as you need. You just need:

products - name, description
product_options - size, price

Thanks Tony. I guess I got a bit carried away with too many tables.