t_experience_coupon

<h4>t_experience_coupon ???</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint(20)</td> <td>NO</td> <td></td> <td>????</td> </tr> <tr> <td>coupon_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>source_type</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td>0-?????1-???? ?2-?????3-????4-??</td> </tr> <tr> <td>valid_date_start</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>?????????</td> </tr> <tr> <td>valid_date_end</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>?????????</td> </tr> <tr> <td>valid_days</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>????????????0???????</td> </tr> <tr> <td>send_ch</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>????,0-???????1-???????2-all</td> </tr> <tr> <td>status</td> <td>tinyint(4)</td> <td>YES</td> <td>0</td> <td>0????3????</td> </tr> <tr> <td>scope_of_product</td> <td>varchar(50)</td> <td>NO</td> <td></td> <td>?????????????????????????????ID?</td> </tr> <tr> <td>exp_day</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>????</td> </tr> <tr> <td>scope_desc</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>???????????????</td> </tr> <tr> <td>gotten_number</td> <td>int(11)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>used_number</td> <td>int(11)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>expire_number</td> <td>int(11)</td> <td>YES</td> <td></td> <td>????</td> </tr> <tr> <td>total_number</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td>????????</td> </tr> <tr> <td>remark</td> <td>varchar(500)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>create_user</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>last_modify_user</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>create_time</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>last_modify_time</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>update_time</td> <td>timestamp</td> <td>NO</td> <td>CURRENT_TIMESTAMP</td> <td></td> </tr> <tr> <td>max_receive_number</td> <td>int(11)</td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table>