javaweb课程设计基于SpringBoot养老院管理系统-毕业设计-源代码+初始化数据库脚本

/* Navicat Premium Data Transfer Source Server : 152.32.173.77 Source Server Type : MySQL Source Server Version : 50651 Source Host : 152.32.173.77:3316 Source Schema : bs_yly Target Server Type : MySQL Target Server Version : 50651 File Encoding : 65001 Date: 18/12/2022 20:22:08 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_admin -- ---------------------------- DROP TABLE IF EXISTS `tb_admin`; CREATE TABLE `tb_admin` ( `id` int(4) NOT NULL AUTO_INCREMENT, `username` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `password` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `realname` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `sex` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `age` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `address` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `tel` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `addtime` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `sf` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT '普通管理员', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_admin -- ---------------------------- INSERT INTO `tb_admin` VALUES (1, 'admin', '111', '陈道明', '男', '25', '成都市金牛区', '13900000000', '2016-03-09 22:59:56', '系统管理员'); INSERT INTO `tb_admin` VALUES (13, '13', '13', '13', '13', '13', '13', '13', '13', '13'); INSERT INTO `tb_admin` VALUES (14, '111', '111', '奥巴马', '男', '22', '洪山区珞喻路吴家湾', '13800000000', '2016-03-18 02:07:31', '普通管理员'); -- ---------------------------- -- Table structure for tb_admin_role -- ---------------------------- DROP TABLE IF EXISTS `tb_admin_role`; CREATE TABLE `tb_admin_role` ( `role_id` int(11) NOT NULL AUTO_INCREMENT, `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `system` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` int(11) NULL DEFAULT 0, `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(0), PRIMARY KEY (`role_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_admin_role -- ---------------------------- INSERT INTO `tb_admin_role` VALUES (1, '管理员', '', '', NULL, '2022-12-17 23:58:21', '2022-12-17 23:58:21'); -- ---------------------------- -- Table structure for tb_admin_user -- ---------------------------- DROP TABLE IF EXISTS `tb_admin_user`; CREATE TABLE `tb_admin_user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` int(8) NULL DEFAULT NULL, `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(0), PRIMARY KEY (`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_admin_user -- ---------------------------- INSERT INTO `tb_admin_user` VALUES (1, 'admin', 'admin', '123123', NULL, '', '2022-12-17 23:54:13', '2022-12-17 23:54:13'); -- ---------------------------- -- Table structure for tb_cw -- ---------------------------- DROP TABLE IF EXISTS `tb_cw`; CREATE TABLE `tb_cw` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sj` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cw` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for tb_functions -- ---------------------------- DROP TABLE IF EXISTS `tb_functions`; CREATE TABLE `tb_functions` ( `func_id` int(11) NOT NULL AUTO_INCREMENT, `func_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `func_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `parent_id` int(11) NULL DEFAULT 0, `status` int(8) NULL DEFAULT 0, `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(0), PRIMARY KEY (`func_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_functions -- ---------------------------- INSERT INTO `tb_functions` VALUES (1, '系统管理', '', 0, 0, '2022-12-18 14:03:36', '2022-12-18 14:03:36'); INSERT INTO `tb_functions` VALUES (2, '用户管理', '/adminUser/list', 1, 0, '2022-12-18 14:04:07', '2022-12-18 14:04:07'); INSERT INTO `tb_functions` VALUES (3, '用户-角色管理', '/userRole/list', 1, 0, '2022-12-19 04:04:59', '2022-12-19 04:04:59'); INSERT INTO `tb_functions` VALUES (4, ' 功能管理', '/function/list', 1, 0, '2022-12-18 00:07:19', '2022-12-18 00:07:19'); INSERT INTO `tb_functions` VALUES (5, '角色管理', '/adminRole/list', 1, 0, '2022-12-18 16:14:55', '2022-12-18 16:14:55'); INSERT INTO `tb_functions` VALUES (6, '角色-功能管理', '/roleFunction/list', 1, 0, '2022-12-18 16:15:41', '2022-12-18 16:15:41'); INSERT INTO `tb_functions` VALUES (7, '养老院', '', 0, 0, '2022-12-18 16:19:36', '2022-12-18 16:19:36'); INSERT INTO `tb_functions` VALUES (8, '费用管理', '/feiyong/list', 7, 0, '2022-12-18 16:24:31', '2022-12-18 16:24:31'); INSERT INTO `tb_functions` VALUES (9, '护工管理', '/hugong/list', 7, 0, '2022-12-18 16:24:57', '2022-12-18 16:24:57'); INSERT INTO `tb_functions` VALUES (10, '老人管理', '/lianxiren/list', 7, 0, '2022-12-19 06:25:19', '2022-12-19 06:25:19'); INSERT INTO `tb_functions` VALUES (11, '请假管理', '/qingjia/list', 7, 0, '2022-12-18 16:25:45', '2022-12-18 16:25:45'); INSERT INTO `tb_functions` VALUES (12, '事故管理', '/shigu/list', 7, 0, '2022-12-18 16:26:04', '2022-12-18 16:26:04'); INSERT INTO `tb_functions` VALUES (13, '薪资管理', '/xinzi/list', 7, 0, '2022-12-18 16:26:24', '2022-12-18 16:26:24'); INSERT INTO `tb_functions` VALUES (14, '床位管理', '/chuangwei/list', 7, 0, '2022-12-18 19:30:56', '2022-12-18 19:30:56'); -- ---------------------------- -- Table structure for tb_fy -- ---------------------------- DROP TABLE IF EXISTS `tb_fy`; CREATE TABLE `tb_fy` ( `id` int(4) NOT NULL AUTO_INCREMENT, `lr` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `fy` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `kc` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT N