# paycenter
paycenter
- [pay\_card\_base](#pay_card_base)
- [pay\_card\_info](#pay_card_info)
- [pay\_card\_media](#pay_card_media)
- [pay\_consume\_deposit](#pay_consume_deposit)
- [pay\_consume\_record](#pay_consume_record)
- [pay\_consume\_trade](#pay_consume_trade)
- [pay\_consume\_withdraw](#pay_consume_withdraw)
- [pay\_message\_template](#pay_message_template)
- [pay\_order\_state](#pay_order_state)
- [pay\_payment\_channel](#pay_payment_channel)
- [pay\_record\_state](#pay_record_state)
- [pay\_service\_fee](#pay_service_fee)
- [pay\_trade\_mode](#pay_trade_mode)
- [pay\_trade\_type](#pay_trade_type)
- [pay\_transfer\_money](#pay_transfer_money)
- [pay\_union\_order](#pay_union_order)
- [pay\_user\_app](#pay_user_app)
- [pay\_user\_bank\_card](#pay_user_bank_card)
- [pay\_user\_base](#pay_user_base)
- [pay\_user\_info](#pay_user_info)
- [pay\_user\_resource](#pay_user_resource)
- [pay\_web\_config](#pay_web_config)
pay\_card\_base FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentcard\_id
int(10)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
卡的id
app\_id
int(11)
(NULL)
NO
9999
select,insert,update,references
app id ： 9999 通用
card\_name
varchar(100)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
卡名称
card\_prize
varchar(2000)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
卡片里面的奖品
card\_desc
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
卡片描述
card\_start\_time
date
(NULL)
NO
0000-00-00
select,insert,update,references
卡的有效开始时间
card\_end\_time
date
(NULL)
NO
0000-00-00
select,insert,update,references
卡的有效结束时间
card\_image
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
卡片图片网址
card\_num
int(255)
(NULL)
NO
0
select,insert,update,references
卡片数量
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_card\_base
0
PRIMARY
1
card\_id
A
21
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_card\_info FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentcard\_code
varchar(50)
utf8\_general\_ci
NO
PRI
(NULL)
select,insert,update,references
卡片激活码
card\_password
varchar(20)
utf8\_general\_ci
NO
select,insert,update,references
卡片密码
card\_id
int(10)
(NULL)
NO
(NULL)
select,insert,update,references
卡片id
card\_fetch\_time
timestamp
(NULL)
NO
0000-00-00 00:00:00
select,insert,update,references
领奖时间
card\_media\_id
smallint(6)
(NULL)
NO
(NULL)
select,insert,update,references
媒体id,参照base\_card\_media表
server\_id
int(11)
(NULL)
NO
0
select,insert,update,references
领卡人的服务器id
user\_id
int(10)
(NULL)
NO
(NULL)
select,insert,update,references
user\_account
varchar(100)
utf8\_general\_ci
NO
select,insert,update,references
领卡人账号
card\_time
timestamp
(NULL)
NO
CURRENT\_TIMESTAMP
select,insert,update,references
卡牌生成时间
card\_money
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
充值卡余额
card\_froze\_money
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
卡冻结金额
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_card\_info
0
PRIMARY
1
card\_code
A
1859
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_card\_media FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentcard\_media\_id
mediumint(9)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
卡片的媒体id
card\_media\_name
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
卡片的媒体标题
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_card\_media
0
PRIMARY
1
card\_media\_id
A
0
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_consume\_deposit FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentdeposit\_trade\_no
varchar(64)
utf8\_general\_ci
NO
select,insert,update,references
交易号
deposit\_buyer\_id
varchar(30)
utf8\_general\_ci
NO
select,insert,update,references
用户号
deposit\_total\_fee
decimal(10,2)
(NULL)
NO
0.00
select,insert,update,references
交易金额
deposit\_pay\_channel
varchar(100)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
充值的付款方式
deposit\_gmt\_create
timestamp
(NULL)
NO
CURRENT\_TIMESTAMP
select,insert,update,references
交易创建时间
deposit\_gmt\_payment
datetime
(NULL)
NO
0000-00-00 00:00:00
select,insert,update,references
交易付款时间
deposit\_gmt\_close
datetime
(NULL)
NO
0000-00-00 00:00:00
select,insert,update,references
deposit\_trade\_status
varchar(100)
utf8\_general\_ci
NO
select,insert,update,references
交易状态
deposit\_return\_trade\_no
varchar(50)
utf8\_general\_ci
NO
select,insert,update,references
充值成功以后的流水
Indexes[Back](#header)
pay\_consume\_record FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentconsume\_record\_id
bigint(20)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
交易记录id
order\_id
varchar(100)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
商户订单id
user\_id
int(10) unsigned
(NULL)
NO
(NULL)
select,insert,update,references
所属用id
user\_nickname
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
昵称
record\_money
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
金额
record\_date
date
(NULL)
NO
(NULL)
select,insert,update,references
年-月-日
record\_year
smallint(4)
(NULL)
NO
(NULL)
select,insert,update,references
年
record\_month
tinyint(2)
(NULL)
NO
(NULL)
select,insert,update,references
月
record\_day
tinyint(2)
(NULL)
NO
(NULL)
select,insert,update,references
日
record\_title
varchar(100)
utf8\_general\_ci
NO
select,insert,update,references
标题
record\_desc
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
描述
record\_time
timestamp
(NULL)
NO
CURRENT\_TIMESTAMP
select,insert,update,references
创建时间
trade\_type\_id
tinyint(1)
(NULL)
NO
0
select,insert,update,references
ž‹交易类型
user\_type
tinyint(1)
(NULL)
NO
(NULL)
select,insert,update,references
1-收款方 2-付款方
record\_status
tinyint(1)
(NULL)
NO
1
select,insert,update,references
付款状态
record\_payorder
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
实际支付单号
record\_paytime
datetime
(NULL)
NO
(NULL)
select,insert,update,references
支付时间
record\_delete
tinyint(1)
(NULL)
NO
0
select,insert,update,references
0未删除 1删除
credit\_remain
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
白条剩余还款金额
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_consume\_record
0
PRIMARY
1
consume\_record\_id
A
8115
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_consume\_trade FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentconsume\_trade\_id
varchar(100)
utf8\_general\_ci
NO
PRI
(NULL)
select,insert,update,references
交易订单id
order\_id
varchar(100)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
商户订单id
buyer\_id
int(10) unsigned
(NULL)
NO
0
select,insert,update,references
买家id
seller\_id
int(11)
(NULL)
NO
0
select,insert,update,references
卖家id
pay\_user\_id
int(11)
(NULL)
NO
0
select,insert,update,references
付款人id
order\_state\_id
tinyint(4)
(NULL)
NO
1
select,insert,update,references
订单状态
trade\_type\_id
tinyint(1)
(NULL)
NO
(NULL)
select,insert,update,references
交易类型
payment\_channel\_id
tinyint(4)
(NULL)
NO
MUL
(NULL)
select,insert,update,references
支付渠道
app\_id
int(10) unsigned
(NULL)
NO
MUL
0
select,insert,update,references
订单来源
server\_id
int(10) unsigned
(NULL)
NO
(NULL)
select,insert,update,references
服务器id
trade\_type
tinyint(1)
(NULL)
NO
1
select,insert,update,references
1:担保交易 2：直接交易
order\_payment\_amount
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
总付款额度 = trade\_payment\_amount + trade\_payment\_money + trade\_payment\_recharge\_card + trade\_payment\_points
trade\_payment\_amount
decimal(10,2)
(NULL)
NO
0.00
select,insert,update,references
实付金额，在线支付金额
trade\_payment\_money
decimal(10,2)
(NULL)
NO
0.00
select,insert,update,references
余额支付
trade\_payment\_recharge\_card
decimal(10,2)
(NULL)
NO
0.00
select,insert,update,references
充值卡余额支付
trade\_payment\_points
decimal(10,2)
(NULL)
NO
0.00
select,insert,update,references
积分支付
trade\_discount
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
折扣优惠
trade\_commis\_amount
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
佣金
trade\_commis\_refund
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
退还佣金
trade\_refund\_amount
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
订单退款
trade\_amount
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
总额虚拟的 = trade\_order\_amount + trade\_discount
trade\_date
date
(NULL)
NO
(NULL)
select,insert,update,references
年-月-日
trade\_year
smallint(4)
(NULL)
NO
(NULL)
select,insert,update,references
年
trade\_month
tinyint(2)
(NULL)
NO
(NULL)
select,insert,update,references
月
trade\_day
tinyint(2)
(NULL)
NO
(NULL)
select,insert,update,references
日
trade\_title
varchar(100)
utf8\_general\_ci
NO
select,insert,update,references
标题
trade\_desc
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
描述
trade\_remark
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
备注
trade\_create\_time
timestamp
(NULL)
NO
CURRENT\_TIMESTAMP
select,insert,update,references
创建时间
trade\_pay\_time
timestamp
(NULL)
NO
0000-00-00 00:00:00
select,insert,update,references
付款时间
trade\_finish\_time
timestamp
(NULL)
NO
0000-00-00 00:00:00
select,insert,update,references
结束时间
trade\_delete
tinyint(1)
(NULL)
NO
0
select,insert,update,references
是否删除
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_consume\_trade
0
PRIMARY
1
consume\_trade\_id
A
2771
(NULL)
(NULL)
BTREE
pay\_consume\_trade
1
company\_id
1
payment\_channel\_id
A
4
(NULL)
(NULL)
BTREE
pay\_consume\_trade
1
company\_id
2
server\_id
A
4
(NULL)
(NULL)
BTREE
pay\_consume\_trade
1
app\_id
1
app\_id
A
2
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_consume\_withdraw FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(10)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
ID
pay\_uid
int(8)
(NULL)
NO
(NULL)
select,insert,update,references
会员支付ID
orderid
varchar(50)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
交易明细ID
amount
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
总数
add\_time
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
创建时间
censor
varchar(50)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
管理员
check\_time
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
操作时间
is\_succeed
tinyint(2)
(NULL)
YES
0
select,insert,update,references
是否成功
bankflow
varchar(50)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
银行流水账号
con
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
描述
bank
varchar(50)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
银行
cardno
varchar(32)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
cardname
varchar(50)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
supportTime
int(6)
(NULL)
YES
0
select,insert,update,references
fee
float(10,2)
(NULL)
YES
0.00
select,insert,update,references
remark
varchar(255)
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
平台审核备注
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_consume\_withdraw
0
PRIMARY
1
id
A
46
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_message\_template FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(10)
(NULL)
NO
PRI
(NULL)
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
commentpay\_message\_template
0
PRIMARY
1
id
A
8
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_order\_state FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentorder\_state\_id
tinyint(4)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
状态id
order\_state\_name
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
订单状态
order\_state\_text\_1
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
order\_state\_text\_2
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
order\_state\_text\_3
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
order\_state\_remark
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
备注
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_order\_state
0
PRIMARY
1
order\_state\_id
A
7
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_payment\_channel FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentpayment\_channel\_id
tinyint(4) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
ID
payment\_channel\_code
varchar(20)
utf8\_general\_ci
NO
select,insert,update,references
代码名称
payment\_channel\_name
varchar(100)
utf8\_general\_ci
NO
select,insert,update,references
支付名称
payment\_channel\_image
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
支付方式图片
payment\_channel\_config
text
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
支付接口配置信息
payment\_channel\_status
tinyint(1)
(NULL)
NO
0
select,insert,update,references
接口状态
payment\_channel\_allow
enum('pc','wap','both')
utf8\_general\_ci
NO
pc
select,insert,update,references
类型
payment\_channel\_wechat
tinyint(4)
(NULL)
NO
1
select,insert,update,references
微信中是否可以使用
payment\_channel\_enable
tinyint(4)
(NULL)
NO
1
select,insert,update,references
是否启用
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_payment\_channel
0
PRIMARY
1
payment\_channel\_id
A
6
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_record\_state FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentrecord\_state\_id
tinyint(4)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
状态id
record\_state\_name
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
交易状态
record\_state\_text\_1
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
record\_state\_text\_2
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
record\_state\_text\_3
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
record\_state\_remark
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
备注
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_record\_state
0
PRIMARY
1
record\_state\_id
A
6
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_service\_fee FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(6)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
name
varchar(100)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
fee\_rates
float(12,2)
(NULL)
YES
0.00
select,insert,update,references
fee\_min
int(2)
(NULL)
YES
0
select,insert,update,references
fee\_max
int(2)
(NULL)
YES
0
select,insert,update,references
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_service\_fee
0
PRIMARY
1
id
A
4
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_trade\_mode FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommenttrade\_mode\_id
tinyint(4)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
交易方式id
trade\_mode\_name
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
交易方式名称
trade\_mode\_text
varchar(20)
utf8\_general\_ci
NO
select,insert,update,references
交易方式名称
trade\_mode\_partner
varchar(20)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
商户号
trade\_mode\_key
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
密钥
trade\_mode\_sign
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
校验码
trade\_mode\_image
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
支付方式图片
trade\_mode\_remark
varchar(200)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
交易方式备注
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_trade\_mode
0
PRIMARY
1
trade\_mode\_id
A
4
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_trade\_type FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommenttrade\_type\_id
tinyint(4)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
状态id
trade\_type\_name
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
订单状态
trade\_type\_text
varchar(20)
utf8\_general\_ci
NO
select,insert,update,references
名称
trade\_type\_remark
varchar(200)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
备注
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_trade\_type
0
PRIMARY
1
trade\_type\_id
A
4
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_transfer\_money FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid
int(11)
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
from\_user
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
发起转帐或红包的人
to\_user
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
接收人
send\_time
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
发送时间
receive\_time
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
收到时间
money
decimal(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
转了多少钱
status
tinyint(4)
(NULL)
NO
0
select,insert,update,references
1为已收到，2为过期
txt
text
utf8\_general\_ci
YES
(NULL)
select,insert,update,references
注释
type
tinyint(1)
(NULL)
NO
1
select,insert,update,references
1红包 2 转帐
transaction\_number
char(20)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
交易单号
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_transfer\_money
0
PRIMARY
1
id
A
655
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_union\_order FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentunion\_order\_id
varchar(20)
utf8\_general\_ci
NO
PRI
(NULL)
select,insert,update,references
编号
inorder
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
合并订单编号
trade\_title
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
商品名称 - 标题
trade\_payment\_amount
float(10,2)
(NULL)
NO
(NULL)
select,insert,update,references
总价格
create\_time
datetime
(NULL)
NO
(NULL)
select,insert,update,references
创建时间
buyer\_id
int(12)
(NULL)
NO
(NULL)
select,insert,update,references
买家ID
trade\_desc
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
描述
order\_state\_id
tinyint(1)
(NULL)
NO
1
select,insert,update,references
订单状态 1- 待付款状态
pay\_time
datetime
(NULL)
NO
(NULL)
select,insert,update,references
支付时间
payment\_channel\_id
tinyint(4)
(NULL)
NO
(NULL)
select,insert,update,references
支付渠道
app\_id
int(11)
(NULL)
NO
0
select,insert,update,references
订单来源
trade\_type\_id
tinyint(1)
(NULL)
NO
0
select,insert,update,references
交易类型
union\_cards\_pay\_amount
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
购物卡支付金额
union\_cards\_return\_amount
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
购物卡退款金额
union\_money\_pay\_amount
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
预存款支付金额
union\_money\_return\_amount
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
预存款退款金额
union\_online\_pay\_amount
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
在线支付金额
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_union\_order
0
PRIMARY
1
union\_order\_id
A
5949
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_user\_app FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentapp\_id
int(11) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
服务ID
app\_name
varchar(40)
utf8\_general\_ci
NO
select,insert,update,references
服务名称
app\_key
varchar(50)
utf8\_general\_ci
NO
select,insert,update,references
服务密钥
app\_url
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
服务网址
app\_status
tinyint(1) unsigned
(NULL)
NO
1
select,insert,update,references
状态 1：启用 0：禁用
user\_id
int(10) unsigned
(NULL)
NO
0
select,insert,update,references
用户id-平台id，平台结算最后映射到这个用户账户中-platform\_id，server\_id, platform\_user\_id
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_user\_app
0
PRIMARY
1
app\_id
A
8
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_user\_bank\_card FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentcard\_id
int(10) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
id
user\_id
int(10)
(NULL)
NO
(NULL)
select,insert,update,references
用户id
bank\_name
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
银行名称
bank\_card\_number
varchar(50)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
银行卡号
bank\_user\_name
varchar(30)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
开户人姓名
bank\_mobile\_number
varchar(11)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
银行预留手机号
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_user\_bank\_card
0
PRIMARY
1
card\_id
A
11
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_user\_base FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id
int(10) unsigned
(NULL)
NO
PRI
(NULL)
auto\_increment
select,insert,update,references
用户id
user\_number
varchar(50)
utf8\_general\_ci
NO
select,insert,update,references
用户编号
user\_account
varchar(50)
utf8\_general\_ci
NO
UNI
select,insert,update,references
用户帐号
user\_passwd
char(32)
utf8\_general\_ci
NO
select,insert,update,references
密码：使用用户中心-此处废弃
user\_pay\_passwd
varchar(32)
utf8\_general\_ci
NO
select,insert,update,references
支付确认密码
user\_key
char(32)
utf8\_general\_ci
NO
select,insert,update,references
用户Key
user\_delete
tinyint(4)
(NULL)
NO
0
select,insert,update,references
是否被封禁，0：未封禁，1：封禁
user\_login\_times
mediumint(8) unsigned
(NULL)
NO
1
select,insert,update,references
登录次数
user\_login\_time
datetime
(NULL)
NO
0000-00-00 00:00:00
select,insert,update,references
最后登录时间
user\_login\_ip
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
登录ip
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_user\_base
0
PRIMARY
1
user\_id
A
284
(NULL)
(NULL)
BTREE
pay\_user\_base
0
user\_account
1
user\_account
A
284
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_user\_info FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id
int(10) unsigned
(NULL)
NO
PRI
(NULL)
select,insert,update,references
用户id
user\_realname
varchar(30)
utf8\_general\_ci
NO
select,insert,update,references
真实姓名
user\_nickname
varchar(30)
utf8\_general\_ci
NO
select,insert,update,references
用户昵称
user\_type\_id
smallint(4) unsigned
(NULL)
YES
0
select,insert,update,references
用户类别
user\_level\_id
smallint(4) unsigned
(NULL)
YES
1
select,insert,update,references
用户等级
user\_active\_time
timestamp
(NULL)
NO
CURRENT\_TIMESTAMP
select,insert,update,references
激活时间
user\_remark
varchar(200)
utf8\_general\_ci
NO
select,insert,update,references
备注消息
user\_provinceid
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
user\_cityid
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
user\_areaid
int(11)
(NULL)
NO
(NULL)
select,insert,update,references
user\_address
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
用户详细地址
user\_email
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
用户邮箱
user\_mobile
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
用户手机
user\_qq
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
user\_avatar
varchar(255)
utf8\_general\_ci
NO
select,insert,update,references
user\_identity\_card
varchar(30)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
身份证号
user\_identity\_statu
tinyint(1)
(NULL)
NO
0
select,insert,update,references
0未审核1待审核2审核成功3审核失败
user\_identity\_type
tinyint(1)
(NULL)
NO
1
select,insert,update,references
证件类型 1身份证 2护照 3军官证
user\_identity\_font\_logo
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
证件照反面
user\_identity\_face\_logo
varchar(255)
utf8\_general\_ci
NO
(NULL)
select,insert,update,references
证件照正面
user\_identity\_start\_time
date
(NULL)
NO
(NULL)
select,insert,update,references
证件有效期，开始时间
user\_identity\_end\_time
date
(NULL)
NO
(NULL)
select,insert,update,references
证件有效期，结束时间
user\_bt\_status
tinyint(1)
(NULL)
NO
0
select,insert,update,references
白条审核状态：0未审核1待审核2审核成功3审核失败
user\_btapply\_time
datetime
(NULL)
NO
(NULL)
select,insert,update,references
白条申请时间
user\_btverify\_time
datetime
(NULL)
NO
(NULL)
select,insert,update,references
白条审核时间
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_user\_info
0
PRIMARY
1
user\_id
A
346
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_user\_resource FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id
int(10) unsigned
(NULL)
NO
PRI
(NULL)
select,insert,update,references
用户id
user\_money\_pending\_settlement
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
待结算余额
user\_money
decimal(16,2) unsigned
(NULL)
NO
0.00
select,insert,update,references
用户资金-预付款充值、转账、结算后的款项等等
user\_money\_frozen
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
user\_recharge\_card
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
充值卡余额-只能从来购物
user\_recharge\_card\_frozen
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
user\_points
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
积分
user\_points\_frozen
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
user\_credit\_limit
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
信用额度
user\_credit\_availability
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
可用额度
user\_credit\_return
decimal(16,2)
(NULL)
NO
0.00
select,insert,update,references
已还信用额度
user\_credit\_cycle
mediumint(4)
(NULL)
NO
30
select,insert,update,references
白条还款周期
IndexesTableNon
uniqueKey
nameSeq
in
indexColumn
nameCollationCardinalitySub
partPackedNullIndex
typeCommentIndex
commentpay\_user\_resource
0
PRIMARY
1
user\_id
A
286
(NULL)
(NULL)
BTREE
[Back](#header)
pay\_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
commentpay\_web\_config
0
PRIMARY
1
config\_key
A
207
(NULL)
(NULL)
BTREE
pay\_web\_config
1
index
1
config\_key
A
207
(NULL)
(NULL)
BTREE
pay\_web\_config
1
index
2
config\_type
A
207
(NULL)
(NULL)
BTREE
- 序言
- 系统要求
- 版本更新日志
- 远丰商城技术对接说明
- 开发指导
- 框架内容
- 基础
- 开发规范
- 目录结构
- 架构
- 架构总览
- 数据库
- 数据库连接
- 基本使用
- 缓存
- 配置
- 路由
- 数据字典
- ucenter
- shop
- paycenter
- ucenter_admin
- shop_admin
- paycenter_admin
- 通讯内容
- 商家中心
- 顶部导航栏
- 店铺信息栏
- 店铺及商品提示栏
- 交易提示栏
- 销售情况统计栏
- 单品销量排行栏
- 店铺运营推广栏
- 平台联系方式栏
- 订单物流
- 商品
- 商品列表
- 商品详情
- 商品发布与编辑
- 分销商品
- 关联版式
- 商品规格
- 图片空间
- 淘宝导入
- 订单流程
- 交易订单
- 订单退款/退货
- 促销
- 团购管理
- 加价购
- 限时折扣
- 满即送
- 代金券管理
- 分销
- 店铺
- 店铺设置
- 自销产品供应商
- 实体店铺
- 品牌申请
- 店铺信息
- 消费者保障服务
- 门店账号
- 分销商--产品供应商
- 分销明细
- 批发市场
- 售后服务
- 咨询管理
- 投诉管理
- 退款管理
- 退货管理
- 云方案架构
- 负载集群
- 云存储
- 接口
- Api接口说明
- 品牌
- 商品规格
- 商品类型
- 商品分类
- 商品
- 订单
- 商品/店铺收藏
- 足迹
- 退款及退货
- 商家店铺
- 会员
- 入驻协议
- 订单接口
- 商品接口
- 订单物流接口
- 商家中心接口
- 促销接口
- 快递鸟物流接口
- 代金券接口
- 首页版块
- 团购
- 平台红包
- 限时折扣接口
- 拼团接口
- wap首页模板
- 杂项
- 远程上传图片
- JS
- 银联支付
- 多语言
- 商品评分
- 图片加载
- 买家申请退款退货
- 商家退款退货
- 平台退款退货
- 添加发票
- 提交订单
- 确认订单
- 运费销售区域
- 获取会员地址
- 充值
- 导出XLS
- 商城系统集成
- 多语言实现
- 三级分销推广链接发展推广员
- app.ini.php
- 去分销
- 版本更新
- 物流支持
- 运营人员建议
- 业务逻辑
- 统计结算
- 客服消息
- 账号
- 三级分销
- IM
- 配置
- 平台帐号
- 活动数据表说明