电子商务mysql设计_设计电子商务数据库 – MySQL

我正在做一个电子商务项目,并对存储产品的数据库设计感到困惑.我推测有三种方法可以制作数据库：

1.

每个产品类别可以有单独的表.

Table: Categories

------------------

cat_ID

cat_name

Table: Sub_Categories

---------------------

sub_cat_ID

categories_cat_ID

sub_cat_name

Table: Books

-------------

book_ID

sub_categories_sub_cat_ID

book_title

book_author

book_ISBN

book_price

etc

Table: Clothes

---------------

clothes_ID

sub_categories_sub_cat_ID

clothes_name

clothes_color

clothes_size

clothes_description

clothes_price

etc

Table: Perfumes

----------------

perfumes_ID

sub_categories_sub_cat_ID

perfume_name

perfume_size

perfume_weight

perfume_description

perfume_price

etc

2.

将所有产品组合在一个表中,并允许某些值为null

Table: Categories

------------------

cat_ID

cat_name

Table: Sub_Categories

---------------------

sub_cat_ID

categories_cat_ID

sub_cat_name

Table: Products

---------------

product_ID

sub_categories_sub_cat_ID

title

description

price

author (can be null for everything except books)

size

weight (can be null for everything except perfumes)

ISBN (can be null for everything except books)

color (can be null for everything except clothes)

etc

3.

将类似的列字段组合在一个名为products的表中,并为特定数据提供单独的表.

Table: Categories

------------------

cat_ID

cat_name

Table: Sub_Categories

---------------------

sub_cat_ID

categories_cat_ID

sub_cat_name

Table: Products

----------------

product_ID

sub_categories_sub_cat_ID

title

description

price

Table: Books

-------------

products_product_id

sub_categories_sub_cat_ID

author

publisher

ISBN

Table: Perfumes

----------------

products_product_id

sub_categories_sub_cat_ID

size

weight

Table: Clothes

--------------

products_product_id

sub_categories_sub_cat_ID

color

size (this can be a one to many relationship to cater to multiple sizes of one product?)

我非常感谢启蒙,谢谢