okr_okrshop_groups_order_goods
<h4>okr_okrshop_groups_order_goods 拼团订单商品表</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>order_id</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>订单ID</td>
</tr>
<tr>
<td>user_id</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>用户ID</td>
</tr>
<tr>
<td>goods_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>shop_name</td>
<td>varchar(32)</td>
<td>NO</td>
<td></td>
<td>店铺名称</td>
</tr>
<tr>
<td>title</td>
<td>text</td>
<td>NO</td>
<td></td>
<td>产品标题</td>
</tr>
<tr>
<td>image</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td>商品主图</td>
</tr>
<tr>
<td>group_type</td>
<td>enum('alone','group','ladder')</td>
<td>NO</td>
<td></td>
<td>拼团类型:alone=直购,group=拼团,ladder=阶梯拼团</td>
</tr>
<tr>
<td>group_no</td>
<td>varchar(32)</td>
<td>YES</td>
<td></td>
<td>拼团号</td>
</tr>
<tr>
<td>is_alone</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>是否显示单购是:0=否,1=是</td>
</tr>
<tr>
<td>is_ladder</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>开启阶梯团:0=否,1=是</td>
</tr>
<tr>
<td>ladder_id</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>阶梯ID</td>
</tr>
<tr>
<td>purchase_limit</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>个人购买次数限制,默认是0,没有次数限制</td>
</tr>
<tr>
<td>people_num</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>组团人数</td>
</tr>
<tr>
<td>group_hour</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>组团限时(小时)</td>
</tr>
<tr>
<td>goods_sku_sn</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td>商品编码</td>
</tr>
<tr>
<td>goods_sku_id</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>订单ID</td>
</tr>
<tr>
<td>difference</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td>选择的sku</td>
</tr>
<tr>
<td>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>refund_id</td>
<td>int(10)</td>
<td>YES</td>
<td>0</td>
<td>退款ID</td>
</tr>
<tr>
<td>refund_status</td>
<td>enum('0','1','2','3','4','5')</td>
<td>YES</td>
<td>0</td>
<td>退款状态:0=未退款,1=退款中,2=待退货,3=退款完成,4=退款关闭,5=退款被拒</td>
</tr>
<tr>
<td>group_price</td>
<td>decimal(10,2) unsigned</td>
<td>NO</td>
<td>0.00</td>
<td>拼团价</td>
</tr>
<tr>
<td>market_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>discount_price</td>
<td>decimal(10,2) unsigned</td>
<td>NO</td>
<td>0.00</td>
<td>优惠价格</td>
</tr>
<tr>
<td>number</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</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>