字段
|
类型
|
整理
|
属性
|
Null
|
默认
|
额外
|
mid
|
mediumint(8)
|
|
UNSIGNED
|
是
|
NULL
|
会员ID
|
mtype
|
enum('个人','企业')
|
utf8_general_ci
|
|
是
|
个人
|
会员类型
|
userid
|
char(20)
|
utf8_general_ci
|
|
是
|
|
注册用户名
|
pwd
|
char(32)
|
utf8_general_ci
|
|
是
|
|
密码
|
uname
|
char(36)
|
utf8_general_ci
|
|
是
|
|
昵称
|
sex
|
enum('男','女','保密')
|
utf8_general_ci
|
|
是
|
保密
|
性别
|
rank
|
smallint(5)
|
|
UNSIGNED
|
是
|
0
|
会员级别值
|
uprank
|
smallint(5)
|
|
UNSIGNED
|
是
|
0
|
是否待升级
|
money
|
mediumint(8)
|
|
UNSIGNED
|
是
|
0
|
会员金币
|
upmoney
|
smallint(5)
|
|
UNSIGNED
|
是
|
0
|
是否待充值
|
email
|
char(50)
|
utf8_general_ci
|
|
是
|
|
Email
|
scores
|
mediumint(8)
|
|
UNSIGNED
|
是
|
0
|
积分
|
matt
|
smallint(5)
|
|
UNSIGNED
|
是
|
0
|
推荐
|
spacesta
|
smallint(6)
|
|
|
是
|
0
|
会员空间状况
|
face
|
char(50)
|
utf8_general_ci
|
|
是
|
|
头像
|
safequestion
|
smallint(5)
|
|
UNSIGNED
|
是
|
0
|
安全提示问题
|
safeanswer
|
char(30)
|
utf8_general_ci
|
|
是
|
|
安全提示问题答案
|
jointime
|
int(10)
|
|
UNSIGNED
|
是
|
0
|
注册时间
|
joinip
|
char(16)
|
utf8_general_ci
|
|
是
|
|
注册IP
|
logintime
|
int(10)
|
|
UNSIGNED
|
是
|
0
|
登陆时间
|
loginip
|
char(16)
|
utf8_general_ci
|
|
是
|
|
登陆IP
|
|