菜单表
<ul>
<li>oauth_menu </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>MENU_ID</td>
<td>varchar (32)</td>
<td>否</td>
<td>&#039</td>
<td>菜单ID</td>
</tr>
<tr>
<td>MENU_NAME</td>
<td>varchar (100)</td>
<td>否</td>
<td></td>
<td>菜单名称</td>
</tr>
<tr>
<td>PARENT_ID</td>
<td>varchar (32)</td>
<td>否</td>
<td></td>
<td>上级ID</td>
</tr>
<tr>
<td>PATH</td>
<td>varchar (200)</td>
<td>是</td>
<td></td>
<td>地址</td>
</tr>
<tr>
<td>PERM</td>
<td>varchar (200)</td>
<td>是</td>
<td></td>
<td>权限</td>
</tr>
<tr>
<td>TYPE</td>
<td>varchar (1)</td>
<td>否</td>
<td></td>
<td>类型【0:目录;1:菜单;2:按钮】</td>
</tr>
<tr>
<td>ICON</td>
<td>varchar (100)</td>
<td>是</td>
<td></td>
<td>图标</td>
</tr>
<tr>
<td>ORDER_NUM</td>
<td>int</td>
<td>否</td>
<td></td>
<td>排序</td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>datetime</td>
<td>否</td>
<td></td>
<td>更新时间</td>
</tr>
<tr>
<td>COMPONENT</td>
<td>varchar (50)</td>
<td>是</td>
<td></td>
<td>组件路径</td>
</tr>
<tr>
<td>STATUS</td>
<td>char (1)</td>
<td>是</td>
<td></td>
<td>状态【1:启用;2:禁用】</td>
</tr>
<tr>
<td>VISIBLE</td>
<td>char (1)</td>
<td>是</td>
<td></td>
<td>菜单状态(1显示 2隐藏)</td>
</tr>
</tbody>
</table>