java-新冠疫情数据统计系统.zip

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50735 Source Host : localhost:3306 Source Database : coronavirus Target Server Type : MYSQL Target Server Version : 50735 File Encoding : 65001 Date: 2022-03-11 11:50:06 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for authentication -- ---------------------------- DROP TABLE IF EXISTS `authentication`; CREATE TABLE `authentication` ( `id` int(11) NOT NULL AUTO_INCREMENT, `description` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of authentication -- ---------------------------- INSERT INTO `authentication` VALUES ('1', '管理员', 'Admin'); INSERT INTO `authentication` VALUES ('2', '用户', 'User'); -- ---------------------------- -- Table structure for base -- ---------------------------- DROP TABLE IF EXISTS `base`; CREATE TABLE `base` ( `id` int(11) NOT NULL AUTO_INCREMENT, `idCard` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `age` int(11) DEFAULT NULL, `gender` enum('男','女') DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `phone` bigint(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `idCard` (`idCard`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of base -- ---------------------------- INSERT INTO `base` VALUES ('78', '513030199411234123', '王曦彤', '23', '女', '四川成都红星路', '13508123423'); INSERT INTO `base` VALUES ('79', '513042198810241234', '张霞', '38', '女', '四川成都火车北站', '13508018342'); INSERT INTO `base` VALUES ('80', '513012199011234233', '王佳', '23', '女', '四川成都市新都区', '13508302342'); INSERT INTO `base` VALUES ('81', '513031197212015234', '黄雅莉', '52', '女', '四川南充市', '15308410834'); INSERT INTO `base` VALUES ('82', '513030199411234234', '李明涛', '52', '男', '四川成都锦江区', '13580293523'); INSERT INTO `base` VALUES ('83', '510302199611051234', '张夏婷', '23', '女', '成都红星路', '15083029342'); INSERT INTO `base` VALUES ('84', '513001199103221234', '张天昊', '27', '男', '四川成都红星路', '15082308123'); INSERT INTO `base` VALUES ('85', '510381198502123421', '黄小龙', '38', '男', '四川达州', '15083013942'); INSERT INTO `base` VALUES ('86', '130431188012020013', '张三', '20', '男', '北京市大兴区', '18600000001'); INSERT INTO `base` VALUES ('87', '130431188012020014', '李四', '25', '女', '北京市朝阳区', '18600000002'); -- ---------------------------- -- Table structure for checkout -- ---------------------------- DROP TABLE IF EXISTS `checkout`; CREATE TABLE `checkout` ( `baseId` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `currentPosition` varchar(255) DEFAULT NULL, `bodyTemperature` double DEFAULT NULL, `healthState` varchar(255) DEFAULT NULL, `isToHighArea` varchar(255) DEFAULT NULL, `isTouch` varchar(255) DEFAULT NULL, `remarks` varchar(255) DEFAULT NULL, `checkOutDate` date DEFAULT NULL, PRIMARY KEY (`baseId`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of checkout -- ---------------------------- INSERT INTO `checkout` VALUES ('1', '王五', '北京西城区', '36.5', '很好', '无', '无', '身体健康', '2022-03-11'); INSERT INTO `checkout` VALUES ('2', '赵六', '北京东城区', '36.4', '很好', '无', '无', '身体健康,一切良好', '2022-03-11'); -- ---------------------------- -- Table structure for cure -- ---------------------------- DROP TABLE IF EXISTS `cure`; CREATE TABLE `cure` ( `baseId` int(11) NOT NULL, `dischargeDate` date DEFAULT NULL, `current` varchar(128) DEFAULT NULL, PRIMARY KEY (`baseId`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of cure -- ---------------------------- INSERT INTO `cure` VALUES ('78', '2020-10-01', '良好'); INSERT INTO `cure` VALUES ('80', '2020-10-08', '治愈了'); INSERT INTO `cure` VALUES ('82', '2022-03-11', '治愈'); -- ---------------------------- -- Table structure for dead -- ---------------------------- DROP TABLE IF EXISTS `dead`; CREATE TABLE `dead` ( `baseId` int(11) NOT NULL, `deadTime` date DEFAULT NULL, PRIMARY KEY (`baseId`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of dead -- ---------------------------- INSERT INTO `dead` VALUES ('79', '2020-10-08'); INSERT INTO `dead` VALUES ('86', '2022-03-11'); -- ---------------------------- -- Table structure for inspect -- ---------------------------- DROP TABLE IF EXISTS `inspect`; CREATE TABLE `inspect` ( `testId` int(11) NOT NULL AUTO_INCREMENT, `baseId` int(11) NOT NULL, `testDate` date DEFAULT NULL, `ctTest` enum('病变','正常') DEFAULT NULL, `nuTest` enum('阴性','阳性') DEFAULT NULL, PRIMARY KEY (`testId`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of inspect -- ---------------------------- INSERT INTO `inspect` VALUES ('1', '84', '2020-10-05', '正常', '阳性'); INSERT INTO `inspect` VALUES ('2', '86', '2022-03-10', '病变', '阳性'); INSERT INTO `inspect` VALUES ('3', '86', '2022-03-11', '正常', '阴性'); -- ---------------------------- -- Table structure for patient -- ---------------------------- DROP TABLE IF EXISTS `patient`; CREATE TABLE `patient` ( `baseId` int(11) NOT NULL, `infectionSource` varchar(128) DEFAULT NULL, `onsetDate` date DEFAULT NULL, `symptoms` varchar(128) DEFAULT NULL, `hospital` varchar(32) DEFAULT NULL, `critical` enum('是','否') DEFAULT NULL, `note` varchar(256) DEFAULT NULL, PRIMARY KEY (`baseId`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of patient -- ---------------------------- INSERT INTO `patient` VALUES ('78', '华南海鲜市场', '2020-10-01', '发烧', '华西医院', '否', '测试'); INSERT INTO `patient` VALUES ('79', '海鲜市场', '2020-10-03', '咳嗽', '人民医院', '否', '阳性'); INSERT INTO `patient` VALUES ('80', '华南海鲜', '2020-10-08', '咳嗽发烧', '华西医院', '否', '确诊了哦'); INSERT INTO `patient` VALUES ('82', '武汉列车', '2020-10-01', '发热', '传染病医院', '否', '测试'); INSERT INTO `patient` VALUES ('83', '武汉', '2020-10-01', '发绕', '32', '否', '测试'); INSERT INTO `patient` VALUES ('84', '武汉航班', '2020-10-02', '咳嗽', '27', '否', '测试患者'); INSERT INTO `patient` VALUES ('86', '密切接触者', '2022-03-10', '发热', '北京市第一医院', '否', '无其他症状'); INSERT INTO `patient` VALUES ('87', '密切接触者', '2022-03-07', '发热,呕吐', '北京市第三医院', '是', '有其他症状'); -- ---------------------------- -- Table structure for touch -- ---------------------------- DROP TABLE IF EXISTS `touch`; CREATE TABLE `touch` ( `baseId` int(11) DEFAULT NULL, `comeFrom` varchar(56) DEFAULT NULL, `isoAddress` varchar(128) DEFAULT NULL, `startDate` date DEFAULT NULL, `finished` enum('是','否') DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of touch -- ---------------------------- INSERT INTO `touch` VALUES ('79', '境外航班', '传染病医院', '2020-10-02', '是'); INSERT INTO `touch` VALUES ('80', '华南海鲜', '传染病医院', '2020-10-07', '是'); INSERT INTO