okr_okrshop_pay

<h4>okr_okrshop_pay 订单支付表 日志类</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>pay_no</td> <td>varchar(32)</td> <td>NO</td> <td></td> <td>交易号</td> </tr> <tr> <td>trade_no</td> <td>varchar(32)</td> <td>YES</td> <td></td> <td>交易订单号</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_no</td> <td>varchar(18)</td> <td>NO</td> <td></td> <td>订单号</td> </tr> <tr> <td>pay_type</td> <td>enum('0','1','2')</td> <td>NO</td> <td>0</td> <td>支付类型:0=余额支付,1=微信支付,2=支付宝支付</td> </tr> <tr> <td>pay_state</td> <td>enum('0','1','2')</td> <td>NO</td> <td>0</td> <td>支付状态 (支付回调):0=未支付,1=已支付,2=已退款</td> </tr> <tr> <td>type</td> <td>enum('goods','groups')</td> <td>NO</td> <td>goods</td> <td>订单类型:goods=商品订单,groups=拼团订单</td> </tr> <tr> <td>number</td> <td>int(10)</td> <td>NO</td> <td>0</td> <td>总数</td> </tr> <tr> <td>price</td> <td>decimal(10,2) unsigned</td> <td>NO</td> <td>0.00</td> <td>支付金额</td> </tr> <tr> <td>order_price</td> <td>decimal(10,2) unsigned</td> <td>NO</td> <td>0.00</td> <td>订单金额</td> </tr> <tr> <td>freight_price</td> <td>decimal(10,2) unsigned</td> <td>NO</td> <td>0.00</td> <td>快递金额</td> </tr> <tr> <td>coupon_price</td> <td>decimal(10,2) unsigned</td> <td>NO</td> <td>0.00</td> <td>优惠券金额</td> </tr> <tr> <td>discount_price</td> <td>decimal(10,2) unsigned</td> <td>NO</td> <td>0.00</td> <td>优惠金额</td> </tr> <tr> <td>refund_price</td> <td>decimal(10,2) unsigned</td> <td>NO</td> <td>0.00</td> <td>退款金额</td> </tr> <tr> <td>actual_payment</td> <td>decimal(10,2) unsigned</td> <td>NO</td> <td>0.00</td> <td>实际支付</td> </tr> <tr> <td>total_amount</td> <td>decimal(10,2) unsigned</td> <td>YES</td> <td>0.00</td> <td>总金额</td> </tr> <tr> <td>notice</td> <td>text</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>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>