paycenter · 商城二開文檔

<table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td class="toptext">paycenter</td> </tr> </table> <a name="header">&nbsp</a><ul> <li><a href="#pay_card_base">pay_card_base</a></li> <li><a href="#pay_card_info">pay_card_info</a></li> <li><a href="#pay_card_media">pay_card_media</a></li> <li><a href="#pay_consume_deposit">pay_consume_deposit</a></li> <li><a href="#pay_consume_record">pay_consume_record</a></li> <li><a href="#pay_consume_trade">pay_consume_trade</a></li> <li><a href="#pay_consume_withdraw">pay_consume_withdraw</a></li> <li><a href="#pay_message_template">pay_message_template</a></li> <li><a href="#pay_order_state">pay_order_state</a></li> <li><a href="#pay_payment_channel">pay_payment_channel</a></li> <li><a href="#pay_record_state">pay_record_state</a></li> <li><a href="#pay_service_fee">pay_service_fee</a></li> <li><a href="#pay_trade_mode">pay_trade_mode</a></li> <li><a href="#pay_trade_type">pay_trade_type</a></li> <li><a href="#pay_transfer_money">pay_transfer_money</a></li> <li><a href="#pay_union_order">pay_union_order</a></li> <li><a href="#pay_user_app">pay_user_app</a></li> <li><a href="#pay_user_bank_card">pay_user_bank_card</a></li> <li><a href="#pay_user_base">pay_user_base</a></li> <li><a href="#pay_user_info">pay_user_info</a></li> <li><a href="#pay_user_resource">pay_user_resource</a></li> <li><a href="#pay_web_config">pay_web_config</a></li> </ul> <a name='pay_card_base'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_card_base</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">card_id</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡的id</td> </tr> <tr> <td align="left" valign="top">app_id</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">9999</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">app id ： 9999 通用</td> </tr> <tr> <td align="left" valign="top">card_name</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡名稱</td> </tr> <tr> <td align="left" valign="top">card_prize</td> <td align="left" valign="top">varchar(2000)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片里面的獎品</td> </tr> <tr> <td align="left" valign="top">card_desc</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片描述</td> </tr> <tr> <td align="left" valign="top">card_start_time</td> <td align="left" valign="top">date</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡的有效開始時間</td> </tr> <tr> <td align="left" valign="top">card_end_time</td> <td align="left" valign="top">date</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡的有效結束時間</td> </tr> <tr> <td align="left" valign="top">card_image</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片圖片網址</td> </tr> <tr> <td align="left" valign="top">card_num</td> <td align="left" valign="top">int(255)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片數量</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">Payceneter付款平臺的卡片表，Payceneter付款平臺添加卡片信息卡片的有效時間添加成功后，平臺方可以將卡號卡密給用戶，用戶拿著卡號卡密可以對商城余額進行充值，可以抵扣支付金額</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_card_base</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">card_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">21</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_card_info'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_card_info</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">card_code</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片激活碼</td> </tr> <tr> <td align="left" valign="top">card_password</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片密碼</td> </tr> <tr> <td align="left" valign="top">card_id</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片id</td> </tr> <tr> <td align="left" valign="top">card_fetch_time</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00 00:00:00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">領獎時間</td> </tr> <tr> <td align="left" valign="top">card_media_id</td> <td align="left" valign="top">smallint(6)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">媒體id,參照base_card_media表</td> </tr> <tr> <td align="left" valign="top">server_id</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">領卡人的服務器id</td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_account</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">領卡人賬號</td> </tr> <tr> <td align="left" valign="top">card_time</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">CURRENT_TIMESTAMP</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡牌生成時間</td> </tr> <tr> <td align="left" valign="top">card_money</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">充值卡余額</td> </tr> <tr> <td align="left" valign="top">card_froze_money</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡凍結金額</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">領卡人的信息表，對上述領卡人的信息與卡片綁定</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_card_info</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">card_code</td> <td align="left" valign="top">A</td> <td align="left" valign="top">1859</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_card_media'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_card_media</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">card_media_id</td> <td align="left" valign="top">mediumint(9)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片的媒體id</td> </tr> <tr> <td align="left" valign="top">card_media_name</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">卡片的媒體標題</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">卡片的展示信息，對應的媒體內容，待升級內容</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_card_media</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">card_media_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">0</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_consume_deposit'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_consume_deposit</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">deposit_trade_no</td> <td align="left" valign="top">varchar(64)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易號</td> </tr> <tr> <td align="left" valign="top">deposit_buyer_id</td> <td align="left" valign="top">varchar(30)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶號</td> </tr> <tr> <td align="left" valign="top">deposit_total_fee</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易金額</td> </tr> <tr> <td align="left" valign="top">deposit_pay_channel</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">充值的付款方式</td> </tr> <tr> <td align="left" valign="top">deposit_gmt_create</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">CURRENT_TIMESTAMP</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易創建時間</td> </tr> <tr> <td align="left" valign="top">deposit_gmt_payment</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00 00:00:00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易付款時間</td> </tr> <tr> <td align="left" valign="top">deposit_gmt_close</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00 00:00:00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">deposit_trade_status</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易狀態</td> </tr> <tr> <td align="left" valign="top">deposit_return_trade_no</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">充值成功以后的流水</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶在付款paycenter客戶端對于賬戶余額充值的流水賬單，每進行一次賬戶余額充值操作，會增加一條流水，上述字段是增加流水的對應信息</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <a href="#header">Back</a> <a name='pay_consume_record'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_consume_record</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">consume_record_id</td> <td align="left" valign="top">bigint(20)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易記錄id</td> </tr> <tr> <td align="left" valign="top">order_id</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">商戶訂單id</td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">所屬用id</td> </tr> <tr> <td align="left" valign="top">user_nickname</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">昵稱</td> </tr> <tr> <td align="left" valign="top">record_money</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">金額</td> </tr> <tr> <td align="left" valign="top">record_date</td> <td align="left" valign="top">date</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">年-月-日</td> </tr> <tr> <td align="left" valign="top">record_year</td> <td align="left" valign="top">smallint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">年</td> </tr> <tr> <td align="left" valign="top">record_month</td> <td align="left" valign="top">tinyint(2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">月</td> </tr> <tr> <td align="left" valign="top">record_day</td> <td align="left" valign="top">tinyint(2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">日</td> </tr> <tr> <td align="left" valign="top">record_title</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">標題</td> </tr> <tr> <td align="left" valign="top">record_desc</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">描述</td> </tr> <tr> <td align="left" valign="top">record_time</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">CURRENT_TIMESTAMP</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">創建時間</td> </tr> <tr> <td align="left" valign="top">trade_type_id</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">??交易類型</td> </tr> <tr> <td align="left" valign="top">user_type</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">1-收款方 2-付款方</td> </tr> <tr> <td align="left" valign="top">record_status</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">付款狀態</td> </tr> <tr> <td align="left" valign="top">record_payorder</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">實際支付單號</td> </tr> <tr> <td align="left" valign="top">record_paytime</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付時間</td> </tr> <tr> <td align="left" valign="top">record_delete</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">0未刪除 1刪除</td> </tr> <tr> <td align="left" valign="top">credit_remain</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">白條剩余還款金額</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶用自己的余額購買商品，扣除相對應的賬戶余額后，會增加一條流水單對于該賬戶余額減少的記錄信息，上述對應扣除余額的流水單信息user_id代表用戶id，可在pay_user_info表里找該用戶的個人信息 order_id是訂單id可在pay_consume_trade表里通過order_id字段一一對應查找相對應的訂單信息 </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_consume_record</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">consume_record_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">8115</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_consume_trade'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_consume_trade</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">consume_trade_id</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易訂單id</td> </tr> <tr> <td align="left" valign="top">order_id</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">商戶訂單id</td> </tr> <tr> <td align="left" valign="top">buyer_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">買家id</td> </tr> <tr> <td align="left" valign="top">seller_id</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">賣家id</td> </tr> <tr> <td align="left" valign="top">pay_user_id</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">付款人id</td> </tr> <tr> <td align="left" valign="top">order_state_id</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">訂單狀態</td> </tr> <tr> <td align="left" valign="top">trade_type_id</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易類型</td> </tr> <tr> <td align="left" valign="top">payment_channel_id</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">MUL</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付渠道</td> </tr> <tr> <td align="left" valign="top">app_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">MUL</td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">訂單來源</td> </tr> <tr> <td align="left" valign="top">server_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">服務器id</td> </tr> <tr> <td align="left" valign="top">trade_type</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">1:擔保交易 2：直接交易</td> </tr> <tr> <td align="left" valign="top">order_payment_amount</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">總付款額度 = trade_payment_amount + trade_payment_money + trade_payment_recharge_card + trade_payment_points</td> </tr> <tr> <td align="left" valign="top">trade_payment_amount</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">實付金額，在線支付金額</td> </tr> <tr> <td align="left" valign="top">trade_payment_money</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">余額支付</td> </tr> <tr> <td align="left" valign="top">trade_payment_recharge_card</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">充值卡余額支付</td> </tr> <tr> <td align="left" valign="top">trade_payment_points</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">積分支付</td> </tr> <tr> <td align="left" valign="top">trade_discount</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">折扣優惠</td> </tr> <tr> <td align="left" valign="top">trade_commis_amount</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">傭金</td> </tr> <tr> <td align="left" valign="top">trade_commis_refund</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">退還傭金</td> </tr> <tr> <td align="left" valign="top">trade_refund_amount</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">訂單退款</td> </tr> <tr> <td align="left" valign="top">trade_amount</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">總額虛擬的 = trade_order_amount + trade_discount</td> </tr> <tr> <td align="left" valign="top">trade_date</td> <td align="left" valign="top">date</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">年-月-日</td> </tr> <tr> <td align="left" valign="top">trade_year</td> <td align="left" valign="top">smallint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">年</td> </tr> <tr> <td align="left" valign="top">trade_month</td> <td align="left" valign="top">tinyint(2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">月</td> </tr> <tr> <td align="left" valign="top">trade_day</td> <td align="left" valign="top">tinyint(2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">日</td> </tr> <tr> <td align="left" valign="top">trade_title</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">標題</td> </tr> <tr> <td align="left" valign="top">trade_desc</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">描述</td> </tr> <tr> <td align="left" valign="top">trade_remark</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">備注</td> </tr> <tr> <td align="left" valign="top">trade_create_time</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">CURRENT_TIMESTAMP</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">創建時間</td> </tr> <tr> <td align="left" valign="top">trade_pay_time</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00 00:00:00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">付款時間</td> </tr> <tr> <td align="left" valign="top">trade_finish_time</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00 00:00:00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">結束時間</td> </tr> <tr> <td align="left" valign="top">trade_delete</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">是否刪除</td> </tr><tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶訂單記錄表，用戶下單付款時產生此條支付數據，如果是商城用戶端下單并支付的時候會產生此條訂單，上面字段是支付的來源，方式，渠道做了區分</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_consume_trade</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">consume_trade_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">2771</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">pay_consume_trade</td> <td align="left" valign="top">1</td> <td align="left" valign="top">company_id</td> <td align="left" valign="top">1</td> <td align="left" valign="top">payment_channel_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">4</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">pay_consume_trade</td> <td align="left" valign="top">1</td> <td align="left" valign="top">company_id</td> <td align="left" valign="top">2</td> <td align="left" valign="top">server_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">4</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">pay_consume_trade</td> <td align="left" valign="top">1</td> <td align="left" valign="top">app_id</td> <td align="left" valign="top">1</td> <td align="left" valign="top">app_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">2</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_consume_withdraw'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_consume_withdraw</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">id</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">ID</td> </tr> <tr> <td align="left" valign="top">pay_uid</td> <td align="left" valign="top">int(8)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">會員支付ID</td> </tr> <tr> <td align="left" valign="top">orderid</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易明細ID</td> </tr> <tr> <td align="left" valign="top">amount</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">總數</td> </tr> <tr> <td align="left" valign="top">add_time</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">創建時間</td> </tr> <tr> <td align="left" valign="top">censor</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">管理員</td> </tr> <tr> <td align="left" valign="top">check_time</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">操作時間</td> </tr> <tr> <td align="left" valign="top">is_succeed</td> <td align="left" valign="top">tinyint(2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">是否成功</td> </tr> <tr> <td align="left" valign="top">bankflow</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">銀行流水賬號</td> </tr> <tr> <td align="left" valign="top">con</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">描述</td> </tr> <tr> <td align="left" valign="top">bank</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">銀行</td> </tr> <tr> <td align="left" valign="top">cardno</td> <td align="left" valign="top">varchar(32)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">cardname</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">supportTime</td> <td align="left" valign="top">int(6)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">fee</td> <td align="left" valign="top">float(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">remark</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">平臺審核備注</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">余額提現的記錄表是將余額提現到微信，支付寶，銀行是系統會產生一條記錄流水單，關于此筆金額的走向，是那個用戶pay_uid，產生的提現訂單號 orderid ，總錢數amount，如果提現到銀行bank銀行名稱，cardno銀行卡號， Cardname持卡人姓名，fee提現手續費 is_succeed 審核狀態該筆提現訂單是否成功 remark提現備注如提現到支付寶 withdraw_identity 為支付寶賬戶，微信就為微信賬戶，withdraw_name支付寶用戶所屬姓名</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_consume_withdraw</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">46</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_message_template'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_message_template</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">id</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">code</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">name</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">title</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">主題</td> </tr> <tr> <td align="left" valign="top">content_email</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">郵件內容</td> </tr> <tr> <td align="left" valign="top">type</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">0商家 1用戶</td> </tr> <tr> <td align="left" valign="top">is_phone</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">0關閉 1開啟</td> </tr> <tr> <td align="left" valign="top">is_email</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">0關閉 1開啟</td> </tr> <tr> <td align="left" valign="top">is_mail</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">0關閉 1開啟</td> </tr> <tr> <td align="left" valign="top">content_mail</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">站內信內容</td> </tr> <tr> <td align="left" valign="top">content_phone</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">短信內容</td> </tr> <tr> <td align="left" valign="top">force_phone</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">手機短信0不強制1強制</td> </tr> <tr> <td align="left" valign="top">force_email</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">郵件0不強制1強制</td> </tr> <tr> <td align="left" valign="top">force_mail</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">站內信0不強制1強制</td> </tr> <tr> <td align="left" valign="top">mold</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">0常用提示 1訂單提示 2卡券提示 3售后提示</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">信息模板表，信息模板的編號code，用戶功能需要向客戶端發送信息的代碼上綁定相對應的編碼，然后編輯信息模板按照編輯內容進行發送有3種方式，3個方式的狀態，mold為功能性提示</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_message_template</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">8</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_order_state'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_order_state</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">order_state_id</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">狀態id</td> </tr> <tr> <td align="left" valign="top">order_state_name</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">訂單狀態</td> </tr> <tr> <td align="left" valign="top">order_state_text_1</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">order_state_text_2</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">order_state_text_3</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">order_state_remark</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">備注</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">支付系統的訂單狀態表，每一個狀態數字代表一個訂單狀態order_state_text_對此訂單狀態的描述</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_order_state</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">order_state_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">7</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_payment_channel'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_payment_channel</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">payment_channel_id</td> <td align="left" valign="top">tinyint(4) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">ID</td> </tr> <tr> <td align="left" valign="top">payment_channel_code</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">代碼名稱</td> </tr> <tr> <td align="left" valign="top">payment_channel_name</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付名稱</td> </tr> <tr> <td align="left" valign="top">payment_channel_image</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付方式圖片</td> </tr> <tr> <td align="left" valign="top">payment_channel_config</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付接口配置信息</td> </tr> <tr> <td align="left" valign="top">payment_channel_status</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">接口狀態</td> </tr> <tr> <td align="left" valign="top">payment_channel_allow</td> <td align="left" valign="top">enum('pc','wap','both')</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">pc</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">類型</td> </tr> <tr> <td align="left" valign="top">payment_channel_wechat</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">微信中是否可以使用</td> </tr> <tr> <td align="left" valign="top">payment_channel_enable</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">是否啟用</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">支付平臺添加支付頁面的支付方式例如支付寶和微信支付，payment_channel_code代表支付方式的編碼，payment_channel_name付款方式的名稱，例如支付寶、微信、支付寶電腦端、小程序支付，payment_channel_config每種支付方式的配置信息，例如在相對應的支付平臺申請的支付賬戶和APPID</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_payment_channel</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">payment_channel_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">6</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_record_state'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_record_state</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">record_state_id</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">狀態id</td> </tr> <tr> <td align="left" valign="top">record_state_name</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易狀態</td> </tr> <tr> <td align="left" valign="top">record_state_text_1</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">record_state_text_2</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">record_state_text_3</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">record_state_remark</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">備注</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">交易狀態表，每個數字對應每一項交易的狀態，record_state_id狀態數字id，record_state_name狀態名稱，record_state_text_對交易狀態的描述</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_record_state</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">record_state_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">6</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_service_fee'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_service_fee</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">id</td> <td align="left" valign="top">int(6)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">name</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">fee_rates</td> <td align="left" valign="top">float(12,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">fee_min</td> <td align="left" valign="top">int(2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">fee_max</td> <td align="left" valign="top">int(2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr><tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶對于服務不同需求所以對應的收取費用name，提取需求的描述，fee_rates float收取的相應費用，fee_min最小收取的服務費，fee_max最大的收取的服務費用</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_service_fee</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">4</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_trade_mode'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_trade_mode</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">trade_mode_id</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易方式id</td> </tr> <tr> <td align="left" valign="top">trade_mode_name</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易方式名稱</td> </tr> <tr> <td align="left" valign="top">trade_mode_text</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易方式名稱</td> </tr> <tr> <td align="left" valign="top">trade_mode_partner</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">商戶號</td> </tr> <tr> <td align="left" valign="top">trade_mode_key</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">密鑰</td> </tr> <tr> <td align="left" valign="top">trade_mode_sign</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">校驗碼</td> </tr> <tr> <td align="left" valign="top">trade_mode_image</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付方式圖片</td> </tr> <tr> <td align="left" valign="top">trade_mode_remark</td> <td align="left" valign="top">varchar(200)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易方式備注</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">交易類型表，trade_mode_id交易數字ID，trade_mode_name交易類型編碼，在代碼中定義的交易常量trade_mode_text交易名稱，交易接收方的賬戶，密鑰，校驗碼信息</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_trade_mode</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">trade_mode_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">4</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_trade_type'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_trade_type</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">trade_type_id</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">狀態id</td> </tr> <tr> <td align="left" valign="top">trade_type_name</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">訂單狀態</td> </tr> <tr> <td align="left" valign="top">trade_type_text</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">名稱</td> </tr> <tr> <td align="left" valign="top">trade_type_remark</td> <td align="left" valign="top">varchar(200)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">備注</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">訂單狀態表，在pay_consume_record交易記錄表里的trade_type_id字段對應的狀態信息在此表里進行信息展示</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_trade_type</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">trade_type_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">4</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_transfer_money'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_transfer_money</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">id</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">from_user</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">發起轉帳或紅包的人</td> </tr> <tr> <td align="left" valign="top">to_user</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">接收人</td> </tr> <tr> <td align="left" valign="top">send_time</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">發送時間</td> </tr> <tr> <td align="left" valign="top">receive_time</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">收到時間</td> </tr> <tr> <td align="left" valign="top">money</td> <td align="left" valign="top">decimal(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">轉了多少錢</td> </tr> <tr> <td align="left" valign="top">status</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">1為已收到，2為過期</td> </tr> <tr> <td align="left" valign="top">txt</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">注釋</td> </tr> <tr> <td align="left" valign="top">type</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">1紅包 2 轉帳</td> </tr> <tr> <td align="left" valign="top">transaction_number</td> <td align="left" valign="top">char(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易單號</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">轉賬和收紅包記錄表，記錄相對應的金額，發接的信息人信息，收取狀態status，交易單號transaction_number，時間</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_transfer_money</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">655</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_union_order'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_union_order</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">union_order_id</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">編號</td> </tr> <tr> <td align="left" valign="top">inorder</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">合并訂單編號</td> </tr> <tr> <td align="left" valign="top">trade_title</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">商品名稱 - 標題</td> </tr> <tr> <td align="left" valign="top">trade_payment_amount</td> <td align="left" valign="top">float(10,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">總價格</td> </tr> <tr> <td align="left" valign="top">create_time</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">創建時間</td> </tr> <tr> <td align="left" valign="top">buyer_id</td> <td align="left" valign="top">int(12)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">買家ID</td> </tr> <tr> <td align="left" valign="top">trade_desc</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">描述</td> </tr> <tr> <td align="left" valign="top">order_state_id</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">訂單狀態 1- 待付款狀態</td> </tr> <tr> <td align="left" valign="top">pay_time</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付時間</td> </tr> <tr> <td align="left" valign="top">payment_channel_id</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付渠道</td> </tr> <tr> <td align="left" valign="top">app_id</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">訂單來源</td> </tr> <tr> <td align="left" valign="top">trade_type_id</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">交易類型</td> </tr> <tr> <td align="left" valign="top">union_cards_pay_amount</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">購物卡支付金額</td> </tr> <tr> <td align="left" valign="top">union_cards_return_amount</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">購物卡退款金額</td> </tr> <tr> <td align="left" valign="top">union_money_pay_amount</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">預存款支付金額</td> </tr> <tr> <td align="left" valign="top">union_money_return_amount</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">預存款退款金額</td> </tr> <tr> <td align="left" valign="top">union_online_pay_amount</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">在線支付金額</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8"> 支付訂單記錄表包括對已支付訂單進行合并訂單后共用一個支付單號進行統一付款，支付單號union_order_id，訂單號（包括合并訂單號）、notify_data支付回調參數例如微信支付是屬于異步支付，支付成功后，微信會進行訂單信息推送，會將推送的json 信息放在此字段，包括標準版預售的活動，會將預售給予的定金presale_deposit此次付款的金額進行記錄，還有預售的尾款final_price，當參加后后續需要付款的金額會包括union_money_pay_amount支付金額里進行存儲，剩余的尾款訂單號presale_union_order_id也會加以存儲</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_union_order</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">union_order_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">5949</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_user_app'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_user_app</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">app_id</td> <td align="left" valign="top">int(11) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">服務ID</td> </tr> <tr> <td align="left" valign="top">app_name</td> <td align="left" valign="top">varchar(40)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">服務名稱</td> </tr> <tr> <td align="left" valign="top">app_key</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">服務密鑰</td> </tr> <tr> <td align="left" valign="top">app_url</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">服務網址</td> </tr> <tr> <td align="left" valign="top">app_status</td> <td align="left" valign="top">tinyint(1) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">狀態 1：啟用 0：禁用</td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶id-平臺id，平臺結算最后映射到這個用戶賬戶中-platform_id，server_id, platform_user_id</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">服務配置信息表，多個系統信息是以接口方式達到數據互通 app_id各個接口相互識別的接口id，app_name相同網站的名稱例如，ucenter、paycenter 各個網站接口公共app_key 各個網站接口公共地址app_url 此網址對接接口的啟用狀態app_status</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_user_app</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">app_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">8</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_user_bank_card'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_user_bank_card</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">card_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">id</td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶id</td> </tr> <tr> <td align="left" valign="top">bank_name</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">銀行名稱</td> </tr> <tr> <td align="left" valign="top">bank_card_number</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">銀行卡號</td> </tr> <tr> <td align="left" valign="top">bank_user_name</td> <td align="left" valign="top">varchar(30)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">開戶人姓名</td> </tr> <tr> <td align="left" valign="top">bank_mobile_number</td> <td align="left" valign="top">varchar(11)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">銀行預留手機號</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶錄入的銀行卡信息表</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_user_bank_card</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">card_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">11</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_user_base'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_user_base</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶id</td> </tr> <tr> <td align="left" valign="top">user_number</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶編號</td> </tr> <tr> <td align="left" valign="top">user_account</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">UNI</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶帳號</td> </tr> <tr> <td align="left" valign="top">user_passwd</td> <td align="left" valign="top">char(32)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">密碼：使用用戶中心-此處廢棄</td> </tr> <tr> <td align="left" valign="top">user_pay_passwd</td> <td align="left" valign="top">varchar(32)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">支付確認密碼</td> </tr> <tr> <td align="left" valign="top">user_key</td> <td align="left" valign="top">char(32)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶Key</td> </tr> <tr> <td align="left" valign="top">user_delete</td> <td align="left" valign="top">tinyint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">是否被封禁，0：未封禁，1：封禁</td> </tr> <tr> <td align="left" valign="top">user_login_times</td> <td align="left" valign="top">mediumint(8) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">登錄次數</td> </tr> <tr> <td align="left" valign="top">user_login_time</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00 00:00:00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">最后登錄時間</td> </tr> <tr> <td align="left" valign="top">user_login_ip</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">登錄ip</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">Paycenter用戶表包括用戶在平臺的狀態，如是未封禁狀態可以用支付密碼user_passwd進行余額支付用戶每次登陸會自動生成一個登陸的用戶秘鑰user_key 、 user_login_times記錄的是登錄的次數，其他字段是登錄信息的記錄</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_user_base</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">284</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">pay_user_base</td> <td align="left" valign="top">0</td> <td align="left" valign="top">user_account</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_account</td> <td align="left" valign="top">A</td> <td align="left" valign="top">284</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_user_info'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_user_info</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶id</td> </tr> <tr> <td align="left" valign="top">user_realname</td> <td align="left" valign="top">varchar(30)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">真實姓名</td> </tr> <tr> <td align="left" valign="top">user_nickname</td> <td align="left" valign="top">varchar(30)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶昵稱</td> </tr> <tr> <td align="left" valign="top">user_type_id</td> <td align="left" valign="top">smallint(4) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶類別</td> </tr> <tr> <td align="left" valign="top">user_level_id</td> <td align="left" valign="top">smallint(4) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">YES</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶等級</td> </tr> <tr> <td align="left" valign="top">user_active_time</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">CURRENT_TIMESTAMP</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">激活時間</td> </tr> <tr> <td align="left" valign="top">user_remark</td> <td align="left" valign="top">varchar(200)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">備注消息</td> </tr> <tr> <td align="left" valign="top">user_provinceid</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_cityid</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_areaid</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_address</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶詳細地址</td> </tr> <tr> <td align="left" valign="top">user_email</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶郵箱</td> </tr> <tr> <td align="left" valign="top">user_mobile</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶手機</td> </tr> <tr> <td align="left" valign="top">user_qq</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_avatar</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_identity_card</td> <td align="left" valign="top">varchar(30)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">身份證號</td> </tr> <tr> <td align="left" valign="top">user_identity_statu</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">0未審核1待審核2審核成功3審核失敗</td> </tr> <tr> <td align="left" valign="top">user_identity_type</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">證件類型 1身份證 2護照 3軍官證</td> </tr> <tr> <td align="left" valign="top">user_identity_font_logo</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">證件照反面</td> </tr> <tr> <td align="left" valign="top">user_identity_face_logo</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">證件照正面</td> </tr> <tr> <td align="left" valign="top">user_identity_start_time</td> <td align="left" valign="top">date</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">證件有效期，開始時間</td> </tr> <tr> <td align="left" valign="top">user_identity_end_time</td> <td align="left" valign="top">date</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">證件有效期，結束時間</td> </tr> <tr> <td align="left" valign="top">user_bt_status</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">白條審核狀態：0未審核1待審核2審核成功3審核失敗</td> </tr> <tr> <td align="left" valign="top">user_btapply_time</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">白條申請時間</td> </tr> <tr> <td align="left" valign="top">user_btverify_time</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">白條審核時間</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">Paycenter的個人信息表，用戶的個人信息，實名認證、所在的省user_provinceid、所在市user_cityid、所在區user_areaid、詳細地址user_address、用戶的email字段user_email、用戶的手機號user_mobile、用戶的QQ號user_qq、用戶的頭像user_avatar、用戶的身份證件號user_identity_card、身份證的正面照片user_identity_face_logo、身份證的背面照片user_identity_font_logo、身份證件的有效期開始時間user_identity_start_time、身份證件的過效期開始時間user_identity_end_time、用戶申請時間user_btapply_time、用戶身份信息提交時間user_btverify_time</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_user_info</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">346</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_user_resource'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_user_resource</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶id</td> </tr> <tr> <td align="left" valign="top">user_money_pending_settlement</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">待結算余額</td> </tr> <tr> <td align="left" valign="top">user_money</td> <td align="left" valign="top">decimal(16,2) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶資金-預付款充值、轉賬、結算后的款項等等</td> </tr> <tr> <td align="left" valign="top">user_money_frozen</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_recharge_card</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">充值卡余額-只能從來購物</td> </tr> <tr> <td align="left" valign="top">user_recharge_card_frozen</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_points</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">積分</td> </tr> <tr> <td align="left" valign="top">user_points_frozen</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_credit_limit</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">信用額度</td> </tr> <tr> <td align="left" valign="top">user_credit_availability</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">可用額度</td> </tr> <tr> <td align="left" valign="top">user_credit_return</td> <td align="left" valign="top">decimal(16,2)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0.00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">已還信用額度</td> </tr> <tr> <td align="left" valign="top">user_credit_cycle</td> <td align="left" valign="top">mediumint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">30</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">白條還款周期</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶資源表用戶余額剩余資金user_money、用戶凍結資金user_money_frozen、凍結的充值卡余額user_recharge_card_frozen、用戶凍結積分user_points_frozen</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_user_resource</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">286</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='pay_web_config'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_web_config</td> <td>&nbsp</td> <tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Fields</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="center" valign="top" class="fieldcolumn">Field</td> <td align="center" valign="top" class="fieldcolumn">Type</td> <td align="center" valign="top" class="fieldcolumn">Collation</td> <td align="center" valign="top" class="fieldcolumn">Null</td> <td align="center" valign="top" class="fieldcolumn">Key</td> <td align="center" valign="top" class="fieldcolumn">Default</td> <td align="center" valign="top" class="fieldcolumn">Extra</td> <td align="center" valign="top" class="fieldcolumn">Privileges</td> <td align="center" valign="top" class="fieldcolumn">Comment</td> </tr> <tr> <td align="left" valign="top">config_key</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">數組下標</td> </tr> <tr> <td align="left" valign="top">config_value</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">數組值</td> </tr> <tr> <td align="left" valign="top">config_type</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">config_enable</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">狀態值，1可能，0不可用</td> </tr> <tr> <td align="left" valign="top">config_comment</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">config_datatype</td> <td align="left" valign="top">enum('string','json','number')</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">string</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">數據類型</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">Paycenter網址的公共配置表，對于公共參數都存儲在這個表里，此表此條數據操作的類型config_type、公共內容描述config_comment</td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="fieldheader" width="100%" align="left" valign="top">Indexes</td> </tr> </table> <table width="100%" cellspacing="0" cellapdding="2" border="1"> <tr> <td align="left" valign="top" class="fieldcolumn">Table</td> <td align="left" valign="top" class="fieldcolumn">Non unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column name</td> <td align="left" valign="top" class="fieldcolumn">Collation</td> <td align="left" valign="top" class="fieldcolumn">Cardinality</td> <td align="left" valign="top" class="fieldcolumn">Sub part</td> <td align="left" valign="top" class="fieldcolumn">Packed</td> <td align="left" valign="top" class="fieldcolumn">Null</td> <td align="left" valign="top" class="fieldcolumn">Index type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">pay_web_config</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">config_key</td> <td align="left" valign="top">A</td> <td align="left" valign="top">207</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">pay_web_config</td> <td align="left" valign="top">1</td> <td align="left" valign="top">index</td> <td align="left" valign="top">1</td> <td align="left" valign="top">config_key</td> <td align="left" valign="top">A</td> <td align="left" valign="top">207</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">pay_web_config</td> <td align="left" valign="top">1</td> <td align="left" valign="top">index</td> <td align="left" valign="top">2</td> <td align="left" valign="top">config_type</td> <td align="left" valign="top">A</td> <td align="left" valign="top">207</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table>