应急救援管理系统 SpringBoot 计算机毕设

/* SQLyog Ultimate v11.33 (64 bit) MySQL - 5.0.67-community-log : Database - rescue ********************************************************************* */ /*!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*/`rescue` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `rescue`; /*Table structure for table `admin` */ DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL, `username` varchar(20) default NULL, `password` varchar(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `admin` */ insert into `admin`(`id`,`username`,`password`) values (1,'admin','123456'),(2,'demo','111111'),(3,'test','test'); /*Table structure for table `beian` */ DROP TABLE IF EXISTS `beian`; CREATE TABLE `beian` ( `beianid` int(10) NOT NULL, `beianname` varchar(20) default NULL, `beianmessage` varchar(255) default NULL, `beiantime` datetime default NULL, `beianren` varchar(20) default NULL, PRIMARY KEY (`beianid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `beian` */ insert into `beian`(`beianid`,`beianname`,`beianmessage`,`beiantime`,`beianren`) values (3001,'案例1','内容xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx','2021-10-06 16:20:22','王午'),(3002,'案例2','内容xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx','2021-10-04 16:36:46','张三'),(3003,'案例3','内容xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx','2022-03-11 15:38:44','张三'),(3004,'案例4','内容xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx','2022-03-19 17:11:12','张三'); /*Table structure for table `emerperson` */ DROP TABLE IF EXISTS `emerperson`; CREATE TABLE `emerperson` ( `emerid` varchar(10) collate utf8_bin NOT NULL, `username` varchar(10) collate utf8_bin NOT NULL, `password` varchar(20) collate utf8_bin NOT NULL, `sex` varchar(2) collate utf8_bin default NULL, `duty` varchar(100) collate utf8_bin default NULL, `phone` varchar(20) collate utf8_bin default NULL, `area` varchar(255) collate utf8_bin default NULL, `email` varchar(30) collate utf8_bin default NULL, `idnumber` varchar(30) collate utf8_bin default NULL, `comment` varchar(255) collate utf8_bin default NULL, `state` varchar(20) collate utf8_bin default '无任务', PRIMARY KEY (`emerid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `emerperson` */ insert into `emerperson`(`emerid`,`username`,`password`,`sex`,`duty`,`phone`,`area`,`email`,`idnumber`,`comment`,`state`) values ('10001','张三','123456','男','应急员','14925967342','中兴一街','[email protected]','123456789456789126','干了15年','已出勤'),('10002','李四','123456','女','应急员','14925967341','中兴一街','[email protected]','158456395245621856','干了2年','已出勤'),('10003','王五','123456','女','应急员','14925967345','中兴五街','[email protected]','123123123123123123','干了8年','无任务'),('10009','小七','asdf','男','技术员','14925967362','中兴二街','[email protected]','987654321456789123','无','无任务'),('10010','小三','adsf ','男','应急员','14925963342','中兴四街','[email protected]','123456789123456789','无','已出勤'),('1005','小六','asdf','男','指挥员','14925567342','中兴三街','[email protected]','123456789123456789','无','无任务'),('1007','张章','123456','女','应急员','14925967340','开元一大街','[email protected]','123456789987654321','熟悉救援流程','无任务'),('1008','张柳','123456','女','接听人员','14925927342','开元第三大街','[email protected]','123456789123456789','熟悉火灾救援流程','无任务'); /*Table structure for table `equipment` */ DROP TABLE IF EXISTS `equipment`; CREATE TABLE `equipment` ( `equid` int(10) NOT NULL, `equname` varchar(50) collate utf8_bin default NULL, `equstatus` varchar(20) collate utf8_bin default NULL, `equnumber` int(10) default NULL, `fuzeren` varchar(20) collate utf8_bin default NULL COMMENT '负责人', `phone` varchar(20) collate utf8_bin default NULL, `time` datetime default NULL, `weihuren` varchar(50) collate utf8_bin default NULL, PRIMARY KEY (`equid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `equipment` */ insert into `equipment`(`equid`,`equname`,`equstatus`,`equnumber`,`fuzeren`,`phone`,`time`,`weihuren`) values (1,'干粉灭火器','正常',20,'张','13838845721','2021-10-03 21:01:36','张三'),(2,'普通水枪','紧急维护',10,'李','13838845721','2021-10-03 21:01:36','小张'),(3,'二氧化碳灭火器','正常',10,'王','13838845721',NULL,'小王'),(4,'泡沫灭火器','正常',10,'赵','13838845721','2022-03-19 16:35:27','小六'),(5,'高压水枪','设备损坏',10,'孔','13838845721','2022-03-19 16:36:03','张琪'),(6,'发电机','正常',10,'齐','13529481289','2022-03-19 16:47:43','张三'),(7,'雨衣','正常',100,'刘','15612354264',NULL,NULL),(27,'高压水枪','正常',50,'武','16842568412','2022-03-04 00:00:00','张三'); /*Table structure for table `event` */ DROP TABLE IF EXISTS `event`; CREATE TABLE `event` ( `eventid` int(20) NOT NULL auto_increment COMMENT '事件编号', `etype` varchar(255) collate utf8_bin default NULL COMMENT '事件类型', `casualty` varchar(100) collate utf8_bin default NULL COMMENT '伤亡情况', `eventarea` varchar(100) collate utf8_bin default NULL COMMENT '事件地点', `policetime` datetime default NULL COMMENT '报警时间', `phone` varchar(20) collate utf8_bin default NULL COMMENT '联系方式', `policeman` varchar(20) collate utf8_bin default NULL COMMENT '报警人', `ischeck` varchar(20) collate utf8_bin default '否' COMMENT '是否审核', `checkreply` varchar(10) collate utf8_bin default '审核中' COMMENT '审核回复', `addtime` datetime default NULL COMMENT '添加时间', `jiejingtime` datetime default NULL, `sfcl` varchar(10) collate utf8_bin default '否', `emerid` int(10) default NULL COMMENT '应急员', `yuanid` int(10) default NULL COMMENT '预案', `beianid` int(10) default NULL COMMENT '备案', `sfpg` varchar(10) collate utf8_bin default '否' COMMENT '是否完成评估', `finishevent` varchar(10) collate utf8_bin default '否' COMMENT '完成时间', `sfyjya` varchar(10) collate utf8_bin default '否' COMMENT '是否启动应急预案', PRIMARY KEY (`eventid`) ) ENGINE=InnoDB AUTO_INCREMENT=300020 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `event` */ insert into `event`(`eventid`,`etype`,`casualty`,`eventarea`,`policetime`,`phone`,`policeman`,`ischeck`,`checkreply`,`addtime`,`jiejingtime`,`sfcl`,`emerid`,`yuanid`,`beianid`,`sfpg`,`finishevent`,`sfyjya`) values (300001,'暴雨','1人受伤','二七','2021-10-02 11:10:00','13939942615','小张','是','已出警','2022-03-11 00:00:00','2022-03-29 16:05:42','是',10001,2001,3002,'是','是','否'),(300002,'火灾','5人被困','中牟','2021-09-15 00:00:00','13939942616','小张','否','审核中','2021-09-15 00:00:00',NULL,'否',10009,2003,3002,'否','否','否'),(300003,'火灾','3人被困','塔沟A','2021-10-02 00:00:00','13939942618','王五','是','已出警','2022-03-15 00:00:00','2021-10-06 21:52:21','否',10003,2002,0,'否','否','否'),(300004,'泥石流','10人被困','本地A区','2021-10-02 21:04:04','13939942613','张小乐','否','审核中','2021-10-02 21:04:23',NULL,'否',0,0,NULL,'否','否','否'),(300007,'暴雨','3人被困','本地B区','2021-10-12 10:21:00','13939942612','张武','是','已出警','2021-10-03 15:51:27',NULL,'否',0,0,NULL,'否','否','否'),(300010,'�