数据表:ims_yz_aggregation_cps_equity_goods_sku。
| 字段 | 类型 | 默认值 | 约束 | 说明 |
|---|---|---|---|---|
id | integer unsigned | - | 非空、自增 | |
uniacid | integer | - | - | 公众号ID |
name | string(255) | - | - | 商品名称 |
logo | string(255) | - | - | 商品logo |
brand_id | integer | - | - | 品牌id |
category_id | integer | - | - | 分类id |
status | integer | - | - | 状态1上架2售罄 |
face_price | decimal | 0.00 | - | |
sale_price | decimal | 0.00 | - | |
cost_price | decimal | 0.00 | - | |
instruction | string(255) | 0 | - | |
use_notice | string(255) | 0 | - | |
type | integer | 0 | - | |
stock | integer | 0 | - | |
equity_id | integer | 0 | - | |
goods_id | integer | 0 | - | |
reward_point | decimal | 0.00 | - | |
reward_point1 | decimal | 0.00 | - | |
reward_point2 | decimal | 0.00 | - | |
reward_balance | decimal | 0.00 | - | |
reward_balance1 | decimal | 0.00 | - | |
reward_balance2 | decimal | 0.00 | - | |
created_at | integer | - | - | |
updated_at | integer | - | - | |
deleted_at | integer | - | - | |
b_id | integer | - | - |
