/*
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
