数据表:ims_yz_store_business_alliance_agent_level(店商联盟--等级)。
| 字段 | 类型 | 默认值 | 约束 | 说明 |
|---|---|---|---|---|
id | integer unsigned | - | 非空、自增 | |
uniacid | integer | - | - | 公众号id |
level_weight | integer | - | - | 商品id |
name | string(255) | - | - | 等级名称 |
goods_id | text(65535) | - | - | 商品组id |
is_store | integer | - | - | 是否关联门店 |
store_reward | text(65535) | - | - | 门店团队会员对应该插件等级奖励 |
is_region | integer | - | - | 是否关联区域 |
region_reward | text(65535) | - | - | 店长团队会员对应该插件等级奖励 |
recommend_reward | text(65535) | - | - | 推荐奖 |
deposit | decimal | - | - | 定金 |
task_reward | string(255) | - | - | 任务奖励 |
store_price_difference_income | string(255) | - | - | 门店差价收益 |
region_price_difference_income | string(255) | - | - | 区域差价收益 |
is_operation_center | integer | - | - | 是否关联运营中心 |
operation_center_reward | decimal | - | - | 运营中心奖励 |
support_award | decimal | - | - | 帮扶奖励 |
team_award | decimal | - | - | 团队奖励 |
team_new_store_award | decimal | - | - | 团队新生店奖励 |
created_at | integer | - | - | |
updated_at | integer | - | - | |
deleted_at | integer | - | - |
