当前位置： 首页 > article >正文

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

article 2024/9/19 19:51:31

博主介绍：
    ✌我是阿龙，一名专注于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.kler.cn/news/310866.html

相关文章：

  • python 实现collatz sequence考拉兹序列算法
  • 如何使用下拉字段创建WordPress表单（简单方法）
  • 1.熟悉接口测试（Postman工具）
  • JavaWeb笔记整理——Redis
  • 程序员装新机
  • 【架构设计】多级缓存：应用案例与问题解决策略
  • Linux入门学习：Linux权限理解
  • PyQGIS开发 1 环境配置
  • web渗透—RCE
  • 单片机中为什么要使用5v转3.3v，不直接使用3.3V电压
  • 【Bug解决】Nacos启动成功，但却无法访问（提示：无法访问此网站，192.168.10.88的响应时间过长）
  • 【算法题】46. 全排列-力扣(LeetCode)
  • Flink 实现无界流
  • 十七，Spring Boot 整合 MyBatis 的详细步骤(两种方式)
  • 四、JVM原理-4.2、内存管理
  • 计算机视觉（CV）技术是指计算机系统通过模拟人类视觉系统来识别、理解和解释图像和视频的能力。它可以在各种领域中发挥巨大作用，但也面临一些挑战。
  • tasklist命令的应用实例
  • 力扣150题——位运算
  • 小程序开发设计-第一个小程序：创建小程序项目④
  • Java学习路线指南
  • PowerShell install 一键部署Oracle23ai
  • 基于安卓的音乐app设计与实现(全套)
  • Android 开发高频面试题之——Flutter
  • 【JVM】类加载过程|双亲委派模型
  • RTX 4090 系列即将停产，RTX 5090 系列蓄势待发
  • 【系统架构设计】系统的可靠性分析与设计
  • 接口自动化框架入门（requests+pytest）
  • 最好用的翻译器：什么是DeepL？如何订阅支付DeepL，订阅DeepL Pro以及申请DeepL API？
  • 蓝桥杯—STM32G431RBT6按键的多方式使用（包含软件消抖方法精讲）从原理层面到实际应用（一）
  • TS - tsconfig.json 和 tsconfig.node.json 的关系，如何在TS 中使用 JS 不报错