/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - xinliyalizixunpingpan
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`xinliyalizixunpingpan` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `xinliyalizixunpingpan`;

/*Table structure for table `config` */

DROP TABLE IF EXISTS `config`;

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='配置文件';

/*Data for the table `config` */

insert  into `config`(`id`,`name`,`value`) values (1,'轮播图1','upload/config1.jpg'),(2,'轮播图2','upload/config2.jpg'),(3,'轮播图3','upload/config3.jpg');

/*Table structure for table `dictionary` */

DROP TABLE IF EXISTS `dictionary`;

CREATE TABLE `dictionary` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dic_code` varchar(200) DEFAULT NULL COMMENT '字段',
  `dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',
  `code_index` int(11) DEFAULT NULL COMMENT '编码',
  `index_name` varchar(200) DEFAULT NULL COMMENT '编码名字  Search111 ',
  `super_id` int(11) DEFAULT NULL COMMENT '父字段id',
  `beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='字典表';

/*Data for the table `dictionary` */

insert  into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`beizhu`,`create_time`) values (24,'xinlijiankang_types','心理健康类型',1,'心理健康类型1',NULL,NULL,'2023-03-11 14:18:22'),(25,'xinlijiankang_types','心理健康类型',2,'心理健康类型2',NULL,NULL,'2023-03-11 14:18:22'),(26,'xinlijiankang_types','心理健康类型',3,'心理健康类型3',NULL,NULL,'2023-03-11 14:18:22'),(27,'xinlijiankang_collection_types','收藏表类型',1,'收藏',NULL,NULL,'2023-03-11 14:18:22'),(28,'xinlijiankang_collection_types','收藏表类型',2,'赞',NULL,NULL,'2023-03-11 14:18:22'),(29,'xinlijiankang_collection_types','收藏表类型',3,'踩',NULL,NULL,'2023-03-11 14:18:22'),(30,'zhixunshi_chat_types','数据类型',1,'问题',NULL,NULL,'2023-03-11 14:18:22'),(31,'zhixunshi_chat_types','数据类型',2,'回复',NULL,NULL,'2023-03-11 14:18:22'),(32,'zhuangtai_types','状态',1,'未回复',NULL,NULL,'2023-03-11 14:18:22'),(33,'zhuangtai_types','状态',2,'已回复',NULL,NULL,'2023-03-11 14:18:22'),(34,'zujuan_types','组卷方式',1,'自动组题',NULL,NULL,'2023-03-11 14:18:22'),(35,'zujuan_types','组卷方式',2,'手动组题',NULL,NULL,'2023-03-11 14:18:22'),(36,'exampaper_types','试卷状态',1,'启用',NULL,NULL,'2023-03-11 14:18:22'),(37,'exampaper_types','试卷状态',2,'禁用',NULL,NULL,'2023-03-11 14:18:22'),(38,'examquestion_types','试题类型',1,'单选题',NULL,NULL,'2023-03-11 14:18:22'),(39,'examquestion_types','试题类型',2,'多选题',NULL,NULL,'2023-03-11 14:18:22'),(40,'examquestion_types','试题类型',3,'判断题',NULL,NULL,'2023-03-11 14:18:22'),(41,'examquestion_types','试题类型',4,'填空题',NULL,NULL,'2023-03-11 14:18:22'),(42,'news_types','公告类型',1,'公告类型1',NULL,NULL,'2023-03-11 14:18:22'),(43,'news_types','公告类型',2,'公告类型2',NULL,NULL,'2023-03-11 14:18:22'),(44,'news_types','公告类型',3,'公告类型3',NULL,NULL,'2023-03-11 14:18:22'),(45,'sex_types','性别',1,'男',NULL,NULL,'2023-03-11 14:18:22'),(46,'sex_types','性别',2,'女',NULL,NULL,'2023-03-11 14:18:22');

/*Table structure for table `exampaper` */

DROP TABLE IF EXISTS `exampaper`;

CREATE TABLE `exampaper` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `exampaper_name` varchar(200) NOT NULL COMMENT '试卷名称 Search111',
  `exampaper_date` int(11) DEFAULT NULL COMMENT '考试时长(分钟)',
  `exampaper_myscore` int(20) NOT NULL DEFAULT '0' COMMENT '试卷总分数',
  `exampaper_types` int(11) NOT NULL DEFAULT '0' COMMENT '试卷状态 Search111',
  `zujuan_types` int(11) DEFAULT NULL COMMENT '组卷方式',
  `exampaper_delete` int(255) DEFAULT '0' COMMENT '逻辑删除（1代表未删除 2代表已删除）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='试卷表';

/*Data for the table `exampaper` */

insert  into `exampaper`(`id`,`exampaper_name`,`exampaper_date`,`exampaper_myscore`,`exampaper_types`,`zujuan_types`,`exampaper_delete`,`create_time`) values (6,'123',123,100,1,1,1,'2023-03-11 14:33:49'),(7,'123',123,100,1,2,1,'2023-03-11 14:56:11');

/*Table structure for table `exampapertopic` */

DROP TABLE IF EXISTS `exampapertopic`;

CREATE TABLE `exampapertopic` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `exampaper_id` int(20) NOT NULL COMMENT '试卷',
  `examquestion_id` int(20) NOT NULL COMMENT '试题',
  `exampapertopic_number` int(20) NOT NULL COMMENT '试题分数',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='试卷选题';

/*Data for the table `exampapertopic` */

insert  into `exampapertopic`(`id`,`exampaper_id`,`examquestion_id`,`exampapertopic_number`,`create_time`) values (47,6,16,25,'2023-03-11 14:34:08'),(48,6,15,25,'2023-03-11 14:34:08'),(49,6,14,25,'2023-03-11 14:34:08'),(50,6,13,25,'2023-03-11 14:34:08'),(51,7,16,50,'2023-03-11 14:56:17'),(52,7,15,50,'2023-03-11 14:56:18');

/*Table structure for table `examquestion` */

DROP TABLE IF EXISTS `examquestion`;

CREATE TABLE `examquestion` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `examquestion_name` varchar(200) NOT NULL COMMENT '试题名称 Search111',
  `examquestion_options` longtext COMMENT '选项，json字符串',
  `examquestion_answer` varchar(200) DEFAULT NULL COMMENT '正确答案',
  `examquestion_analysis` longtext COMMENT '答案解析',
  `examquestion_types` int(20) DEFAULT '0' COMMENT '试题类型',
  `examquestion_sequence` int(20) DEFAULT '100' COMMENT '试题排序，值越大排越前面',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='试题表';

/*Data for the table `examquestion` */

insert  into `examquestion`(`id`,`examquestion_name`,`examquestion_options`,`examquestion_answer`,`examquestion_analysis`,`examquestion_types`,`examquestion_sequence`,`create_time`) values (13,'题目名称1','[]','题目名称1','答案解析1',4,100,'2023-02-21 20:38:20'),(14,'题目名称2','[{\"text\":\"对\",\"code\":\"A\"},{\"text\":\"错\",\"code\":\"B\"}]','A','答案解析2',3,100,'2023-02-21 20:38:31'),(15,'题目名称3','[{\"text\":\"选项1\",\"code\":\"A\"},{\"text\":\"选项2\",\"code\":\"B\"},{\"text\":\"选项3\",\"code\":\"C\"},{\"text\":\"选项4\",\"code\":\"D\"}]','A,B','答案解析3',2,100,'2023-02-21 20:39:22'),(16,'题目名称4','[{\"text\":\"选项1\",\"code\":\"A\"},{\"text\":\"选项2\",\"code\":\"B\"},{\"text\":\"选项3\",\"code\":\"C\"},{\"text\":\"选项4\",\"code\":\"D\"}]','A','选a的代表xxxxxx\n选b的代表aaaaaa\n选、、、、、、、、',1,100,'2023-02-21 20:39:53');

/*Table structure for table `examrecord` */

DROP TABLE IF EXISTS `examrecord`;

CREATE TABLE `examrecord` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `examrecord_uuid_number` varchar(200) DEFAULT NULL COMMENT '考试编号',
  `yonghu_id` int(20) NOT NULL COMMENT '考试学生',
  `exampaper_id` int(20) NOT NULL COMMENT '所属试卷id（外键）',
  `total_score` int(200) DEFAULT NULL COMMENT '所得总分',
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '考试时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='考试记录表';

/*Data for the table `examrecord` */

insert  into `examrecord`(`id`,`examrecord_uuid_number`,`yonghu_id`,`exampaper_id`,`total_score`,`insert_time`,`create_time`) values (3,'1678516486368',1,6,0,'2023-03-11 14:34:46','2023-03-11 14:34:46'),(4,'1678516686481',1,6,50,'2023-03-11 14:38:06','2023-03-11 14:38:06');

/*Table structure for table `examredetails` */

DROP TABLE IF EXISTS `examredetails`;

CREATE TABLE `examredetails` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `examredetails_uuid_number` varchar(200) DEFAULT NULL COMMENT '试卷编号',
  `yonghu_id` int(20) NOT NULL COMMENT '学生id',
  `examquestion_id` int(20) NOT NULL COMMENT '试题id（外键）',
  `examredetails_myanswer` varchar(200) DEFAULT NULL COMMENT '考生答案',
  `examredetails_myscore` int(20) NOT NULL DEFAULT '0' COMMENT '试题得分',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='答题详情表';

/*Data for the table `examredetails` */

insert  into `examredetails`(`id`,`examredetails_uuid_number`,`yonghu_id`,`examquestion_id`,`examredetails_myanswer`,`examredetails_myscore`,`create_time`) values (9,'1678516486368',1,13,'123',0,'2023-03-11 14:34:46'),(10,'1678516486368',1,14,'B',0,'2023-03-11 14:34:46'),(11,'1678516486368',1,15,'B,D',0,'2023-03-11 14:34:46'),(12,'1678516486368',1,16,'未作答',0,'2023-03-11 14:34:46'),(13,'1678516686481',1,13,'213',0,'2023-03-11 14:38:06'),(14,'1678516686481',1,14,'A',25,'2023-03-11 14:38:06'),(15,'1678516686481',1,15,'D',0,'2023-03-11 14:38:06'),(16,'1678516686481',1,16,'A',25,'2023-03-11 14:38:06');

/*Table structure for table `news` */

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `news_name` varchar(200) DEFAULT NULL COMMENT '公告标题  Search111 ',
  `news_types` int(11) DEFAULT NULL COMMENT '公告类型  Search111 ',
  `news_photo` varchar(200) DEFAULT NULL COMMENT '公告图片',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '添加时间',
  `news_content` text COMMENT '公告详情',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='通知公告';

/*Data for the table `news` */

insert  into `news`(`id`,`news_name`,`news_types`,`news_photo`,`insert_time`,`news_content`,`create_time`) values (1,'公告标题1',3,'upload/news1.jpg','2023-03-11 14:18:32','公告详情1','2023-03-11 14:18:32'),(2,'公告标题2',3,'upload/news2.jpg','2023-03-11 14:18:32','公告详情2','2023-03-11 14:18:32'),(3,'公告标题3',3,'upload/news3.jpg','2023-03-11 14:18:32','公告详情3','2023-03-11 14:18:32'),(4,'公告标题4',1,'upload/news4.jpg','2023-03-11 14:18:32','公告详情4','2023-03-11 14:18:32'),(5,'公告标题5',3,'upload/news5.jpg','2023-03-11 14:18:32','公告详情5','2023-03-11 14:18:32'),(6,'公告标题6',3,'upload/news1.jpg','2023-03-11 14:18:32','公告详情6','2023-03-11 14:18:32'),(7,'公告标题7',1,'upload/news2.jpg','2023-03-11 14:18:32','公告详情7','2023-03-11 14:18:32'),(8,'公告标题8',3,'upload/news1.jpg','2023-03-11 14:18:32','公告详情8','2023-03-11 14:18:32'),(9,'公告标题9',3,'upload/news2.jpg','2023-03-11 14:18:32','公告详情9','2023-03-11 14:18:32'),(10,'公告标题10',3,'upload/news3.jpg','2023-03-11 14:18:32','公告详情10','2023-03-11 14:18:32'),(11,'公告标题11',3,'upload/news4.jpg','2023-03-11 14:18:32','公告详情11','2023-03-11 14:18:32'),(12,'公告标题12',3,'upload/news1.jpg','2023-03-11 14:18:32','公告详情12','2023-03-11 14:18:32'),(13,'公告标题13',3,'upload/news2.jpg','2023-03-11 14:18:32','公告详情13','2023-03-11 14:18:32'),(14,'公告标题14',3,'upload/news3.jpg','2023-03-11 14:18:32','公告详情14','2023-03-11 14:18:32');

/*Table structure for table `token` */

DROP TABLE IF EXISTS `token`;

CREATE TABLE `token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='token表';

/*Data for the table `token` */

insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (4,1,'a1','yonghu','用户','fcxh9ce99be63nimi1wg6xamrlpjhh3v','2023-03-11 14:29:16','2023-03-11 15:37:31'),(5,1,'admin','users','管理员','u9q09xehd5vd6wxlanpejqnc8n2ybw5q','2023-03-11 14:33:24','2023-03-11 15:56:46'),(6,1,'a1','zhixunshi','咨询师','qxuaykish54iocoluwz42ntuebwt84oo','2023-03-11 14:55:32','2023-03-11 15:55:32');

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员';

/*Data for the table `users` */

insert  into `users`(`id`,`username`,`password`,`role`,`addtime`) values (1,'admin','admin','管理员','2022-05-01 00:00:00');

/*Table structure for table `xinlijiankang` */

DROP TABLE IF EXISTS `xinlijiankang`;

CREATE TABLE `xinlijiankang` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `xinlijiankang_name` varchar(200) DEFAULT NULL COMMENT '心理健康标题 Search111',
  `xinlijiankang_photo` varchar(200) DEFAULT NULL COMMENT '心理健康照片',
  `xinlijiankang_video` varchar(200) DEFAULT NULL COMMENT '心理健康视频',
  `xinlijiankang_types` int(11) DEFAULT NULL COMMENT '心理健康类型 Search111',
  `zan_number` int(11) DEFAULT NULL COMMENT '赞',
  `cai_number` int(11) DEFAULT NULL COMMENT '踩',
  `xinlijiankang_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `xinlijiankang_content` text COMMENT '心理健康详情',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show1 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='心理健康';

/*Data for the table `xinlijiankang` */

insert  into `xinlijiankang`(`id`,`xinlijiankang_name`,`xinlijiankang_photo`,`xinlijiankang_video`,`xinlijiankang_types`,`zan_number`,`cai_number`,`xinlijiankang_delete`,`xinlijiankang_content`,`create_time`) values (1,'心理健康标题1','upload/xinlijiankang1.jpg','upload/video.mp4',2,70,97,1,'心理健康详情1','2023-03-11 14:18:32'),(2,'心理健康标题2','upload/xinlijiankang2.jpg','upload/video.mp4',3,259,389,1,'心理健康详情2','2023-03-11 14:18:32'),(3,'心理健康标题3','upload/xinlijiankang3.jpg','upload/video.mp4',3,94,309,1,'心理健康详情3','2023-03-11 14:18:32'),(4,'心理健康标题4','upload/xinlijiankang4.jpg','upload/video.mp4',3,258,368,1,'心理健康详情4','2023-03-11 14:18:32'),(5,'心理健康标题5','upload/xinlijiankang5.jpg','upload/video.mp4',2,259,6,1,'心理健康详情5','2023-03-11 14:18:32'),(6,'心理健康标题6','upload/xinlijiankang3.jpg','upload/video.mp4',3,95,342,1,'心理健康详情6','2023-03-11 14:18:32'),(7,'心理健康标题7','upload/xinlijiankang4.jpg','upload/video.mp4',2,94,151,1,'心理健康详情7','2023-03-11 14:18:32'),(8,'心理健康标题8','upload/xinlijiankang1.jpg','upload/video.mp4',2,146,471,1,'心理健康详情8','2023-03-11 14:18:32'),(9,'心理健康标题9','upload/xinlijiankang2.jpg','upload/video.mp4',2,493,154,1,'心理健康详情9','2023-03-11 14:18:32'),(10,'心理健康标题10','upload/xinlijiankang3.jpg','upload/video.mp4',2,377,126,1,'心理健康详情10','2023-03-11 14:18:32'),(11,'心理健康标题11','upload/xinlijiankang4.jpg','upload/video.mp4',2,10,28,1,'心理健康详情11','2023-03-11 14:18:32'),(12,'心理健康标题12','upload/xinlijiankang3.jpg','upload/video.mp4',1,224,364,1,'心理健康详情12','2023-03-11 14:18:32'),(13,'心理健康标题13','upload/xinlijiankang4.jpg','upload/video.mp4',2,209,236,1,'心理健康详情13','2023-03-11 14:18:32'),(14,'心理健康标题14','upload/xinlijiankang5.jpg','upload/video.mp4',3,375,55,1,'心理健康详情14','2023-03-11 14:18:32');

/*Table structure for table `xinlijiankang_collection` */

DROP TABLE IF EXISTS `xinlijiankang_collection`;

CREATE TABLE `xinlijiankang_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `xinlijiankang_id` int(11) DEFAULT NULL COMMENT '心理健康',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `xinlijiankang_collection_types` int(11) DEFAULT NULL COMMENT '类型',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '收藏时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='心理健康收藏';

/*Data for the table `xinlijiankang_collection` */

insert  into `xinlijiankang_collection`(`id`,`xinlijiankang_id`,`yonghu_id`,`xinlijiankang_collection_types`,`insert_time`,`create_time`) values (1,1,2,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(2,2,3,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(3,3,2,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(5,5,1,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(6,6,1,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(7,7,2,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(8,8,3,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(10,10,1,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(11,11,1,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(12,12,3,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(13,13,2,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(14,14,3,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(16,13,1,3,'2023-03-11 14:37:38','2023-03-11 14:37:38');

/*Table structure for table `xinlijiankang_liuyan` */

DROP TABLE IF EXISTS `xinlijiankang_liuyan`;

CREATE TABLE `xinlijiankang_liuyan` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `xinlijiankang_id` int(11) DEFAULT NULL COMMENT '心理健康',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `xinlijiankang_liuyan_text` text COMMENT '留言内容',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '留言时间',
  `reply_text` text COMMENT '回复内容',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='心理健康留言';

/*Data for the table `xinlijiankang_liuyan` */

insert  into `xinlijiankang_liuyan`(`id`,`xinlijiankang_id`,`yonghu_id`,`xinlijiankang_liuyan_text`,`insert_time`,`reply_text`,`update_time`,`create_time`) values (1,1,3,'留言内容1','2023-03-11 14:18:32','回复信息1','2023-03-11 14:18:32','2023-03-11 14:18:32'),(2,2,3,'留言内容2','2023-03-11 14:18:32','回复信息2','2023-03-11 14:18:32','2023-03-11 14:18:32'),(3,3,2,'留言内容3','2023-03-11 14:18:32','回复信息3','2023-03-11 14:18:32','2023-03-11 14:18:32'),(4,4,3,'留言内容4','2023-03-11 14:18:32','回复信息4','2023-03-11 14:18:32','2023-03-11 14:18:32'),(5,5,1,'留言内容5','2023-03-11 14:18:32','回复信息5','2023-03-11 14:18:32','2023-03-11 14:18:32'),(6,6,2,'留言内容6','2023-03-11 14:18:32','回复信息6','2023-03-11 14:18:32','2023-03-11 14:18:32'),(7,7,3,'留言内容7','2023-03-11 14:18:32','回复信息7','2023-03-11 14:18:32','2023-03-11 14:18:32'),(8,8,1,'留言内容8','2023-03-11 14:18:32','回复信息8','2023-03-11 14:18:32','2023-03-11 14:18:32'),(9,9,3,'留言内容9','2023-03-11 14:18:32','回复信息9','2023-03-11 14:18:32','2023-03-11 14:18:32'),(10,10,1,'留言内容10','2023-03-11 14:18:32','回复信息10','2023-03-11 14:18:32','2023-03-11 14:18:32'),(11,11,3,'留言内容11','2023-03-11 14:18:32','回复信息11','2023-03-11 14:18:32','2023-03-11 14:18:32'),(12,12,1,'留言内容12','2023-03-11 14:18:32','回复信息12','2023-03-11 14:18:32','2023-03-11 14:18:32'),(13,13,1,'留言内容13','2023-03-11 14:18:32','回复信息13','2023-03-11 14:18:32','2023-03-11 14:18:32'),(14,14,1,'留言内容14','2023-03-11 14:18:32','回复信息14','2023-03-11 14:18:32','2023-03-11 14:18:32'),(15,13,1,'123123','2023-03-11 14:37:46','123123','2023-03-11 14:56:55','2023-03-11 14:37:46');

/*Table structure for table `yonghu` */

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) DEFAULT NULL COMMENT '账户',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `yonghu_name` varchar(200) DEFAULT NULL COMMENT '用户姓名 Search111 ',
  `sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111',
  `yonghu_photo` varchar(200) DEFAULT NULL COMMENT '用户头像',
  `yonghu_id_number` varchar(200) DEFAULT NULL COMMENT '身份证号',
  `yonghu_phone` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `yonghu_email` varchar(200) DEFAULT NULL COMMENT '电子邮箱',
  `yonghu_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户';

/*Data for the table `yonghu` */

insert  into `yonghu`(`id`,`username`,`password`,`yonghu_name`,`sex_types`,`yonghu_photo`,`yonghu_id_number`,`yonghu_phone`,`yonghu_email`,`yonghu_delete`,`create_time`) values (1,'a1','123456','用户姓名1',1,'upload/yonghu1.jpg','410224199010102001','17703786901','1@qq.com',1,'2023-03-11 14:18:32'),(2,'a2','123456','用户姓名2',2,'upload/yonghu2.jpg','410224199010102002','17703786902','2@qq.com',1,'2023-03-11 14:18:32'),(3,'a3','123456','用户姓名3',2,'upload/yonghu3.jpg','410224199010102003','17703786903','3@qq.com',1,'2023-03-11 14:18:32');

/*Table structure for table `zhixunshi` */

DROP TABLE IF EXISTS `zhixunshi`;

CREATE TABLE `zhixunshi` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) DEFAULT NULL COMMENT '账户',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `zhixunshi_name` varchar(200) DEFAULT NULL COMMENT '咨询师姓名 Search111 ',
  `sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111',
  `zhixunshi_photo` varchar(200) DEFAULT NULL COMMENT '咨询师头像',
  `zhixunshi_id_number` varchar(200) DEFAULT NULL COMMENT '身份证号',
  `zhixunshi_phone` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `zhixunshi_email` varchar(200) DEFAULT NULL COMMENT '电子邮箱',
  `zhixunshi_congye` varchar(200) DEFAULT NULL COMMENT '从业时长',
  `zhixunshi_shanchang` varchar(200) DEFAULT NULL COMMENT '擅长',
  `zhixunshi_content` text COMMENT '个人简介',
  `zhixunshi_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='咨询师';

/*Data for the table `zhixunshi` */

insert  into `zhixunshi`(`id`,`username`,`password`,`zhixunshi_name`,`sex_types`,`zhixunshi_photo`,`zhixunshi_id_number`,`zhixunshi_phone`,`zhixunshi_email`,`zhixunshi_congye`,`zhixunshi_shanchang`,`zhixunshi_content`,`zhixunshi_delete`,`create_time`) values (1,'a1','123456','咨询师姓名1',1,'upload/zhixunshi1.jpg','410224199010102001','17703786901','1@qq.com','从业时长1','擅长1','个人简介1',1,'2023-03-11 14:18:32'),(2,'a2','123456','咨询师姓名2',1,'upload/zhixunshi2.jpg','410224199010102002','17703786902','2@qq.com','从业时长2','擅长2','个人简介2',1,'2023-03-11 14:18:32'),(3,'a3','123456','咨询师姓名3',1,'upload/zhixunshi3.jpg','410224199010102003','17703786903','3@qq.com','从业时长3','擅长3','个人简介3',1,'2023-03-11 14:18:32');

/*Table structure for table `zhixunshi_chat` */

DROP TABLE IF EXISTS `zhixunshi_chat`;

CREATE TABLE `zhixunshi_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '提问人',
  `zhixunshi_id` int(11) DEFAULT NULL COMMENT '回答人',
  `zhixunshi_chat_issue_text` text COMMENT '问题',
  `issue_time` timestamp NULL DEFAULT NULL COMMENT '问题时间',
  `zhixunshi_chat_reply_text` text COMMENT '回复',
  `reply_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
  `zhuangtai_types` int(255) DEFAULT NULL COMMENT '状态',
  `zhixunshi_chat_types` int(11) DEFAULT NULL COMMENT '数据类型',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '提问时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='心理咨询';

/*Data for the table `zhixunshi_chat` */

insert  into `zhixunshi_chat`(`id`,`yonghu_id`,`zhixunshi_id`,`zhixunshi_chat_issue_text`,`issue_time`,`zhixunshi_chat_reply_text`,`reply_time`,`zhuangtai_types`,`zhixunshi_chat_types`,`insert_time`,`create_time`) values (1,2,3,'问题1','2023-03-11 14:18:32','回复1','2023-03-11 14:18:32',1,2,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(2,3,1,'问题2','2023-03-11 14:18:32','回复2','2023-03-11 14:18:32',1,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(3,3,2,'问题3','2023-03-11 14:18:32','回复3','2023-03-11 14:18:32',1,2,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(4,3,3,'问题4','2023-03-11 14:18:32','回复4','2023-03-11 14:18:32',2,2,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(5,2,1,'问题5','2023-03-11 14:18:32','回复5','2023-03-11 14:18:32',1,2,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(6,1,2,'问题6','2023-03-11 14:18:32','回复6','2023-03-11 14:18:32',1,2,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(7,1,1,'问题7','2023-03-11 14:18:32','回复7','2023-03-11 14:18:32',2,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(8,3,1,'问题8','2023-03-11 14:18:32','回复8','2023-03-11 14:18:32',2,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(9,2,2,'问题9','2023-03-11 14:18:32','回复9','2023-03-11 14:18:32',1,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(10,2,3,'问题10','2023-03-11 14:18:32','回复10','2023-03-11 14:18:32',2,2,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(11,2,3,'问题11','2023-03-11 14:18:32','回复11','2023-03-11 14:18:32',1,2,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(12,2,1,'问题12','2023-03-11 14:18:32','回复12','2023-03-11 14:18:32',2,2,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(13,2,2,'问题13','2023-03-11 14:18:32','回复13','2023-03-11 14:18:32',1,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(14,3,3,'问题14','2023-03-11 14:18:32','回复14','2023-03-11 14:18:32',1,1,'2023-03-11 14:18:32','2023-03-11 14:18:32'),(15,1,2,'12312312','2023-03-11 14:38:19',NULL,NULL,1,1,'2023-03-11 14:38:19','2023-03-11 14:38:19'),(16,1,1,NULL,NULL,'11223331231','2023-03-11 14:55:53',NULL,2,'2023-03-11 14:55:54','2023-03-11 14:55:54');

/*Table structure for table `zhixunshi_yuyue` */

DROP TABLE IF EXISTS `zhixunshi_yuyue`;

CREATE TABLE `zhixunshi_yuyue` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `zhixunshi_id` int(11) DEFAULT NULL COMMENT '咨询师',
  `zhixunshi_yuyue_time` timestamp NULL DEFAULT NULL COMMENT '预约时间',
  `zhixunshi_yuyue_text` text COMMENT '备注',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '添加时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='咨询师预约';

/*Data for the table `zhixunshi_yuyue` */

insert  into `zhixunshi_yuyue`(`id`,`zhixunshi_id`,`zhixunshi_yuyue_time`,`zhixunshi_yuyue_text`,`insert_time`,`create_time`) values (15,2,'2023-03-24 14:38:16','123123123','2023-03-11 14:38:26','2023-03-11 14:38:26');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;