Field Name

Primary key or not

Field Type

Number of bytes occupied

Whether empty is allowed

Description

goods_sku_id

Y

int

11

Primary key product specification id, self-incrementing

goods_id

int

11

Product id

spec_sku_id

varchar

255

Product SKU record index

image_id

int

11

Image id

goods_no

varchar

100

Item number

goods_price

decimal

10

Product prices

line_price

int

10

Product Line Price

stock_num

int

11

Inventory

goods_sales

int

11

Sales

goods_weight

double

11

Net weight