/*
 Navicat Premium Data Transfer

 Source Server         : 本地Mysql
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : mmh

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

 Date: 15/05/2023 19:54:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` bigint(20) NOT NULL,
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物资名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '物资描述',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (1, '医用口罩', '一盒50支', '2023-04-07 20:24:36');
INSERT INTO `goods` VALUES (1644332484615016450, '抗原试纸', '一盒20支', '2023-04-07 21:33:09');
INSERT INTO `goods` VALUES (1644585806596997121, '连花清瘟胶囊', '清瘟解毒、宣肺泄热', '2023-04-08 14:19:45');

-- ----------------------------
-- Table structure for inform
-- ----------------------------
DROP TABLE IF EXISTS `inform`;
CREATE TABLE `inform`  (
  `id` bigint(20) NOT NULL,
  `describe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '公告内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of inform
-- ----------------------------
INSERT INTO `inform` VALUES (1, '      亲爱的居民朋友们，请按时填写核酸检测信息！');

-- ----------------------------
-- Table structure for nucleic
-- ----------------------------
DROP TABLE IF EXISTS `nucleic`;
CREATE TABLE `nucleic`  (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `gender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
  `age` int(3) NULL DEFAULT NULL COMMENT '年龄',
  `id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `question1` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题1',
  `question2` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题2',
  `question3` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题3',
  `question4` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题4',
  `question5` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题5',
  `code_color` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '健康码',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  CONSTRAINT `nucleic_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nucleic
-- ----------------------------
INSERT INTO `nucleic` VALUES (1644510484102991874, 2, '张三--1', '男', 22, 'zhangsan', '11111111111111111111', '否', '否', '否', '发热，低于37.3℃', '阴性', '黄码', '2023-04-08 09:20:27');
INSERT INTO `nucleic` VALUES (1644510537517453314, 2, '张三--1', '男', 22, 'zhangsan', '2222222222222', '是', '是', '是', '发热，高于37.3℃，并伴随其他症状', '阳性', '红码', '2022-08-08 09:20:40');
INSERT INTO `nucleic` VALUES (1644548680648024065, 2, '张三--1', '男', 22, 'zhangsan', '111111111111111111111', '否', '否', '否', '无不良症状', '阴性', '黄码', '2023-04-08 11:52:14');
INSERT INTO `nucleic` VALUES (1656958596205637633, 1656958216524656642, '李四', '男', NULL, '513701200102222222', '11111111111111111111111', '否', '否', '否', '无不良症状', '阴性', '绿码', '2023-05-12 17:44:48');
INSERT INTO `nucleic` VALUES (1656959238009647105, 1656958216524656641, '张三', '男', 23, '513701200101111111', '11111111111111', '否', '否', '否', '发热，低于37.3℃', '阴性', '黄码', '2023-05-12 17:47:21');

-- ----------------------------
-- Table structure for reserve
-- ----------------------------
DROP TABLE IF EXISTS `reserve`;
CREATE TABLE `reserve`  (
  `id` bigint(20) NOT NULL,
  `goods_id` bigint(20) NULL DEFAULT NULL COMMENT '物资id',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `user_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请人',
  `goods_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物资名称',
  `number` int(10) NULL DEFAULT NULL COMMENT '申请数量',
  `status` int(1) NULL DEFAULT -1 COMMENT '预约状态',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  INDEX `goods_id`(`goods_id`) USING BTREE,
  CONSTRAINT `reserve_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserve_ibfk_2` FOREIGN KEY (`goods_id`) REFERENCES `goods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of reserve
-- ----------------------------
INSERT INTO `reserve` VALUES (1644318447126773761, 1, 2, '张三--1', '口罩--1', 18, 1, '2023-04-07 20:37:22');
INSERT INTO `reserve` VALUES (1644509643270868994, 1, 2, '张三--1', '口罩--1', 1, 1, '2023-04-08 09:17:07');
INSERT INTO `reserve` VALUES (1644548626956738561, 1, 2, '张三--1', '口罩--1', 1, 1, '2023-04-08 11:52:01');
INSERT INTO `reserve` VALUES (1644548635244683266, 1644332484615016450, 2, '张三--1', '抗原试纸', 3, 0, '2023-04-08 11:52:03');
INSERT INTO `reserve` VALUES (1656958529675587586, 1, 1656958216524656642, '李四', '口罩--1', 2, 0, '2023-05-12 17:44:32');
INSERT INTO `reserve` VALUES (1656961563289841666, 1, 1656958216524656642, '李四', '口罩--1', 2, -1, '2023-05-12 17:56:36');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint(20) NOT NULL,
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `age` int(3) NULL DEFAULT NULL COMMENT '年龄',
  `gender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '男' COMMENT '性别',
  `email` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预约地址',
  `id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `identity` int(2) NULL DEFAULT 0 COMMENT '用户身份; 1:管理员 0:普通居民',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'http://oss.one-hand.cn/one-hand.jpg' COMMENT '头像地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '管理员--555', 110, '男', '1932707777@qq.cmo', '四川省德阳市罗江区大学路59号', 'admin', '8de9846c12aa71fa796019e264018f45', 1, '18282753333', 'http://oss.one-hand.cn/one-hand.jpg');
INSERT INTO `user` VALUES (2, '张三--44', 22, '女', '163163163@163.com', '成都市33333333', 'zhangsan', '8de9846c12aa71fa796019e264018f45', 1, '18282777777', 'http://oss.one-hand.cn/mmh/911a6dd2-9f2d-481d-9149-289155437cc7.png');
INSERT INTO `user` VALUES (1656958216524656641, '张三', 23, '男', NULL, '成都市金牛区', '513701200101111111', '237519ae07392a88f85164c6eee2d7e8', 0, NULL, 'http://oss.one-hand.cn/mmh/757bac8e-f45e-45f0-9e71-382ec3ca5853.jpg');
INSERT INTO `user` VALUES (1656958216524656642, '李四', NULL, '男', NULL, NULL, '513701200102222222', '89f6a2f9975e512b8d38b1983a235de6', 0, '111111111', 'http://oss.one-hand.cn/mmh/bd543791-9b39-412f-9433-6f1056d28470.jpg');
INSERT INTO `user` VALUES (1656958216524656643, '王五', NULL, '男', NULL, NULL, '513701200103333333', '830fded1c63715fc49b01299dd3506fe', 0, NULL, 'http://oss.one-hand.cn/one-hand.jpg');

-- ----------------------------
-- Table structure for vaccine
-- ----------------------------
DROP TABLE IF EXISTS `vaccine`;
CREATE TABLE `vaccine`  (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `gender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
  `age` int(3) NULL DEFAULT NULL COMMENT '年龄',
  `id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接种类型',
  `strong_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否接种加强针',
  `day1` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第一针',
  `day2` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第二针',
  `day3` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三针',
  `day4` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加强针',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  CONSTRAINT `vaccine_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of vaccine
-- ----------------------------
INSERT INTO `vaccine` VALUES (1644511154109501442, 2, '张三--1', '男', 22, 'zhangsan', '111111111111111', '三针剂', '否', '2023-04-11', '2023-04-20', '2023-04-28', '2023-04-20', '2023-04-08 09:23:07');
INSERT INTO `vaccine` VALUES (1656958743195021313, 1656958216524656642, '李四', '男', NULL, '513701200102222222', '111111111111111111', '三针剂', '是', '2021-05-12', '2021-05-12', '2021-05-20', '2023-05-05', '2023-05-12 17:45:23');
INSERT INTO `vaccine` VALUES (1656959155633516546, 1656958216524656641, '张三', '男', 23, '513701200101111111', '111111111111', '三针剂', '否', '2023-05-18', '2023-05-26', '2023-05-27', NULL, '2023-05-12 17:47:02');

SET FOREIGN_KEY_CHECKS = 1;