biz_departmentaccount
<h4>biz_departmentaccount</h4>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>类型长度</th>
<th>是否NULL</th>
<th>默认值</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>bigint(20)</td>
<td>NO</td>
<td></td>
<td>唯一标识</td>
</tr>
<tr>
<td>No</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>事业部门帐户编号</td>
</tr>
<tr>
<td>DepartmentID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>事业部门ID</td>
</tr>
<tr>
<td>Rate</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>提成比例,目前所有省份来自字典,可能每个省不一样</td>
</tr>
<tr>
<td>ServiceNum</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>总共服务完成单数</td>
</tr>
<tr>
<td>CMMoney</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>账户总额</td>
</tr>
<tr>
<td>Rank</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>事业部排名</td>
</tr>
<tr>
<td>Level</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>事业部门级别,以后可能总代理有级别区分影响提成等</td>
</tr>
<tr>
<td>Description</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>相关描述</td>
</tr>
<tr>
<td>State</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>驾驶员帐户状态</td>
</tr>
<tr>
<td>BankName</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>银行开户</td>
</tr>
<tr>
<td>BankNo</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>银行卡号</td>
</tr>
<tr>
<td>BankAccount</td>
<td>varchar(20)</td>
<td>YES</td>
<td></td>
<td>银行账户名</td>
</tr>
<tr>
<td>CreateBy</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>创建人</td>
</tr>
<tr>
<td>CreateDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>创建日期</td>
</tr>
<tr>
<td>LastUpdateDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>最近修改日期</td>
</tr>
<tr>
<td>LastUpdateBy</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>最近修改人</td>
</tr>
<tr>
<td>BankProv</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>BankCity</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
</tbody>
</table>