# 會員基礎表 * 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否)|