Java+Springboot+Vue+elememt社区疫情防控系统设计和实现

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80023 Source Host : localhost:3306 Source Schema : jingantong Target Server Type : MySQL Target Server Version : 80023 File Encoding : 65001 Date: 11/02/2022 14:04:10 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for jat_access -- ---------------------------- DROP TABLE IF EXISTS `jat_access`; CREATE TABLE `jat_access` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `areaId` int(0) NOT NULL, `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `createTime` datetime(0) NOT NULL, `healthy` int(0) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, INDEX `A_userId`(`name`) USING BTREE, INDEX `A_areaId`(`areaId`) USING BTREE, CONSTRAINT `A_areaId` FOREIGN KEY (`areaId`) REFERENCES `jat_area` (`areaId`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for jat_area -- ---------------------------- DROP TABLE IF EXISTS `jat_area`; CREATE TABLE `jat_area` ( `areaId` int(0) NOT NULL AUTO_INCREMENT, `areaName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`areaId`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for jat_message -- ---------------------------- DROP TABLE IF EXISTS `jat_message`; CREATE TABLE `jat_message` ( `id` int(0) NOT NULL AUTO_INCREMENT, `title` varchar(110) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `infoSource` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `mtime` datetime(0) NULL DEFAULT NULL, `summary` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for jat_pass -- ---------------------------- DROP TABLE IF EXISTS `jat_pass`; CREATE TABLE `jat_pass` ( `id` int(0) NOT NULL AUTO_INCREMENT, `uid` int(0) NULL DEFAULT NULL, `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `idnum` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `vaccine` int(0) NULL DEFAULT NULL, `temperature` double(10, 2) NULL DEFAULT NULL, `contact` int(0) NULL DEFAULT NULL, `status` int(0) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, INDEX `fk_uid`(`uid`) USING BTREE, CONSTRAINT `fk_uid` FOREIGN KEY (`uid`) REFERENCES `jat_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for jat_patient -- ---------------------------- DROP TABLE IF EXISTS `jat_patient`; CREATE TABLE `jat_patient` ( `id` int(0) NOT NULL AUTO_INCREMENT, `Platitude` double(30, 7) NULL DEFAULT NULL, `Plongitude` double(30, 7) NULL DEFAULT NULL, `Paddress` varchar(130) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `Ptime` datetime(0) NOT NULL, `Pstatus` int(0) NULL DEFAULT NULL COMMENT '0 确诊 1 无症状感染 2 疑似 3 密接', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for jat_report -- ---------------------------- DROP TABLE IF EXISTS `jat_report`; CREATE TABLE `jat_report` ( `id` int(0) NOT NULL AUTO_INCREMENT, `content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `repTime` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for jat_user -- ---------------------------- DROP TABLE IF EXISTS `jat_user`; CREATE TABLE `jat_user` ( `id` int(0) NOT NULL AUTO_INCREMENT, `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `passwd` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `idNum` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `accountNum` int(0) NULL DEFAULT NULL, `address` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` int(0) NULL DEFAULT NULL, `contact` int(0) NULL DEFAULT NULL COMMENT '1 是 2 否', `temperature` double(10, 2) NULL DEFAULT NULL, `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `areaId` int(0) NULL DEFAULT NULL, `identity` int(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 0, `qrvaccine` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `areaId`(`areaId`) USING BTREE, INDEX `phone`(`phone`) USING BTREE, CONSTRAINT `areaId` FOREIGN KEY (`areaId`) REFERENCES `jat_area` (`areaId`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; SET FOREIGN_KEY_CHECKS = 1;