DB_51Aspx/vaccination.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : vaccination

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

 Date: 26/07/2022 15:57:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for case_history
-- ----------------------------
DROP TABLE IF EXISTS `case_history`;
CREATE TABLE `case_history`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '病名',
  `hospital` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院',
  `happen_time` datetime(0) NULL DEFAULT NULL COMMENT '发生时间',
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of case_history
-- ----------------------------
INSERT INTO `case_history` VALUES (8, '感冒', '南京第一人民医院', '2022-07-26 00:00:00', '2022-07-26 11:04:51', '2022-07-26 11:04:51', 20);
INSERT INTO `case_history` VALUES (11, '发烧11', '南京第一人民医院', '2022-07-26 00:00:00', '2022-07-26 15:50:33', '2022-07-26 15:50:48', 19);
INSERT INTO `case_history` VALUES (12, '感冒', '南京第一人民医院', '2022-07-26 00:00:00', '2022-07-26 15:53:15', '2022-07-26 15:53:15', 19);

-- ----------------------------
-- Table structure for epidemic_prevention_knowledge
-- ----------------------------
DROP TABLE IF EXISTS `epidemic_prevention_knowledge`;
CREATE TABLE `epidemic_prevention_knowledge`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容',
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  `send_user_id` bigint(20) NULL DEFAULT NULL COMMENT '发布人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of epidemic_prevention_knowledge
-- ----------------------------
INSERT INTO `epidemic_prevention_knowledge` VALUES (8, '疫苗', '打疫苗', '2022-07-26 11:07:55', '2022-07-26 11:07:55', 18);
INSERT INTO `epidemic_prevention_knowledge` VALUES (10, '防疫知识', '打疫苗了111', '2022-07-26 15:51:54', '2022-07-26 15:52:00', 18);