Springboot+vue的医院固定资产管理系统 Javaee项目，springboot vue前后端分离项目

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 80031 Source Host : localhost:3306 Source Database : springbootd9y56 Target Server Type : MYSQL Target Server Version : 80031 File Encoding : 65001 Date: 2023-10-01 17:33:35 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for config -- ---------------------------- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='配置文件'; -- ---------------------------- -- Records of config -- ---------------------------- INSERT INTO `config` VALUES ('1', 'picture1', 'upload/picture1.jpg'); INSERT INTO `config` VALUES ('2', 'picture2', 'upload/picture2.jpg'); INSERT INTO `config` VALUES ('3', 'picture3', 'upload/picture3.jpg'); -- ---------------------------- -- Table structure for gudingzichan -- ---------------------------- DROP TABLE IF EXISTS `gudingzichan`; CREATE TABLE `gudingzichan` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `zichanbianma` varchar(200) DEFAULT NULL COMMENT '资产编码', `zichanmingcheng` varchar(200) NOT NULL COMMENT '资产名称', `zichanleixing` varchar(200) DEFAULT NULL COMMENT '资产类型', `zichantupian` varchar(200) NOT NULL COMMENT '资产图片', `zichandanjia` int NOT NULL COMMENT '资产单价', `zichanshuliang` int DEFAULT NULL COMMENT '资产数量', `zichanzongjia` varchar(200) DEFAULT NULL COMMENT '资产总价', `shiyongzhuangkuang` varchar(200) NOT NULL COMMENT '使用状况', `goumaishijian` date DEFAULT NULL COMMENT '购买时间', `zichanxiangqing` longtext COMMENT '资产详情', `guishushuoming` longtext COMMENT '归属说明', `shiyongmiaoshu` longtext COMMENT '使用描述', PRIMARY KEY (`id`), UNIQUE KEY `zichanbianma` (`zichanbianma`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3 COMMENT='固定资产'; -- ---------------------------- -- Records of gudingzichan -- ---------------------------- INSERT INTO `gudingzichan` VALUES ('21', '2023-05-27 17:12:18', '1111111111', '资产名称1', '资产类型1', 'upload/gudingzichan_zichantupian1.jpg', '1', '9', '资产总价1', '使用状况1', '2023-05-27', '资产详情1', '归属说明1', '使用描述1'); INSERT INTO `gudingzichan` VALUES ('22', '2023-05-27 17:12:18', '2222222222', '资产名称2', '资产类型2', 'upload/gudingzichan_zichantupian2.jpg', '2', '2', '资产总价2', '使用状况2', '2023-05-27', '资产详情2', '归属说明2', '使用描述2'); INSERT INTO `gudingzichan` VALUES ('23', '2023-05-27 17:12:18', '3333333333', '资产名称3', '资产类型3', 'upload/gudingzichan_zichantupian3.jpg', '3', '3', '资产总价3', '使用状况3', '2023-05-27', '资产详情3', '归属说明3', '使用描述3'); INSERT INTO `gudingzichan` VALUES ('24', '2023-05-27 17:12:18', '4444444444', '资产名称4', '资产类型4', 'upload/gudingzichan_zichantupian4.jpg', '4', '4', '资产总价4', '使用状况4', '2023-05-27', '资产详情4', '归属说明4', '使用描述4'); INSERT INTO `gudingzichan` VALUES ('25', '2023-05-27 17:12:18', '5555555555', '资产名称5', '资产类型5', 'upload/gudingzichan_zichantupian5.jpg', '5', '5', '资产总价5', '使用状况5', '2023-05-27', '资产详情5', '归属说明5', '使用描述5'); INSERT INTO `gudingzichan` VALUES ('26', '2023-05-27 17:12:18', '6666666666', '资产名称6', '资产类型6', 'upload/gudingzichan_zichantupian6.jpg', '6', '6', '资产总价6', '使用状况6', '2023-05-27', '资产详情6', '归属说明6', '使用描述6'); -- ---------------------------- -- Table structure for keshi -- ---------------------------- DROP TABLE IF EXISTS `keshi`; CREATE TABLE `keshi` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `keshihao` varchar(200) DEFAULT NULL COMMENT '科室号', `keshimingcheng` varchar(200) DEFAULT NULL COMMENT '科室名称', `mima` varchar(200) DEFAULT NULL COMMENT '密码', `yishengxingming` varchar(200) DEFAULT NULL COMMENT '医生姓名', `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话', PRIMARY KEY (`id`), UNIQUE KEY `keshihao` (`keshihao`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COMMENT='科室'; -- ---------------------------- -- Records of keshi -- ---------------------------- INSERT INTO `keshi` VALUES ('11', '2023-05-27 17:12:18', '科室号1', '科室名称1', '123456', '医生姓名1', '联系电话1'); INSERT INTO `keshi` VALUES ('12', '2023-05-27 17:12:18', '科室号2', '科室名称2', '123456', '医生姓名2', '联系电话2'); INSERT INTO `keshi` VALUES ('13', '2023-05-27 17:12:18', '科室号3', '科室名称3', '123456', '医生姓名3', '联系电话3'); INSERT INTO `keshi` VALUES ('14', '2023-05-27 17:12:18', '科室号4', '科室名称4', '123456', '医生姓名4', '联系电话4'); INSERT INTO `keshi` VALUES ('15', '2023-05-27 17:12:18', '科室号5', '科室名称5', '123456', '医生姓名5', '联系电话5'); INSERT INTO `keshi` VALUES ('16', '2023-05-27 17:12:18', '科室号6', '科室名称6', '123456', '医生姓名6', '联系电话6'); -- ---------------------------- -- Table structure for token -- ---------------------------- DROP TABLE IF EXISTS `token`; CREATE TABLE `token` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `userid` bigint NOT NULL COMMENT '用户id', `username` varchar(100) NOT NULL COMMENT '用户名', `tablename` varchar(100) DEFAULT NULL COMMENT '表名', `role` varchar(100) DEFAULT NULL COMMENT '角色', `token` varchar(200) NOT NULL COMMENT '密码', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COMMENT='token表'; -- ---------------------------- -- Records of token -- ---------------------------- INSERT INTO `token` VALUES ('1', '1', 'admin', 'users', '管理员', 'limddhl7djirstd4w4dpbzcwh2ko52nr', '2023-10-01 17:22:54', '2023-10-01 18:28:07'); INSERT INTO `token` VALUES ('2', '11', '科室号1', 'keshi', '科室', 'gu3j9lvua6vdp6i3n0vrnt89okr7t6so', '2023-10-01 17:25:21', '2023-10-01 18:30:15'); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `username` varchar(100) NOT NULL COMMENT '用户名', `password` varchar(100) NOT NULL COMMENT '密码', `role` varchar(100) DEFAULT '管理员' COMMENT '角色', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='用户表'; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES ('1', 'admin', 'admin', '管理员', '2023-05-27 17:12:18'); -- ---------------------------- -- Table structure for zichanchuku -- ---------------------------- DROP TABLE IF EXISTS `zichanchuku`; CREATE TABLE `zichanchuku` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `zichanbianma` varchar(200) DEFAULT NULL COMMENT '资产编码', `zichanmingcheng` varchar(200) NOT NULL COMMENT '资产名称', `zichanleixing` varchar(200) DEFAULT