vsl_store_goods
数据库字典/vsl_store_goods/门店商品表
| 字段名 |
数据类型 |
允许为空 |
描述 |
| id |
int(10) unsigned |
NO |
表序号 |
| goods_id |
int(10) unsigned |
NO |
商品id |
| shop_id |
int(10) unsigned |
NO |
店铺id |
| store_id |
int(10) unsigned |
NO |
门店id |
| website_id |
int(10) unsigned |
NO |
平台id |
| goods_name |
varchar(50) |
NO |
商品名称 |
| category_id |
int(10) unsigned |
NO |
商品分类id |
| category_id_1 |
int(10) unsigned |
NO |
一级分类id |
| category_id_2 |
int(10) unsigned |
NO |
二级分类id |
| category_id_3 |
int(10) unsigned |
NO |
三级分类id |
| price |
decimal(10,2) |
NO |
商品原价格 |
| market_price |
decimal(10,2) |
NO |
市场价 |
| picture |
int(11) unsigned |
NO |
商品主图 |
| bar_code |
varchar(50) |
YES |
商品条形码 |
| state |
tinyint(2) unsigned |
NO |
商品状态，0下架，1上架 |
| sales |
int(10) unsigned |
NO |
销量 |
| stock |
int(10) unsigned |
NO |
商品库存 |
| img_id_array |
varchar(32) |
YES |
商品图片序列 |
| create_time |
int(11) unsigned |
YES |
商品添加时间 |
