Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005

    E-Commerce Table Structure

    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.

  2. #2
    Join Date
    Sep 2002
    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

  3. #3
    Join Date
    Apr 2005
    Thanks Tony. I guess I got a bit carried away with too many tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts