t_product
<h4>t_product</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>??id</td>
</tr>
<tr>
<td>name</td>
<td>varchar(200)</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>day</td>
<td>int(11)</td>
<td>NO</td>
<td></td>
<td>??/?</td>
</tr>
<tr>
<td>moduleid</td>
<td>varchar(11)</td>
<td>YES</td>
<td></td>
<td>????</td>
</tr>
<tr>
<td>remark</td>
<td>text</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(1)</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>YES</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>compliance</td>
<td>tinyint(2)</td>
<td>NO</td>
<td>0</td>
<td>????0????? 1??????</td>
</tr>
<tr>
<td>ext</td>
<td>text</td>
<td>YES</td>
<td></td>
<td>????json???</td>
</tr>
<tr>
<td>applepid</td>
<td>varchar(100)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>isreal</td>
<td>tinyint(4)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>limit_etime</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>limit_stime</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>limitnum</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td></td>
</tr>
<tr>
<td>limit_day</td>
<td>tinyint(1)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>coupons</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>reg_workwx</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>before_risk</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></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>
<tr>
<td>risk_sign_way</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
</tbody>
</table>