数据表:ims_yz_new_poster_award(新海报--奖励记录)。
| 字段 | 类型 | 默认值 | 约束 | 说明 |
|---|---|---|---|---|
id | integer | - | 非空、自增 | |
uniacid | integer unsigned | - | 非空 | |
poster_id | integer unsigned | - | 非空 | 海报id |
subscriber_memberid | integer unsigned | - | 非空 | 关注者会员id |
recommender_memberid | integer unsigned | - | 非空 | 推荐者会员id |
recommender_credit | integer unsigned | 0 | - | 推荐者获得积分 |
recommender_bonus | decimal unsigned | 0.00 | - | 推荐者获得金额 |
recommender_wechat_bonus | decimal unsigned | 0.00 | - | 推荐者获得微信金额 |
recommender_coupon_id | integer unsigned | 0 | - | 推荐者获得优惠券id |
recommender_coupon_num | integer unsigned | 0 | - | 推荐者获得优惠券数量 |
subscriber_credit | integer unsigned | 0 | - | 关注者获得积分 |
subscriber_bonus | decimal unsigned | 0.00 | - | 关注者获得金额 |
subscriber_wechat_bonus | decimal unsigned | 0.00 | - | 关注者获得微信金额 |
subscriber_coupon_id | integer unsigned | 0 | - | 关注者获得优惠券id |
subscriber_coupon_num | integer unsigned | 0 | - | 关注者获得优惠券数量 |
created_at | integer unsigned | - | - | |
updated_at | integer unsigned | - | - | |
deleted_at | integer unsigned | - | - |
