okr_okrshop_advert
<h4>okr_okrshop_advert 广告表</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>admin_id</td>
<td>int(10)</td>
<td>NO</td>
<td>0</td>
<td>管理员ID</td>
</tr>
<tr>
<td>module</td>
<td>enum('open','page','category','first','other')</td>
<td>NO</td>
<td></td>
<td>投放模块:open=开屏广告,page=自定义页面广告,category=类目广告,first=首次欢迎广告,other=其他广告</td>
</tr>
<tr>
<td>category_id</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>投放类目</td>
</tr>
<tr>
<td>type</td>
<td>enum('banner','image','video')</td>
<td>NO</td>
<td></td>
<td>媒体类型:banner=幻灯片,image=图片,video=视频</td>
</tr>
<tr>
<td>media</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td>媒体文件</td>
</tr>
<tr>
<td>url</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td>广告链接</td>
</tr>
<tr>
<td>title</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td>广告标题</td>
</tr>
<tr>
<td>content</td>
<td>text</td>
<td>NO</td>
<td></td>
<td>广告内容</td>
</tr>
<tr>
<td>city</td>
<td>varchar(100)</td>
<td>NO</td>
<td></td>
<td>投放城市</td>
</tr>
<tr>
<td>startdate</td>
<td>date</td>
<td>YES</td>
<td></td>
<td>开始日期</td>
</tr>
<tr>
<td>enddate</td>
<td>date</td>
<td>YES</td>
<td></td>
<td>结束日期</td>
</tr>
<tr>
<td>views</td>
<td>int(10) unsigned</td>
<td>NO</td>
<td>0</td>
<td>点击次数</td>
</tr>
<tr>
<td>show</td>
<td>int(10) unsigned</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>weigh</td>
<td>int(10)</td>
<td>NO</td>
<td>0</td>
<td>权重</td>
</tr>
<tr>
<td>status</td>
<td>enum('normal','hidden')</td>
<td>YES</td>
<td>normal</td>
<td>状态</td>
</tr>
</tbody>
</table>