okr_okrshop_groups_goods
<h4>okr_okrshop_groups_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>shop_id</td>
<td>int(10) unsigned</td>
<td>YES</td>
<td>0</td>
<td>店铺ID</td>
</tr>
<tr>
<td>shop_category_id</td>
<td>varchar(100)</td>
<td>YES</td>
<td></td>
<td>店铺内类目</td>
</tr>
<tr>
<td>category_id</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>商品类目</td>
</tr>
<tr>
<td>brand_id</td>
<td>int(10) unsigned</td>
<td>YES</td>
<td>0</td>
<td>品牌ID</td>
</tr>
<tr>
<td>category_attribute</td>
<td>longtext</td>
<td>YES</td>
<td></td>
<td>类目属性</td>
</tr>
<tr>
<td>title</td>
<td>varchar(100)</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>images</td>
<td>varchar(1500)</td>
<td>NO</td>
<td></td>
<td>产品相册</td>
</tr>
<tr>
<td>description</td>
<td>varchar(255)</td>
<td>NO</td>
<td></td>
<td>商品描述</td>
</tr>
<tr>
<td>is_alone</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>1</td>
<td>是否显示单购是:0=否,1=是</td>
</tr>
<tr>
<td>people_num</td>
<td>int(3)</td>
<td>YES</td>
<td>0</td>
<td>组团人数</td>
</tr>
<tr>
<td>groups_num</td>
<td>int(3)</td>
<td>YES</td>
<td>0</td>
<td>成团人数</td>
</tr>
<tr>
<td>is_ladder</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>开启阶梯团:0=否,1=是</td>
</tr>
<tr>
<td>group_hour</td>
<td>int(10)</td>
<td>NO</td>
<td>24</td>
<td>组团限时(小时)</td>
</tr>
<tr>
<td>purchase_limit</td>
<td>int(6)</td>
<td>NO</td>
<td>0</td>
<td>个人购买次数限制,默认是0,没有次数限制</td>
</tr>
<tr>
<td>is_discount</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>是否显示团长优惠是:0=否,1=是</td>
</tr>
<tr>
<td>discount_type</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>团长优惠类型:0=金额,1=百分百</td>
</tr>
<tr>
<td>discount</td>
<td>float(10,2)</td>
<td>YES</td>
<td>0.00</td>
<td>优惠金额/折扣</td>
</tr>
<tr>
<td>flag</td>
<td>set('hot','index','recommend')</td>
<td>NO</td>
<td></td>
<td>标志(多选):hot=热门,index=首页,recommend=推荐</td>
</tr>
<tr>
<td>stock</td>
<td>enum('porder','payment')</td>
<td>NO</td>
<td>porder</td>
<td>库存计算方式:porder=下单减库存,payment=付款减库存</td>
</tr>
<tr>
<td>content</td>
<td>longtext</td>
<td>NO</td>
<td></td>
<td>商品详情</td>
</tr>
<tr>
<td>freight_id</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>运费模板</td>
</tr>
<tr>
<td>grounding</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>上架状态</td>
</tr>
<tr>
<td>specs</td>
<td>enum('single','multi')</td>
<td>NO</td>
<td>single</td>
<td>商品规格:single=单规格,multi=多规格</td>
</tr>
<tr>
<td>distribution</td>
<td>enum('true','false')</td>
<td>NO</td>
<td>false</td>
<td>是否独立分销:true=开启,false=关闭</td>
</tr>
<tr>
<td>activity</td>
<td>enum('true','false')</td>
<td>NO</td>
<td>false</td>
<td>是否活动中:true=是,false=否</td>
</tr>
<tr>
<td>views</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>点击</td>
</tr>
<tr>
<td>price</td>
<td>decimal(10,2)</td>
<td>YES</td>
<td>0.00</td>
<td>产品价格</td>
</tr>
<tr>
<td>sales</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>销量</td>
</tr>
<tr>
<td>payment</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>付款人数</td>
</tr>
<tr>
<td>comment</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>评论</td>
</tr>
<tr>
<td>praise</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>好评</td>
</tr>
<tr>
<td>moderate</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>中评</td>
</tr>
<tr>
<td>negative</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>差评</td>
</tr>
<tr>
<td>like</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>收藏</td>
</tr>
<tr>
<td>weigh</td>
<td>int(10)</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>