t_new_sync_order_202009
<h4>t_new_sync_order_202009</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>??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>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>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>currch</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>??????</td>
</tr>
<tr>
<td>FROM_UNIXTIME(otime/1000,'%Y%m%d')</td>
<td>varchar(8)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
</tbody>
</table>