paycenter · 英文版開發文檔

# 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