t_order_third_copy
<h4>t_order_third_copy ???????</h4>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>类型长度</th>
<th>是否NULL</th>
<th>默认值</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>orderid</td>
<td>varchar(20)</td>
<td>NO</td>
<td></td>
<td></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>NO</td>
<td></td>
<td>??ID</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???"???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>smallint(6)</td>
<td>YES</td>
<td></td>
<td>???????</td>
</tr>
<tr>
<td>couponid</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>ip</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></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>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>update_time</td>
<td>timestamp</td>
<td>NO</td>
<td>CURRENT_TIMESTAMP</td>
<td></td>
</tr>
<tr>
<td>moduleid</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>ValueMd5</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></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></td>
</tr>
</tbody>
</table>