养护益生健康管理平台养护益生健康管理平台

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: jspmzyx82 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `jspmzyx82` -- /*!40000 DROP DATABASE IF EXISTS `jspmzyx82`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jspmzyx82` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `jspmzyx82`; -- -- Table structure for table `chat` -- DROP TABLE IF EXISTS `chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id', `ask` longtext COMMENT '提问', `reply` longtext COMMENT '回复', `isreply` int(11) DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='在线咨询'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat` -- LOCK TABLES `chat` WRITE; /*!40000 ALTER TABLE `chat` DISABLE KEYS */; INSERT INTO `chat` VALUES (41,'2022-03-27 13:30:37',1,1,'提问1','回复1',1),(42,'2022-03-27 13:30:37',2,2,'提问2','回复2',2),(43,'2022-03-27 13:30:37',3,3,'提问3','回复3',3),(44,'2022-03-27 13:30:37',4,4,'提问4','回复4',4),(45,'2022-03-27 13:30:37',5,5,'提问5','回复5',5),(46,'2022-03-27 13:30:37',6,6,'提问6','回复6',6); /*!40000 ALTER TABLE `chat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config` -- LOCK TABLES `config` WRITE; /*!40000 ALTER TABLE `config` DISABLE KEYS */; INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg'); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discussjiankangzhishi` -- DROP TABLE IF EXISTS `discussjiankangzhishi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussjiankangzhishi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `refid` bigint(20) NOT NULL COMMENT '关联表id', `userid` bigint(20) NOT NULL COMMENT '用户id', `nickname` varchar(200) DEFAULT NULL COMMENT '用户名', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='健康知识评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussjiankangzhishi` -- LOCK TABLES `discussjiankangzhishi` WRITE; /*!40000 ALTER TABLE `discussjiankangzhishi` DISABLE KEYS */; INSERT INTO `discussjiankangzhishi` VALUES (111,'2022-03-27 13:30:37',1,1,'用户名1','评论内容1','回复内容1'),(112,'2022-03-27 13:30:37',2,2,'用户名2','评论内容2','回复内容2'),(113,'2022-03-27 13:30:37',3,3,'用户名3','评论内容3','回复内容3'),(114,'2022-03-27 13:30:37',4,4,'用户名4','评论内容4','回复内容4'),(115,'2022-03-27 13:30:37',5,5,'用户名5','评论内容5','回复内容5'),(116,'2022-03-27 13:30:37',6,6,'用户名6','评论内容6','回复内容6'); /*!40000 ALTER TABLE `discussjiankangzhishi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exampaper` -- DROP TABLE IF EXISTS `exampaper`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exampaper` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `name` varchar(200) NOT NULL COMMENT '健康自检名称', `time` int(11) NOT NULL COMMENT '健康测试时长(分钟)', `status` int(11) NOT NULL DEFAULT '0' COMMENT '健康自检状态', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='健康自检表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exampaper` -- LOCK TABLES `exampaper` WRITE; /*!40000 ALTER TABLE `exampaper` DISABLE KEYS */; INSERT INTO `exampaper` VALUES (1,'2022-03-27 13:30:37','十万个为什么',60,1); /*!40000 ALTER TABLE `exampaper` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `examquestion` -- DROP TABLE IF EXISTS `examquestion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `examquestion` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `paperid` bigint(20) NOT NULL COMMENT '所属健康自检id（外键）', `papername` varchar(200) NOT NULL COMMENT '健康自检名称', `questionname` varchar(200) NOT NULL COMMENT '自检试题名称', `options` longtext COMMENT '选项，json字符串', `score` bigint(20) DEFAULT '0' COMMENT '分值', `answer` varchar(200) DEFAULT NULL COMMENT '正确答案', `analysis` longtext COMMENT '答案解析', `type` bigint(20) DEFAULT '0' COMMENT '自检试题类型，0：单选题 1：多选题 2：判断题 3：填空题（暂不考虑多项填空）', `sequence` bigint(20) DEFAULT '100' COMMENT '自检试题排序，值越大排越前面', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='自检试题'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `examquestion` -- LOCK TABLES `examquestion` WRITE; /*!40000 ALTER TABLE `examquestion` DISABLE KEYS */; INSERT INTO `examquestion` VALUES (1,'2022-03-27 13:30:37',1,'十万个为什么','下面动物不属于昆虫的是（）。','[{\"text\":\"A.苍蝇\",\"code\":\"A\"},{\"text\":\"B.蜜蜂\",\"code\":\"B\"},{\"text\":\"C.蜂鸟\",\"code\":\"C\"}]',20,'C','蜂鸟',0,1),(2,'2022-03-27 13:30:37',1,'十万个为什么','油着火后可以用水扑灭。','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',20,'B','油着火后不可以用水扑灭',2,2),(3,'2022-03-27 13:30:37',1,'十万个为什么','地球是个球体，中间是（ ）。','[]',30,'赤道','赤道',3,3),(4,'2022-03-27 13:30:37',1,'十万个为什么','下面动物中会流汗的有（ ）。','[{\"text\":\"A.马\",\"code\":\"A\"},{\"text\":\"B.猫\",\"code\":\"B\"},{\"text\":\"C.狗\",\"code\":\"C\"}]',30,'A,B','狗不会流汗',1,4); /*!40000 ALTER TABLE `examquestion` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `examrecord` -- DROP TABLE IF EXISTS `examrecord`; /*!40101 SET @saved_cs_cl