# ucenter
ucenter
- [server\_id\_seq](#server_id_seq)
- [ucenter\_base\_app](#ucenter_base_app)
- [ucenter\_base\_app\_server](#ucenter_base_app_server)
- [ucenter\_base\_district](#ucenter_base_district)
- [ucenter\_message\_template](#ucenter_message_template)
- [ucenter\_reg\_option](#ucenter_reg_option)
- [ucenter\_reg\_option\_value](#ucenter_reg_option_value)
- [ucenter\_server\_id\_seq](#ucenter_server_id_seq)
- [ucenter\_user\_app](#ucenter_user_app)
- [ucenter\_user\_app\_server](#ucenter_user_app_server)
- [ucenter\_user\_bind\_connect](#ucenter_user_bind_connect)
- [ucenter\_user\_grade](#ucenter_user_grade)
- [ucenter\_user\_id\_seq](#ucenter_user_id_seq)
- [ucenter\_user\_info](#ucenter_user_info)
- [ucenter\_user\_info\_detail](#ucenter_user_info_detail)
- [ucenter\_user\_option](#ucenter_user_option)
- [ucenter\_user\_privacy](#ucenter_user_privacy)
- [ucenter\_web\_config](#ucenter_web_config)
- [user\_id\_seq](#user_id_seq)
- - - - - -
server\_id\_seq FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(10) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentserver\_id\_seq
0
PRIMARY
1
id
A
0
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_base\_app FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentapp\_id
int(11) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
服务ID
app\_name
varchar(40)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
服务名称
app\_type
smallint(5) unsigned
(NULL)
NO
0
select,insert,update,references
服务类型
app\_seq
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
顺序号
app\_key
varchar(50)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
服务密钥
app\_ip\_list
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
服务 IP 列表
app\_url
varchar(255)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
服务网址
app\_admin\_url
varchar(255)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
后台网址
app\_url\_recharge
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
app\_url\_order
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
检查订单是否存在的url地址
app\_logo
varchar(255)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
LOGO 图片地址
app\_hosts
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
域名列表
return\_fields
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
返回字段
app\_status
tinyint(1)
(NULL)
NO
1
select,insert,update,references
1:启用 0：禁用
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_base\_app
0
PRIMARY
1
app\_id
A
7
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_base\_app\_server FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentserver\_id
mediumint(9) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
服务器id
server\_prefix
varchar(50)
utf8\_general\_ci
NO
select,insert,update,references
服务器前缀 ：一区
server\_name
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
服务器名称
server\_url
varchar(200)
utf8\_general\_ci
NO
MUL
(NULL)
select,insert,update,references
服务器url
server\_order
int(11)
(NULL)
NO
0
select,insert,update,references
服务器列表排序
app\_id
smallint(6)
(NULL)
NO
MUL
(NULL)
select,insert,update,references
所属游戏id
company\_id
int(11)
(NULL)
NO
MUL
(NULL)
select,insert,update,references
运营商id
server\_type
tinyint(4)
(NULL)
NO
1
select,insert,update,references
服类型,1:new,2:hot,3:满 4:维护
server\_state
tinyint(4)
(NULL)
NO
0
select,insert,update,references
服务器状态,0:备运 1:开服中 2、停服,3:服务器宕机
socket\_ip
varchar(15)
utf8\_general\_ci
NO
select,insert,update,references
socket 的ip地址
socket\_port
mediumint(9)
(NULL)
NO
0
select,insert,update,references
socket的端口号
server\_stop\_start\_time
datetime
(NULL)
NO
(NULL)
select,insert,update,references
停服开始时间
server\_stop\_end\_time
datetime
(NULL)
NO
(NULL)
select,insert,update,references
停服结束时间
server\_stop\_tip
varchar(100)
utf8\_general\_ci
NO
select,insert,update,references
服务器宕机提示
app\_version\_package
varchar(100)
utf8\_general\_ci
NO
select,insert,update,references
CPP中定义的版本, 决定是否显示
company\_name
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
公司名称
company\_phone
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
电话
contacter
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
联系人
sign\_time
datetime
(NULL)
NO
(NULL)
select,insert,update,references
签约时间
user\_name
varchar(50)
utf8\_general\_ci
NO
select,insert,update,references
管理员账号
account\_num
mediumint(8)
(NULL)
NO
(NULL)
select,insert,update,references
账号个数
db\_host
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
数据库IP
db\_user
varchar(50)
utf8\_general\_ci
NO
select,insert,update,references
db\_name
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
数据库名
db\_passwd
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
数据库密码
upload\_path
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
附件存放地址
business\_agent
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
业务代表
price
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
费用
effective\_date\_start
date
(NULL)
NO
(NULL)
select,insert,update,references
有效期开始与结束
effective\_date\_end
date
(NULL)
NO
(NULL)
select,insert,update,references
有效期开始与结束1
plantform\_url
varchar(200)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
mallbuilder平台url
ucenter\_url
varchar(200)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
paycenter\_url
varchar(200)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
cloud\_type
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_base\_app\_server
0
PRIMARY
1
server\_id
A
0
(NULL)
(NULL)
BTREE
ucenter\_base\_app\_server
1
game\_id
1
app\_id
A
0
(NULL)
(NULL)
BTREE
ucenter\_base\_app\_server
1
server\_url
1
server\_url
A
0
(NULL)
(NULL)
BTREE
ucenter\_base\_app\_server
1
company\_id
1
company\_id
A
0
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_base\_district FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentdistrict\_id
mediumint(8) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
地区id
district\_name
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
地区名称
district\_parent\_id
mediumint(8) unsigned
(NULL)
NO
MUL
0
select,insert,update,references
父id
district\_displayorder
smallint(6)
(NULL)
NO
0
select,insert,update,references
排序
district\_region
varchar(50)
utf8\_general\_ci
NO
select,insert,update,references
区域名称 - 华北、东北、华东、华南、华中、西南、西北、港澳台、海外
district\_is\_leaf
tinyint(1)
(NULL)
NO
1
select,insert,update,references
无子类
district\_is\_level
tinyint(1)
(NULL)
NO
1
select,insert,update,references
等级
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_base\_district
0
PRIMARY
1
district\_id
A
43767
(NULL)
(NULL)
BTREE
ucenter\_base\_district
1
upid
1
district\_parent\_id
A
7294
(NULL)
(NULL)
BTREE
ucenter\_base\_district
1
upid
2
district\_displayorder
A
7294
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_message\_template FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(10)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
code
varchar(100)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
name
varchar(100)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
title
varchar(100)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
主题
content\_email
text
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
邮件内容
type
tinyint(1)
(NULL)
NO
(NULL)
select,insert,update,references
0商家1用户
is\_phone
tinyint(1)
(NULL)
NO
0
select,insert,update,references
0关闭1开启
is\_email
tinyint(1)
(NULL)
NO
0
select,insert,update,references
0关闭1开启
is\_mail
tinyint(1)
(NULL)
NO
0
select,insert,update,references
0关闭1开启
content\_mail
text
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
站内信内容
content\_phone
text
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
短信内容
force\_phone
tinyint(1)
(NULL)
NO
0
select,insert,update,references
手机短信0不强制1强制
force\_email
tinyint(1)
(NULL)
NO
0
select,insert,update,references
邮件0不强制1强制
force\_mail
tinyint(1)
(NULL)
NO
0
select,insert,update,references
站内信0不强制1强制
mold
tinyint(1)
(NULL)
NO
0
select,insert,update,references
0常用提示1订单提示2卡券提示3售后提示
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_message\_template
0
PRIMARY
1
id
A
9
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_reg\_option FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentreg\_option\_id
int(11)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
选项值
reg\_option\_name
varchar(20)
utf8\_general\_ci
NO
select,insert,update,references
reg\_option\_order
int(3)
(NULL)
NO
(NULL)
select,insert,update,references
option\_id
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
选项id
reg\_option\_required
tinyint(1) unsigned
(NULL)
NO
0
select,insert,update,references
是否必须(BOOL):0-非必填;1-必填
reg\_option\_placeholder
varchar(100)
utf8\_general\_ci
NO
select,insert,update,references
placeholder
reg\_option\_datatype
varchar(20)
utf8\_general\_ci
NO
select,insert,update,references
data\_type
reg\_option\_value
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
配置选项
reg\_option\_active
tinyint(1)
(NULL)
NO
0
select,insert,update,references
是否启用
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_reg\_option
0
PRIMARY
1
reg\_option\_id
A
13
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_reg\_option\_value FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentreg\_option\_value\_id
int(11)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
选项值
reg\_option\_id
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
选项id
reg\_option\_value\_image
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
选项值图片
reg\_option\_value\_order
tinyint(3) unsigned
(NULL)
NO
50
select,insert,update,references
reg\_option\_value\_name
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
选项值名称
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_reg\_option\_value
0
PRIMARY
1
reg\_option\_value\_id
A
0
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_server\_id\_seq FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(10) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_server\_id\_seq
0
PRIMARY
1
id
A
0
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_app FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_name
varchar(100)
utf8\_general\_ci
NO
PRI
(NULL)
select,insert,update,references
用户名
app\_id
int(11) unsigned
(NULL)
NO
PRI
0
select,insert,update,references
服务ID
app\_user\_id
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
用户在该服务的ID
app\_user\_level
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
用户在该服务的等级
active\_time
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
激活时间
app\_quantity
int(11)
(NULL)
NO
1
select,insert,update,references
app数量
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_app
0
PRIMARY
1
user\_name
A
56
(NULL)
(NULL)
BTREE
ucenter\_user\_app
0
PRIMARY
2
app\_id
A
56
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_app\_server FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_name
varchar(100)
utf8\_general\_ci
NO
PRI
(NULL)
select,insert,update,references
这个user\_name是指玩家在运营商那边的唯一标记，不是官方平台的账号
app\_id
int(11)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
应用在官方平台的app\_id
server\_id
int(11)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
服务器id
active\_time
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
激活时间
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_app\_server
0
PRIMARY
1
user\_name
A
56
(NULL)
(NULL)
BTREE
ucenter\_user\_app\_server
0
PRIMARY
2
app\_id
A
56
(NULL)
(NULL)
BTREE
ucenter\_user\_app\_server
0
PRIMARY
3
server\_id
A
56
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_bind\_connect FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentbind\_id
varchar(100)
utf8\_general\_ci
NO
PRI
(NULL)
select,insert,update,references
绑定标记：mobie/email/openid 绑定类型+openid
bind\_type
tinyint(4)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
绑定类型 1:sinaweibo 2:qq 3:weixin 11:email 12:mobile
user\_id
int(10) unsigned
(NULL)
NO
0
select,insert,update,references
用户id
bind\_time
timestamp
(NULL)
NO
CURRENT\_TIMESTAMP
select,insert,update,references
绑定时间
bind\_nickname
varchar(50)
utf8\_general\_ci
NO
select,insert,update,references
名称
bind\_avator
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
地址
bind\_gender
tinyint(1)
(NULL)
NO
1
select,insert,update,references
性别 1:男 2:女
bind\_openid
varchar(200)
utf8\_general\_ci
NO
select,insert,update,references
访问
bind\_token
varchar(200)
latin1\_swedish\_ci
NO
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_bind\_connect
0
PRIMARY
1
bind\_id
A
612
(NULL)
(NULL)
BTREE
ucenter\_user\_bind\_connect
0
PRIMARY
2
bind\_type
A
612
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_grade FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_grade\_id
int(11)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
user\_grade\_name
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
user\_grade\_demand
int(10)
(NULL)
NO
0
select,insert,update,references
条件
user\_grade\_treatment
text
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
权益
user\_grade\_blogo
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
大图
user\_grade\_logo
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
LOGO
user\_grade\_valid
int(1)
(NULL)
NO
0
select,insert,update,references
有效期
user\_grade\_sum
int(11)
(NULL)
NO
0
select,insert,update,references
年费
user\_grade\_rate
float(3,1)
(NULL)
NO
0.0
select,insert,update,references
折扣率
user\_grade\_time
datetime
(NULL)
NO
(NULL)
select,insert,update,references
创建时间
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_grade
0
PRIMARY
1
user\_grade\_id
A
5
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_id\_seq FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(10) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_id\_seq
0
PRIMARY
1
id
A
0
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_info FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id
int(11) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
用户ID
user\_name
varchar(100)
utf8\_general\_ci
NO
UNI
(NULL)
select,insert,update,references
用户名
password
char(32)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
密码
user\_state
tinyint(1) unsigned
(NULL)
NO
0
select,insert,update,references
状态(0:未激活,1:未认证,2:已认证,3:锁定)
action\_time
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
活动时间
action\_ip
varchar(15)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
活动IP
session\_id
varchar(100)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_info
0
PRIMARY
1
user\_id
A
649
(NULL)
(NULL)
BTREE
ucenter\_user\_info
0
user\_name
1
user\_name
A
649
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_info\_detail FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_name
varchar(100)
utf8\_general\_ci
NO
PRI
(NULL)
select,insert,update,references
用户名
nickname
varchar(100)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
昵称
user\_group
int(11)
(NULL)
NO
0
select,insert,update,references
用户组
user\_site\_id
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
用户站点ID
user\_site\_domain
varchar(50)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
用户站点域名
user\_question
varchar(100)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
密码提示问题
user\_answer
varchar(100)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
密码提示答案
user\_avatar
varchar(255)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
头像
user\_avatar\_thumb
varchar(255)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
头像缩略图
user\_gender
tinyint(1) unsigned
(NULL)
NO
0
select,insert,update,references
性别
user\_truename
varchar(20)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
真实姓名
user\_tel
varchar(30)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
电话
user\_birth
varchar(10)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
生日(YYYY-MM-DD)
user\_qq
varchar(20)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
QQ
user\_msn
varchar(255)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
MSN
user\_province
varchar(20)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
省份
user\_city
varchar(20)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
城市
user\_intro
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
个人简介
user\_sign
varchar(500)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
用户签名
user\_reg\_time
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
注册时间
user\_count\_login
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
登录次数
user\_lastlogin\_time
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
上次登录时间
user\_lastlogin\_ip
varchar(15)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
上次登录IP
user\_like\_games
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
喜爱的游戏
user\_reg\_ip
varchar(15)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
注册IP
user\_money
int(11) unsigned
(NULL)
NO
0
select,insert,update,references
用户资金
user\_credit
int(11)
(NULL)
NO
0
select,insert,update,references
用户积分
user\_getpsw\_code
varchar(32)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
取回密码认证码
user\_verify\_code
varchar(32)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
认证账号认证码
user\_phone\_code
varchar(32)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
手机验证码
user\_phone\_code\_stats
varchar(20)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
获取手机验证码记录(获取次数,上次获取时间)
user\_idcard
varchar(30)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
身份证
user\_mobile
varchar(20)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
手机号码
user\_email
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
user\_binded
varchar(50)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
已绑定项目
user\_history\_password
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
历史密码
user\_history\_ip
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
历史 IP
user\_grade
tinyint(1)
(NULL)
NO
0
select,insert,update,references
user\_mobile\_verify
tinyint(1)
(NULL)
NO
0
select,insert,update,references
user\_email\_verify
tinyint(1)
(NULL)
NO
0
select,insert,update,references
user\_provinceid
int(11)
(NULL)
NO
0
select,insert,update,references
user\_cityid
int(11)
(NULL)
NO
0
select,insert,update,references
user\_areaid
int(11)
(NULL)
NO
0
select,insert,update,references
user\_area
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_info\_detail
0
PRIMARY
1
user\_name
A
651
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_option FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_option\_id
int(11)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
选项值
reg\_option\_id
int(3)
(NULL)
NO
(NULL)
select,insert,update,references
reg\_option\_value\_id
varchar(20)
utf8\_general\_ci
NO
select,insert,update,references
user\_id
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
选项id
user\_option\_value
text
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_option
0
PRIMARY
1
user\_option\_id
A
50
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_user\_privacy FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id
int(10) unsigned
(NULL)
NO
PRI
(NULL)
select,insert,update,references
用户id
user\_privacy\_email
tinyint(1)
(NULL)
NO
0
select,insert,update,references
邮箱设置0公开1好友可见2保密
user\_privacy\_realname
tinyint(1)
(NULL)
NO
0
select,insert,update,references
真实姓名设置0公开1好友可见2保密
user\_privacy\_sex
tinyint(1)
(NULL)
NO
0
select,insert,update,references
性别设置0公开1好友可见2保密
user\_privacy\_birthday
tinyint(1)
(NULL)
NO
0
select,insert,update,references
生日设置0公开1好友可见2保密
user\_privacy\_area
tinyint(1)
(NULL)
NO
0
select,insert,update,references
所在地区设置0公开1好友可见2保密
user\_privacy\_qq
tinyint(1)
(NULL)
NO
0
select,insert,update,references
QQ设置0公开1好友可见2保密
user\_privacy\_ww
tinyint(1)
(NULL)
NO
0
select,insert,update,references
阿里旺旺设置0公开1好友可见2保密
user\_privacy\_mobile
tinyint(1)
(NULL)
NO
0
select,insert,update,references
手机设置0公开1好友可见2保密
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_user\_privacy
0
PRIMARY
1
user\_id
A
38
(NULL)
(NULL)
BTREE
[Back](#header)
ucenter\_web\_config FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentconfig\_key
varchar(50)
utf8\_general\_ci
NO
PRI
(NULL)
select,insert,update,references
数组下标
config\_value
text
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
数组值
config\_type
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
config\_enable
tinyint(1)
(NULL)
NO
1
select,insert,update,references
状态值，1可能，0不可用
config\_comment
text
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
config\_datatype
enum('string','json','number')
utf8\_general\_ci
NO
string
select,insert,update,references
数据类型
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentucenter\_web\_config
0
PRIMARY
1
config\_key
A
226
(NULL)
(NULL)
BTREE
ucenter\_web\_config
1
index
1
config\_key
A
226
(NULL)
(NULL)
BTREE
ucenter\_web\_config
1
index
2
config\_type
A
226
(NULL)
(NULL)
BTREE
[Back](#header)
user\_id\_seq FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(10) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentuser\_id\_seq
0
PRIMARY
1
id
A
1
(NULL)
(NULL)
BTREE
- 序言
- 系统要求
- 版本更新日志
- 远丰商城技术对接说明
- 开发指导
- 框架内容
- 基础
- 开发规范
- 目录结构
- 架构
- 架构总览
- 数据库
- 数据库连接
- 基本使用
- 缓存
- 配置
- 路由
- 数据字典
- ucenter
- shop
- paycenter
- ucenter_admin
- shop_admin
- paycenter_admin
- 通讯内容
- 商家中心
- 顶部导航栏
- 店铺信息栏
- 店铺及商品提示栏
- 交易提示栏
- 销售情况统计栏
- 单品销量排行栏
- 店铺运营推广栏
- 平台联系方式栏
- 订单物流
- 商品
- 商品列表
- 商品详情
- 商品发布与编辑
- 分销商品
- 关联版式
- 商品规格
- 图片空间
- 淘宝导入
- 订单流程
- 交易订单
- 订单退款/退货
- 促销
- 团购管理
- 加价购
- 限时折扣
- 满即送
- 代金券管理
- 分销
- 店铺
- 店铺设置
- 自销产品供应商
- 实体店铺
- 品牌申请
- 店铺信息
- 消费者保障服务
- 门店账号
- 分销商--产品供应商
- 分销明细
- 批发市场
- 售后服务
- 咨询管理
- 投诉管理
- 退款管理
- 退货管理
- 云方案架构
- 负载集群
- 云存储
- 接口
- Api接口说明
- 品牌
- 商品规格
- 商品类型
- 商品分类
- 商品
- 订单
- 商品/店铺收藏
- 足迹
- 退款及退货
- 商家店铺
- 会员
- 入驻协议
- 订单接口
- 商品接口
- 订单物流接口
- 商家中心接口
- 促销接口
- 快递鸟物流接口
- 代金券接口
- 首页版块
- 团购
- 平台红包
- 限时折扣接口
- 拼团接口
- wap首页模板
- 杂项
- 远程上传图片
- JS
- 银联支付
- 多语言
- 商品评分
- 图片加载
- 买家申请退款退货
- 商家退款退货
- 平台退款退货
- 添加发票
- 提交订单
- 确认订单
- 运费销售区域
- 获取会员地址
- 充值
- 导出XLS
- 商城系统集成
- 多语言实现
- 三级分销推广链接发展推广员
- app.ini.php
- 去分销
- 版本更新
- 物流支持
- 运营人员建议
- 业务逻辑
- 统计结算
- 客服消息
- 账号
- 三级分销
- IM
- 配置
- 平台帐号
- 活动数据表说明