t_new_sync_order_20200901

<h4>t_new_sync_order_20200901</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>0</td> <td>id</td> </tr> <tr> <td>orderid</td> <td>varchar(20)</td> <td>NO</td> <td></td> <td>??ID</td> </tr> <tr> <td>username</td> <td>varchar(50)</td> <td>NO</td> <td></td> <td>??????/UP????</td> </tr> <tr> <td>productid</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>??ID</td> </tr> <tr> <td>productname</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>producttype</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>0-?????1-????</td> </tr> <tr> <td>count</td> <td>smallint(6)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>totaldays</td> <td>int(6)</td> <td>YES</td> <td></td> <td>?????</td> </tr> <tr> <td>mobile</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>???????????</td> </tr> <tr> <td>totalprice</td> <td>int(10)</td> <td>YES</td> <td></td> <td>????????</td> </tr> <tr> <td>paytotal</td> <td>int(10)</td> <td>YES</td> <td></td> <td>???????</td> </tr> <tr> <td>status</td> <td>smallint(6)</td> <td>YES</td> <td></td> <td>????????180????220????/???90????80????70?????????230,??&quot;???200?????210&quot;??</td> </tr> <tr> <td>isrefund</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>?????0-???1-????????????</td> </tr> <tr> <td>bustype</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>?????0-???1-????????????</td> </tr> <tr> <td>source</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>?????1:????2:????</td> </tr> <tr> <td>plat</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>???????,0-pc?1-android?2-ios</td> </tr> <tr> <td>channel</td> <td>int(10)</td> <td>YES</td> <td></td> <td>???????</td> </tr> <tr> <td>couponid</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>???id</td> </tr> <tr> <td>ip</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>IP</td> </tr> <tr> <td>canceluser</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>canceltime</td> <td>bigint(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>otime</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>ext1</td> <td>varchar(10000)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>etgorderid</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>E?????</td> </tr> <tr> <td>tradetype</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>E???????1-???2-???3-????</td> </tr> <tr> <td>business_type</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>?????1-???2-???3-???4-???5-???6-???7-???8-?????</td> </tr> <tr> <td>business_name</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>??????</td> </tr> <tr> <td>payeename</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>E???????</td> </tr> <tr> <td>refundamount</td> <td>int(10)</td> <td>YES</td> <td></td> <td>E????????</td> </tr> <tr> <td>callback</td> <td>varchar(1000)</td> <td>YES</td> <td></td> <td>E????????</td> </tr> <tr> <td>auto_updateTime</td> <td>timestamp</td> <td>NO</td> <td>CURRENT_TIMESTAMP</td> <td>??????</td> </tr> <tr> <td>ValueMd5</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>md5?</td> </tr> <tr> <td>cancelamount</td> <td>int(10)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>cssid</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>??id</td> </tr> <tr> <td>xua</td> <td>varchar(500)</td> <td>YES</td> <td></td> <td>??xua</td> </tr> <tr> <td>guid</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>??guid</td> </tr> <tr> <td>orich</td> <td>int(10)</td> <td>YES</td> <td></td> <td>?????</td> </tr> <tr> <td>currch</td> <td>int(10)</td> <td>YES</td> <td></td> <td>??????</td> </tr> <tr> <td>appver</td> <td>smallint(6)</td> <td>YES</td> <td></td> <td>app???</td> </tr> <tr> <td>update_time</td> <td>timestamp</td> <td>NO</td> <td>CURRENT_TIMESTAMP</td> <td>????</td> </tr> <tr> <td>ver</td> <td>bigint(20)</td> <td>YES</td> <td>0</td> <td>??????????</td> </tr> <tr> <td>moduleid</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>????ID</td> </tr> <tr> <td>register_time</td> <td>bigint(20)</td> <td>YES</td> <td>0</td> <td></td> </tr> <tr> <td>register_channel</td> <td>bigint(20)</td> <td>YES</td> <td>0</td> <td></td> </tr> <tr> <td>install_channel</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>install_time</td> <td>bigint(20)</td> <td>YES</td> <td>0</td> <td></td> </tr> <tr> <td>webpayid</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>???????</td> </tr> <tr> <td>terminal</td> <td>varchar(40)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>platform</td> <td>varchar(40)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>teach_app</td> <td>varchar(40)</td> <td>YES</td> <td></td> <td>????????????????</td> </tr> <tr> <td>teach_channel</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>????????????????</td> </tr> <tr> <td>teach_time</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>????????????????</td> </tr> </tbody> </table>