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>