用户

<ul> <li>sys_user </li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>user_id</td> <td>bigint (20)</td> <td>否</td> <td></td> <td>用户ID</td> </tr> <tr> <td>dept_id</td> <td>bigint (20)</td> <td>是</td> <td></td> <td>部门ID</td> </tr> <tr> <td>user_name</td> <td>varchar (30)</td> <td>否</td> <td></td> <td>用户账号</td> </tr> <tr> <td>nick_name</td> <td>varchar (30)</td> <td>否</td> <td></td> <td>用户昵称</td> </tr> <tr> <td>user_type</td> <td>varchar (2)</td> <td>是</td> <td>00</td> <td>用户类型（00系统用户）</td> </tr> <tr> <td>email</td> <td>varchar (50)</td> <td>是</td> <td></td> <td>用户邮箱</td> </tr> <tr> <td>phonenumber</td> <td>varchar (11)</td> <td>是</td> <td></td> <td>手机号码</td> </tr> <tr> <td>sex</td> <td>char (1)</td> <td>是</td> <td>0</td> <td>用户性别（0男 1女 2未知）</td> </tr> <tr> <td>avatar</td> <td>varchar (100)</td> <td>是</td> <td></td> <td>头像地址</td> </tr> <tr> <td>password</td> <td>varchar (100)</td> <td>是</td> <td></td> <td>密码</td> </tr> <tr> <td>status</td> <td>char (1)</td> <td>是</td> <td>0</td> <td>帐号状态（0正常 1停用）</td> </tr> <tr> <td>del_flag</td> <td>char (1)</td> <td>是</td> <td>0</td> <td>删除标志（0代表存在 2代表删除）</td> </tr> <tr> <td>login_ip</td> <td>varchar (128)</td> <td>是</td> <td></td> <td>最后登录IP</td> </tr> <tr> <td>login_date</td> <td>datetime</td> <td>是</td> <td></td> <td>最后登录时间</td> </tr> <tr> <td>create_by</td> <td>varchar (64)</td> <td>是</td> <td></td> <td>创建者</td> </tr> <tr> <td>create_time</td> <td>datetime</td> <td>是</td> <td></td> <td>创建时间</td> </tr> <tr> <td>update_by</td> <td>varchar (64)</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>remark</td> <td>varchar (500)</td> <td>是</td> <td></td> <td>备注</td> </tr> </tbody> </table>