[PHP] B2B2C product module database design, forum database design, system database design oracle database design

goods_common (public goods table)

The difference between specifications and attributes is that specifications affect the price, attributes do not affect the price. On the product classification page, there is attribute filtering

Specification name field

Serialize the specification name array and store it in this Field

For example: Array ([1] => color),

key corresponds to the id of the specification table, and value corresponds to the name of the specification table

Specification value field

serializes the value array corresponding to the specification name Store this field

For example: Array ( [1] => Array ( [222] => Blue [224] => Green [225] => Plum Red [226] => Black) ) ,

The key of the first dimension corresponds to the specification table id, the key of the two-dimensional array corresponds to the id of the specification value table, and the value corresponds to the name of the specification value table

Commodity attributes

For example: Array ( [206] => Array ( [name] => Style [3050] => Sweater) [207] => Array ( [name] => Material [3059] => Cotton))

The key of the one-dimensional array corresponds to the attribute The id of the table, the name of the two-dimensional array corresponds to the name of the attribute table, the second element key of the two-dimensional array corresponds to the attribute value table id, and the value corresponds to the name of the attribute value table

Commodity public id

Product name

Product promotion Word

Product category id

Product category name ————Moderate redundancy, reduce the association table

Store id

Store name ————More redundancy, reduce the association table

Brand id

Brand name

Type id    ———Associate the type table and associate the attributes under the type

Product main image     ———Only save the file name of the uploaded image, the full path is spliced ​​through the program, more flexible

Product content

Product Status    ———0 Removed, 1 Normal

Reason for violation

Product review

Reason for review failure

Product lock

Product addition time

Product shelf time

Product price

Market price

Cost price

Discount

Merchant custom number

Freight rate template

Freight rate template name

Is it recommended?

Is free shipping?

Is a VAT invoice issued?

First-level region id

Second-level region id

Store classification The first and last id are separated by,

Top related layout

Bottom related layout

goods (product master table)

Add products of different specifications and generate multiple product information, sku is different,

product SKUid

product Public id

Product name (+ specification name)

Product promotion words

Store id

Store name

Product category id

Product brand ID

Product price

Market price

Merchant custom number

Click quantity

Sales quantity

Collection quantity

Product specification serialization, for example: Array ([222] => blue)

Product inventory

Product main image

Product status

Product review status

Product addition time

Product editing time

First-level region ID

Second-level region ID

Color specification ID

Shipping template ID

Is it recommended?

Is free shipping

Is a VAT invoice issued?

Store classification Use id first and last, separated

good reviews

number of reviews

spec (product specification table)

specification id

specification name

specification sorting

category id

category name

spec_value (product specification value Table)

Specification value id

Specification value name

Specification id

Classification id

Store id

Specification color

Sort

attribute (product attribute table)

Attribute id

Attribute name

Type Id

attribute value column

whether to display

sort

attribute_value (product attribute value table)

attribute value id

attribute value name

attribute id

type id

attribute value sort

category (product Category table)

category id

category name

type id

type name

parent id

sort

title

keyword

description

type (product type table)

type id

Type name

Sort

Category id

Category name

The above introduces the [PHP] B2B2C product module database design, including database design and b2b2c content. I hope it will be helpful to friends who are interested in PHP tutorials.