【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等多个平台推荐,成为各大平台的优质作者。

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

免费赠送相关学习资料:

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

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

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

如若内容造成侵权/违法违规/事实不符,请联系长河编程网进行投诉反馈email:809451989@qq.com,一经查实,立即删除!

相关文章

LeetCode[中等] 54.螺旋矩阵

给你一个 m 行 n 列的矩阵 matrix &#xff0c;请按照 顺时针螺旋顺序 &#xff0c;返回矩阵中的所有元素。 思路&#xff1a;定义方向数组&#xff0c;按照顺时针顺序&#xff1a;右(0,1)&#xff0c;下(1,0)&#xff0c;左(0,-1)&#xff0c;上(0,-1) 从矩阵的左上角开始遍历…

5. 数字证书与公钥基础设施

5. 数字证书与公钥基础设施 (1) PKI 的定义、组成及应用 PKI(Public Key Infrastructure,公钥基础设施) 是一个使用公钥技术来提供安全服务的框架。它定义了如何管理和维护公钥,以及如何通过证书来验证公钥的真实性。PKI的核心组成部分包括: 证书颁发机构(CA, Certifica…

Maven 安装

Maven 安装 Maven 下载安装 下载MAVEN 选择版本注意&#xff1a; IDEA 2022 兼容maven 3.8.1及之前的所用版本 IDEA 2021 兼容maven 3.8.1及之前的所用版本 IDEA 2020 兼容Maven 3.6.3及之前所有版本 IDEA 2018 兼容Maven3.6.1及之前所有版本 打开MAVEN官网 下载需要的版本 Wi…

软件设计师——操作系统

&#x1f4d4;个人主页&#x1f4da;&#xff1a;秋邱-CSDN博客☀️专属专栏✨&#xff1a;软考——软件设计师&#x1f3c5;往期回顾&#x1f3c6;&#xff1a;C: 类和对象&#xff08;上&#xff09;&#x1f31f;其他专栏&#x1f31f;&#xff1a;C语言_秋邱 一、操作系统…

Qt_窗口界面QMainWindow的介绍

目录 1、菜单栏QMenuBar 1.1 使用QMainWindow的准备工作 1.2 在ui文件中设计窗口 1.3 在代码中设计窗口 1.4 实现点击菜单项的反馈 1.5 菜单中设置快捷键 1.6 菜单中添加子菜单 1.7 菜单项中添加分割线和图标 1.8 关于菜单栏创建方式的讨论 2、工具栏QToolBar …

谷歌-BERT-“bert-base-chinese ”

1 需求 需求&#xff1a;自动下载模型和分词器 需求&#xff1a;手动导入模型和分词器 需求&#xff1a;pipeline使用预训练模型 需求&#xff1a;训练和评估 需求&#xff1a;测试 关键词&#xff1a;训练数据集、评估数据集、测试数据集 需求&#xff1a;上线 2 接口 3 自…

[UTCTF2020]sstv

用goldwave和010editor打开均未发现线索&#xff0c; 网上搜索sstv&#xff0c;豆包回答如下&#xff1a; 慢扫描电视&#xff08;Slow Scan Television&#xff0c;简称 SSTV&#xff09;是一种通过无线电传输和接收静态图像的技术。 一、工作原理 SSTV 通过将图像逐行扫描并…

鸿蒙OpenHarmony【轻量系统内核通信机制(互斥锁)】子系统开发

互斥锁 基本概念 互斥锁又称互斥型信号量&#xff0c;是一种特殊的二值性信号量&#xff0c;用于实现对共享资源的独占式处理。 任意时刻互斥锁的状态只有两种&#xff0c;开锁或闭锁。当任务持有互斥锁时&#xff0c;该互斥锁处于闭锁状态&#xff0c;这个任务获得该互斥锁…

利用Metasploit进行信息收集与扫描

Metasploit之信息收集和扫描 在本文中&#xff0c;我们将学习以下内容 使用Metasploit被动收集信息 使用Metasploit主动收集信息 使用Nmap进行端口扫描 使用db_nmap方式进行端口扫描 使用ARP进行主机发现 UDP服务探测 SMB扫描和枚举 SSH版本扫描 FTP扫描 SMTP枚举 …

基于python上门维修预约服务数据分析系统

目录 技术栈和环境说明解决的思路具体实现截图python语言框架介绍技术路线性能/安全/负载方面可行性分析论证python-flask核心代码部分展示python-django核心代码部分展示操作可行性详细视频演示源码获取 技术栈和环境说明 结合用户的使用需求&#xff0c;本系统采用运用较为广…

Git使用详解:从安装到精通

前言 什么是Git Git是一个分布式版本控制工具&#xff0c;主要用于管理开发过程中的源代码文件&#xff08;Java类、xml文件、html页面等&#xff09;&#xff0c;在软件开发过程中被广泛使用。 可以理解&#xff1a; git是一个管理源代码的工具&#xff0c;主要用于企业团队开…

接口自动化框架入门(requests+pytest)

一、接口自动化概述 二、数据库概述 2.1 概念 存储数据的仓库&#xff0c;程序中数据的载体 2.2 分类 关系型数据库&#xff1a;安全 如mysql&#xff0c;oracle&#xff0c;SQLLite database tables 行列 非关系型数据库&#xff1a;高效 如redis&#xff0c;mongoDB 数…

学习大数据DAY59 全量抽取和增量抽取实战

目录 需求流程&#xff1a; 需求分析与规范 作业 作业2 需求流程&#xff1a; 全量抽取 增量抽取 - DataX Kettle Sqoop ... 场景: 业务部门同事或者甲方的工作人员给我们的部门经理和你提出了新的需 求 流程: 联系 > 开会讨论 > 确认需求 > 落地 需求文档( 具体…

4.提升客户服务体验:ChatGPT在客服中的应用(4/10)

本文大纲旨在指导撰写一篇全面探讨ChatGPT如何通过优化客户服务流程、提供实际应用案例和用户反馈&#xff0c;以提升客户服务体验的深入博客文章。 引言 在当今竞争激烈的商业环境中&#xff0c;客户服务已成为企业成功的关键因素。优质的客户服务不仅能够增强客户满意度和忠…

天池Fashion AI 比赛失败经历分享

关联比赛: FashionAI全球挑战赛—服饰关键点定位 昨天是天池Fashion AI初赛Deadline&#xff0c; 成绩出来复赛都没能进&#xff0c;虽然结果很遗憾&#xff0c;但在比赛的过程中也接触到了不少的新东西&#xff0c;希望能在这里把我尝试过的方法都分享出来。作为对自己的总结…

Why Is Prompt Tuning for Vision-Language Models Robust to Noisy Labels?

文章汇总 本文的作者针对了提示学习的结构设计进行了分析&#xff0c;发现了一些规律&#xff1a; 1)固定的类名令牌为模型的优化提供了强正则化&#xff0c;减少了由噪声样本引起的梯度。 2)从多样化和通用的web数据中学习到的强大的预训练图像文本嵌入为图像分类提供了强大…

基于kubernetes-nmstate配置节点网络

kubernetes-nmstate 简介 kubernetes-nmstate 通过 Kubernetes API 驱动的声明式节点网络配置。 随着混合云的出现&#xff0c;节点网络设置变得更加具有挑战性。不同的环境有不同的网络要求。 容器网络接口&#xff08;CNI&#xff09;标准实现了不同的解决方案&#xff0c;…

简单多状态dp第二弹 leetcode -删除并获得点数 -粉刷房子

740. 删除并获得点数 删除并获得点数 分析: 使用动态规划解决 这道题依旧是 打家劫舍I 问题的变型。 我们注意到题目描述&#xff0c;选择 x 数字的时候&#xff0c; x - 1 与 x 1 是不能被选择的。像不像 打家劫舍 问题中&#xff0c;选择 i 位置的金额之后&#xff0c;就不…

更高效的搜索工具,国内免费好用的AI智能搜索引擎工具

搜索引擎是我们获取信息的重要渠道&#xff0c;然而由于搜索引擎搜索结果存在较多的广告以及一些无关内容&#xff0c;这使我们的搜索效率变得更低效。小编就和大家分享几款国内免费好用的AI智能搜索工具&#xff0c;提高搜索效率。 1.开搜AI搜索 开搜AI搜索是一款基于深度学…

低版本SqlSugar的where条件中使用可空类型报语法错误

SQLServer数据表中有两列可空列&#xff0c;均为数值类型&#xff0c;同时在数据库中录入测试数据&#xff0c;Age和Height列均部分有值。   使用SqlSugar的DbFirst功能生成数据库表类&#xff0c;其中Age、Height属性均为可空类型。   开始使用的SqlSugar版本较低&…