数据表:ims_yz_store_shareholder_bonus_info(门店股东-股东分红详情数据表)。
| 字段 | 类型 | 默认值 | 约束 | 说明 |
|---|---|---|---|---|
id | integer unsigned | - | 非空、自增 | |
uniacid | integer | 0 | - | 公众号id |
bonus_id | integer | 0 | - | 周期分红id |
store_id | integer | 0 | - | 门店id |
uid | integer | 0 | - | 会员id |
level_id | integer | 0 | - | 股东等级id |
level_count | integer | 0 | - | 同等级人数 |
ratio | decimal | 0.00 | - | 分红比例 |
turnover | decimal | 0.00 | - | 周期营业额 |
bonus_total | decimal | 0.00 | - | 分红总金额 |
amount | decimal | 0.00 | - | 分红金额 |
created_at | integer | - | - | |
updated_at | integer | - | - | |
deleted_at | integer | - | - | |
bonus_point | decimal | 0.00 | 非空 | 积分奖励 |
bonus_frozen_love | decimal | 0.00 | 非空 | 冻结爱心值奖励 |
