sys_datarage
<h4>sys_datarage 数据访问权限规则表</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>UserID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>DepartIds</td>
<td>text</td>
<td>YES</td>
<td></td>
<td>部门ID,仓库ID等</td>
</tr>
<tr>
<td>Attribute1</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute2</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute3</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute4</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute5</td>
<td>varchar(50)</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>LastUpdateDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>最后更新时间</td>
</tr>
<tr>
<td>Type</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>类型 1.数据权限 2.仓库权限</td>
</tr>
</tbody>
</table>