okr_okrshop_groups
<h4>okr_okrshop_groups 拼团表</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>group_no</td>
<td>varchar(32)</td>
<td>NO</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>所属商家</td>
</tr>
<tr>
<td>goods_id</td>
<td>int(10)</td>
<td>NO</td>
<td>0</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>is_ladder</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>是否阶梯拼团</td>
</tr>
<tr>
<td>ladder_id</td>
<td>int(10)</td>
<td>NO</td>
<td>0</td>
<td>阶梯ID</td>
</tr>
<tr>
<td>people_num</td>
<td>int(10)</td>
<td>NO</td>
<td>0</td>
<td>成团人数</td>
</tr>
<tr>
<td>join_num</td>
<td>int(10)</td>
<td>NO</td>
<td>0</td>
<td>参团人数</td>
</tr>
<tr>
<td>state</td>
<td>enum('ready','start','success','fail','auto')</td>
<td>NO</td>
<td>ready</td>
<td>拼团状态:ready=准备中,start=拼团中,success=已成团,fail=拼团失败,auto=自动成团</td>
</tr>
<tr>
<td>createtime</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>开团时间</td>
</tr>
<tr>
<td>grouptime</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>成团时间</td>
</tr>
<tr>
<td>validitytime</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>