用户表 t_user

<ul> <li>用户表</li> </ul> <p><table border="0" cellpadding="0" cellspacing="0" width="712" style="border-collapse: collapse;width:536pt"><colgroup><col width="69" style="width:52pt"> <col width="103" style="mso-width-source:userset;mso-width-alt:3306;width:78pt"> <col width="265" style="mso-width-source:userset;mso-width-alt:8490;width:199pt"> <col width="125" style="mso-width-source:userset;mso-width-alt:3989;width:94pt"> <col width="81" style="mso-width-source:userset;mso-width-alt:2581;width:61pt"> <col width="69" style="width:52pt"></colgroup><tbody><tr height="19" style="height:14.0pt"><td height="19" class="xl65" width="69" style="height:14.0pt;width:52pt">序号</td><td class="xl65" width="103" style="width:78pt">字段名称</td><td class="xl65" width="265" style="width:199pt">注释</td><td class="xl65" width="125" style="width:94pt">必填</td><td class="xl65" width="81" style="width:61pt">数据类型</td><td class="xl65" width="69" style="width:52pt">主键唯一</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">1</td><td class="xl66">user_id</td><td class="xl66">用户ID</td><td class="xl66">是</td><td class="xl66">int</td><td class="xl66">是</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">2</td><td class="xl66">username</td><td class="xl66">用户名</td><td class="xl66">是</td><td class="xl66">varchar(64)</td><td class="xl66">　</td></tr><tr height="17" style="mso-height-source:userset;height:13.0pt"><td height="17" class="xl66" align="right" style="height:13.0pt">3</td><td class="xl66">password</td><td class="xl66">密码</td><td class="xl66">是</td><td class="xl66">varchar(64)</td><td class="xl66">　</td></tr><tr height="21" style="mso-height-source:userset;height:15.5pt"><td height="21" class="xl66" align="right" style="height:15.5pt">4</td><td class="xl66">salt</td><td class="xl66">盐值</td><td class="xl66">是</td><td class="xl66">varchar(8)</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">5</td><td class="xl66">telephone</td><td class="xl66">手机号</td><td class="xl66">是</td><td class="xl66">varchar(11)</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">6</td><td class="xl66">img</td><td class="xl66">头像</td><td class="xl66">否</td><td class="xl66" colspan="2" style="mso-ignore:colspan">varchar(255)</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">7</td><td class="xl66">nickname</td><td class="xl66">昵称</td><td class="xl66">否</td><td class="xl66">varchar(32)</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">8</td><td class="xl66">sex</td><td class="xl66">性别<span style="mso-spacerun:yes"> </span>（0、男；1、女）</td><td class="xl66">否</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">9</td><td class="xl66">exercise</td><td class="xl66">运动量</td><td class="xl66">是</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">10</td><td class="xl66">point</td><td class="xl66">积分</td><td class="xl66">是</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">11</td><td class="xl66">balance</td><td class="xl66">余额</td><td class="xl66">是</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">12</td><td class="xl66">status</td><td class="xl66">状态 （0、离线 ；1、在线；2、注销）</td><td class="xl66">是</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">13</td><td class="xl66">update_time</td><td class="xl66">更新时间</td><td class="xl66">是</td><td class="xl66">timestamp</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">14</td><td class="xl66">create_time</td><td class="xl66">创建时间</td><td class="xl66">是</td><td class="xl66">timestamp</td><td class="xl66">　</td></tr></tbody></table></p>