/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : localhost:3306
 Source Schema         : antiepidemic

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : 65001

 Date: 19/09/2022 22:20:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for apply
-- ----------------------------
DROP TABLE IF EXISTS `apply`;
CREATE TABLE `apply`  (
  `a_id` int(11) NOT NULL AUTO_INCREMENT,
  `a_time` date NULL DEFAULT NULL COMMENT '申请时间',
  `a_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `duration` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '时长',
  `ispass` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否通过',
  `uid` int(11) NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`a_id`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE,
  CONSTRAINT `apply_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of apply
-- ----------------------------
INSERT INTO `apply` VALUES (1, '2022-02-11', '治安维护', '3', '不通过', 11);
INSERT INTO `apply` VALUES (2, '2022-02-17', '宣传信息', '2', '通过', 11);
INSERT INTO `apply` VALUES (3, '2022-02-24', '医护协助', '4', '通过', 16);
INSERT INTO `apply` VALUES (4, '2022-03-22', '信息录入', '2', '通过', 16);
INSERT INTO `apply` VALUES (5, '2022-03-15', '治安维护', '5', '不通过', 16);
INSERT INTO `apply` VALUES (6, '2022-03-25', '医护协助', '3', '通过', 16);
INSERT INTO `apply` VALUES (7, '2022-06-30', '医护协助', '3', '不通过', 16);
INSERT INTO `apply` VALUES (9, '2022-07-01', '治安维护', '二个小时', '通过', 11);
INSERT INTO `apply` VALUES (10, '2022-07-02', '信息宣传', '五个小时', '通过', 11);
INSERT INTO `apply` VALUES (11, '2022-07-03', '信息宣传', '三个小时', '申请中', 13);
INSERT INTO `apply` VALUES (12, '2022-07-03', '治安维护', '一个小时', '通过', 53);
INSERT INTO `apply` VALUES (13, '2022-07-03', '信息宣传', '三个小时', '通过', 14);
INSERT INTO `apply` VALUES (14, '2022-07-03', '信息宣传', '一个小时', '通过', 11);
INSERT INTO `apply` VALUES (15, '2022-07-04', '治安维护', '一个小时', '通过', 12);

-- ----------------------------
-- Table structure for building
-- ----------------------------
DROP TABLE IF EXISTS `building`;
CREATE TABLE `building`  (
  `b_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `b_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '楼号',
  `b_descr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`b_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of building
-- ----------------------------
INSERT INTO `building` VALUES (1, '一号楼', '这是一号楼');
INSERT INTO `building` VALUES (2, '二号楼', '这是二号楼');
INSERT INTO `building` VALUES (3, '三号楼', '这是三号楼');
INSERT INTO `building` VALUES (4, '四号楼', '这是四号楼');
INSERT INTO `building` VALUES (5, '五号楼', '这是五号楼');
INSERT INTO `building` VALUES (6, '六号楼', '这是六号楼');
INSERT INTO `building` VALUES (7, '七号楼', '这是七号楼');
INSERT INTO `building` VALUES (8, '八号楼', '这是八号楼');
INSERT INTO `building` VALUES (9, '九号楼', '这是九号楼');
INSERT INTO `building` VALUES (10, '十号楼', '这是十号楼');

-- ----------------------------
-- Table structure for health
-- ----------------------------
DROP TABLE IF EXISTS `health`;
CREATE TABLE `health`  (
  `hid` int(11) NOT NULL AUTO_INCREMENT,
  `htime` date NULL DEFAULT NULL COMMENT '日期',
  `temp` double(11, 1) NULL DEFAULT NULL COMMENT '体温单位℃',
  `condition` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '健康状况',
  `nucleic` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '核酸检测结果',
  `uid` int(11) NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`hid`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE,
  CONSTRAINT `health_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 62 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of health
-- ----------------------------
INSERT INTO `health` VALUES (1, '2022-06-03', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (2, '2022-06-04', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (3, '2022-06-01', 36.0, '健康', '阴性', 3);
INSERT INTO `health` VALUES (4, '2022-06-02', 36.0, '健康', '阴性', 3);
INSERT INTO `health` VALUES (5, '2022-06-03', 36.0, '健康', '阴性', 3);
INSERT INTO `health` VALUES (6, '2022-06-04', 36.0, '健康', '阴性', 3);
INSERT INTO `health` VALUES (7, '2022-06-05', 36.0, '健康', '阴性', 3);
INSERT INTO `health` VALUES (8, '2022-06-05', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (14, '2022-06-06', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (15, '2022-06-07', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (16, '2022-06-01', 36.0, '健康', '阴性', 1);
INSERT INTO `health` VALUES (17, '2022-06-02', 36.0, '健康', '阴性', 1);
INSERT INTO `health` VALUES (18, '2022-06-08', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (19, '2022-06-29', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (20, '2022-06-03', 36.0, '健康', '二十四小时内未做', 1);
INSERT INTO `health` VALUES (22, '2022-06-01', 36.0, '健康', '阴性', 11);
INSERT INTO `health` VALUES (23, '2022-06-02', 36.0, '健康', '阴性', 11);
INSERT INTO `health` VALUES (24, '2022-06-03', 36.0, '健康', '二十四小时内未做', 11);
INSERT INTO `health` VALUES (44, '2022-06-30', 36.0, '健康', '二十四小时内未做', 1);
INSERT INTO `health` VALUES (45, '2022-06-30', 36.0, '健康', '二十四小时内未做', 2);
INSERT INTO `health` VALUES (46, '2022-06-30', 36.0, '健康', '二十四小时内未做', 5);
INSERT INTO `health` VALUES (48, '2022-07-01', 36.0, '健康', '阴性', 11);
INSERT INTO `health` VALUES (49, '2022-07-01', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (50, '2022-07-02', 36.0, '健康', '阴性', 2);
INSERT INTO `health` VALUES (56, '2022-07-03', 36.0, '健康', '二十四小时内未做', 1);
INSERT INTO `health` VALUES (57, '2022-07-03', 36.0, '健康', '阴性', 53);
INSERT INTO `health` VALUES (58, '2022-07-03', 36.0, '健康', '二十四小时内未做', 5);
INSERT INTO `health` VALUES (59, '2022-07-03', 36.0, '健康', '二十四小时内未做', 14);
INSERT INTO `health` VALUES (60, '2022-07-03', 36.0, '健康', '二十四小时内未做', 11);
INSERT INTO `health` VALUES (61, '2022-07-04', 36.0, '健康', '阴性', 12);

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room`  (
  `r_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `r_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '房间号',
  `r_descr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`r_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of room
-- ----------------------------
INSERT INTO `room` VALUES (1, '101', '这是101号房间');
INSERT INTO `room` VALUES (2, '102', '这是102号房间');
INSERT INTO `room` VALUES (3, '201', '这是201号房间');
INSERT INTO `room` VALUES (4, '202', '这是202号房间');
INSERT INTO `room` VALUES (5, '301', '这是301号房间');
INSERT INTO `room` VALUES (6, '302', '这是302号房间');
INSERT INTO `room` VALUES (7, '401', '这是401号房间');
INSERT INTO `room` VALUES (8, '402', '这是402号房间');
INSERT INTO `room` VALUES (9, '501', '这是501号房间');
INSERT INTO `room` VALUES (10, '502', '这是502号房间');
INSERT INTO `room` VALUES (11, '601', '这是601号房间');
INSERT INTO `room` VALUES (12, '602', '这是602号房间');
INSERT INTO `room` VALUES (13, '701', '这是701号房间');
INSERT INTO `room` VALUES (14, '702', '这是702号房间');
INSERT INTO `room` VALUES (15, '801', '这是801号房间');
INSERT INTO `room` VALUES (16, '802', '这是802号房间');
INSERT INTO `room` VALUES (17, '901', '这是901号房间');
INSERT INTO `room` VALUES (18, '902', '这是902号房间');

-- ----------------------------
-- Table structure for thing
-- ----------------------------
DROP TABLE IF EXISTS `thing`;
CREATE TABLE `thing`  (
  `tid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tClass` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类',
  `tName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `num` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数量',
  `specification` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格',
  `place` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产地',
  PRIMARY KEY (`tid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of thing
-- ----------------------------
INSERT INTO `thing` VALUES (1, '防护物资', '口罩', '20箱', '100只*100袋*1箱', '呼和浩特市');
INSERT INTO `thing` VALUES (2, '防护物资', '手套', '10箱', '100只*100袋*1箱', '呼和浩特市');
INSERT INTO `thing` VALUES (3, '消毒用品', '84消毒液', '20箱', '40瓶*1箱', '呼和浩特市');
INSERT INTO `thing` VALUES (4, '诊断用品', '红外线体温仪', '2箱', '1个*1箱', '呼和浩特市');
INSERT INTO `thing` VALUES (5, '防护物资', '防护服', '5箱', '1箱*10袋*10件', '呼和浩特市');
INSERT INTO `thing` VALUES (6, '防护物资', '防护服', '4箱', '1箱*10袋*10件', '包头');
INSERT INTO `thing` VALUES (7, '消毒用品', '注射器', '20箱', '1箱*10袋*10支', '呼和浩特市');
INSERT INTO `thing` VALUES (8, '诊断用品', '注射器', '4箱', '1箱*10袋*10件', '包头');
INSERT INTO `thing` VALUES (9, '防护物资', '防护服', '', '', '');
INSERT INTO `thing` VALUES (10, '防护物资', '防护服', '40箱', '1箱*10袋*10支', '呼和浩特市');
INSERT INTO `thing` VALUES (11, '防护物资', '防护服', '20箱', '1箱*10袋*10件', '呼和浩特市');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` int(11) NOT NULL COMMENT '密码',
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
  `phone` int(11) NULL DEFAULT NULL COMMENT '电话',
  `usertype` int(11) NULL DEFAULT NULL COMMENT '权限,0管理员；1医生；2用户',
  `mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `b_id` int(11) NULL DEFAULT NULL COMMENT '楼号',
  `r_id` int(11) NULL DEFAULT NULL COMMENT '房间号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `b_id`(`b_id`) USING BTREE,
  INDEX `r_id`(`r_id`) USING BTREE,
  CONSTRAINT `user_ibfk_1` FOREIGN KEY (`b_id`) REFERENCES `building` (`b_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `user_ibfk_2` FOREIGN KEY (`r_id`) REFERENCES `room` (`r_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '001', 123, '张高级', '女', 0, 77576565, 3, '3151159602@qq.com', 1, 1);
INSERT INTO `user` VALUES (2, '002', 111, '张代理', '男', 0, 12345678, 0, '3151159602@qq.com', 6, 1);
INSERT INTO `user` VALUES (3, '003', 123, '撒躺躺', '男', 0, 214748364, 0, '3151159602@qq.com', 1, 3);
INSERT INTO `user` VALUES (4, '004', 123, '何药药', '男', 0, 2147483647, 0, '3151159602@qq.com', 1, 4);
INSERT INTO `user` VALUES (5, '005', 123, '白谱', '男', 0, 11345678, 1, '3151159602@qq.com', 1, 5);
INSERT INTO `user` VALUES (6, '006', 123, '欧茉莉', '女', 25, 2147483647, 1, '3151159602@qq.com', 1, 6);
INSERT INTO `user` VALUES (7, '007', 123, '张医生', '男', 30, 2147483647, 1, '3151159602@qq.com', 1, 7);
INSERT INTO `user` VALUES (8, '008', 123, '西土瓦', '男', 40, 1856718771, 1, '3151159602@qq.com', 1, 8);
INSERT INTO `user` VALUES (9, '009', 123, '甄白雪', '女', 19, 2147483647, 1, '3151159602@qq.com', 1, 9);
INSERT INTO `user` VALUES (10, '010', 123, '撒哒哒', '男', 30, 2147483647, 1, '3151159602@qq.com', 1, 18);
INSERT INTO `user` VALUES (11, '011', 123, '鬼学姐', '男', 0, 34534254, 2, '3151159602@qq.com', 2, 1);
INSERT INTO `user` VALUES (12, '012', 123, '潘刮痧', '男', 40, 2147483647, 2, '3151159602@qq.com', 2, 2);
INSERT INTO `user` VALUES (13, '013', 123, '欧空姐', '女', 0, 2147483647, 2, '3151159602@qq.com', 2, 3);
INSERT INTO `user` VALUES (14, '014', 123, '魏高管', '男', 31, 2147483647, 2, '3151159602@qq.com', 2, 4);
INSERT INTO `user` VALUES (15, '015', 123, '魏饭', '男', 30, 2147483647, 2, '3151159602@qq.com', 2, 5);
INSERT INTO `user` VALUES (16, '016', 123, '魏公主', '女', 20, 2147483647, 2, '3151159602@qq.com', 2, 6);
INSERT INTO `user` VALUES (17, '017', 123, '魏国王', '男', 43, 2147483647, 2, '3151159602@qq.com', 2, 6);
INSERT INTO `user` VALUES (18, '018', 123, '魏王后', '女', 43, 2147483647, 2, '3151159602@qq.com', 2, 6);
INSERT INTO `user` VALUES (19, '019', 123, '大主唱', '男', 30, 2147483647, 2, '3151159602@qq.com', 3, 1);
INSERT INTO `user` VALUES (20, '020', 123, '乔钻石', '男', 33, 2147483647, 2, '3151159602@qq.com', 3, 4);
INSERT INTO `user` VALUES (21, '021', 123, '大果王', '男', 0, 12345678, 2, '3151159602@qq.com', 3, 2);
INSERT INTO `user` VALUES (22, '022', 123, '何美男', '男', 19, 2147483647, 2, '3151159602@qq.com', 3, 3);
INSERT INTO `user` VALUES (23, '023', 123, '白空少', '男', 20, 1278678637, 2, '3151159602@qq.com', 3, 5);
INSERT INTO `user` VALUES (24, '024', 123, '甄千金', '女', 20, 2147483647, 2, '3151159602@qq.com', 3, 6);
INSERT INTO `user` VALUES (25, 'ddd', 123, '花花', '女', 0, 9876543, 0, '3151159602@qq.com', 6, 4);
INSERT INTO `user` VALUES (26, 'aa', 888, '滴滴滴', '男', 34, 2147483647, 1, NULL, 8, 6);
INSERT INTO `user` VALUES (44, 'sy153', 8888, '莉莉', NULL, 0, 0, 1, NULL, NULL, NULL);
INSERT INTO `user` VALUES (48, 'manag', 123, '姐姐', NULL, 0, 0, 2, NULL, NULL, NULL);
INSERT INTO `user` VALUES (51, 'pppp', 123, '芳芳', NULL, 0, 0, 0, NULL, NULL, NULL);
INSERT INTO `user` VALUES (53, '954', 123, '花花', '女', 0, 9876543, 2, '3151159602@qq.com', 7, 11);
INSERT INTO `user` VALUES (57, '432', 123, NULL, NULL, 0, 0, 0, NULL, NULL, NULL);
INSERT INTO `user` VALUES (58, '677', 123, NULL, NULL, 0, 0, 0, NULL, NULL, NULL);
INSERT INTO `user` VALUES (59, 'zhang', 123, NULL, NULL, 0, 0, 0, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for vaccine
-- ----------------------------
DROP TABLE IF EXISTS `vaccine`;
CREATE TABLE `vaccine`  (
  `vId` int(11) NOT NULL AUTO_INCREMENT,
  `vTimeO` date NULL DEFAULT NULL COMMENT '接种日期1',
  `placeO` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接种地点1',
  `vTimeT` date NULL DEFAULT NULL COMMENT '接种日期2\r',
  `placeT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接种地点2',
  `vTimeTr` date NULL DEFAULT NULL COMMENT '接种日期3',
  `placeTr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接种地点3',
  `uid` int(11) NULL DEFAULT NULL COMMENT '用户id\r',
  PRIMARY KEY (`vId`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE,
  CONSTRAINT `vaccine_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of vaccine
-- ----------------------------
INSERT INTO `vaccine` VALUES (1, '2022-05-01', '包头', '2022-06-01', '包头', '2022-07-20', '包头', 1);
INSERT INTO `vaccine` VALUES (2, '2022-03-01', '包头', '2022-04-01', '包头', '2022-07-03', '呼和浩特市', 2);
INSERT INTO `vaccine` VALUES (4, '2022-03-02', '包头', '2022-04-03', '包头', '2022-05-06', '包头', 3);
INSERT INTO `vaccine` VALUES (7, '2022-07-02', '包头', '2022-07-16', '包头', '2022-07-23', '包头', 51);
INSERT INTO `vaccine` VALUES (8, '2022-07-01', '包头', '2022-07-01', '包头', '2022-07-02', '呼和浩特市', 48);
INSERT INTO `vaccine` VALUES (9, '2022-07-02', '包头', '2022-08-02', '呼和浩特市', '2022-07-02', '呼和浩特市', 44);
INSERT INTO `vaccine` VALUES (10, '2022-07-02', '包头', '2022-08-04', '呼和浩特市', '2022-07-02', '', 53);
INSERT INTO `vaccine` VALUES (11, '2022-07-01', '包头', '2022-07-01', NULL, '2022-07-01', NULL, 4);
INSERT INTO `vaccine` VALUES (12, '2022-07-01', '', '2022-07-01', NULL, '2022-07-01', NULL, 5);
INSERT INTO `vaccine` VALUES (13, '2022-07-29', '包头', '2022-07-29', NULL, '2022-07-29', NULL, 6);

SET FOREIGN_KEY_CHECKS = 1;