主要使用技术
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,'-02-26 16:32:48','-02-26 16:32:48','东城区','北京市市辖区','秀沿路秀怡苑','北京市','东大门20号'),(2,'-02-26 16:35:14','-02-26 16:35:14','朝阳区','北京市市辖区','故宫路朝阳小区','北京市','东大门20号'),(3,'-02-26 16:37:11','-02-26 16:37:11','河北区','天津市市辖区','河北路青青小区','天津市','东大门20号'),(5,'-03-06 14:49:51','-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,'-03-14 14:26:03','-03-14 18:24:53','系统管理','','mdi-settings',0,NULL,'\0',''),(3,'-03-14 16:58:55','-02-22 15:04:24','菜单管理','/admin/menu/list','mdi-view-list',1,2,'\0',''),(5,'-03-14 17:04:44','-03-14 18:27:53','新增','/admin/menu/add','mdi-plus',2,3,'\0',''),(7,'-03-14 17:07:43','-03-15 12:11:25','角色管理','/admin/role/list','mdi-account-settings-variant',5,2,'\0',''),(8,'-03-14 18:28:48','-03-21 22:04:45','编辑','edit(\'/admin/menu/edit\')','mdi-grease-pencil',3,3,'',''),(9,'-03-14 18:30:00','-03-21 22:08:20','删除','del(\'/admin/menu/delete\')','mdi-close',4,3,'',''),(10,'-03-15 12:12:00','-03-15 12:12:00','添加','/admin/role/add','mdi-account-plus',6,7,'\0',''),(11,'-03-15 12:12:36','-03-21 22:10:45','编辑','edit(\'/admin/role/edit\')','mdi-account-edit',7,7,'',''),(12,'-03-15 12:13:19','-03-21 22:15:27','删除','del(\'/admin/role/delete\')','mdi-account-remove',8,7,'',''),(13,'-03-15 12:14:52','-03-15 12:17:00','用户管理','/admin/user/list','mdi-account-multiple',9,2,'\0',''),(14,'-03-15 12:15:22','-03-15 12:17:27','添加','/admin/user/add','mdi-account-plus',10,13,'\0',''),(15,'-03-16 17:18:14','-03-21 22:11:19','编辑','edit(\'/admin/user/edit\')','mdi-account-edit',11,13,'',''),(16,'-03-16 17:19:01','-03-21 22:15:36','删除','del(\'/admin/user/delete\')','mdi-account-remove',12,13,'',''),(19,'-03-22 11:24:36','-03-22 11:26:00','上传图片','/upload/upload_photo','mdi-arrow-up-bold-circle',0,13,'\0','\0'),(20,'-03-22 14:09:35','-03-22 14:09:47','日志管理','/system/operator_log_list','mdi-tag-multiple',13,2,'\0',''),(21,'-03-22 14:11:39','-03-22 14:11:39','删除','del(\'/system/delete_operator_log\')','mdi-tag-remove',14,20,'',''),(22,'-03-22 14:12:57','-03-22 14:46:55','清空日志','delAll(\'/system/delete_all_operator_log\')','mdi-delete-circle',15,20,'',''),(23,'-03-22 14:46:40','-03-22 14:47:09','数据备份','/admin/database_bak/list','mdi-database',16,2,'\0',''),(24,'-03-22 14:48:07','-03-22 15:13:41','备份','add(\'/admin/database_bak/add\')','mdi-database-plus',17,23,'',''),(25,'-03-22 14:49:03','-03-22 14:49:03','删除','del(\'/admin/database_bak/delete\')','mdi-database-minus',18,23,'',''),(26,'-03-22 19:36:20','-03-22 19:36:20','还原','restore(\'/admin/database_bak/restore\')','mdi-database-minus',19,23,'',''),(29,'-02-23 09:18:21','-02-23 09:18:21','人员管理','','mdi-human-male-female',20,NULL,'\0',''),(30,'-02-23 09:39:37','-02-23 09:59:14','地址管理','','mdi-file-outline',21,NULL,'\0',''),(31,'-02-23 09:52:40','-02-23 09:59:26','地址列表','/admin/community/list','mdi-vector-difference',22,30,'\0',''),(32,'-02-23 09:53:39','-02-23 09:53:39','添加','/admin/community/add','mdi-tag',23,31,'\0',''),(33,'-02-23 09:54:39','-02-23 09:54:39','编辑','edit(\'/admin/community/edit\')','mdi-wrench',24,31,'',''),(34,'-02-23 09:55:12','-02-23 09:55:12','删除','del(\'/admin/community/delete\')','mdi-delete-sweep',25,31,'',''),(35,'-02-23 11:07:19','-02-25 17:59:28','流动人员列表','/admin/migrant/list','mdi-account-settings',26,29,'\0',''),(36,'-02-23 11:07:45','-02-23 11:07:57','添加','/admin/migrant/add','mdi-folder-account',27,35,'\0',''),(38,'-02-23 11:10:14','-02-23 11:10:14','删除','del(\'/admin/migrant/delete\')','mdi-delete-forever',29,35,'',''),(39,'-02-23 15:10:07','-02-23 15:10:07','审核','/admin/migrant/approval','mdi-close-octagon-outline',30,35,'\0','\0'),(40,'-02-23 15:43:06','-02-23 15:43:06','导入','poiImport(\'/admin/migrant/import\')','mdi-trending-down',31,35,'',''),(41,'-02-23 15:43:38','-02-23 15:43:48','导出','poiExport(\'/admin/migrant/export\')','mdi-arrow-down-bold',32,35,'',''),(42,'-02-23 15:49:27','-02-25 17:59:39','常驻人员列表','/admin/resident/list','mdi-account-multiple',33,29,'\0',''),(43,'-02-23 16:15:50','-02-23 16:15:50','添加','/admin/resident/add','mdi-account-multiple-plus',34,42,'\0',''),(45,'-02-23 16:18:37','-02-23 16:18:37','删除','del(\'/admin/resident/delete\')','mdi-account-multiple-minus',36,42,'',''),(46,'-02-23 16:19:33','-02-23 16:19:33','导入','poiImport(\'/admin/resident/import\')','mdi-arrow-bottom-right',37,42,'',''),(47,'-02-23 16:20:09','-02-23 16:20:21','导出','poiExport(\'/admin/resident/export\')','mdi-arrow-right-bold',38,42,'',''),(48,'-02-24 14:35:18','-02-24 14:36:29','核酸检测记录','','mdi-clipboard-text',39,NULL,'\0',''),(49,'-02-24 14:36:19','-02-24 14:36:19','核酸检测记录列表','/admin/testRecord/list','mdi-calendar-text',40,48,'\0',''),(50,'-02-24 14:38:28','-02-24 14:38:38','添加','/admin/testRecord/add','mdi-plus',41,49,'\0',''),(51,'-02-24 14:40:29','-02-26 11:25:38','导出未检出核酸人员信息','poiExport(\'/admin/testRecord/export\')','mdi-arrow-right-bold',42,49,'\0','\0'),(52,'-02-24 17:33:30','-02-24 17:33:30','查看详情','/admin/testRecord/show','mdi-alpha',43,49,'\0','\0'),(53,'-02-25 10:56:30','-02-26 15:28:03','核酸检测记录统计','/admin/statistics/statistics','mdi-clipboard-text',44,48,'\0',''),(54,'-02-26 09:12:34','-02-26 09:12:34','删除','del(\'/admin/testRecord/delete\')','mdi-close',45,49,'',''),(55,'-02-26 10:41:37','-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,'-02-26 16:49:18','-02-26 17:16:52','青青小区东区13栋1309室','[\"0226/1614329308822-d78d43eb-1d85-4b83-b4e8-fb409ae3a76b.jpg\",\"0226/1614329308827-b53aa72f-a973-48e9-9520-e7555a0d8e1e.jpg\"]','4220001112154X','湖北武汉',1,'韦小宝',NULL,1,1,3),(2,'-02-26 16:50:28','-02-26 16:50:28','朝阳小区南区18栋一单元1305号','[\"0226/1614329369829-67a622f6-2f69-476c-a9fd-3c71664d026b.jpg\",\"0226/1614329369829-0b641170-03fb-4cd3-a303-e522b4bb40b0.jpg\"]','42200011121542','河南郑州',1,'皮皮',NULL,1,2,2),(3,'-02-26 16:51:32','-02-26 17:26:07','秀三村一组135号','[\"0226/1614329491740-2f2d4796-32c0-4ad7-bd50-d9e3311afbc3.jpg\",\"0226/1614329491739-794d72f7-c8cf-4f1e-99f1-2631e09e9de2.jpg\"]','42200011121543','湖北鄂州',0,'张华','请填写合法内容',1,1,1),(4,'-02-26 16:52:13','-02-26 17:26:07','秀三村二组1305号','[\"0226/1614329498928-e4588aed-b83c-4255-8ff6-735a4c31d792.jpg\",\"0226/1614329498924-f804ae9d-bb25-45ff-9e63-0de54e52a0a8.jpg\"]','42200011121547','北京朝阳',0,'黎明',NULL,0,1,1),(5,'-02-26 17:26:07','-03-06 14:58:19','秀三村一组135号',NULL,'42200011121543','湖北鄂州',0,'张华',NULL,1,1,1),(6,'-02-26 17:26:07','-03-06 14:58:19','秀三村二组1305号',NULL,'42200011121547','北京朝阳',0,'黎明',NULL,0,1,1),(7,'-03-06 14:50:55','-03-06 14:51:25','上海市浦东区康桥集团',NULL,'412723199602259020','河南',0,'王金库',NULL,1,1,1),(8,'-03-06 14:51:25','-03-06 14:53:07','北京东路',NULL,'412723199602259020','河南',0,'王金库',NULL,1,1,1),(10,'-03-06 14:53:33','-03-06 14:58:19','北京东路',NULL,'412723199602259030','河南',0,'张大爷',NULL,1,1,1),(11,'-03-06 14:56:09','-03-06 14:58:19','北京东路',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),(12,'-03-06 14:56:09','-03-06 14:58:19','秀三村一组135号',NULL,'42200011121234','湖北鄂州',0,'测试',NULL,1,1,1),(13,'-03-06 14:56:09','-03-06 14:58:19','秀三村二组1305号',NULL,'42200011125678','北京朝阳',0,'测试',NULL,0,1,1),(14,'-03-06 14:58:19','-03-06 15:06:08','北京东路',NULL,'412723199602259030','河南',0,'张大爷',NULL,1,1,1),(15,'-03-06 14:58:19','-03-06 15:06:08','北京东路',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),(16,'-03-06 14:58:19','-03-06 15:06:08','秀三村一组135号',NULL,'42200011121543','湖北鄂州',0,'张华',NULL,1,1,1),(17,'-03-06 14:58:19','-03-06 15:06:08','秀三村一组135号',NULL,'42200011121234','湖北鄂州',0,'测试',NULL,1,1,1),(18,'-03-06 14:58:19','-03-06 15:06:08','秀三村二组1305号',NULL,'42200011121547','北京朝阳',0,'黎明',NULL,0,1,1),(19,'-03-06 14:58:19','-03-06 15:06:08','秀三村二组1305号',NULL,'42200011125678','北京朝阳',0,'测试',NULL,0,1,1),(21,'-03-06 15:06:08','-03-06 15:07:13','北京东路',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),(23,'-03-06 15:06:08','-03-06 15:07:13','秀三村一组135号',NULL,'42200011121234','湖北鄂州',0,'测试',NULL,1,1,1),(24,'-03-06 15:06:08','-03-06 15:40:22','秀三村二组1305号',NULL,'42200011121547','北京朝阳',0,'黎明',NULL,0,1,1),(25,'-03-06 15:06:08','-03-06 15:07:13','秀三村二组1305号',NULL,'42200011125678','北京朝阳',0,'测试',NULL,0,1,1),(26,'-03-06 15:07:13','-03-06 15:13:32','秀三村三组135号',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),(27,'-03-06 15:07:13','-03-06 15:13:32','秀三村一组135号',NULL,'42200011121234','湖北鄂州',0,'测试',NULL,1,1,1),(31,'-03-06 15:13:28','-03-06 15:39:55','秀三村三组135号',NULL,'412723199602258000','河南',0,'测试',NULL,1,1,1),(32,'-03-06 15:13:32','-03-06 15:40:02','秀三村三组135号',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),(33,'-03-06 15:13:32','-03-06 15:40:02','秀三村一组135号',NULL,'42200011121234','湖北鄂州',0,'测试',NULL,1,1,1),(34,'-03-06 15:13:32','-03-06 15:40:02','秀三村二组135号',NULL,'42200011125678','北京朝阳',0,'测试',NULL,1,1,1),(35,'-03-06 15:39:55','-03-06 15:42:58','秀三村二组135号',NULL,'42200011125000','北京朝阳',0,'测试',NULL,1,1,1),(36,'-03-06 15:39:55','-03-06 15:39:55','秀三村一组135号',NULL,'42200011121000','湖北鄂州',1,'测试',NULL,1,1,1),(37,'-03-06 15:39:55','-03-06 15:40:22','秀三村三组135号',NULL,'412723199602258000','河南',0,'测试',NULL,1,1,1),(38,'-03-06 15:40:02','-03-06 15:40:22','秀三村三组135号',NULL,'412723199602258564','河南',0,'测试',NULL,1,1,1),(39,'-03-06 15:40:02','-03-06 15:40:22','秀三村一组135号',NULL,'42200011121234','湖北鄂州',0,'测试',NULL,1,1,1),(40,'-03-06 15:40:02','-03-06 15:40:22','秀三村二组135号',NULL,'42200011125678','北京朝阳',0,'测试',NULL,1,1,1),(41,'-03-06 15:40:22','-03-06 15:40:22','秀三村三组135号',NULL,'412723199602258564','河南',1,'测试',NULL,1,1,1),(42,'-03-06 15:40:22','-03-06 15:40:22','秀三村三组135号',NULL,'412723199602258000','河南',1,'测试',NULL,1,1,1),(43,'-03-06 15:40:22','-03-06 15:40:22','秀三村一组135号',NULL,'42200011121234','湖北鄂州',1,'测试',NULL,1,1,1),(46,'-03-06 15:56:45','-03-06 16:02:10','北京东路','[\"0306/1615017392608-74e6fdd3-7bf8-4eff-92cb-ef1feb0f58c7.jpg\",\"0306/1615017392612-b1304bb8-f158-4bbf-a9e0-ed4182be15c0.jpg\"]','412723199602259080','河南',1,'张大爷','不通过',1,0,1),(47,'-03-06 16:05:44','-03-06 16:06:34','北京东路','[\"0306/1615017938317-6e692fd8-c24e-48a7-9986-ad052c15c61f.jpg\",\"0306/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,'-08-21 11:29:00','-08-21 11:29:00','用户【admin】于【-08-21 11:29:00】登录系统！','admin'),(610,'-08-21 11:30:15','-08-21 11:30:15','用户【Change】于【-08-21 11:30:15】登录系统！','Change'),(611,'-08-21 11:37:19','-08-21 11:37:19','用户【admin】于【-08-21 11:37:19】登录系统！','admin'),(612,'-08-21 11:40:56','-08-21 11:40:56','用户【admin】于【-08-21 11:40:56】登录系统！','admin'),(613,'-08-21 11:43:57','-08-21 11:43:57','用户【admin】于【-08-21 11:43:57】登录系统！','admin'),(614,'-08-21 11:47:01','-08-21 11:47:01','用户【admin】于【-08-21 11:47:01】登录系统！','admin'),(615,'-08-21 16:32:21','-08-21 16:32:21','用户【admin】于【-08-21 16:32:21】登录系统！','admin'),(616,'-08-21 16:42:50','-08-21 16:42:50','用户【admin】于【-08-21 16:42:50】登录系统！','admin'),(617,'-08-21 16:48:51','-08-21 16:48:51','用户【admin】于【-08-21 16:48:51】登录系统！','admin'),(618,'-08-21 17:05:48','-08-21 17:05:48','用户【admin】于【-08-21 17:05:48】登录系统！','admin'),(619,'-08-21 17:06:28','-08-21 17:06:28','用户【Change】于【-08-21 17:06:28】登录系统！','Change'),(620,'-08-21 17:22:07','-08-21 17:22:07','用户【jack】于【-08-21 17:22:07】登录系统！','jack'),(621,'-08-21 17:24:23','-08-21 17:24:23','用户【admin】于【-08-21 17:24:23】登录系统！','admin'),(622,'-08-21 17:26:18','-08-21 17:26:18','用户【jack】于【-08-21 17:26:18】登录系统！','jack'),(623,'-08-23 12:42:34','-08-23 12:42:34','用户【admin】于【-08-23 12:42:34】登录系统！','admin'),(624,'-09-18 12:20:26','-09-18 12:20:26','用户【admin】于【-09-18 12:20:26】登录系统！','admin'),(625,'-09-18 12:22:31','-09-18 12:22:31','用户【admin】于【-09-18 12:22:31】登录系统！','admin'),(626,'-09-18 12:24:46','-09-18 12:24:46','编辑角色【超级管理员】','admin'),(627,'-09-18 12:25:05','-09-18 12:25:05','用户【admin】于【-09-18 12:25:05】登录系统！','admin'),(628,'-09-18 12:30:00','-09-18 12:30:00','用户【admin】于【-09-18 12:30:00】登录系统！','admin'),(629,'-09-18 12:32:16','-09-18 12:32:16','用户【jack】于【-09-18 12:32:16】登录系统！','jack'),(630,'-09-18 12:32:53','-09-18 12:32:53','用户【admin】于【-09-18 12:32:53】登录系统！','admin'),(631,'-09-18 12:37:04','-09-18 12:37:04','用户【admin】于【-09-18 12:37:04】登录系统！','admin'),(632,'-09-18 12:38:23','-09-18 12:38:23','用户【admin】于【-09-18 12:38:23】登录系统！','admin'),(633,'-09-18 12:39:48','-09-18 12:39:48','编辑角色【超级管理员】','admin'),(634,'-09-18 12:40:40','-09-18 12:40:40','用户【jack】于【-09-18 12:40:40】登录系统！','jack'),(635,'-09-18 12:41:11','-09-18 12:41:11','用户【admin】于【-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,'-02-26 17:13:30','-02-26 17:26:19',584657842,'上海市嘉定区城中路20号','4220001112151X',0,'仲谋','户主',1,1,1),(2,'-02-26 17:13:58','-02-26 17:26:19',548754689,'上海市宝山区上大路99号','42200011121512',0,'中牟','女儿',0,1,1),(3,'-02-26 17:14:39','-02-26 17:26:19',845687459,'上海市黄浦区xx路A栋B单元','42200011121513',0,'钟某','儿子',1,1,1),(4,'-02-26 17:16:43','-02-26 17:16:43',845957456,'天津天津','42200011121543',1,'张华','户主',1,1,3),(5,'-02-26 17:26:19','-03-06 15:43:43',584657842,'上海市嘉定区城中路20号','4220001112151X',0,'仲谋','户主',1,1,1),(6,'-02-26 17:26:19','-03-06 15:43:43',548754689,'上海市宝山区上大路99号','42200011121512',0,'中牟','女儿',0,1,1),(7,'-02-26 17:26:19','-03-06 15:43:43',845687459,'上海市黄浦区xx路A栋B单元','42200011121513',0,'钟某','儿子',1,1,1),(9,'-03-06 15:42:34','-03-06 15:43:43',789456123,'测试一波','412723199602259020',0,'王金库','父子',1,1,1),(10,'-03-06 15:42:58','-03-06 15:43:43',654123789,'测试一笔','42200011125000',0,'王金库','父子',1,1,1),(11,'-03-06 15:43:43','-03-06 15:45:40',584657842,'上海市嘉定区城中路20号','4220001112151X',0,'仲谋','户主',1,1,1),(12,'-03-06 15:43:43','-03-06 15:45:40',654123789,'测试一笔','42200011125000',0,'王金库','父子',1,1,1),(13,'-03-06 15:43:43','-03-06 15:45:46',789456123,'测试一波','412723199602259020',0,'王金库','父子',1,1,1),(14,'-03-06 15:43:43','-03-06 15:45:46',548754689,'上海市宝山区上大路99号','42200011121512',0,'中牟','女儿',0,1,1),(15,'-03-06 15:43:43','-03-06 15:45:46',845687459,'上海市黄浦区xx路A栋B单元','42200011121513',0,'钟某','儿子',1,1,1),(16,'-03-06 15:45:40','-03-06 15:45:46',584657842,'上海市嘉定区城中路20号','4220001112151X',0,'仲谋','户主',1,1,1),(17,'-03-06 15:45:40','-03-06 15:45:46',654123789,'测试一笔','42200011125000',0,'王金库','父子',1,1,1),(18,'-03-06 15:45:40','-03-06 15:45:50',548754689,'上海市宝山区上大路99号','42200011125555',0,'中牟','女儿',0,1,1),(19,'-03-06 15:45:40','-03-06 15:45:50',845687459,'上海市黄浦区xx路A栋B单元','42200011124444',0,'钟某','儿子',1,1,1),(20,'-03-06 15:45:40','-03-06 15:45:50',789456123,'测试一波','412723199602259000',0,'王金库','父子',1,1,1),(21,'-03-06 15:45:46','-03-06 15:45:50',584657842,'上海市嘉定区城中路20号','4220001112151X',0,'仲谋','户主',1,1,1),(22,'-03-06 15:45:46','-03-06 15:45:50',654123789,'测试一笔','42200011125000',0,'王金库','父子',1,1,1),(23,'-03-06 15:45:46','-03-06 15:45:46',789456123,'测试一波','412723199602259020',1,'王金库','父子',1,1,1),(24,'-03-06 15:45:46','-03-06 15:45:46',548754689,'上海市宝山区上大路99号','42200011121512',1,'中牟','女儿',0,1,1),(25,'-03-06 15:45:46','-03-06 15:45:46',845687459,'上海市黄浦区xx路A栋B单元','42200011121513',1,'钟某','儿子',1,1,1),(26,'-03-06 15:45:50','-03-06 15:45:50',584657842,'上海市嘉定区城中路20号','4220001112151X',1,'仲谋','户主',1,1,1),(27,'-03-06 15:45:50','-03-06 15:45:50',654123789,'测试一笔','42200011125000',1,'王金库','父子',1,1,1),(28,'-03-06 15:45:50','-03-06 15:45:50',548754689,'上海市宝山区上大路99号','42200011125555',1,'中牟','女儿',0,1,1),(29,'-03-06 15:45:50','-03-06 15:45:50',845687459,'上海市黄浦区xx路A栋B单元','42200011124444',1,'钟某','儿子',1,1,1),(30,'-03-06 15:45:50','-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,'-03-15 13:16:38','-09-18 12:39:48','超级管理员','超级管理员拥有最高权限。',1),(2,'-03-15 13:18:57','-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,'-02-26 16:54:12','-02-26 16:54:42','秀三村一组135号','42200011121543','上海火眼实验室','18186000287','钟锐','911658153M','-02-26 00:00:00','0226/1614329642311-19afb831-428a-461e-9180-92975920659f.jpg','张华',NULL,1,1,1),(2,'-02-26 17:19:35','-02-26 17:28:25','天津天津','42200011121543','上海浦东','15234525410','钟某','159584M','-02-26 17:18:00','0226/1614331152815-55ff8b3b-b162-4a25-966b-5c454727d9e6.png','张华',NULL,1,1,3),(3,'-03-06 15:46:49','-03-06 15:46:49','北京东路','412723199602249040','s测试一波','15518166316','王金库','123456','-03-06 00:00:00','0306/1615016773666-be7eacdc-207d-485b-acae-1a7d84f030d1.jpg','张大爷',NULL,0,1,1),(5,'-03-06 15:50:17','-03-06 15:50:17','北京东路','42200011121000','s测试一波','15518166316','王金库','123456','-03-05 00:00:00','0306/1615017002534-4cab4313-e188-4597-9981-eb136e079969.jpg','测试',NULL,1,1,1),(6,'-03-06 15:57:19','-03-06 16:03:16','测试一波','412723199602259020','s测试一波','15518166316','王金库','123456','-03-06 00:00:00','0306/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,'-02-22 16:45:24','-08-21 16:53:27','0821/1629536004408-f9b3c42f-d830-44d5-b559-593165cf3e73.png','123456','admin',1,1),(2,'-02-26 16:45:22','-08-21 17:06:40','0821/1629536797657-8ab921f2-a758-4fe4-8106-79d9ea25eeb9.png','123456','jack',1,2),(3,'-02-26 16:45:37','-02-26 16:45:37','','123456','tom',2,2),(4,'-02-26 16:46:24','-02-26 16:46:24','0226/1614329175597-d111383c-09a8-48ca-a2e9-98fcd21ce75d.jpeg','123456','rose',3,2),(5,'-03-06 16:06:19','-03-06 16:06:19','0306/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 */;
