okr_okrshop_order

<h4>okr_okrshop_order 订单表</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(10) unsigned</td> <td>NO</td> <td></td> <td>ID</td> </tr> <tr> <td>user_id</td> <td>int(10)</td> <td>NO</td> <td>0</td> <td>用户ID</td> </tr> <tr> <td>shop_id</td> <td>int(10)</td> <td>NO</td> <td>0</td> <td>所属商家</td> </tr> <tr> <td>order_no</td> <td>varchar(18)</td> <td>NO</td> <td></td> <td>订单号</td> </tr> <tr> <td>address_id</td> <td>int(10)</td> <td>NO</td> <td>0</td> <td>地址ID</td> </tr> <tr> <td>coupon_id</td> <td>int(10)</td> <td>NO</td> <td>0</td> <td>优惠券ID</td> </tr> <tr> <td>isaddress</td> <td>int(10)</td> <td>NO</td> <td>0</td> <td>是否修改过地址，修改过为1</td> </tr> <tr> <td>freight_type</td> <td>int(10)</td> <td>NO</td> <td>0</td> <td>运费组合策略</td> </tr> <tr> <td>express_name</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>快递公司</td> </tr> <tr> <td>express_no</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>快递号</td> </tr> <tr> <td>state</td> <td>enum('1','2','3','4','5','6','7')</td> <td>NO</td> <td>1</td> <td>订单状态:1=待支付,2=待发货,3=待收货,4=待评论,5=售后订单(已弃用),6=已完成,7=已取消</td> </tr> <tr> <td>remarks</td> <td>varchar(500)</td> <td>YES</td> <td></td> <td>订单备注</td> </tr> <tr> <td>createtime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>创建时间</td> </tr> <tr> <td>paymenttime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>付款时间</td> </tr> <tr> <td>delivertime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>发货时间</td> </tr> <tr> <td>taketime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>收货时间</td> </tr> <tr> <td>dealtime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>成交时间(评论时间)</td> </tr> <tr> <td>updatetime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>更新时间</td> </tr> <tr> <td>deletetime</td> <td>int(10)</td> <td>YES</td> <td></td> <td>删除时间</td> </tr> <tr> <td>status</td> <td>enum('normal','hidden')</td> <td>YES</td> <td>normal</td> <td>状态</td> </tr> </tbody> </table>