yr_column
<h4>yr_column 栏目</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>merchant_id</td>
<td>bigint(10)</td>
<td>NO</td>
<td></td>
<td>商户号</td>
</tr>
<tr>
<td>domain</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>1</td>
<td>网站域名:1chengdu2021,2GoChengdu</td>
</tr>
<tr>
<td>site</td>
<td>varchar(32)</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>alias</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>别名</td>
</tr>
<tr>
<td>description</td>
<td>varchar(512)</td>
<td>NO</td>
<td></td>
<td>栏目介绍</td>
</tr>
<tr>
<td>status</td>
<td>tinyint(2)</td>
<td>NO</td>
<td>0</td>
<td>状态,0-禁用,1-使用,-1-删除 (修改:0 - 下线 1 - 上线 2 - 维护 -1 - 删除)</td>
</tr>
<tr>
<td>type</td>
<td>tinyint(2)</td>
<td>NO</td>
<td>1</td>
<td>栏目类型:0链接,1文章,2单页面,3栏目集合,4征集,5其他,6比赛,7直播,8服务资源</td>
</tr>
<tr>
<td>parent_id</td>
<td>bigint(20)</td>
<td>NO</td>
<td>0</td>
<td>父栏目ID</td>
</tr>
<tr>
<td>weight</td>
<td>int(10)</td>
<td>NO</td>
<td>0</td>
<td>排序权重</td>
</tr>
<tr>
<td>ext_id</td>
<td>bigint(2)</td>
<td>YES</td>
<td>0</td>
<td>扩展表ID</td>
</tr>
<tr>
<td>subset</td>
<td>varchar(2048)</td>
<td>YES</td>
<td></td>
<td>子集逗号分隔</td>
</tr>
<tr>
<td>number</td>
<td>int(4)</td>
<td>NO</td>
<td>0</td>
<td>迷你导航显示的展示个数</td>
</tr>
<tr>
<td>cover</td>
<td>varchar(255)</td>
<td>NO</td>
<td></td>
<td>封面</td>
</tr>
<tr>
<td>h5_cover</td>
<td>varchar(255)</td>
<td>NO</td>
<td></td>
<td>h5封面</td>
</tr>
<tr>
<td>icon</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>icon</td>
</tr>
<tr>
<td>is_nav</td>
<td>tinyint(1)</td>
<td>YES</td>
<td>1</td>
<td>是否导航(0 - 无 1 - 导航 2 - 金刚位)</td>
</tr>
<tr>
<td>link_url</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>链接地址</td>
</tr>
<tr>
<td>template</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>栏目使用的模板</td>
</tr>
<tr>
<td>template_list</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>内容列表模板</td>
</tr>
<tr>
<td>template_detail</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>内容详情页模板</td>
</tr>
<tr>
<td>create_time</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int(11)</td>
<td>NO</td>
<td>0</td>
<td>更新时间</td>
</tr>
<tr>
<td>site_type</td>
<td>tinyint(1)</td>
<td>YES</td>
<td>1</td>
<td>站点类型:1大运会官网,2智慧大运App</td>
</tr>
<tr>
<td>bg_img</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>栏目背景图</td>
</tr>
<tr>
<td>seo_title</td>
<td>varchar(1024)</td>
<td>YES</td>
<td></td>
<td>SEO title</td>
</tr>
<tr>
<td>seo_keywords</td>
<td>varchar(1024)</td>
<td>YES</td>
<td></td>
<td>SEO keywords,用,分开</td>
</tr>
<tr>
<td>seo_desc</td>
<td>varchar(1024)</td>
<td>YES</td>
<td></td>
<td>SEO Description</td>
</tr>
<tr>
<td>oplog</td>
<td>varchar(255)</td>
<td>NO</td>
<td></td>
<td>操作人信息</td>
</tr>
<tr>
<td>template_type</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>模版类别:0 - 默认 1 - 样式一 2 - 样式二</td>
</tr>
<tr>
<td>live_type</td>
<td>tinyint(1)</td>
<td>NO</td>
<td>0</td>
<td>直播类型:0 - 无 1 - 图文直播 2 - 视频直播 3 - 图文/视频直播</td>
</tr>
<tr>
<td>pc_content</td>
<td>text</td>
<td>NO</td>
<td></td>
<td>PC内容</td>
</tr>
</tbody>
</table>