Home >Backend Development >PHP Tutorial >[PHP] B2B2C product module database design, forum database design, system database design oracle database design
[PHP] B2B2C product module database design, forum database design, system database design oracle database design
- WBOYOriginal
- 2016-07-29 08:52:561541browse
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.