cultural_tourism_resources

<h4>cultural_tourism_resources 文旅服务资源库</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>lang</td> <td>varchar(20)</td> <td>NO</td> <td></td> <td>语言</td> </tr> <tr> <td>merchant_id</td> <td>bigint(20)</td> <td>NO</td> <td></td> <td>商户ID</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>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>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> </tbody> </table>