"3510骑迹-骑车游东莞"方案

districts (大区表) id, name, slug, geom(多边形) towns (镇街表) id, district_id, name, center_point enterprises (认证企业表) id, name, wechat_appid, api_key, status routes (骑迹路书表) id, enterprise_id, title, distance, difficulty, description, gpx_track(geometry), district_tags, likes_count, comment_count, status(published/draft), wechat_pushed_at, created_at route_media (路书多媒体) route_id, image_url, video_url, sort user_route_actions (用户动作) id, user_id, route_id, type(like/rating/collect), rating_value, created_at comments (评价表) id, route_id, user_id, content, likes, parent_id wechat_push_logs id, route_id, enterprise_id, push_time, article_url ✅ 空间索引支持"5公里范围路书推荐" + 六大片区划分快速筛选，微信公众号素材库接口自动拉取图文。