Hi, I am having problem with desinging db structure for bundled products.
In my website I sell subscription and other products for subscribers.
Subscription has additional products in it included.
I defined subscriptions as a product with product_category = SUBSCRIPTION
Currently I have product and bundled_product tables:
product table has:
product_id
product_category_id
product_price
product_discount
date_added
....
bundled_product table has:
bundle_id
product_id
date_added
In this structure I am I have some questions:
1. Where the product price should be in? in product table or bundled_product table
2. To list products to users which table should I use product table or bundled_product table. because I also have single products.
If I do this I will need to add one row for single products;
3. should I add another cross relation table for relation between bundled_product and product table?
4. Lets say subscription bundle consists of product_type A, B, and C products (one from each product type). Lets say as promotion I want to add additional product type C to subscription. when there is 2 products with same type in bundled I need tell user which C product is MAIN product and which is PROMOTIONAL
I building this type of DB first time I cant decide how should I design my DB.
Thanks in advance...