SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
-
Feb 10, 2006, 10:41 #1
- Join Date
- Feb 2006
- Posts
- 4
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
standard data model for ecommerce?
I know every ecommerce database schema is difference. But is there a typical data model we can follow? I just do not want to reinvent the wheel and want to get a semi-standard data model to jump start my database design.
To be a little specific about my current challenge:
1. how to classify one product into multiple categories.
2. how to handle different set of product specifications, should I create a separate table for each type of products, such as tblElectronics, tblClothes, tblBooks, etc.
Any references are welcome. Thanks.
-
Feb 10, 2006, 11:40 #2
- Join Date
- Feb 2006
- Location
- Pittsburgh, Los Angeles
- Posts
- 706
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
1. how to classify one product into multiple categories.
category_product
product id
category id
So for each product/category combo you'll have an entry in this table.
2. how to handle different set of product specifications, should I create a separate table for each type of products, such as tblElectronics, tblClothes, tblBooks, etc.
-
Feb 10, 2006, 12:25 #3
- Join Date
- Feb 2006
- Posts
- 4
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Have a category table and product table and then a table "inbetween" them with the form:
category_product
product id
category id
Often product specifications can be pinned to the categories they appear in...if not just make a product types table. Each product will then have a foreign key that points to the product type its a part of.
Bookmarks