数据表:ims_yz_sell_award_log(销售奖励-奖励数据表)。
| 字段 | 类型 | 默认值 | 约束 | 说明 |
|---|---|---|---|---|
id | integer unsigned | - | 非空、自增 | |
uniacid | integer | 0 | - | 公众号id |
uid | integer | 0 | - | 获得奖励的会员id |
buy_uid | integer | 0 | - | 下单的会员id |
activity_id | integer | 0 | - | 活动id |
order_id | integer | 0 | - | 订单id |
order_sn | string(100) | 0 | - | 订单编号 |
order_price | decimal | 0.00 | - | 订单金额 |
goods_id | integer | 0 | - | 商品id |
goods_title | string(255) | 0 | - | 商品名称 |
goods_thumb | string(255) | 0 | - | 商品图片 |
ratio | decimal | 0.00 | - | 奖励比例 |
time | integer | 0 | - | 第几次奖励 |
amount | decimal | 0.00 | - | 奖励金额 |
coupon_id | integer | 0 | - | 奖励优惠券id |
coupon_name | string(255) | 0 | - | 奖励优惠券名称 |
created_at | integer | - | - | |
updated_at | integer | - | - | |
deleted_at | integer | - | - |
