okr_okrshop_refund
<h4>okr_okrshop_refund 订单退款表</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>店铺ID</td>
</tr>
<tr>
<td>order_id</td>
<td>int(10)</td>
<td>NO</td>
<td>0</td>
<td>订单ID</td>
</tr>
<tr>
<td>order_pay_id</td>
<td>int(10)</td>
<td>NO</td>
<td>0</td>
<td>支付ID</td>
</tr>
<tr>
<td>order_type</td>
<td>enum('goods','groups','seckill')</td>
<td>YES</td>
<td>goods</td>
<td>订单类型:goods=普通订单,groups=拼团订单,seckill=秒杀订单</td>
</tr>
<tr>
<td>goods_ids</td>
<td>varchar(100)</td>
<td>YES</td>
<td></td>
<td>退款产品</td>
</tr>
<tr>
<td>expressType</td>
<td>enum('0','1')</td>
<td>NO</td>
<td>0</td>
<td>物流状态:0=未收到货,1=已收到货</td>
</tr>
<tr>
<td>price</td>
<td>decimal(10,2) unsigned</td>
<td>NO</td>
<td>0.00</td>
<td>退款金额</td>
</tr>
<tr>
<td>type</td>
<td>enum('0','1')</td>
<td>NO</td>
<td>0</td>
<td>退款类型:0=我要退款(无需退货),1=退货退款</td>
</tr>
<tr>
<td>reason</td>
<td>enum('0','1','2','3','4','5','6')</td>
<td>NO</td>
<td>0</td>
<td>退货理由:0=不喜欢,1=空包裹,2=一直未送达,3=颜色/尺码不符,4=质量问题,5=少件漏发,6=假冒品牌</td>
</tr>
<tr>
<td>images</td>
<td>text</td>
<td>YES</td>
<td></td>
<td>图片</td>
</tr>
<tr>
<td>refund_content</td>
<td>text</td>
<td>YES</td>
<td></td>
<td>退款理由</td>
</tr>
<tr>
<td>refuse_content</td>
<td>text</td>
<td>YES</td>
<td></td>
<td>拒绝理由</td>
</tr>
<tr>
<td>notice</td>
<td>text</td>
<td>YES</td>
<td></td>
<td>回调数据</td>
</tr>
<tr>
<td>express_name</td>
<td>varchar(50)</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('0','1','2','3','4','5','6','7','8')</td>
<td>NO</td>
<td>0</td>
<td>退款状态:0=申请退款,1=卖家同意,2=卖家拒绝,3=申请平台介入,4=成功退款,5=退款已关闭,6=已提交物流,7=第三方退款中,8=退款失败</td>
</tr>
<tr>
<td>createtime</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>创建时间</td>
</tr>
<tr>
<td>agreetime</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>同意时间</td>
</tr>
<tr>
<td>returntime</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>退货时间</td>
</tr>
<tr>
<td>rejecttime</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>卖家拒绝时间</td>
</tr>
<tr>
<td>closingtime</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>退款关闭时间</td>
</tr>
<tr>
<td>completetime</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>