【2025】儿童疫苗接种预约小程序（源码+文档+解答）

博主介绍：
    ✌我是阿龙，一名专注于Java技术领域的程序员，全网拥有10W+粉丝。作为CSDN特邀作者、博客专家、新星计划导师，我在计算机毕业设计开发方面积累了丰富的经验。同时，我也是掘金、华为云、阿里云、InfoQ等平台的优质作者。通过长期分享和实战指导，我致力于帮助更多学生完成毕业项目和技术提升。

技术范围：
    我熟悉的技术领域涵盖SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、爬虫、数据可视化、小程序、安卓app、大数据、物联网、机器学习等方面的设计与开发。如果你有任何技术难题，我都乐意与你分享解决方案。

 主要内容：
     我的服务内容包括：免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文撰写与辅导、论文降重、长期答辩答疑辅导。此外，我还提供腾讯会议一对一的专业讲解和模拟答辩演练，帮助你全面掌握答辩技巧与代码逻辑。

🍅获取源码请在文末联系我🍅
如果你对我的内容感兴趣，记得先收藏！对于毕设选题、项目开发或论文撰写等相关问题，随时欢迎留言咨询，我会尽力帮助更多同学顺利完成学业。

最主要的是免费咨询相关问题！！

文档学习资料（阿龙可以赠送所有的录制好的讲解视频）：

系统实现界面：需要详细视频请DD我下方！！

实现代码：

-- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost    Database: cl33877383
-- ------------------------------------------------------
-- 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: `cl33877383`
--

/*!40000 DROP DATABASE IF EXISTS `cl33877383`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cl33877383` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `cl33877383`;

--
-- 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,'swiper1','file/swiperPicture1.jpg'),(2,'swiper2','file/swiperPicture2.jpg'),(3,'swiper3','file/swiperPicture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussyimiaojiezhongzhishi`
--

DROP TABLE IF EXISTS `discussyimiaojiezhongzhishi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussyimiaojiezhongzhishi` (
  `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',
  `avatarurl` longtext COMMENT '头像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='疫苗接种知识评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussyimiaojiezhongzhishi`
--

LOCK TABLES `discussyimiaojiezhongzhishi` WRITE;
/*!40000 ALTER TABLE `discussyimiaojiezhongzhishi` DISABLE KEYS */;
/*!40000 ALTER TABLE `discussyimiaojiezhongzhishi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussyimiaokepu`
--

DROP TABLE IF EXISTS `discussyimiaokepu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussyimiaokepu` (
  `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',
  `avatarurl` longtext COMMENT '头像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='疫苗科普评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussyimiaokepu`
--

LOCK TABLES `discussyimiaokepu` WRITE;
/*!40000 ALTER TABLE `discussyimiaokepu` DISABLE KEYS */;
/*!40000 ALTER TABLE `discussyimiaokepu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussyimiaoxinxi`
--

DROP TABLE IF EXISTS `discussyimiaoxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussyimiaoxinxi` (
  `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',
  `avatarurl` longtext COMMENT '头像',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='疫苗信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussyimiaoxinxi`
--

LOCK TABLES `discussyimiaoxinxi` WRITE;
/*!40000 ALTER TABLE `discussyimiaoxinxi` DISABLE KEYS */;
/*!40000 ALTER TABLE `discussyimiaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ertongxinxi`
--

DROP TABLE IF EXISTS `ertongxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ertongxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jianhurenshoujihao` varchar(200) DEFAULT NULL COMMENT '监护人手机号',
  `jianhurenxingming` varchar(200) DEFAULT NULL COMMENT '监护人姓名',
  `ertongxingming` varchar(200) DEFAULT NULL COMMENT '儿童姓名',
  `ertongjiezhongbianhao` varchar(200) DEFAULT NULL COMMENT '儿童接种编号',
  `ertongchushengriqi` date DEFAULT NULL COMMENT '儿童出生日期',
  `ertongxingbie` varchar(200) DEFAULT NULL COMMENT '儿童性别',
  `ertongyunqizhoushu` varchar(200) DEFAULT NULL COMMENT '儿童孕期周数',
  `ertongchushengshengao` varchar(200) DEFAULT NULL COMMENT '儿童出生身高',
  `ertongchushengtizhong` varchar(200) DEFAULT NULL COMMENT '儿童出生体重',
  `ertongguominshi` varchar(200) DEFAULT NULL COMMENT '儿童过敏史',
  `jianhurenyuertongguanxi` varchar(200) DEFAULT NULL COMMENT '监护人与儿童关系',
  `jiatingzhuzhi` varchar(200) DEFAULT NULL COMMENT '家庭住址',
  `ertongzhaopian` longtext COMMENT '儿童照片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1715485914077 DEFAULT CHARSET=utf8 COMMENT='儿童信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ertongxinxi`
--

LOCK TABLES `ertongxinxi` WRITE;
/*!40000 ALTER TABLE `ertongxinxi` DISABLE KEYS */;
INSERT INTO `ertongxinxi` VALUES (31,'2024-05-12 03:32:49','监护人手机号1','监护人姓名1','儿童姓名1','儿童接种编号1','2024-05-12','男','儿童孕期周数1','儿童出生身高1','儿童出生体重1','儿童过敏史1','监护人与儿童关系1','家庭住址1','file/ertongxinxiErtongzhaopian1.jpg,file/ertongxinxiErtongzhaopian2.jpg,file/ertongxinxiErtongzhaopian3.jpg'),(32,'2024-05-12 03:32:49','监护人手机号2','监护人姓名2','儿童姓名2','儿童接种编号2','2024-05-12','男','儿童孕期周数2','儿童出生身高2','儿童出生体重2','儿童过敏史2','监护人与儿童关系2','家庭住址2','file/ertongxinxiErtongzhaopian2.jpg,file/ertongxinxiErtongzhaopian3.jpg,file/ertongxinxiErtongzhaopian4.jpg'),(33,'2024-05-12 03:32:49','监护人手机号3','监护人姓名3','儿童姓名3','儿童接种编号3','2024-05-12','男','儿童孕期周数3','儿童出生身高3','儿童出生体重3','儿童过敏史3','监护人与儿童关系3','家庭住址3','file/ertongxinxiErtongzhaopian3.jpg,file/ertongxinxiErtongzhaopian4.jpg,file/ertongxinxiErtongzhaopian5.jpg'),(34,'2024-05-12 03:32:49','监护人手机号4','监护人姓名4','儿童姓名4','儿童接种编号4','2024-05-12','男','儿童孕期周数4','儿童出生身高4','儿童出生体重4','儿童过敏史4','监护人与儿童关系4','家庭住址4','file/ertongxinxiErtongzhaopian4.jpg,file/ertongxinxiErtongzhaopian5.jpg,file/ertongxinxiErtongzhaopian6.jpg'),(35,'2024-05-12 03:32:49','监护人手机号5','监护人姓名5','儿童姓名5','儿童接种编号5','2024-05-12','男','儿童孕期周数5','儿童出生身高5','儿童出生体重5','儿童过敏史5','监护人与儿童关系5','家庭住址5','file/ertongxinxiErtongzhaopian5.jpg,file/ertongxinxiErtongzhaopian6.jpg,file/ertongxinxiErtongzhaopian7.jpg'),(36,'2024-05-12 03:32:49','监护人手机号6','监护人姓名6','儿童姓名6','儿童接种编号6','2024-05-12','男','儿童孕期周数6','儿童出生身高6','儿童出生体重6','儿童过敏史6','监护人与儿童关系6','家庭住址6','file/ertongxinxiErtongzhaopian6.jpg,file/ertongxinxiErtongzhaopian7.jpg,file/ertongxinxiErtongzhaopian8.jpg'),(1715485914076,'2024-05-12 03:51:53','13600000000','李四妈妈','李四','20230501','2023-05-01','男','33周','60cm','20kg','无','母女','深圳龙华','file/1715485912754.webp');
/*!40000 ALTER TABLE `ertongxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jiezhongdanwei`
--

DROP TABLE IF EXISTS `jiezhongdanwei`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiezhongdanwei` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jiezhongdanweimingcheng` varchar(200) NOT NULL COMMENT '接种单位名称',
  `denglumima` varchar(200) NOT NULL COMMENT '登录密码',
  `jiezhongdanweidianhua` varchar(200) DEFAULT NULL COMMENT '接种单位电话',
  `tupian` longtext COMMENT '图片',
  `jiezhongdanweidizhi` varchar(200) DEFAULT NULL COMMENT '接种单位地址',
  `gongzuoshijian` varchar(200) DEFAULT NULL COMMENT '工作时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jiezhongdanweimingcheng` (`jiezhongdanweimingcheng`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486147356 DEFAULT CHARSET=utf8 COMMENT='接种单位';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jiezhongdanwei`
--

LOCK TABLES `jiezhongdanwei` WRITE;
/*!40000 ALTER TABLE `jiezhongdanwei` DISABLE KEYS */;
INSERT INTO `jiezhongdanwei` VALUES (21,'2024-05-12 03:32:49','接种单位名称1','123456','19819881111','file/jiezhongdanweiTupian1.jpg','接种单位地址1','工作时间1'),(22,'2024-05-12 03:32:49','接种单位名称2','123456','19819881112','file/jiezhongdanweiTupian2.jpg','接种单位地址2','工作时间2'),(23,'2024-05-12 03:32:49','接种单位名称3','123456','19819881113','file/jiezhongdanweiTupian3.jpg','接种单位地址3','工作时间3'),(24,'2024-05-12 03:32:49','接种单位名称4','123456','19819881114','file/jiezhongdanweiTupian4.jpg','接种单位地址4','工作时间4'),(25,'2024-05-12 03:32:49','接种单位名称5','123456','19819881115','file/jiezhongdanweiTupian5.jpg','接种单位地址5','工作时间5'),(26,'2024-05-12 03:32:49','接种单位名称6','123456','19819881116','file/jiezhongdanweiTupian6.jpg','接种单位地址6','工作时间6'),(1715486147355,'2024-05-12 03:55:47','深圳预防中心','1','13622222222','file/1715486130423.jpg','深圳龙华','周一至周五早8至晚6');
/*!40000 ALTER TABLE `jiezhongdanwei` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jiezhongyichangfankui`
--

DROP TABLE IF EXISTS `jiezhongyichangfankui`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiezhongyichangfankui` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yimiaodingdanhao` varchar(200) NOT NULL COMMENT '疫苗订单号',
  `jianhurenshoujihao` varchar(200) NOT NULL COMMENT '监护人手机号',
  `jianhurenxingming` varchar(200) NOT NULL COMMENT '监护人姓名',
  `ertongxingming` varchar(200) DEFAULT NULL COMMENT '儿童姓名',
  `ertongjiezhongbianhao` varchar(200) DEFAULT NULL COMMENT '儿童接种编号',
  `yimiaomingcheng` varchar(200) DEFAULT NULL COMMENT '疫苗名称',
  `yimiaochangjia` varchar(200) DEFAULT NULL COMMENT '疫苗厂家',
  `jiezhongzhenshu` varchar(200) NOT NULL COMMENT '接种针数',
  `jiezhongshijian` varchar(200) DEFAULT NULL COMMENT '接种时间',
  `jiezhongdanweimingcheng` varchar(200) NOT NULL COMMENT '接种单位名称',
  `jiezhonghoujiankangzhuangkuang` varchar(200) DEFAULT NULL COMMENT '接种后健康状况',
  `jiezhonghoubuliangfanying` varchar(200) DEFAULT NULL COMMENT '接种后不良反应',
  `dengjishijian` date DEFAULT NULL COMMENT '登记时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486384626 DEFAULT CHARSET=utf8 COMMENT='接种异常反馈';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jiezhongyichangfankui`
--

LOCK TABLES `jiezhongyichangfankui` WRITE;
/*!40000 ALTER TABLE `jiezhongyichangfankui` DISABLE KEYS */;
INSERT INTO `jiezhongyichangfankui` VALUES (121,'2024-05-12 03:32:49','疫苗订单号1','监护人手机号1','监护人姓名1','儿童姓名1','儿童接种编号1','疫苗名称1','疫苗厂家1','接种针数1','接种时间1','接种单位名称1','接种后健康状况1','接种后不良反应1','2024-05-12'),(122,'2024-05-12 03:32:49','疫苗订单号2','监护人手机号2','监护人姓名2','儿童姓名2','儿童接种编号2','疫苗名称2','疫苗厂家2','接种针数2','接种时间2','接种单位名称2','接种后健康状况2','接种后不良反应2','2024-05-12'),(123,'2024-05-12 03:32:49','疫苗订单号3','监护人手机号3','监护人姓名3','儿童姓名3','儿童接种编号3','疫苗名称3','疫苗厂家3','接种针数3','接种时间3','接种单位名称3','接种后健康状况3','接种后不良反应3','2024-05-12'),(124,'2024-05-12 03:32:49','疫苗订单号4','监护人手机号4','监护人姓名4','儿童姓名4','儿童接种编号4','疫苗名称4','疫苗厂家4','接种针数4','接种时间4','接种单位名称4','接种后健康状况4','接种后不良反应4','2024-05-12'),(125,'2024-05-12 03:32:49','疫苗订单号5','监护人手机号5','监护人姓名5','儿童姓名5','儿童接种编号5','疫苗名称5','疫苗厂家5','接种针数5','接种时间5','接种单位名称5','接种后健康状况5','接种后不良反应5','2024-05-12'),(126,'2024-05-12 03:32:49','疫苗订单号6','监护人手机号6','监护人姓名6','儿童姓名6','儿童接种编号6','疫苗名称6','疫苗厂家6','接种针数6','接种时间6','接种单位名称6','接种后健康状况6','接种后不良反应6','2024-05-12'),(1715486384625,'2024-05-12 03:59:44','1715486216531','13600000000','李四妈妈','李四','20230501','预防针','礓盛极一时转基因 ','1','2024-05-12 11:59:25','深圳预防中心','健康','无','2024-05-12');
/*!40000 ALTER TABLE `jiezhongyichangfankui` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu`
--

DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `menujson` longtext 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 `menu`
--

LOCK TABLES `menu` WRITE;
/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
INSERT INTO `menu` VALUES (1,'2024-05-12 03:32:49','[{\"backMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-phone\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"轮播图\",\"menuJump\":\"列表\",\"tableName\":\"config\"}],\"fontClass\":\"icon-common27\",\"menu\":\"轮播图管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-camera\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"menu\":\"疫苗接种知识\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongzhishi\"},{\"appFrontIcon\":\"cuIcon-news\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"menu\":\"疫苗科普\",\"menuJump\":\"列表\",\"tableName\":\"yimiaokepu\"}],\"fontClass\":\"icon-common33\",\"menu\":\"公告管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-vipcard\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"管理员\",\"menuJump\":\"列表\",\"tableName\":\"users\"},{\"appFrontIcon\":\"cuIcon-explore\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"用户\",\"menuJump\":\"列表\",\"tableName\":\"yonghu\"},{\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"接种单位\",\"menuJump\":\"列表\",\"tableName\":\"jiezhongdanwei\"}],\"fontClass\":\"icon-common5\",\"menu\":\"管理员管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-list\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\",\"入库\",\"出库\"],\"menu\":\"疫苗信息\",\"menuJump\":\"列表\",\"tableName\":\"yimiaoxinxi\"},{\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"疫苗类型\",\"menuJump\":\"列表\",\"tableName\":\"yimiaoleixing\"}],\"fontClass\":\"icon-common33\",\"menu\":\"疫苗管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-skin\",\"buttons\":[\"查看\",\"修改\",\"删除\"],\"menu\":\"疫苗入库\",\"menuJump\":\"列表\",\"tableName\":\"yimiaoruku\"},{\"appFrontIcon\":\"cuIcon-cardboard\",\"buttons\":[\"查看\",\"修改\",\"删除\"],\"menu\":\"疫苗出库\",\"menuJump\":\"列表\",\"tableName\":\"yimiaochuku\"}],\"fontClass\":\"icon-temp-hot-line\",\"menu\":\"疫苗出入库\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-news\",\"buttons\":[\"查看\",\"删除\"],\"menu\":\"儿童信息\",\"menuJump\":\"列表\",\"tableName\":\"ertongxinxi\"}],\"fontClass\":\"icon-common40\",\"menu\":\"儿童信息\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-wenzi\",\"buttons\":[\"查看\",\"删除\"],\"menu\":\"预约疫苗接种\",\"menuJump\":\"列表\",\"tableName\":\"yuyueyimiaojiezhong\"}],\"fontClass\":\"icon-common17\",\"menu\":\"预约订单\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-full\",\"buttons\":[\"查看\",\"删除\"],\"menu\":\"消息提醒\",\"menuJump\":\"列表\",\"tableName\":\"xiaoxitixing\"}],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pay\",\"buttons\":[\"查看\",\"删除\"],\"menu\":\"疫苗接种登记\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongdengji\"}],\"fontClass\":\"icon-common1\",\"menu\":\"接种登记\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-form\",\"buttons\":[\"查看\",\"删除\"],\"menu\":\"接种异常反馈\",\"menuJump\":\"列表\",\"tableName\":\"jiezhongyichangfankui\"}],\"fontClass\":\"icon-common40\",\"menu\":\"接种异常反馈\",\"unicode\":\"\"}],\"frontMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-vip\",\"buttons\":[\"查看评论\",\"预约\",\"预约疫苗接种\"],\"fontClass\":\"icon-temp-hot-line\",\"menu\":\"疫苗信息\",\"menuJump\":\"列表\",\"tableName\":\"yimiaoxinxi\",\"unicode\":\"\"}],\"fontClass\":\"icon-temp-hot-line\",\"menu\":\"疫苗信息\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-similar\",\"buttons\":[\"查看评论\"],\"fontClass\":\"icon-git-repository-line\",\"menu\":\"疫苗接种知识\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongzhishi\",\"unicode\":\"\"}],\"fontClass\":\"icon-git-repository-line\",\"menu\":\"疫苗知识\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"查看评论\"],\"fontClass\":\"icon-git-repository-fill\",\"menu\":\"疫苗科普\",\"menuJump\":\"列表\",\"tableName\":\"yimiaokepu\",\"unicode\":\"\"}],\"fontClass\":\"icon-git-repository-fill\",\"menu\":\"疫苗科普\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-full\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"menuJump\":\"列表\",\"tableName\":\"xiaoxitixing\",\"unicode\":\"\"}],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-keyboard\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-edit--fill\",\"menu\":\"预约疫苗接种\",\"menuJump\":\"列表\",\"tableName\":\"yuyueyimiaojiezhong\",\"unicode\":\"\"}],\"fontClass\":\"icon-edit--fill\",\"menu\":\"预约订单\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-gift-line\",\"menu\":\"疫苗接种登记\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongdengji\",\"unicode\":\"\"}],\"fontClass\":\"icon-gift-line\",\"menu\":\"接种登记\",\"unicode\":\"\"}],\"hasBackLogin\":\"是\",\"hasBackRegister\":\"否\",\"hasFrontLogin\":\"否\",\"hasFrontRegister\":\"否\",\"roleName\":\"管理员\",\"tableName\":\"users\"},{\"backMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-news\",\"buttons\":[\"新增\",\"查看\",\"删除\"],\"menu\":\"儿童信息\",\"menuJump\":\"列表\",\"tableName\":\"ertongxinxi\"}],\"fontClass\":\"icon-common40\",\"menu\":\"儿童信息\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-wenzi\",\"buttons\":[\"查看\"],\"menu\":\"预约疫苗接种\",\"menuJump\":\"列表\",\"tableName\":\"yuyueyimiaojiezhong\"}],\"fontClass\":\"icon-common17\",\"menu\":\"预约订单\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-full\",\"buttons\":[\"查看\"],\"menu\":\"消息提醒\",\"menuJump\":\"列表\",\"tableName\":\"xiaoxitixing\"}],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pay\",\"buttons\":[\"查看\"],\"menu\":\"疫苗接种登记\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongdengji\"}],\"fontClass\":\"icon-common1\",\"menu\":\"接种登记\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-form\",\"buttons\":[\"查看\"],\"menu\":\"接种异常反馈\",\"menuJump\":\"列表\",\"tableName\":\"jiezhongyichangfankui\"}],\"fontClass\":\"icon-common40\",\"menu\":\"接种异常反馈\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-rank\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"我的收藏\",\"menuJump\":\"1\",\"tableName\":\"storeup\"}],\"fontClass\":\"icon-common17\",\"menu\":\"我的收藏\",\"unicode\":\"\"}],\"frontMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-vip\",\"buttons\":[\"查看评论\",\"预约\",\"预约疫苗接种\"],\"fontClass\":\"icon-temp-hot-line\",\"menu\":\"疫苗信息\",\"menuJump\":\"列表\",\"tableName\":\"yimiaoxinxi\",\"unicode\":\"\"}],\"fontClass\":\"icon-temp-hot-line\",\"menu\":\"疫苗信息\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-similar\",\"buttons\":[\"查看评论\"],\"fontClass\":\"icon-git-repository-line\",\"menu\":\"疫苗接种知识\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongzhishi\",\"unicode\":\"\"}],\"fontClass\":\"icon-git-repository-line\",\"menu\":\"疫苗知识\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"查看评论\"],\"fontClass\":\"icon-git-repository-fill\",\"menu\":\"疫苗科普\",\"menuJump\":\"列表\",\"tableName\":\"yimiaokepu\",\"unicode\":\"\"}],\"fontClass\":\"icon-git-repository-fill\",\"menu\":\"疫苗科普\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-full\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"menuJump\":\"列表\",\"tableName\":\"xiaoxitixing\",\"unicode\":\"\"}],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-keyboard\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-edit--fill\",\"menu\":\"预约疫苗接种\",\"menuJump\":\"列表\",\"tableName\":\"yuyueyimiaojiezhong\",\"unicode\":\"\"}],\"fontClass\":\"icon-edit--fill\",\"menu\":\"预约订单\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-gift-line\",\"menu\":\"疫苗接种登记\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongdengji\",\"unicode\":\"\"}],\"fontClass\":\"icon-gift-line\",\"menu\":\"接种登记\",\"unicode\":\"\"}],\"hasBackLogin\":\"否\",\"hasBackRegister\":\"否\",\"hasFrontLogin\":\"是\",\"hasFrontRegister\":\"是\",\"roleName\":\"用户\",\"tableName\":\"yonghu\"},{\"backMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-wenzi\",\"buttons\":[\"查看\",\"接种登记\",\"消息提醒\"],\"menu\":\"预约疫苗接种\",\"menuJump\":\"列表\",\"tableName\":\"yuyueyimiaojiezhong\"}],\"fontClass\":\"icon-common17\",\"menu\":\"预约订单\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-full\",\"buttons\":[\"查看\"],\"menu\":\"消息提醒\",\"menuJump\":\"列表\",\"tableName\":\"xiaoxitixing\"}],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pay\",\"buttons\":[\"查看\",\"接种异常登记\",\"接种异常反馈\"],\"menu\":\"疫苗接种登记\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongdengji\"}],\"fontClass\":\"icon-common1\",\"menu\":\"接种登记\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-form\",\"buttons\":[\"查看\"],\"menu\":\"接种异常反馈\",\"menuJump\":\"列表\",\"tableName\":\"jiezhongyichangfankui\"}],\"fontClass\":\"icon-common40\",\"menu\":\"接种异常反馈\",\"unicode\":\"\"}],\"frontMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-vip\",\"buttons\":[\"查看评论\",\"预约\",\"预约疫苗接种\"],\"fontClass\":\"icon-temp-hot-line\",\"menu\":\"疫苗信息\",\"menuJump\":\"列表\",\"tableName\":\"yimiaoxinxi\",\"unicode\":\"\"}],\"fontClass\":\"icon-temp-hot-line\",\"menu\":\"疫苗信息\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-similar\",\"buttons\":[\"查看评论\"],\"fontClass\":\"icon-git-repository-line\",\"menu\":\"疫苗接种知识\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongzhishi\",\"unicode\":\"\"}],\"fontClass\":\"icon-git-repository-line\",\"menu\":\"疫苗知识\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"查看评论\"],\"fontClass\":\"icon-git-repository-fill\",\"menu\":\"疫苗科普\",\"menuJump\":\"列表\",\"tableName\":\"yimiaokepu\",\"unicode\":\"\"}],\"fontClass\":\"icon-git-repository-fill\",\"menu\":\"疫苗科普\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-full\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"menuJump\":\"列表\",\"tableName\":\"xiaoxitixing\",\"unicode\":\"\"}],\"fontClass\":\"icon-common9\",\"menu\":\"消息提醒\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-keyboard\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-edit--fill\",\"menu\":\"预约疫苗接种\",\"menuJump\":\"列表\",\"tableName\":\"yuyueyimiaojiezhong\",\"unicode\":\"\"}],\"fontClass\":\"icon-edit--fill\",\"menu\":\"预约订单\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"查看\"],\"fontClass\":\"icon-gift-line\",\"menu\":\"疫苗接种登记\",\"menuJump\":\"列表\",\"tableName\":\"yimiaojiezhongdengji\",\"unicode\":\"\"}],\"fontClass\":\"icon-gift-line\",\"menu\":\"接种登记\",\"unicode\":\"\"}],\"hasBackLogin\":\"是\",\"hasBackRegister\":\"是\",\"hasFrontLogin\":\"否\",\"hasFrontRegister\":\"否\",\"roleName\":\"接种单位\",\"tableName\":\"jiezhongdanwei\"}]');
/*!40000 ALTER TABLE `menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `storeup`
--

DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) DEFAULT NULL COMMENT 'refid',
  `tablename` varchar(200) DEFAULT NULL COMMENT '表名',
  `name` varchar(200) NOT NULL COMMENT '名称',
  `picture` longtext NOT NULL COMMENT '图片',
  `type` varchar(200) DEFAULT NULL COMMENT '类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注)',
  `inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486213317 DEFAULT CHARSET=utf8 COMMENT='我的收藏';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `storeup`
--

LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
INSERT INTO `storeup` VALUES (1715486213316,'2024-05-12 03:56:53',1715486065069,'yimiaoxinxi','预防针','file/1715486029996.jpg','1',NULL,NULL,1715485841607);
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `token`
--

DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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=6 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `token`
--

LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,11,'19819881111','yonghu','用户','ai91b1x6eu2mm6ts91l7eztkbevt53pz','2024-05-12 03:41:00','2024-05-12 04:41:00'),(2,21,'接种单位名称1','jiezhongdanwei','接种单位','f4x99gj5xovj3x6pw1hzj3vfgciez18d','2024-05-12 03:43:53','2024-05-12 04:43:54'),(3,1,'admin','users','管理员','hgfwg1cqxfp5fdgqg2lgbnfo6ihv8d3g','2024-05-12 03:48:46','2024-05-12 05:00:47'),(4,1715485841607,'13600000000','yonghu','用户','jm5syl8rz7rqn0krn84ejwv9sj4mbgcq','2024-05-12 03:50:49','2024-05-12 04:50:49'),(5,1715486147355,'深圳预防中心','jiezhongdanwei','接种单位','2tuert6cn7np2od5iggncgyk8bgcctv8','2024-05-12 03:58:40','2024-05-12 04:58:41');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `username` varchar(200) NOT NULL COMMENT '用户名',
  `password` varchar(200) NOT NULL COMMENT '密码',
  `role` varchar(200) DEFAULT NULL 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 `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'2024-05-12 03:32:49','admin','admin','管理员');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xiaoxitixing`
--

DROP TABLE IF EXISTS `xiaoxitixing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xiaoxitixing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jianhurenshoujihao` varchar(200) NOT NULL COMMENT '监护人手机号',
  `jianhurenxingming` varchar(200) NOT NULL COMMENT '监护人姓名',
  `ertongxingming` varchar(200) DEFAULT NULL COMMENT '儿童姓名',
  `ertongjiezhongbianhao` varchar(200) DEFAULT NULL COMMENT '儿童接种编号',
  `tongzhibiaoti` varchar(200) DEFAULT NULL COMMENT '通知标题',
  `tixingneirong` longtext COMMENT '提醒内容',
  `tongzhishijian` datetime DEFAULT NULL COMMENT '通知时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486348457 DEFAULT CHARSET=utf8 COMMENT='消息提醒';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xiaoxitixing`
--

LOCK TABLES `xiaoxitixing` WRITE;
/*!40000 ALTER TABLE `xiaoxitixing` DISABLE KEYS */;
INSERT INTO `xiaoxitixing` VALUES (161,'2024-05-12 03:32:49','监护人手机号1','监护人姓名1','儿童姓名1','儿童接种编号1','通知标题1','提醒内容1','2024-05-12 11:32:49',1),(162,'2024-05-12 03:32:49','监护人手机号2','监护人姓名2','儿童姓名2','儿童接种编号2','通知标题2','提醒内容2','2024-05-12 11:32:49',2),(163,'2024-05-12 03:32:49','监护人手机号3','监护人姓名3','儿童姓名3','儿童接种编号3','通知标题3','提醒内容3','2024-05-12 11:32:49',3),(164,'2024-05-12 03:32:49','监护人手机号4','监护人姓名4','儿童姓名4','儿童接种编号4','通知标题4','提醒内容4','2024-05-12 11:32:49',4),(165,'2024-05-12 03:32:49','监护人手机号5','监护人姓名5','儿童姓名5','儿童接种编号5','通知标题5','提醒内容5','2024-05-12 11:32:49',5),(166,'2024-05-12 03:32:49','监护人手机号6','监护人姓名6','儿童姓名6','儿童接种编号6','通知标题6','提醒内容6','2024-05-12 11:32:49',6),(1715486348456,'2024-05-12 03:59:07','13600000000','李四妈妈','李四','20230501','李四儿童接种时间到','请按时接种','2024-05-12 11:58:46',1715486147355);
/*!40000 ALTER TABLE `xiaoxitixing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yimiaochuku`
--

DROP TABLE IF EXISTS `yimiaochuku`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yimiaochuku` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yimiaobianhao` varchar(200) DEFAULT NULL COMMENT '疫苗编号',
  `shengchanpici` varchar(200) DEFAULT NULL COMMENT '生产批次',
  `yimiaomingcheng` varchar(200) DEFAULT NULL COMMENT '疫苗名称',
  `yimiaocunliang` int(11) DEFAULT NULL COMMENT '出库数量',
  `yimiaochangjia` varchar(200) DEFAULT NULL COMMENT '疫苗厂家',
  `chukushijian` date DEFAULT NULL COMMENT '出库时间',
  `jiezhongdanweimingcheng` varchar(200) DEFAULT NULL COMMENT '接种单位名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486169603 DEFAULT CHARSET=utf8 COMMENT='疫苗出库';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yimiaochuku`
--

LOCK TABLES `yimiaochuku` WRITE;
/*!40000 ALTER TABLE `yimiaochuku` DISABLE KEYS */;
INSERT INTO `yimiaochuku` VALUES (81,'2024-05-12 03:32:49','疫苗编号1','生产批次1','疫苗名称1',1,'疫苗厂家1','2024-05-12','接种单位名称1'),(82,'2024-05-12 03:32:49','疫苗编号2','生产批次2','疫苗名称2',2,'疫苗厂家2','2024-05-12','接种单位名称2'),(83,'2024-05-12 03:32:49','疫苗编号3','生产批次3','疫苗名称3',3,'疫苗厂家3','2024-05-12','接种单位名称3'),(84,'2024-05-12 03:32:49','疫苗编号4','生产批次4','疫苗名称4',4,'疫苗厂家4','2024-05-12','接种单位名称4'),(85,'2024-05-12 03:32:49','疫苗编号5','生产批次5','疫苗名称5',5,'疫苗厂家5','2024-05-12','接种单位名称5'),(86,'2024-05-12 03:32:49','疫苗编号6','生产批次6','疫苗名称6',6,'疫苗厂家6','2024-05-12','接种单位名称6'),(1715486169602,'2024-05-12 03:56:09','1715485978545','20240101','预防针',1,'礓盛极一时转基因 ','2024-05-12','深圳预防中心');
/*!40000 ALTER TABLE `yimiaochuku` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yimiaojiezhongdengji`
--

DROP TABLE IF EXISTS `yimiaojiezhongdengji`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yimiaojiezhongdengji` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yimiaodingdanhao` varchar(200) DEFAULT NULL COMMENT '疫苗订单号',
  `jianhurenshoujihao` varchar(200) DEFAULT NULL COMMENT '监护人手机号',
  `jianhurenxingming` varchar(200) DEFAULT NULL COMMENT '监护人姓名',
  `ertongxingming` varchar(200) DEFAULT NULL COMMENT '儿童姓名',
  `ertongjiezhongbianhao` varchar(200) DEFAULT NULL COMMENT '儿童接种编号',
  `yimiaomingcheng` varchar(200) DEFAULT NULL COMMENT '疫苗名称',
  `yimiaochangjia` varchar(200) DEFAULT NULL COMMENT '疫苗厂家',
  `jiezhongzhenshu` varchar(200) DEFAULT NULL COMMENT '接种针数',
  `jiezhongshijian` datetime DEFAULT NULL COMMENT '接种时间',
  `jiezhongdanweimingcheng` varchar(200) DEFAULT NULL COMMENT '接种单位名称',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486367364 DEFAULT CHARSET=utf8 COMMENT='疫苗接种登记';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yimiaojiezhongdengji`
--

LOCK TABLES `yimiaojiezhongdengji` WRITE;
/*!40000 ALTER TABLE `yimiaojiezhongdengji` DISABLE KEYS */;
INSERT INTO `yimiaojiezhongdengji` VALUES (111,'2024-05-12 03:32:49','疫苗订单号1','监护人手机号1','监护人姓名1','儿童姓名1','儿童接种编号1','疫苗名称1','疫苗厂家1','接种针数1','2024-05-12 11:32:49','接种单位名称1',1),(112,'2024-05-12 03:32:49','疫苗订单号2','监护人手机号2','监护人姓名2','儿童姓名2','儿童接种编号2','疫苗名称2','疫苗厂家2','接种针数2','2024-05-12 11:32:49','接种单位名称2',2),(113,'2024-05-12 03:32:49','疫苗订单号3','监护人手机号3','监护人姓名3','儿童姓名3','儿童接种编号3','疫苗名称3','疫苗厂家3','接种针数3','2024-05-12 11:32:49','接种单位名称3',3),(114,'2024-05-12 03:32:49','疫苗订单号4','监护人手机号4','监护人姓名4','儿童姓名4','儿童接种编号4','疫苗名称4','疫苗厂家4','接种针数4','2024-05-12 11:32:49','接种单位名称4',4),(115,'2024-05-12 03:32:49','疫苗订单号5','监护人手机号5','监护人姓名5','儿童姓名5','儿童接种编号5','疫苗名称5','疫苗厂家5','接种针数5','2024-05-12 11:32:49','接种单位名称5',5),(116,'2024-05-12 03:32:49','疫苗订单号6','监护人手机号6','监护人姓名6','儿童姓名6','儿童接种编号6','疫苗名称6','疫苗厂家6','接种针数6','2024-05-12 11:32:49','接种单位名称6',6),(1715486367363,'2024-05-12 03:59:27','1715486216531','13600000000','李四妈妈','李四','20230501','预防针','礓盛极一时转基因 ','1','2024-05-12 11:59:25','深圳预防中心',1715486147355);
/*!40000 ALTER TABLE `yimiaojiezhongdengji` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yimiaojiezhongzhishi`
--

DROP TABLE IF EXISTS `yimiaojiezhongzhishi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yimiaojiezhongzhishi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `biaoti` varchar(200) NOT NULL COMMENT '标题',
  `tupian` longtext NOT NULL COMMENT '图片',
  `jianjie` longtext COMMENT '简介',
  `neirong` longtext NOT NULL COMMENT '内容',
  `fabushijian` date DEFAULT NULL COMMENT '发布时间',
  `storeupnum` int(11) DEFAULT NULL COMMENT '收藏数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='疫苗接种知识';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yimiaojiezhongzhishi`
--

LOCK TABLES `yimiaojiezhongzhishi` WRITE;
/*!40000 ALTER TABLE `yimiaojiezhongzhishi` DISABLE KEYS */;
INSERT INTO `yimiaojiezhongzhishi` VALUES (131,'2024-05-12 03:32:49','标题1','file/yimiaojiezhongzhishiTupian1.jpg,file/yimiaojiezhongzhishiTupian2.jpg,file/yimiaojiezhongzhishiTupian3.jpg','简介1','内容1','2024-05-12',1),(132,'2024-05-12 03:32:49','标题2','file/yimiaojiezhongzhishiTupian2.jpg,file/yimiaojiezhongzhishiTupian3.jpg,file/yimiaojiezhongzhishiTupian4.jpg','简介2','内容2','2024-05-12',2),(133,'2024-05-12 03:32:49','标题3','file/yimiaojiezhongzhishiTupian3.jpg,file/yimiaojiezhongzhishiTupian4.jpg,file/yimiaojiezhongzhishiTupian5.jpg','简介3','内容3','2024-05-12',3),(134,'2024-05-12 03:32:49','标题4','file/yimiaojiezhongzhishiTupian4.jpg,file/yimiaojiezhongzhishiTupian5.jpg,file/yimiaojiezhongzhishiTupian6.jpg','简介4','内容4','2024-05-12',4),(135,'2024-05-12 03:32:49','标题5','file/yimiaojiezhongzhishiTupian5.jpg,file/yimiaojiezhongzhishiTupian6.jpg,file/yimiaojiezhongzhishiTupian7.jpg','简介5','内容5','2024-05-12',5),(136,'2024-05-12 03:32:49','标题6','file/yimiaojiezhongzhishiTupian6.jpg,file/yimiaojiezhongzhishiTupian7.jpg,file/yimiaojiezhongzhishiTupian8.jpg','简介6','内容6','2024-05-12',6);
/*!40000 ALTER TABLE `yimiaojiezhongzhishi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yimiaokepu`
--

DROP TABLE IF EXISTS `yimiaokepu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yimiaokepu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yimiaomingcheng` varchar(200) DEFAULT NULL COMMENT '疫苗名称',
  `tupian` longtext COMMENT '图片',
  `jiezhongshijian` varchar(200) DEFAULT NULL COMMENT '接种时间',
  `zhuyishixiang` varchar(200) DEFAULT NULL COMMENT '注意事项',
  `buliangfanying` varchar(200) DEFAULT NULL COMMENT '不良反应',
  `storeupnum` int(11) DEFAULT NULL COMMENT '收藏数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COMMENT='疫苗科普';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yimiaokepu`
--

LOCK TABLES `yimiaokepu` WRITE;
/*!40000 ALTER TABLE `yimiaokepu` DISABLE KEYS */;
INSERT INTO `yimiaokepu` VALUES (151,'2024-05-12 03:32:49','疫苗名称1','file/yimiaokepuTupian1.jpg,file/yimiaokepuTupian2.jpg,file/yimiaokepuTupian3.jpg','接种时间1','注意事项1','不良反应1',1),(152,'2024-05-12 03:32:49','疫苗名称2','file/yimiaokepuTupian2.jpg,file/yimiaokepuTupian3.jpg,file/yimiaokepuTupian4.jpg','接种时间2','注意事项2','不良反应2',2),(153,'2024-05-12 03:32:49','疫苗名称3','file/yimiaokepuTupian3.jpg,file/yimiaokepuTupian4.jpg,file/yimiaokepuTupian5.jpg','接种时间3','注意事项3','不良反应3',3),(154,'2024-05-12 03:32:49','疫苗名称4','file/yimiaokepuTupian4.jpg,file/yimiaokepuTupian5.jpg,file/yimiaokepuTupian6.jpg','接种时间4','注意事项4','不良反应4',4),(155,'2024-05-12 03:32:49','疫苗名称5','file/yimiaokepuTupian5.jpg,file/yimiaokepuTupian6.jpg,file/yimiaokepuTupian7.jpg','接种时间5','注意事项5','不良反应5',5),(156,'2024-05-12 03:32:49','疫苗名称6','file/yimiaokepuTupian6.jpg,file/yimiaokepuTupian7.jpg,file/yimiaokepuTupian8.jpg','接种时间6','注意事项6','不良反应6',6);
/*!40000 ALTER TABLE `yimiaokepu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yimiaoleixing`
--

DROP TABLE IF EXISTS `yimiaoleixing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yimiaoleixing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yimiaoleixing` varchar(200) DEFAULT NULL COMMENT '疫苗类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1715485975739 DEFAULT CHARSET=utf8 COMMENT='疫苗类型';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yimiaoleixing`
--

LOCK TABLES `yimiaoleixing` WRITE;
/*!40000 ALTER TABLE `yimiaoleixing` DISABLE KEYS */;
INSERT INTO `yimiaoleixing` VALUES (91,'2024-05-12 03:32:49','疫苗类型1'),(92,'2024-05-12 03:32:49','疫苗类型2'),(93,'2024-05-12 03:32:49','疫苗类型3'),(94,'2024-05-12 03:32:49','疫苗类型4'),(95,'2024-05-12 03:32:49','疫苗类型5'),(96,'2024-05-12 03:32:49','疫苗类型6'),(1715485975738,'2024-05-12 03:52:55','预防针');
/*!40000 ALTER TABLE `yimiaoleixing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yimiaoruku`
--

DROP TABLE IF EXISTS `yimiaoruku`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yimiaoruku` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yimiaobianhao` varchar(200) DEFAULT NULL COMMENT '疫苗编号',
  `shengchanpici` varchar(200) DEFAULT NULL COMMENT '生产批次',
  `yimiaomingcheng` varchar(200) DEFAULT NULL COMMENT '疫苗名称',
  `yimiaochangjia` varchar(200) DEFAULT NULL COMMENT '疫苗厂家',
  `yimiaocunliang` int(11) DEFAULT NULL COMMENT '入库数量',
  `rukushijian` date DEFAULT NULL COMMENT '入库时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486074417 DEFAULT CHARSET=utf8 COMMENT='疫苗入库';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yimiaoruku`
--

LOCK TABLES `yimiaoruku` WRITE;
/*!40000 ALTER TABLE `yimiaoruku` DISABLE KEYS */;
INSERT INTO `yimiaoruku` VALUES (71,'2024-05-12 03:32:49','疫苗编号1','生产批次1','疫苗名称1','疫苗厂家1',1,'2024-05-12'),(72,'2024-05-12 03:32:49','疫苗编号2','生产批次2','疫苗名称2','疫苗厂家2',2,'2024-05-12'),(73,'2024-05-12 03:32:49','疫苗编号3','生产批次3','疫苗名称3','疫苗厂家3',3,'2024-05-12'),(74,'2024-05-12 03:32:49','疫苗编号4','生产批次4','疫苗名称4','疫苗厂家4',4,'2024-05-12'),(75,'2024-05-12 03:32:49','疫苗编号5','生产批次5','疫苗名称5','疫苗厂家5',5,'2024-05-12'),(76,'2024-05-12 03:32:49','疫苗编号6','生产批次6','疫苗名称6','疫苗厂家6',6,'2024-05-12'),(1715486074416,'2024-05-12 03:54:33','1715485978545','20240101','预防针','礓盛极一时转基因 ',100,'2024-05-12');
/*!40000 ALTER TABLE `yimiaoruku` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yimiaoxinxi`
--

DROP TABLE IF EXISTS `yimiaoxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yimiaoxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yimiaobianhao` varchar(200) DEFAULT NULL COMMENT '疫苗编号',
  `shengchanpici` varchar(200) DEFAULT NULL COMMENT '生产批次',
  `yimiaomingcheng` varchar(200) DEFAULT NULL COMMENT '疫苗名称',
  `tupian` longtext COMMENT '图片',
  `yimiaoleixing` varchar(200) DEFAULT NULL COMMENT '疫苗类型',
  `yimiaochangjia` varchar(200) DEFAULT NULL COMMENT '疫苗厂家',
  `yimiaocunliang` int(11) DEFAULT NULL COMMENT '疫苗存量',
  `yimiaocunchufangshi` varchar(200) DEFAULT NULL COMMENT '疫苗存储方式',
  `yimiaofufeifangshi` varchar(200) DEFAULT NULL COMMENT '疫苗付费方式',
  `yimiaojiezhongzhenshu` varchar(200) DEFAULT NULL COMMENT '疫苗接种针数',
  `yimiaojiezhongjiangeshijian` varchar(200) DEFAULT NULL COMMENT '疫苗接种间隔时间',
  `jiezhongchangjianfanying` varchar(200) DEFAULT NULL COMMENT '接种常见反应',
  `jiezhongqianjinji` varchar(200) DEFAULT NULL COMMENT '接种前禁忌',
  `yimiaoxiangqingjieshao` longtext COMMENT '疫苗祥情介绍',
  `storeupnum` int(11) DEFAULT NULL COMMENT '收藏数量',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yimiaobianhao` (`yimiaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486065070 DEFAULT CHARSET=utf8 COMMENT='疫苗信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yimiaoxinxi`
--

LOCK TABLES `yimiaoxinxi` WRITE;
/*!40000 ALTER TABLE `yimiaoxinxi` DISABLE KEYS */;
INSERT INTO `yimiaoxinxi` VALUES (41,'2024-05-12 03:32:49','1111111111','生产批次1','疫苗名称1','file/yimiaoxinxiTupian1.jpg,file/yimiaoxinxiTupian2.jpg,file/yimiaoxinxiTupian3.jpg','疫苗类型1','疫苗厂家1',1,'疫苗存储方式1','自费','疫苗接种针数1','疫苗接种间隔时间1','接种常见反应1','接种前禁忌1','疫苗祥情介绍1',1),(42,'2024-05-12 03:32:49','2222222222','生产批次2','疫苗名称2','file/yimiaoxinxiTupian2.jpg,file/yimiaoxinxiTupian3.jpg,file/yimiaoxinxiTupian4.jpg','疫苗类型2','疫苗厂家2',2,'疫苗存储方式2','自费','疫苗接种针数2','疫苗接种间隔时间2','接种常见反应2','接种前禁忌2','疫苗祥情介绍2',2),(43,'2024-05-12 03:32:49','3333333333','生产批次3','疫苗名称3','file/yimiaoxinxiTupian3.jpg,file/yimiaoxinxiTupian4.jpg,file/yimiaoxinxiTupian5.jpg','疫苗类型3','疫苗厂家3',3,'疫苗存储方式3','自费','疫苗接种针数3','疫苗接种间隔时间3','接种常见反应3','接种前禁忌3','疫苗祥情介绍3',3),(44,'2024-05-12 03:32:49','4444444444','生产批次4','疫苗名称4','file/yimiaoxinxiTupian4.jpg,file/yimiaoxinxiTupian5.jpg,file/yimiaoxinxiTupian6.jpg','疫苗类型4','疫苗厂家4',4,'疫苗存储方式4','自费','疫苗接种针数4','疫苗接种间隔时间4','接种常见反应4','接种前禁忌4','疫苗祥情介绍4',4),(45,'2024-05-12 03:32:49','5555555555','生产批次5','疫苗名称5','file/yimiaoxinxiTupian5.jpg,file/yimiaoxinxiTupian6.jpg,file/yimiaoxinxiTupian7.jpg','疫苗类型5','疫苗厂家5',5,'疫苗存储方式5','自费','疫苗接种针数5','疫苗接种间隔时间5','接种常见反应5','接种前禁忌5','疫苗祥情介绍5',5),(46,'2024-05-12 03:32:49','6666666666','生产批次6','疫苗名称6','file/yimiaoxinxiTupian6.jpg,file/yimiaoxinxiTupian7.jpg,file/yimiaoxinxiTupian8.jpg','疫苗类型6','疫苗厂家6',6,'疫苗存储方式6','自费','疫苗接种针数6','疫苗接种间隔时间6','接种常见反应6','接种前禁忌6','疫苗祥情介绍6',6),(1715486065069,'2024-05-12 03:54:25','1715485978545','20240101','预防针','file/1715486029996.jpg','预防针','礓盛极一时转基因 ',99,'冷藏','免费','1','无需间隔','无','无','<p>1111111111</p>',1);
/*!40000 ALTER TABLE `yimiaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yonghu`
--

DROP TABLE IF EXISTS `yonghu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jianhurenshoujihao` varchar(200) NOT NULL COMMENT '监护人手机号',
  `denglumima` varchar(200) NOT NULL COMMENT '登录密码',
  `jianhurenxingming` varchar(200) NOT NULL COMMENT '监护人姓名',
  `ertongxingming` varchar(200) DEFAULT NULL COMMENT '儿童姓名',
  `ertongjiezhongbianhao` varchar(200) DEFAULT NULL COMMENT '儿童接种编号',
  `jianhurenzhaopian` longtext COMMENT '监护人照片',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jianhurenshoujihao` (`jianhurenshoujihao`)
) ENGINE=InnoDB AUTO_INCREMENT=1715485841608 DEFAULT CHARSET=utf8 COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yonghu`
--

LOCK TABLES `yonghu` WRITE;
/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
INSERT INTO `yonghu` VALUES (11,'2024-05-12 03:32:49','19819881111','123456','监护人姓名1','儿童姓名1','儿童接种编号1','file/yonghuJianhurenzhaopian1.jpg'),(12,'2024-05-12 03:32:49','19819881112','123456','监护人姓名2','儿童姓名2','儿童接种编号2','file/yonghuJianhurenzhaopian2.jpg'),(13,'2024-05-12 03:32:49','19819881113','123456','监护人姓名3','儿童姓名3','儿童接种编号3','file/yonghuJianhurenzhaopian3.jpg'),(14,'2024-05-12 03:32:49','19819881114','123456','监护人姓名4','儿童姓名4','儿童接种编号4','file/yonghuJianhurenzhaopian4.jpg'),(15,'2024-05-12 03:32:49','19819881115','123456','监护人姓名5','儿童姓名5','儿童接种编号5','file/yonghuJianhurenzhaopian5.jpg'),(16,'2024-05-12 03:32:49','19819881116','123456','监护人姓名6','儿童姓名6','儿童接种编号6','file/yonghuJianhurenzhaopian6.jpg'),(1715485841607,'2024-05-12 03:50:41','13600000000','1','李四妈妈','李四','20230501','file/1715485840864.jpg');
/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yuyueyimiaojiezhong`
--

DROP TABLE IF EXISTS `yuyueyimiaojiezhong`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yuyueyimiaojiezhong` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yimiaodingdanhao` varchar(200) DEFAULT NULL COMMENT '疫苗订单号',
  `jianhurenshoujihao` varchar(200) DEFAULT NULL COMMENT '监护人手机号',
  `jianhurenxingming` varchar(200) DEFAULT NULL COMMENT '监护人姓名',
  `ertongxingming` varchar(200) DEFAULT NULL COMMENT '儿童姓名',
  `ertongjiezhongbianhao` varchar(200) DEFAULT NULL COMMENT '儿童接种编号',
  `yimiaomingcheng` varchar(200) DEFAULT NULL COMMENT '疫苗名称',
  `yimiaoleixing` varchar(200) DEFAULT NULL COMMENT '疫苗类型',
  `yimiaochangjia` varchar(200) DEFAULT NULL COMMENT '疫苗厂家',
  `jiezhongzhenshu` varchar(200) DEFAULT NULL COMMENT '接种针数',
  `jiezhongdanweimingcheng` varchar(200) DEFAULT NULL COMMENT '接种单位名称',
  `jiezhongdanweidianhua` varchar(200) DEFAULT NULL COMMENT '接种单位电话',
  `jiezhongdanweidizhi` varchar(200) DEFAULT NULL COMMENT '接种单位地址',
  `yuyuejiezhongshijian` datetime DEFAULT NULL COMMENT '预约接种时间',
  `zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yimiaodingdanhao` (`yimiaodingdanhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1715486249623 DEFAULT CHARSET=utf8 COMMENT='预约疫苗接种';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yuyueyimiaojiezhong`
--

LOCK TABLES `yuyueyimiaojiezhong` WRITE;
/*!40000 ALTER TABLE `yuyueyimiaojiezhong` DISABLE KEYS */;
INSERT INTO `yuyueyimiaojiezhong` VALUES (101,'2024-05-12 03:32:49','1111111111','监护人手机号1','监护人姓名1','儿童姓名1','儿童接种编号1','疫苗名称1','疫苗类型1','疫苗厂家1','接种针数1','接种单位名称1','接种单位电话1','接种单位地址1','2024-05-12 11:32:49','已接种',1),(102,'2024-05-12 03:32:49','2222222222','监护人手机号2','监护人姓名2','儿童姓名2','儿童接种编号2','疫苗名称2','疫苗类型2','疫苗厂家2','接种针数2','接种单位名称2','接种单位电话2','接种单位地址2','2024-05-12 11:32:49','已接种',2),(103,'2024-05-12 03:32:49','3333333333','监护人手机号3','监护人姓名3','儿童姓名3','儿童接种编号3','疫苗名称3','疫苗类型3','疫苗厂家3','接种针数3','接种单位名称3','接种单位电话3','接种单位地址3','2024-05-12 11:32:49','已接种',3),(104,'2024-05-12 03:32:49','4444444444','监护人手机号4','监护人姓名4','儿童姓名4','儿童接种编号4','疫苗名称4','疫苗类型4','疫苗厂家4','接种针数4','接种单位名称4','接种单位电话4','接种单位地址4','2024-05-12 11:32:49','已接种',4),(105,'2024-05-12 03:32:49','5555555555','监护人手机号5','监护人姓名5','儿童姓名5','儿童接种编号5','疫苗名称5','疫苗类型5','疫苗厂家5','接种针数5','接种单位名称5','接种单位电话5','接种单位地址5','2024-05-12 11:32:49','已接种',5),(106,'2024-05-12 03:32:49','6666666666','监护人手机号6','监护人姓名6','儿童姓名6','儿童接种编号6','疫苗名称6','疫苗类型6','疫苗厂家6','接种针数6','接种单位名称6','接种单位电话6','接种单位地址6','2024-05-12 11:32:49','已接种',6),(1715486249622,'2024-05-12 03:57:29','1715486216531','13600000000','李四妈妈','李四','20230501','预防针','预防针','礓盛极一时转基因 ','1','深圳预防中心','13622222222','深圳龙华','2024-05-12 12:30:56','已接种',1715485841607);
/*!40000 ALTER TABLE `yuyueyimiaojiezhong` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-05-13 16:09:46

阿龙开发的项目经验展示（项目案例）：

为什么选择我：

我是程序员阿龙，专注于软件开发，拥有丰富的编程能力和实战经验。在过去的几年里，我辅导了上千名学生，帮助他们顺利完成毕业项目，同时我的技术分享也吸引了超过50W+的粉丝。我是CSDN特邀作者、博客专家、新星计划导师，并在Java领域内获得了多项荣誉，如博客之星。我的作品也被掘金、华为云、阿里云、InfoQ等多个平台推荐，成为各大平台的优质作者。

已经为上百名同学获得优秀毕业生！！！

免费赠送相关学习资料：

源码获取：
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻

 精彩专栏推荐订阅：在下方专栏👇🏻

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：/a/881642.html

如若内容造成侵权/违法违规/事实不符，请联系我们进行投诉反馈qq邮箱809451989@qq.com，一经查实，立即删除！

相关文章

猫咪检测系统源码分享

猫咪检测系统源码分享

猫咪检测检测系统源码分享 [一条龙教学YOLOV8标注好的数据集一键训练_70全套改进创新点发刊_Web前端展示] 1.研究背景与意义 项目参考AAAI Association for the Advancement of Artificial Intelligence 项目来源AACV Association for the Advancement of Computer Vision …
阅读更多...
R语言机器学习算法实战系列（二） SVM算法（Support Vector Machine）

R语言机器学习算法实战系列（二） SVM算法（Support Vector Machine）

文章目录 介绍原理应用方向下载数据加载R包导入数据数据预处理数据描述数据切割标准化数据设置参数训练模型预测测试数据评估模型模型准确性混淆矩阵模型评估指标ROC CurvePRC Curve特征的重要性保存模型总结系统信息介绍 支持向量机（Support Vector Machine，简称SVM）是一种…
阅读更多...
跨站请求伪造(CSRF)漏洞详解

跨站请求伪造(CSRF)漏洞详解

免责申明 本文仅是用于学习检测自己搭建的DVWA靶场环境有关CSRF的原理和攻击实验，请勿用在非法途径上，若将其用于非法目的，所造成的一切后果由您自行承担，产生的一切风险和后果与笔者无关；本文开始前请认真详细学习《‌中华人民共和国网络安全法》‌及其所在国家地区相关法…
阅读更多...
java项目之在线考试与学习交流网页平台源码（springboot）

java项目之在线考试与学习交流网页平台源码（springboot）

风定落花生&#xff0c;歌声逐流水&#xff0c;大家好我是风歌&#xff0c;混迹在java圈的辛苦码农。今天要和大家聊的是一款基于springboot的在线考试与学习交流网页平台。项目源码以及部署相关请联系风歌&#xff0c;文末附上联系信息 。 项目简介&#xff1a; 基于JAVA语言…
阅读更多...
ChatGPT搭上langchain的知识库RAG应用，效果超预期

ChatGPT搭上langchain的知识库RAG应用，效果超预期

最近利用LangchainChatGPT实现了上传文档实现个人知识库应用的能力&#xff0c;效果比想象得要好。文末大家可以体验一下效果~~ 给大家大致介绍下实现方式&#xff0c;参考了Langchain chatchat。 一、LangchainChatGPT 1、概述 LangChain 是一个强大的框架&#xff0c;可以…
阅读更多...
飞驰云联FTP替代方案：安全高效文件传输的新选择

飞驰云联FTP替代方案：安全高效文件传输的新选择

FTP协议广泛应用各行业的文件传输场景中&#xff0c;由于FTP应用获取门槛低、使用普遍&#xff0c;因此大部分企业都习惯使用FTP进行文件传输。然而面临激增的数据量和网络安全威胁的不断演变&#xff0c;FTP在传输安全性与传输性能上有所欠缺&#xff0c;无法满足企业现在的高…
阅读更多...
光伏板缺陷红外检测数据集

光伏板缺陷红外检测数据集

光伏板缺陷红外检测数据集 包含以下4个数据文件&#xff1a; /train&#xff1a;训练集 /valid&#xff1a;验证集 /test&#xff1a;测试集 README.txt&#xff1a;数据说明 【数据说明】检测目标以Pascal VOC格式进行标注&#xff0c;对每个图像进行以下预处理&#xff0c;统…
阅读更多...
Codeforces Round 974 (Div. 3) A-F

Codeforces Round 974 (Div. 3) A-F

封面原图 画师礼島れいあ 下午的ICPC网络赛的难受一晚上全都给我打没了 手速拉满再加上秒杀线段树 这场简直了啊 唯一可惜的是最后还是掉出了1000名 一把上蓝应该没啥希望了吧 A - Robin Helps 题意 侠盗罗宾因劫富济贫而闻名于世 罗宾遇到的 n n n 人&#xff0c;从 1 s …
阅读更多...
中泰免签，准备去泰国旅游了吗？《泰语翻译通》app支持文本翻译和语音识别翻译，解放双手对着说话就能翻译。

中泰免签，准备去泰国旅游了吗？《泰语翻译通》app支持文本翻译和语音识别翻译，解放双手对着说话就能翻译。

泰国是很多中国游客的热门选择&#xff0c;现在去泰国旅游更方便了&#xff0c;因为泰国对中国免签了。如果你打算去泰国&#xff0c;那么下载一个好用的泰语翻译软件是很有必要的。 简单好用的翻译工具 《泰语翻译通》App就是为泰国旅游设计的&#xff0c;它翻译准确&#x…
阅读更多...
Cisco Catalyst 9000 Series Switches, IOS XE Release 17.15.1 ED

Cisco Catalyst 9000 Series Switches, IOS XE Release 17.15.1 ED

Cisco Catalyst 9000 Series Switches, IOS XE Release 17.15.1 ED 思科 Catalyst 9000 交换产品系列 IOS XE 系统软件 请访问原文链接&#xff1a;https://sysin.org/blog/cisco-catalyst-9000/&#xff0c;查看最新版。原创作品&#xff0c;转载请保留出处。 作者主页&…
阅读更多...
uniapp中使用picker-view选择时间

uniapp中使用picker-view选择时间

picker-view 是 UniApp 中用于展示和选择数据的组件。它适用于创建多列选择器&#xff0c;类似于 iOS 和 Android 系统中的选择器视图。以下是 picker-view 的详细介绍&#xff0c;包括用法、属性和事件。 一 用法 <template><view><picker-view :value"…
阅读更多...
机器学习——Stacking

机器学习——Stacking

Stacking&#xff1a; 方法&#xff1a;训练多个模型(可以是强模型)&#xff0c;然后将这些模型的预测结果作为新的特征&#xff0c;输入到下一层新的模型&#xff08;可以是多个&#xff09;中进行训练&#xff0c;从而得到最终的预测结果。 代表&#xff1a;Stacking本身并没…
阅读更多...
Java多线程Thread及其原理深度解析

Java多线程Thread及其原理深度解析

文章目录 1. 实现多线程的方式2. Thread 部分源码2.1. native 方法注册2.2. Thread 中的成员变量2.3. Thread 构造方法与初始化2.4. Thread 线程状态与操作系统状态2.4. start() 与 run() 方法2.5. sleep() 方法2.6. join() 方法2.7. interrupt() 方法 本文参考&#xff1a; 线…
阅读更多...
OpenCV_最简单的鼠标截取ROI区域

OpenCV_最简单的鼠标截取ROI区域

在OpenCV中也存在鼠标的操作&#xff0c;今天我们先介绍一下鼠标中的操作事件 void setMousecallback(const string& winname, MouseCallback onMouse, void* userdata0) setMousecallback参数说明&#xff1a; winname:窗口的名字 onMouse:鼠标响应函数&#xff0c;回调…
阅读更多...
接口加解密及数据加解密

接口加解密及数据加解密

目录 一、 加解密方式介绍 1.1 Hash算法加密 1.2. 对称加密 1.3 非对称加密 二、 我们要讲什么&#xff1f; 三、 接口加解密 四、 数据加解密 一、 加解密方式介绍 所有的加密方式我们可以分为三类&#xff1a;对称加密、非对称加密、Hash算法加密。 算法内部的具体实现…
阅读更多...
【后端开发】JavaEE初阶—线程的理解和编程实现

【后端开发】JavaEE初阶—线程的理解和编程实现

前言&#xff1a; &#x1f31f;&#x1f31f;本期讲解多线程的知识哟~~~&#xff0c;希望能帮到屏幕前的你。 &#x1f308;上期博客在这里&#xff1a;【后端开发】JavaEE初阶——计算机是如何工作的&#xff1f;&#xff1f;&#xff1f;-CSDN博客 &#x1f308;感兴趣的小伙…
阅读更多...
【设计模式】UML类图

【设计模式】UML类图

目录 前言 一、类图概述 二、类图的作用 三、类图表示法 四、类之间关系的表示方法 1. 关联关系 1.1 单向关联 1.2 双向关联 1.3 自关联 2. 聚合关系 3. 组合关系 4. 依赖关系 5. 继承关系 6. 实现关系 总结 前言 统一建模语言&#xff08; Unified Modeling La…
阅读更多...
游戏如何对抗定制挂

游戏如何对抗定制挂

近年来&#xff0c;游戏安全对抗强度相比以往更加激烈&#xff0c;具体表现在“定制挂”趋势显著。在近期收集的近万款外挂样本中&#xff0c;定制挂约占比78%&#xff0c;常见的内存修改器、变速器等通用作弊手段占比正在下降。 所谓定制挂&#xff0c;是指针对某款游戏单独开…
阅读更多...
九章云极DataCanvas公司荣获2024年服贸会“科技创新服务示范案例”

九章云极DataCanvas公司荣获2024年服贸会“科技创新服务示范案例”

9月15日&#xff0c;2024年中国国际服务贸易交易会&#xff08;服贸会&#xff09;示范案例交流会暨颁奖典礼在北京国家会议中心举行&#xff0c;九章云极DataCanvas 公司自研的DataCanvas Alaya NeW智算操作系统凭借卓越的AI创新实力、前瞻性的市场布局以及突破性的技术革新成…
阅读更多...
Python脚本每日自动备份MySQL数据库，无需mysqldump

Python脚本每日自动备份MySQL数据库，无需mysqldump

编写一个Python脚本&#xff0c;每天凌晨3点开始备份 脚本具有以下特点 不需要安装mysql-client&#xff0c;并且Windows Linux都可以使用支持多个数据库连接的备份每个数据库支持多个表备份日志保存下来&#xff0c;方便第二天早上查看备份结果 首先安装需要的库 pip3 ins…
阅读更多...
最新文章

Copyright @ 2022~2023