t_new_sync_order
<h4>t_new_sync_order</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>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,??"???200?????210"??</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>
<tr>
<td>isreal</td>
<td>tinyint(4)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>includesRealProduct</td>
<td>tinyint(4)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>includesVirtualProduct</td>
<td>tinyint(4)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>sign_contract</td>
<td>tinyint(1) unsigned zerofill</td>
<td>YES</td>
<td></td>
<td>??????? 0-???1-???2-??</td>
</tr>
</tbody>
</table>