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 |