test

test


t_base_order_details

<h4>t_base_order_details</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint(20)</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>daytime</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>?????</td> </tr> <tr> <td>payeename</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>payeename_touguteach</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>app</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>appname</td> <td>varchar(30)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>plat</td> <td>varchar(10)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>orderid</td> <td>varchar(40)</td> <td>YES</td> <td></td> <td>???</td> </tr> <tr> <td>username</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>reg_time</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>reg_channel</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>?????</td> </tr> <tr> <td>reg_channel_name</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>?????</td> </tr> <tr> <td>reg_app</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>ctime</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>paytime</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>paytype</td> <td>int(11)</td> <td>YES</td> <td></td> <td>????1,???2,???3,????4,????5,???? 6,????? 7,?? 8,????10,???? 11,???? 12,???? 99,?????</td> </tr> <tr> <td>webpayid</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>?????</td> </tr> <tr> <td>paydetail</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>price</td> <td>float(11,0)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>paytotal</td> <td>float(11,0)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>paychannel</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>?????</td> </tr> <tr> <td>productid</td> <td>varchar(60)</td> <td>YES</td> <td></td> <td>??ID</td> </tr> <tr> <td>productname</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>moduleid</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>??ID</td> </tr> <tr> <td>modulename</td> <td>varchar(500)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>moduletime</td> <td>int(11)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>status</td> <td>int(11)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>tradetype</td> <td>int(11)</td> <td>YES</td> <td></td> <td>???? E???????1-???2-???3-????</td> </tr> <tr> <td>canceltime</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>cancelamount</td> <td>int(11)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>freeflag</td> <td>int(11)</td> <td>YES</td> <td></td> <td>????:0????,1?????</td> </tr> <tr> <td>update_time</td> <td>timestamp</td> <td>YES</td> <td>CURRENT_TIMESTAMP</td> <td></td> </tr> </tbody> </table>

页面列表

ITEM_HTML