# 会员基础表 * user | 字段名 | 说明 | | --- | --- | |u_id|会员索引| |account|会员账号| |password|会员密码| |regtime|注册时间| |last_time|登录时间| |last_ip|登录ip| |last_address|登录地点| |login_num|登录次数| |enable|状态(1启用0禁用2未填写账号待激活)| |enable_msg|状态变更说明| |sg_id |组索引 | |permission|用户权限| |source|来源说明| | --- | --- | | --- | <b>基本属性 | |head|头像| |nickname|昵称| |content|用户签名简介| |sex|性别(0未知1男2女)| |email|邮箱| |vip|vip状态(1vip0普通用户)| |vip_start\_time|vip生效时间| |vip_end\_time|vip失效时间| | lv | (v3)推广等级(0普通会员1推广大使2合伙人3高级合伙人) | |master_1|直接推荐人索引| |master_2|间接推荐人索引| |share_qrcode|分享二维码| | --- | --- | | --- | <b>微信小程序 | |wx_unionid|全局识别码| |wx_openid|微信小程序识别码| |wx_enable|微信小程序状态\[0仅登录1注册登录2已退出登录]| |wx_account|微信号| |wx_brush|微信内部刷手(1是0否)| |wx_brush_num|刷手允许数量| | --- | --- | | --- | <b>抖音小程序 | |dy_union_id|抖音内部浏览器| |dy_open_id|抖音小程序标识码| |dy_enable|抖音小程序状态\[0仅登录1注册登录2已退出登录]| | --- | --- | | --- | <b>支付宝 | |zfb_account|支付宝账号| |zfb_name|支付宝实名| | --- | --- | | --- | <b>seo | |seo|seo账户(1是0否)|