base_cultural_tourism_services
<h4>base_cultural_tourism_services 文旅服务基础库</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) unsigned</td>
<td>NO</td>
<td></td>
<td></td>
</tr>
<tr>
<td>po_id</td>
<td>varchar(120)</td>
<td>NO</td>
<td></td>
<td>唯一标识</td>
</tr>
<tr>
<td>name</td>
<td>varchar(255)</td>
<td>NO</td>
<td></td>
<td>资源名称</td>
</tr>
<tr>
<td>keywords</td>
<td>varchar(255)</td>
<td>NO</td>
<td></td>
<td>资源关键字</td>
</tr>
<tr>
<td>location</td>
<td>varchar(120)</td>
<td>YES</td>
<td></td>
<td>经纬度</td>
</tr>
<tr>
<td>area_code</td>
<td>varchar(120)</td>
<td>YES</td>
<td></td>
<td>市编码CODE</td>
</tr>
<tr>
<td>[{"成都市":"028"},{"自贡市":"0813"},{"攀枝花市":"0812"},{"泸州市":"0830"},{"德阳市":"0838"},{"绵阳市":"0816"},{"广元市":"0839"},{"遂宁市":"0825"},{"内江市":"1832"},{"乐山市":"0833"},{"南充市":"0817"},{"眉山市":"1833"},{"宜宾市":"0831"},{"广安市":"0826"},{"达州市":"0818"},{"雅安市":"0835"},{"巴中市":"0827"},{"资阳市":"0832"},{"阿坝藏族羌族自治州":"0837"},{"甘孜藏族自治州":"0836"},{"凉山彝族自治州":"0834"}]</td>
</tr>
<tr>
<td>province</td>
<td>varchar(120)</td>
<td>YES</td>
<td></td>
<td>省</td>
</tr>
<tr>
<td>city</td>
<td>varchar(120)</td>
<td>YES</td>
<td></td>
<td>市</td>
</tr>
<tr>
<td>area</td>
<td>varchar(120)</td>
<td>YES</td>
<td></td>
<td>区</td>
</tr>
<tr>
<td>address</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>详情地址</td>
</tr>
<tr>
<td>business_area</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>所属商圈</td>
</tr>
<tr>
<td>business_hours</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>营业时间</td>
</tr>
<tr>
<td>telephone</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>联系电话</td>
</tr>
<tr>
<td>featured_content</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>特色内容</td>
</tr>
<tr>
<td>score</td>
<td>varchar(10)</td>
<td>YES</td>
<td></td>
<td>评分</td>
</tr>
<tr>
<td>consumption</td>
<td>varchar(20)</td>
<td>YES</td>
<td></td>
<td>消费</td>
</tr>
<tr>
<td>parking_type</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>停车场类型</td>
</tr>
<tr>
<td>pictures</td>
<td>varchar(1000)</td>
<td>YES</td>
<td></td>
<td>资源图片</td>
</tr>
<tr>
<td>introduction</td>
<td>text</td>
<td>YES</td>
<td></td>
<td>资源简介</td>
</tr>
<tr>
<td>oplog</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>最后操作信息</td>
</tr>
<tr>
<td>status</td>
<td>tinyint(3) unsigned</td>
<td>NO</td>
<td>1</td>
<td>状态：1 - 未入库 2 - 已入库</td>
</tr>
<tr>
<td>create_at</td>
<td>int(10)</td>
<td>NO</td>
<td></td>
<td>创建时间</td>
</tr>
<tr>
<td>update_at</td>
<td>int(10)</td>
<td>YES</td>
<td></td>
<td>修改时间</td>
</tr>
<tr>
<td>pc_content</td>
<td>text</td>
<td>YES</td>
<td></td>
<td>PC内容</td>
</tr>
</tbody>
</table>