Mall construction table (Part 2)

Product attribute table

php-attr

QQ截图20170624145646.png

##attr_name: attribute name

attr_type: Attribute type 0: Unique attribute 1: Single-select attribute

attr_values: Attribute value

type_id: Corresponding type id

Brand table

php_brand

品牌.png

##brand_name:Name

brand_logo:logo

brand_url:Link address

Inventory table

php_product

goods_id: Product ID

goods_number: Inventory quantity

goods_attr: Inventory attribute

Product List

##goods_name: Product name

##goods_sn: Product number

original: Original image

sm_thumb: Small thumbnail

mid_thumb: Medium thumbnail

##max_thumb: Large thumbnail

market_price: Market price

shop_price: Our store price

onsale: Whether to put on the shelves '1', '0'

cate_id: column

brand_id: Brand

type_id: Product type

##goods_desc:Detailed description

goods_weight: Product weight

weight_unit: Weight unit

addtime: Shelf time

updatetime: Modification time

Product picture table

php_goods_pic

##goods_id: product id

original: original product Image

max_thumb: Large thumbnail

sm_thumb: Small thumbnail

Continuing Learning

new file

submit Reset Code

Automatic operation

Mall construction table (Part 2)

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]