aws_users(用户表) · WeCenter开发使用文档

<body> <h2><font color="#447eaf"><b>aws_users 数据表字段解释</b></font> (用户表)</h2> <table> <tbody><tr><td>字段名</td><td>类型</td><td>解释</td><td>附加说明</td></tr> <tr> <td>uid</td><td>int(11) unsigned</td><td>用户的 UID</td><td>auto_increment</td> </tr> <tr> <td>user_name</td><td>varchar(255)</td><td>用户名</td><td></td> </tr> <tr> <td>email</td><td>varchar(255)</td><td>EMAIL</td><td></td> </tr> <tr> <td>mobile</td><td>varchar(16)</td><td>用户手机</td><td></td> </tr> <tr> <td>password</td><td>varchar(32)</td><td>用户密码</td><td></td> </tr> <tr> <td>salt</td><td>varchar(16)</td><td>用户附加混淆码</td><td></td> </tr> <tr> <td>avatar_file</td><td>varchar(128)</td><td>头像文件</td><td></td> </tr> <tr> <td>sex</td><td>tinyint(1)</td><td>性别</td><td></td> </tr> <tr> <td>birthday</td><td>int(10)</td><td>生日</td><td></td> </tr> <tr> <td>province</td><td>varchar(64)</td><td>省</td><td></td> </tr> <tr> <td>city</td><td>varchar(64)</td><td>市</td><td></td> </tr> <tr> <td>job_id</td><td>int(10)</td><td>职业ID</td><td></td> </tr> <tr> <td>reg_time</td><td>int(10)</td><td>注册时间</td><td></td> </tr> <tr> <td>reg_ip</td><td>bigint(12)</td><td>注册IP</td><td></td> </tr> <tr> <td>last_login</td><td>int(10)</td><td>最后登录时间</td><td></td> </tr> <tr> <td>last_ip</td><td>bigint(12)</td><td>最后登录 IP</td><td></td> </tr> <tr> <td>online_time</td><td>int(10)</td><td>在线时间</td><td></td> </tr> <tr> <td>last_active</td><td>int(10)</td><td>最后活跃时间</td><td></td> </tr> <tr> <td>notification_unread</td><td>int(11)</td><td>未读系统通知</td><td></td> </tr> <tr> <td>inbox_unread</td><td>int(11)</td><td>未读短信息</td><td></td> </tr> <tr> <td>inbox_recv</td><td>tinyint(1)</td><td>0-所有人可以发给我,1-我关注的人</td><td></td> </tr> <tr> <td>fans_count</td><td>int(10)</td><td>粉丝数</td><td></td> </tr> <tr> <td>friend_count</td><td>int(10)</td><td>观众数</td><td></td> </tr> <tr> <td>invite_count</td><td>int(10)</td><td>邀请我回答数量</td><td></td> </tr> <tr> <td>question_count</td><td>int(10)</td><td>问题数量</td><td></td> </tr> <tr> <td>answer_count</td><td>int(10)</td><td>回答数量</td><td></td> </tr> <tr> <td>topic_focus_count</td><td>int(10)</td><td>关注话题数量</td><td></td> </tr> <tr> <td>invitation_available</td><td>int(10)</td><td>邀请数量</td><td></td> </tr> <tr> <td>group_id</td><td>int(10)</td><td>用户组</td><td></td> </tr> <tr> <td>reputation_group</td><td>int(10)</td><td>威望对应组</td><td></td> </tr> <tr> <td>forbidden</td><td>tinyint(1)</td><td>是否禁止用户</td><td></td> </tr> <tr> <td>valid_email</td><td>tinyint(1)</td><td>邮箱验证</td><td></td> </tr> <tr> <td>is_first_login</td><td>tinyint(1)</td><td>首次登录标记</td><td></td> </tr> <tr> <td>agree_count</td><td>int(10)</td><td>赞同数量</td><td></td> </tr> <tr> <td>thanks_count</td><td>int(10)</td><td>感谢数量</td><td></td> </tr> <tr> <td>views_count</td><td>int(10)</td><td>个人主页查看数量</td><td></td> </tr> <tr> <td>reputation</td><td>int(10)</td><td>威望</td><td></td> </tr> <tr> <td>reputation_update_time</td><td>int(10)</td><td>威望更新</td><td></td> </tr> <tr> <td>weibo_visit</td><td>tinyint(1)</td><td>微博允许访问</td><td></td> </tr> <tr> <td>integral</td><td>int(10)</td><td>积分</td><td></td> </tr> <tr> <td>draft_count</td><td>int(10)</td><td></td><td></td> </tr> <tr> <td>common_email</td><td>varchar(255)</td><td>常用邮箱</td><td></td> </tr> <tr> <td>url_token</td><td>varchar(32)</td><td>个性网址</td><td></td> </tr> <tr> <td>url_token_update</td><td>int(10)</td><td>个性网址设置时间</td><td></td> </tr> <tr> <td>verified</td><td>varchar(32)</td><td>认证用户：personal个人，enterprise机构，为空是没有认证</td><td></td> </tr> <tr> <td>default_timezone</td><td>varchar(32)</td><td>默认时区</td><td></td> </tr> <tr> <td>email_settings</td><td>varchar(255)</td><td>邮箱设置</td><td></td> </tr> <tr> <td>recent_topics</td><td>text</td><td>最近话题序列化</td><td></td> </tr> <tr> <td>weixin_settings</td><td>varchar(255)</td><td>微信设置</td><td></td> </tr> <tr> <td>article_count</td><td>int(10)</td><td>文章数量</td><td></td> </tr> </tbody></table> </body>