t_product_package
<h4>t_product_package</h4>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>类型长度</th>
<th>是否NULL</th>
<th>默认值</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>pk</td>
<td>int(11)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>id</td>
<td>varchar(50)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>name</td>
<td>varchar(50)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>price</td>
<td>float</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>subproducts</td>
<td>varchar(1000)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>remark</td>
<td>text</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>subproductsinfo</td>
<td>varchar(3000)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>extinfo</td>
<td>varchar(1000)</td>
<td>YES</td>
<td></td>
<td>PC?????????</td>
<td>?????</td>
<td>??</td>
<td>???</td>
</tr>
<tr>
<td>appextinfo</td>
<td>varchar(1000)</td>
<td>YES</td>
<td></td>
<td>app??????????</td>
</tr>
<tr>
<td>appext</td>
<td>varchar(100)</td>
<td>YES</td>
<td></td>
<td>app???????????</td>
</tr>
<tr>
<td>webimgurl</td>
<td>varchar(200)</td>
<td>YES</td>
<td></td>
<td>WEB?????</td>
</tr>
<tr>
<td>appimgurl</td>
<td>varchar(200)</td>
<td>YES</td>
<td></td>
<td>APP?????</td>
</tr>
<tr>
<td>active</td>
<td>tinyint(4)</td>
<td>NO</td>
<td>1</td>
<td></td>
</tr>
<tr>
<td>old</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>1</td>
<td></td>
</tr>
<tr>
<td>groupid</td>
<td>int(11)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>ctime</td>
<td>datetime</td>
<td>NO</td>
<td>CURRENT_TIMESTAMP</td>
<td></td>
</tr>
<tr>
<td>update_time</td>
<td>timestamp</td>
<td>NO</td>
<td>CURRENT_TIMESTAMP</td>
<td></td>
</tr>
<tr>
<td>businesstype</td>
<td>tinyint(1)</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>ext</td>
<td>varchar(1000)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>applepid</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>limitnum</td>
<td>tinyint(1)</td>
<td>NO</td>
<td></td>
<td>?????????? 0??? ?1?1?</td>
</tr>
<tr>
<td>limit_stime</td>
<td>varchar(32)</td>
<td>YES</td>
<td></td>
<td>??????????</td>
</tr>
<tr>
<td>limit_etime</td>
<td>varchar(32)</td>
<td>YES</td>
<td></td>
<td>??????????</td>
</tr>
<tr>
<td>limit_day</td>
<td>tinyint(1)</td>
<td>YES</td>
<td></td>
<td>???????0????????1???????</td>
</tr>
<tr>
<td>reg_workwx</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>???????????</td>
</tr>
<tr>
<td>coupons</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>?????????????ID??????</td>
</tr>
<tr>
<td>before_risk</td>
<td>tinyint(1)</td>
<td>YES</td>
<td></td>
<td>????????1-????0-??????-????</td>
</tr>
<tr>
<td>pay_guide</td>
<td>int(1)</td>
<td>YES</td>
<td>1</td>
<td>????</td>
</tr>
<tr>
<td>app_jump_page</td>
<td>varchar(2000)</td>
<td>YES</td>
<td>upchina://wxapp/mini?userName=gh_c2c24c1e700e&type=0&path=/pages/activity/temporaryActivity/rfKfQrNew/index?url=https%3A%2F%2Fcdn.upchina.com%2FWeEduMiniApp%2Factivity%2Fzfcg_jzl.png</td>
<td>app????</td>
</tr>
<tr>
<td>wechat_qrcode</td>
<td>varchar(2000)</td>
<td>YES</td>
<td><a href="https://cdn.upchina.com/bot_wechat/ddzfwc.png">https://cdn.upchina.com/bot_wechat/ddzfwc.png</a></td>
<td>?????CDN??</td>
</tr>
<tr>
<td>pc_wechat_qrcode</td>
<td>varchar(2000)</td>
<td>YES</td>
<td></td>
<td>PC?????CDN??</td>
</tr>
<tr>
<td>order_sign_way</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
</tbody>
</table>