基于Python的热门旅游景点数据分析系统的设计与实现-计算机毕业设计源码+LW文档

开发语言：Python
框架：django
Python版本：python3.7.7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：PyCharm 
浏览器：谷歌浏览器



DROP TABLE IF EXISTS `08375_menpiaoxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `08375_menpiaoxinxi` (
  `id` bigint(20) NOT NULL DEFAULT '0' COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `laiyuan` longtext CHARACTER SET utf8 COMMENT '来源',
  `biaoti` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '标题',
  `fengmian` longtext CHARACTER SET utf8 COMMENT '封面',
  `miaoshu` longtext CHARACTER SET utf8 COMMENT '描述',
  `weizhi` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '位置',
  `dianping` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '点评',
  `pinglun` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '评论',
  `jiage` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '价格',
  `tese` longtext CHARACTER SET utf8 COMMENT '特色',
  `kaifangshijian` longtext CHARACTER SET utf8 COMMENT '开放时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `08375_tejiajipiao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `08375_tejiajipiao` (
  `id` bigint(20) NOT NULL DEFAULT '0' COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `chufadi` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '出发地',
  `mudidi` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '目的地',
  `fengjingtu` longtext CHARACTER SET utf8 COMMENT '风景图',
  `chufashijian` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '出发时间',
  `jiage` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '价格',
  `redu` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '热度',
  `biaoqian` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '标签',
  `miaoshu` longtext CHARACTER SET utf8 COMMENT '描述'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `mingsuxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mingsuxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `biaoti` varchar(200) DEFAULT NULL COMMENT '标题',
  `fengmian` longtext COMMENT '封面',
  `dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
  `pinglun` varchar(200) DEFAULT NULL COMMENT '评论',
  `fenlei` varchar(200) DEFAULT NULL COMMENT '分类',
  `jiage` int(11) DEFAULT NULL COMMENT '价格',
  `pingfen` float DEFAULT NULL COMMENT '评分',
  `pinglunshu` int(11) DEFAULT NULL COMMENT '评论数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 COMMENT='名宿信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mingsuxinxi`
--
DROP TABLE IF EXISTS `systemintro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `systemintro` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `subtitle` varchar(200) DEFAULT NULL COMMENT '副标题',
  `content` longtext NOT NULL COMMENT '内容',
  `picture1` longtext COMMENT '图片1',
  `picture2` longtext COMMENT '图片2',
  `picture3` longtext COMMENT '图片3',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们';
/*!40101 SET character_set_client = @saved_cs_client */;
如需定做或者获取更多资料，请联系QQ：375279829