数据表:ims_yz_area_dividend_agent(区域分红--区域代理)。
| 字段 | 类型 | 默认值 | 约束 | 说明 |
|---|---|---|---|---|
id | integer unsigned | - | 非空、自增 | |
uniacid | integer | 0 | 非空 | |
member_id | integer | 0 | 非空 | 会员ID |
real_name | string(255) | - | - | 真实姓名 |
mobile | string(60) | - | - | 联系方式 |
province_id | integer | - | - | 省级ID |
province_name | string(60) | - | - | 省级名称 |
city_id | integer | 0 | - | 市级ID |
city_name | string(60) | - | - | 市级名称 |
district_id | integer | 0 | - | 区级ID |
district_name | string(60) | - | - | 区级名称 |
street_id | integer | 0 | - | 街道级ID |
street_name | string(60) | - | - | 街道级名称 |
village_name | string(255) | - | - | 小区名称 |
village_id | integer | - | - | 小区id |
agent_level | boolean | 0 | - | 0:无效;1:省代;2:市代;3:区代:4:街道代理 |
status | boolean | 0 | - | 0:待审核;1:通过;-1驳回 |
agent_at | integer | - | - | 成为代理时间 |
count_order_amount | decimal | 0.00 | - | 区域订单消费金额 |
count_settle_amount | decimal | 0.00 | - | 累计结算分红金额 |
settle_dividend_amount | decimal | 0.00 | - | 已结算分红 |
unsettled_dividend_amount | decimal | 0.00 | - | 未结算分红 |
created_at | integer | - | - | |
updated_at | integer | - | - | |
deleted_at | integer | - | - | |
user_id | integer | 0 | 非空 | |
username | string(100) | - | - | |
password | string(255) | - | - | |
manage | integer | 0 | - | |
ratio | decimal | - | - | |
has_ratio | integer | - | - | |
salt | string(255) | - | - | |
investor_uid | integer | 0 | 非空 | 招商专员会员ID |
application_order_id | integer | - | - | 申请购买订单ID |
apply_source | string(20) | legacy | 非空 | 代理来源:legacy,admin,apply_order |
