JAVA基于SpringBoot的疫情防控核酸检查管理系统【数据库设计、论文、源码、开题报告】

本文链接：https://blog.csdn.net/laowang8/article/details/128087206
主要使用技术

SpringBoot+Jpa+bootstrap+jquery+CSS+JS+Mysql
数据库脚本

/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 5.5.40 : Database - db_yq
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_yq` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `db_yq`;

/*Table structure for table `tb_community` */

DROP TABLE IF EXISTS `tb_community`;

CREATE TABLE `tb_community` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `area` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_community` */

insert  into `tb_community`(`id`,`create_time`,`update_time`,`area`,`city`,`name`,`province`,`street`) values 
(1,'2022-02-26 16:32:48','2022-02-26 16:32:48','东城区','北京市市辖区','秀沿路秀怡苑','北京市','东大门20号'),
(2,'2022-02-26 16:35:14','2022-02-26 16:35:14','朝阳区','北京市市辖区','故宫路朝阳小区','北京市','东大门20号'),
(3,'2022-02-26 16:37:11','2022-02-26 16:37:11','河北区','天津市市辖区','河北路青青小区','天津市','东大门20号'),
(5,'2022-03-06 14:49:51','2022-03-06 14:49:51','川汇区','北京市','万达熙龙湾','河南省','东大门20号');

/*Table structure for table `tb_database_bak` */

DROP TABLE IF EXISTS `tb_database_bak`;

CREATE TABLE `tb_database_bak` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `filename` varchar(128) NOT NULL,
  `filepath` varchar(128) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_database_bak` */

/*Table structure for table `tb_menu` */

DROP TABLE IF EXISTS `tb_menu`;

CREATE TABLE `tb_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `name` varchar(18) NOT NULL,
  `url` varchar(128) DEFAULT NULL,
  `icon` varchar(128) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `is_bitton` bit(1) NOT NULL,
  `is_show` bit(1) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKsbtnjocfrq29e8taxdwo21gic` (`parent_id`) USING BTREE,
  CONSTRAINT `FKsbtnjocfrq29e8taxdwo21gic` FOREIGN KEY (`parent_id`) REFERENCES `tb_menu` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_menu` */

insert  into `tb_menu`(`id`,`create_time`,`update_time`,`name`,`url`,`icon`,`sort`,`parent_id`,`is_bitton`,`is_show`) values 
(2,'2020-03-14 14:26:03','2020-03-14 18:24:53','系统管理','','mdi-settings',0,NULL,'\0',''),
(3,'2020-03-14 16:58:55','2022-02-22 15:04:24','菜单管理','/admin/menu/list','mdi-view-list',1,2,'\0',''),
(5,'2020-03-14 17:04:44','2020-03-14 18:27:53','新增','/admin/menu/add','mdi-plus',2,3,'\0',''),
(7,'2020-03-14 17:07:43','2020-03-15 12:11:25','角色管理','/admin/role/list','mdi-account-settings-variant',5,2,'\0',''),
(8,'2020-03-14 18:28:48','2020-03-21 22:04:45','编辑','edit(\'/admin/menu/edit\')','mdi-grease-pencil',3,3,'',''),
(9,'2020-03-14 18:30:00','2020-03-21 22:08:20','删除','del(\'/admin/menu/delete\')','mdi-close',4,3,'',''),
(10,'2020-03-15 12:12:00','2020-03-15 12:12:00','添加','/admin/role/add','mdi-account-plus',6,7,'\0',''),
(11,'2020-03-15 12:12:36','2020-03-21 22:10:45','编辑','edit(\'/admin/role/edit\')','mdi-account-edit',7,7,'',''),
(12,'2020-03-15 12:13:19','2020-03-21 22:15:27','删除','del(\'/admin/role/delete\')','mdi-account-remove',8,7,'',''),
(13,'2020-03-15 12:14:52','2020-03-15 12:17:00','用户管理','/admin/user/list','mdi-account-multiple',9,2,'\0',''),
(14,'2020-03-15 12:15:22','2020-03-15 12:17:27','添加','/admin/user/add','mdi-account-plus',10,13,'\0',''),
(15,'2020-03-16 17:18:14','2020-03-21 22:11:19','编辑','edit(\'/admin/user/edit\')','mdi-account-edit',11,13,'',''),
(16,'2020-03-16 17:19:01','2020-03-21 22:15:36','删除','del(\'/admin/user/delete\')','mdi-account-remove',12,13,'',''),
(19,'2020-03-22 11:24:36','2020-03-22 11:26:00','上传图片','/upload/upload_photo','mdi-arrow-up-bold-circle',0,13,'\0','\0'),
(20,'2020-03-22 14:09:35','2020-03-22 14:09:47','日志管理','/system/operator_log_list','mdi-tag-multiple',13,2,'\0',''),
(21,'2020-03-22 14:11:39','2020-03-22 14:11:39','删除','del(\'/system/delete_operator_log\')','mdi-tag-remove',14,20,'',''),
(22,'2020-03-22 14:12:57','2020-03-22 14:46:55','清空日志','delAll(\'/system/delete_all_operator_log\')','mdi-delete-circle',15,20,'',''),
(23,'2020-03-22 14:46:40','2020-03-22 14:47:09','数据备份','/admin/database_bak/list','mdi-database',16,2,'\0',''),
(24,'2020-03-22 14:48:07','2020-03-22 15:13:41','备份','add(\'/admin/database_bak/add\')','mdi-database-plus',17,23,'',''),
(25,'2020-03-22 14:49:03','2020-03-22 14:49:03','删除','del(\'/admin/database_bak/delete\')','mdi-database-minus',18,23,'',''),
(26,'2020-03-22 19:36:20','2020-03-22 19:36:20','还原','restore(\'/admin/database_bak/restore\')','mdi-database-minus',19,23,'',''),
(29,'2022-02-23 09:18:21','2022-02-23 09:18:21','人员管理','','mdi-human-male-female',20,NULL,'\0',''),
(30,'2022-02-23 09:39:37','2022-02-23 09:59:14','地址管理','','mdi-file-outline',21,NULL,'\0',''),
(31,'2022-02-23 09:52:40','2022-02-23 09:59:26','地址列表','/admin/community/list','mdi-vector-difference',22,30,'\0',''),
(32,'2022-02-23 09:53:39','2022-02-23 09:53:39','添加','/admin/community/add','mdi-tag',23,31,'\0',''),
(33,'2022-02-23 09:54:39','2022-02-23 09:54:39','编辑','edit(\'/admin/community/edit\')','mdi-wrench',24,31,'',''),
(34,'2022-02-23 09:55:12','2022-02-23 09:55:12','删除','del(\'/admin/community/delete\')','mdi-delete-sweep',25,31,'',''),
(35,'2022-02-23 11:07:19','2022-02-25 17:59:28','流动人员列表','/admin/migrant/list','mdi-account-settings',26,29,'\0',''),
(36,'2022-02-23 11:07:45','2022-02-23 11:07:57','添加','/admin/migrant/add','mdi-folder-account',27,35,'\0',''),
(38,'2022-02-23 11:10:14','2022-02-23 11:10:14','删除','del(\'/admin/migrant/delete\')','mdi-delete-forever',29,35,'',''),
(39,'2022-02-23 15:10:07','2022-02-23 15:10:07','审核','/admin/migrant/approval','mdi-close-octagon-outline',30,35,'\0','\0'),
(40,'2022-02-23 15:43:06','2022-02-23 15:43:06','导入','poiImport(\'/admin/migrant/import\')','mdi-trending-down',31,35,'',''),
(41,'2022-02-23 15:43:38','2022-02-23 15:43:48','导出','poiExport(\'/admin/migrant/export\')','mdi-arrow-down-bold',32,35,'',''),
(42,'2022-02-23 15:49:27','2022-02-25 17:59:39','常驻人员列表','/admin/resident/list','mdi-account-multiple',33,29,'\0',''),
(43,'2022-02-23 16:15:50','2022-02-23 16:15:50','添加','/admin/resident/add','mdi-account-multiple-plus',34,42,'\0',''),
(45,'2022-02-23 16:18:37','2022-02-23 16:18:37','删除','del(\'/admin/resident/delete\')','mdi-account-multiple-minus',36,42,'',''),
(46,'2022-02-23 16:19:33','2022-02-23 16:19:33','导入','poiImport(\'/admin/resident/import\')','mdi-arrow-bottom-right',37,42,'',''),
(47,'2022-02-23 16:20:09','2022-02-23 16:20:21','导出','poiExport(\'/admin/resident/export\')','mdi-arrow-right-bold',38,42,'',''),
(48,'2022-02-24 14:35:18','2022-02-24 14:36:29','核酸检测记录','','mdi-clipboard-text',39,NULL,'\0',''),
(49,'2022-02-24 14:36:19','2022-02-24 14:36:19','核酸检测记录列表','/admin/testRecord/list','mdi-calendar-text',40,48,'\0',''),
(50,'2022-02-24 14:38:28','2022-02-24 14:38:38','添加','/admin/testRecord/add','mdi-plus',41,49,'\0',''),
(51,'2022-02-24 14:40:29','2022-02-26 11:25:38','导出未检出核酸人员信息','poiExport(\'/admin/testRecord/export\')','mdi-arrow-right-bold',42,49,'\0','\0'),
(52,'2022-02-24 17:33:30','2022-02-24 17:33:30','查看详情','/admin/testRecord/show','mdi-alpha',43,49,'\0','\0'),
(53,'2022-02-25 10:56:30','2022-02-26 15:28:03','核酸检测记录统计','/admin/statistics/statistics','mdi-clipboard-text',44,48,'\0',''),
(54,'2022-02-26 09:12:34','2022-02-26 09:12:34','删除','del(\'/admin/testRecord/delete\')','mdi-close',45,49,'',''),
(55,'2022-02-26 10:41:37','2022-02-26 10:41:37','审核','/admin/testRecord/approval','mdi-alert-decagram',46,49,'\0','\0');

/*Table structure for table `tb_migrant` */

DROP TABLE IF EXISTS `tb_migrant`;

CREATE TABLE `tb_migrant` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `card_img` longtext,
  `card_number` varchar(32) DEFAULT NULL,
  `census_address` varchar(255) DEFAULT NULL,
  `is_del` int(11) NOT NULL,
  `name` varchar(18) DEFAULT NULL,
  `reasons` varchar(255) DEFAULT NULL,
  `sex` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `community_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKrxyra27hlu6hedf3kjjqrecc` (`community_id`) USING BTREE,
  CONSTRAINT `FKrxyra27hlu6hedf3kjjqrecc` FOREIGN KEY (`community_id`) REFERENCES `tb_community` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_migrant` */

insert  into `tb_migrant`(`id`,`create_time`,`update_time`,`address`,`card_img`,`card_number`,`census_address`,`is_del`,`name`,`reasons`,`sex`,`status`,`community_id`) values 
(1,'2022-02-26 16:49:18','2022-02-26 17:16:52','青青小区东区13栋1309室','[\"20220226/1614329308822-d78d43eb-1d85-4b83-b4e8-fb409ae3a76b.jpg\",\"20220226/1614329308827-b53aa72f-a973-48e9-9520-e7555a0d8e1e.jpg\"]','42022220001112154X','湖北武汉',1,'韦小宝',NULL,1,1,3),
(2,'2022-02-26 16:50:28','2022-02-26 16:50:28','朝阳小区南区18栋一单元1305号','[\"20220226/1614329369829-67a622f6-2f69-476c-a9fd-3c71664d026b.jpg\",\"20220226/1614329369829-0b641170-03fb-4cd3-a303-e522b4bb40b0.jpg\"]','420222200011121542','河南郑州',1,'皮皮',NULL,1,2,2),
(3,'2022-02-26 16:51:32','2022-02-26 17:26:07','秀三村一组135号','[\"20220226/1614329491740-2f2d4796-32c0-4ad7-bd50-d9e3311afbc3.jpg\",\"20220226/1614329491739-794d72f7-c8cf-4f1e-99f1-2631e09e9de2.jpg\"]','420222200011121543','湖北鄂州',0,'张华','请填写合法内容',1,1,1),
(4,'2022-02-26 16:52:13','2022-02-26 17:26:07','秀三村二组1305号','[\"20220226/1614329498928-e4588aed-b83c-4255-8ff6-735a4c31d792.jpg\",\"20220226/1614329498924-f804ae9d-bb25-45ff-9e63-0de54e52a0a8.jpg\"]','420222200011121547','北京朝阳',0,'黎明',NULL,0,1,1),
(5,'2022-02-26 17:26:07','2022-03-06 14:58:19','秀三村一组135号',NULL,'420222200011121543','湖北鄂州',0,'张华',NULL,1,1,1),
(6,'2022-02-26 17:26:07','2022-03-06 14:58:19','秀三村二组1305号',NULL,'420222200011121547','北京朝阳',0,'黎明',NULL,0,1,1),
(7,'2022-03-06 14:50:55','2022-03-06 14:51:25','上海市浦东区康桥集团',NULL,'412723199602259020','河南',0,'王金库',NULL,1,1,1),
(8,'2022-03-06 14:51:25','2022-03-06 14:53:07','北京东路',NULL,'412723199602259020','河南',0,'王金库',NULL,1,1,1),
(10,'2022-03-06 14:53:33','2022-03-06 14:58:19','北京东路',NULL,'412723199602259030','河南',0,'张大爷',NULL,1,1,1),
(11,'2022-03-06 14:56:09','2022-03-06 14:58:19','北京东路',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),
(12,'2022-03-06 14:56:09','2022-03-06 14:58:19','秀三村一组135号',NULL,'420222200011121234','湖北鄂州',0,'测试',NULL,1,1,1),
(13,'2022-03-06 14:56:09','2022-03-06 14:58:19','秀三村二组1305号',NULL,'420222200011125678','北京朝阳',0,'测试',NULL,0,1,1),
(14,'2022-03-06 14:58:19','2022-03-06 15:06:08','北京东路',NULL,'412723199602259030','河南',0,'张大爷',NULL,1,1,1),
(15,'2022-03-06 14:58:19','2022-03-06 15:06:08','北京东路',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),
(16,'2022-03-06 14:58:19','2022-03-06 15:06:08','秀三村一组135号',NULL,'420222200011121543','湖北鄂州',0,'张华',NULL,1,1,1),
(17,'2022-03-06 14:58:19','2022-03-06 15:06:08','秀三村一组135号',NULL,'420222200011121234','湖北鄂州',0,'测试',NULL,1,1,1),
(18,'2022-03-06 14:58:19','2022-03-06 15:06:08','秀三村二组1305号',NULL,'420222200011121547','北京朝阳',0,'黎明',NULL,0,1,1),
(19,'2022-03-06 14:58:19','2022-03-06 15:06:08','秀三村二组1305号',NULL,'420222200011125678','北京朝阳',0,'测试',NULL,0,1,1),
(21,'2022-03-06 15:06:08','2022-03-06 15:07:13','北京东路',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),
(23,'2022-03-06 15:06:08','2022-03-06 15:07:13','秀三村一组135号',NULL,'420222200011121234','湖北鄂州',0,'测试',NULL,1,1,1),
(24,'2022-03-06 15:06:08','2022-03-06 15:40:22','秀三村二组1305号',NULL,'420222200011121547','北京朝阳',0,'黎明',NULL,0,1,1),
(25,'2022-03-06 15:06:08','2022-03-06 15:07:13','秀三村二组1305号',NULL,'420222200011125678','北京朝阳',0,'测试',NULL,0,1,1),
(26,'2022-03-06 15:07:13','2022-03-06 15:13:32','秀三村三组135号',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),
(27,'2022-03-06 15:07:13','2022-03-06 15:13:32','秀三村一组135号',NULL,'420222200011121234','湖北鄂州',0,'测试',NULL,1,1,1),
(31,'2022-03-06 15:13:28','2022-03-06 15:39:55','秀三村三组135号',NULL,'412723199602258000','河南',0,'测试',NULL,1,1,1),
(32,'2022-03-06 15:13:32','2022-03-06 15:40:02','秀三村三组135号',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),
(33,'2022-03-06 15:13:32','2022-03-06 15:40:02','秀三村一组135号',NULL,'420222200011121234','湖北鄂州',0,'测试',NULL,1,1,1),
(34,'2022-03-06 15:13:32','2022-03-06 15:40:02','秀三村二组135号',NULL,'420222200011125678','北京朝阳',0,'测试',NULL,1,1,1),
(35,'2022-03-06 15:39:55','2022-03-06 15:42:58','秀三村二组135号',NULL,'420222200011125000','北京朝阳',0,'测试',NULL,1,1,1),
(36,'2022-03-06 15:39:55','2022-03-06 15:39:55','秀三村一组135号',NULL,'420222200011121000','湖北鄂州',1,'测试',NULL,1,1,1),
(37,'2022-03-06 15:39:55','2022-03-06 15:40:22','秀三村三组135号',NULL,'412723199602258000','河南',0,'测试',NULL,1,1,1),
(38,'2022-03-06 15:40:02','2022-03-06 15:40:22','秀三村三组135号',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),
(39,'2022-03-06 15:40:02','2022-03-06 15:40:22','秀三村一组135号',NULL,'420222200011121234','湖北鄂州',0,'测试',NULL,1,1,1),
(40,'2022-03-06 15:40:02','2022-03-06 15:40:22','秀三村二组135号',NULL,'420222200011125678','北京朝阳',0,'测试',NULL,1,1,1),
(41,'2022-03-06 15:40:22','2022-03-06 15:40:22','秀三村三组135号',NULL,'412723199602258564','河南',1,'测试',NULL,1,1,1),
(42,'2022-03-06 15:40:22','2022-03-06 15:40:22','秀三村三组135号',NULL,'412723199602258000','河南',1,'测试',NULL,1,1,1),
(43,'2022-03-06 15:40:22','2022-03-06 15:40:22','秀三村一组135号',NULL,'420222200011121234','湖北鄂州',1,'测试',NULL,1,1,1),
(46,'2022-03-06 15:56:45','2022-03-06 16:02:10','北京东路','[\"20220306/1615017392608-74e6fdd3-7bf8-4eff-92cb-ef1feb0f58c7.jpg\",\"20220306/1615017392612-b1304bb8-f158-4bbf-a9e0-ed4182be15c0.jpg\"]','412723199602259080','河南',1,'张大爷','不通过',1,0,1),
(47,'2022-03-06 16:05:44','2022-03-06 16:06:34','北京东路','[\"20220306/1615017938317-6e692fd8-c24e-48a7-9986-ad052c15c61f.jpg\",\"20220306/1615017938317-5a8035d3-d71c-4789-86da-5f13ce93124f.jpg\"]','412723199602259020','河南',1,'张大爷',NULL,0,1,5);

/*Table structure for table `tb_operater_log` */

DROP TABLE IF EXISTS `tb_operater_log`;

CREATE TABLE `tb_operater_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `content` varchar(1024) NOT NULL,
  `operator` varchar(18) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=636 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_operater_log` */

insert  into `tb_operater_log`(`id`,`create_time`,`update_time`,`content`,`operator`) values 
(609,'2021-08-21 11:29:00','2021-08-21 11:29:00','用户【admin】于【2021-08-21 11:29:00】登录系统！','admin'),
(610,'2021-08-21 11:30:15','2021-08-21 11:30:15','用户【Change】于【2021-08-21 11:30:15】登录系统！','Change'),
(611,'2021-08-21 11:37:19','2021-08-21 11:37:19','用户【admin】于【2021-08-21 11:37:19】登录系统！','admin'),
(612,'2021-08-21 11:40:56','2021-08-21 11:40:56','用户【admin】于【2021-08-21 11:40:56】登录系统！','admin'),
(613,'2021-08-21 11:43:57','2021-08-21 11:43:57','用户【admin】于【2021-08-21 11:43:57】登录系统！','admin'),
(614,'2021-08-21 11:47:01','2021-08-21 11:47:01','用户【admin】于【2021-08-21 11:47:01】登录系统！','admin'),
(615,'2021-08-21 16:32:21','2021-08-21 16:32:21','用户【admin】于【2021-08-21 16:32:21】登录系统！','admin'),
(616,'2021-08-21 16:42:50','2021-08-21 16:42:50','用户【admin】于【2021-08-21 16:42:50】登录系统！','admin'),
(617,'2021-08-21 16:48:51','2021-08-21 16:48:51','用户【admin】于【2021-08-21 16:48:51】登录系统！','admin'),
(618,'2021-08-21 17:05:48','2021-08-21 17:05:48','用户【admin】于【2021-08-21 17:05:48】登录系统！','admin'),
(619,'2021-08-21 17:06:28','2021-08-21 17:06:28','用户【Change】于【2021-08-21 17:06:28】登录系统！','Change'),
(620,'2021-08-21 17:22:07','2021-08-21 17:22:07','用户【jack】于【2021-08-21 17:22:07】登录系统！','jack'),
(621,'2021-08-21 17:24:23','2021-08-21 17:24:23','用户【admin】于【2021-08-21 17:24:23】登录系统！','admin'),
(622,'2021-08-21 17:26:18','2021-08-21 17:26:18','用户【jack】于【2021-08-21 17:26:18】登录系统！','jack'),
(623,'2021-08-23 12:42:34','2021-08-23 12:42:34','用户【admin】于【2021-08-23 12:42:34】登录系统！','admin'),
(624,'2021-09-18 12:20:26','2021-09-18 12:20:26','用户【admin】于【2021-09-18 12:20:26】登录系统！','admin'),
(625,'2021-09-18 12:22:31','2021-09-18 12:22:31','用户【admin】于【2021-09-18 12:22:31】登录系统！','admin'),
(626,'2021-09-18 12:24:46','2021-09-18 12:24:46','编辑角色【超级管理员】','admin'),
(627,'2021-09-18 12:25:05','2021-09-18 12:25:05','用户【admin】于【2021-09-18 12:25:05】登录系统！','admin'),
(628,'2021-09-18 12:30:00','2021-09-18 12:30:00','用户【admin】于【2021-09-18 12:30:00】登录系统！','admin'),
(629,'2021-09-18 12:32:16','2021-09-18 12:32:16','用户【jack】于【2021-09-18 12:32:16】登录系统！','jack'),
(630,'2021-09-18 12:32:53','2021-09-18 12:32:53','用户【admin】于【2021-09-18 12:32:53】登录系统！','admin'),
(631,'2021-09-18 12:37:04','2021-09-18 12:37:04','用户【admin】于【2021-09-18 12:37:04】登录系统！','admin'),
(632,'2021-09-18 12:38:23','2021-09-18 12:38:23','用户【admin】于【2021-09-18 12:38:23】登录系统！','admin'),
(633,'2021-09-18 12:39:48','2021-09-18 12:39:48','编辑角色【超级管理员】','admin'),
(634,'2021-09-18 12:40:40','2021-09-18 12:40:40','用户【jack】于【2021-09-18 12:40:40】登录系统！','jack'),
(635,'2021-09-18 12:41:11','2021-09-18 12:41:11','用户【admin】于【2021-09-18 12:41:11】登录系统！','admin');

/*Table structure for table `tb_order_auth` */

DROP TABLE IF EXISTS `tb_order_auth`;

CREATE TABLE `tb_order_auth` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `mac` varchar(32) DEFAULT NULL,
  `order_sn` varchar(18) NOT NULL,
  `phone` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `tb_order_auth` */

/*Table structure for table `tb_resident` */

DROP TABLE IF EXISTS `tb_resident`;

CREATE TABLE `tb_resident` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `account_number` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `card_number` varchar(32) DEFAULT NULL,
  `is_del` int(11) NOT NULL,
  `name` varchar(18) DEFAULT NULL,
  `relation` varchar(255) DEFAULT NULL,
  `sex` int(11) NOT NULL,
  `type` int(11) DEFAULT NULL,
  `community_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKcse8nab4ti88brfuft807cquk` (`community_id`) USING BTREE,
  CONSTRAINT `FKcse8nab4ti88brfuft807cquk` FOREIGN KEY (`community_id`) REFERENCES `tb_community` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_resident` */

insert  into `tb_resident`(`id`,`create_time`,`update_time`,`account_number`,`address`,`card_number`,`is_del`,`name`,`relation`,`sex`,`type`,`community_id`) values 
(1,'2022-02-26 17:13:30','2022-02-26 17:26:19',584657842,'上海市嘉定区城中路20号','42022220001112151X',0,'仲谋','户主',1,1,1),
(2,'2022-02-26 17:13:58','2022-02-26 17:26:19',548754689,'上海市宝山区上大路99号','420222200011121512',0,'中牟','女儿',0,1,1),
(3,'2022-02-26 17:14:39','2022-02-26 17:26:19',845687459,'上海市黄浦区xx路A栋B单元','420222200011121513',0,'钟某','儿子',1,1,1),
(4,'2022-02-26 17:16:43','2022-02-26 17:16:43',845957456,'天津天津','420222200011121543',1,'张华','户主',1,1,3),
(5,'2022-02-26 17:26:19','2022-03-06 15:43:43',584657842,'上海市嘉定区城中路20号','42022220001112151X',0,'仲谋','户主',1,1,1),
(6,'2022-02-26 17:26:19','2022-03-06 15:43:43',548754689,'上海市宝山区上大路99号','420222200011121512',0,'中牟','女儿',0,1,1),
(7,'2022-02-26 17:26:19','2022-03-06 15:43:43',845687459,'上海市黄浦区xx路A栋B单元','420222200011121513',0,'钟某','儿子',1,1,1),
(9,'2022-03-06 15:42:34','2022-03-06 15:43:43',789456123,'测试一波','412723199602259020',0,'王金库','父子',1,1,1),
(10,'2022-03-06 15:42:58','2022-03-06 15:43:43',654123789,'测试一笔','420222200011125000',0,'王金库','父子',1,1,1),
(11,'2022-03-06 15:43:43','2022-03-06 15:45:40',584657842,'上海市嘉定区城中路20号','42022220001112151X',0,'仲谋','户主',1,1,1),
(12,'2022-03-06 15:43:43','2022-03-06 15:45:40',654123789,'测试一笔','420222200011125000',0,'王金库','父子',1,1,1),
(13,'2022-03-06 15:43:43','2022-03-06 15:45:46',789456123,'测试一波','412723199602259020',0,'王金库','父子',1,1,1),
(14,'2022-03-06 15:43:43','2022-03-06 15:45:46',548754689,'上海市宝山区上大路99号','420222200011121512',0,'中牟','女儿',0,1,1),
(15,'2022-03-06 15:43:43','2022-03-06 15:45:46',845687459,'上海市黄浦区xx路A栋B单元','420222200011121513',0,'钟某','儿子',1,1,1),
(16,'2022-03-06 15:45:40','2022-03-06 15:45:46',584657842,'上海市嘉定区城中路20号','42022220001112151X',0,'仲谋','户主',1,1,1),
(17,'2022-03-06 15:45:40','2022-03-06 15:45:46',654123789,'测试一笔','420222200011125000',0,'王金库','父子',1,1,1),
(18,'2022-03-06 15:45:40','2022-03-06 15:45:50',548754689,'上海市宝山区上大路99号','420222200011125555',0,'中牟','女儿',0,1,1),
(19,'2022-03-06 15:45:40','2022-03-06 15:45:50',845687459,'上海市黄浦区xx路A栋B单元','420222200011124444',0,'钟某','儿子',1,1,1),
(20,'2022-03-06 15:45:40','2022-03-06 15:45:50',789456123,'测试一波','412723199602259000',0,'王金库','父子',1,1,1),
(21,'2022-03-06 15:45:46','2022-03-06 15:45:50',584657842,'上海市嘉定区城中路20号','42022220001112151X',0,'仲谋','户主',1,1,1),
(22,'2022-03-06 15:45:46','2022-03-06 15:45:50',654123789,'测试一笔','420222200011125000',0,'王金库','父子',1,1,1),
(23,'2022-03-06 15:45:46','2022-03-06 15:45:46',789456123,'测试一波','412723199602259020',1,'王金库','父子',1,1,1),
(24,'2022-03-06 15:45:46','2022-03-06 15:45:46',548754689,'上海市宝山区上大路99号','420222200011121512',1,'中牟','女儿',0,1,1),
(25,'2022-03-06 15:45:46','2022-03-06 15:45:46',845687459,'上海市黄浦区xx路A栋B单元','420222200011121513',1,'钟某','儿子',1,1,1),
(26,'2022-03-06 15:45:50','2022-03-06 15:45:50',584657842,'上海市嘉定区城中路20号','42022220001112151X',1,'仲谋','户主',1,1,1),
(27,'2022-03-06 15:45:50','2022-03-06 15:45:50',654123789,'测试一笔','420222200011125000',1,'王金库','父子',1,1,1),
(28,'2022-03-06 15:45:50','2022-03-06 15:45:50',548754689,'上海市宝山区上大路99号','420222200011125555',1,'中牟','女儿',0,1,1),
(29,'2022-03-06 15:45:50','2022-03-06 15:45:50',845687459,'上海市黄浦区xx路A栋B单元','420222200011124444',1,'钟某','儿子',1,1,1),
(30,'2022-03-06 15:45:50','2022-03-06 15:45:50',789456123,'测试一波','412723199602259000',1,'王金库','父子',1,1,1);

/*Table structure for table `tb_role` */

DROP TABLE IF EXISTS `tb_role`;

CREATE TABLE `tb_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `name` varchar(18) NOT NULL,
  `remark` varchar(128) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_role` */

insert  into `tb_role`(`id`,`create_time`,`update_time`,`name`,`remark`,`status`) values 
(1,'2020-03-15 13:16:38','2021-09-18 12:39:48','超级管理员','超级管理员拥有最高权限。',1),
(2,'2020-03-15 13:18:57','2022-02-26 11:25:51','普通管理员','普通管理员只有部分权限',1);

/*Table structure for table `tb_role_authorities` */

DROP TABLE IF EXISTS `tb_role_authorities`;

CREATE TABLE `tb_role_authorities` (
  `role_id` bigint(20) NOT NULL,
  `authorities_id` bigint(20) NOT NULL,
  KEY `FKhj7ap1o1cjrl7enr9arf5f2qp` (`authorities_id`) USING BTREE,
  KEY `FKg3xdaexmr0x1qx8omhvjtk46d` (`role_id`) USING BTREE,
  CONSTRAINT `FKg3xdaexmr0x1qx8omhvjtk46d` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`id`),
  CONSTRAINT `FKhj7ap1o1cjrl7enr9arf5f2qp` FOREIGN KEY (`authorities_id`) REFERENCES `tb_menu` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_role_authorities` */

insert  into `tb_role_authorities`(`role_id`,`authorities_id`) values 
(2,29),
(2,35),
(2,36),
(2,38),
(2,39),
(2,40),
(2,41),
(2,42),
(2,43),
(2,45),
(2,46),
(2,47),
(2,48),
(2,49),
(2,50),
(2,51),
(2,52),
(2,54),
(2,55),
(2,53),
(1,2),
(1,3),
(1,5),
(1,8),
(1,9),
(1,7),
(1,10),
(1,11),
(1,12),
(1,13),
(1,14),
(1,15),
(1,16),
(1,19),
(1,20),
(1,21),
(1,22),
(1,23),
(1,24),
(1,25),
(1,26),
(1,29),
(1,35),
(1,36),
(1,38),
(1,39),
(1,40),
(1,41),
(1,42),
(1,43),
(1,45),
(1,46),
(1,47),
(1,30),
(1,31),
(1,32),
(1,33),
(1,34),
(1,48),
(1,49),
(1,50),
(1,51),
(1,52),
(1,54),
(1,55),
(1,53);

/*Table structure for table `tb_test_record` */

DROP TABLE IF EXISTS `tb_test_record`;

CREATE TABLE `tb_test_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `card_number` varchar(32) DEFAULT NULL,
  `gather_address` varchar(255) DEFAULT NULL,
  `gather_mobile` varchar(12) DEFAULT NULL,
  `gather_name` varchar(255) DEFAULT NULL,
  `gather_number` varchar(255) DEFAULT NULL,
  `gather_time` datetime DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `name` varchar(18) DEFAULT NULL,
  `reasons` varchar(255) DEFAULT NULL,
  `sex` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `community_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKoj07tsorv45fvrxsdl0e9expa` (`community_id`) USING BTREE,
  CONSTRAINT `FKoj07tsorv45fvrxsdl0e9expa` FOREIGN KEY (`community_id`) REFERENCES `tb_community` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_test_record` */

insert  into `tb_test_record`(`id`,`create_time`,`update_time`,`address`,`card_number`,`gather_address`,`gather_mobile`,`gather_name`,`gather_number`,`gather_time`,`img`,`name`,`reasons`,`sex`,`status`,`community_id`) values 
(1,'2022-02-26 16:54:12','2022-02-26 16:54:42','秀三村一组135号','420222200011121543','上海火眼实验室','18186000287','钟锐','911658153M','2022-02-26 00:00:00','20220226/1614329642311-19afb831-428a-461e-9180-92975920659f.jpg','张华',NULL,1,1,1),
(2,'2022-02-26 17:19:35','2022-02-26 17:28:25','天津天津','420222200011121543','上海浦东','15234525410','钟某','159584M','2022-02-26 17:18:00','20220226/1614331152815-55ff8b3b-b162-4a25-966b-5c454727d9e6.png','张华',NULL,1,1,3),
(3,'2022-03-06 15:46:49','2022-03-06 15:46:49','北京东路','412723199602249040','s测试一波','15518166316','王金库','123456','2022-03-06 00:00:00','20220306/1615016773666-be7eacdc-207d-485b-acae-1a7d84f030d1.jpg','张大爷',NULL,0,1,1),
(5,'2022-03-06 15:50:17','2022-03-06 15:50:17','北京东路','420222200011121000','s测试一波','15518166316','王金库','123456','2022-03-05 00:00:00','20220306/1615017002534-4cab4313-e188-4597-9981-eb136e079969.jpg','测试',NULL,1,1,1),
(6,'2022-03-06 15:57:19','2022-03-06 16:03:16','测试一波','412723199602259020','s测试一波','15518166316','王金库','123456','2022-03-06 00:00:00','20220306/1615017431174-473255a5-30cc-484b-a235-6601350da9c7.jpg','王金库',NULL,1,1,1);

/*Table structure for table `tb_user` */

DROP TABLE IF EXISTS `tb_user`;

CREATE TABLE `tb_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `head_pic` varchar(128) DEFAULT NULL,
  `password` varchar(32) NOT NULL,
  `username` varchar(18) NOT NULL,
  `community_id` bigint(20) DEFAULT NULL,
  `role_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_btsosjytrl4hu7fnm1intcpo8` (`username`) USING BTREE,
  KEY `FK90sdpnb5vecyfp2oom0lps4ae` (`community_id`) USING BTREE,
  KEY `FKg09b8o67eu61st68rv6nk8npj` (`role_id`) USING BTREE,
  CONSTRAINT `FK90sdpnb5vecyfp2oom0lps4ae` FOREIGN KEY (`community_id`) REFERENCES `tb_community` (`id`),
  CONSTRAINT `FKg09b8o67eu61st68rv6nk8npj` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `tb_user` */

insert  into `tb_user`(`id`,`create_time`,`update_time`,`head_pic`,`password`,`username`,`community_id`,`role_id`) values 
(1,'2022-02-22 16:45:24','2021-08-21 16:53:27','20210821/1629536004408-f9b3c42f-d830-44d5-b559-593165cf3e73.png','123456','admin',1,1),
(2,'2022-02-26 16:45:22','2021-08-21 17:06:40','20210821/1629536797657-8ab921f2-a758-4fe4-8106-79d9ea25eeb9.png','123456','jack',1,2),
(3,'2022-02-26 16:45:37','2022-02-26 16:45:37','','123456','tom',2,2),
(4,'2022-02-26 16:46:24','2022-02-26 16:46:24','20220226/1614329175597-d111383c-09a8-48ca-a2e9-98fcd21ce75d.jpeg','123456','rose',3,2),
(5,'2022-03-06 16:06:19','2022-03-06 16:06:19','20220306/1615017967014-8328e0e8-b05c-40ac-a658-50b382b383bb.jpg','123456','金库测试',5,2);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;