基于SpringBoot的健身俱乐部会员管理系统的设计与实现.zip

/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 80100 Source Host : localhost:3306 Source Schema : hccch Target Server Type : MySQL Target Server Version : 80100 File Encoding : 65001 Date: 22/04/2024 21:29:41 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for card -- ---------------------------- DROP TABLE IF EXISTS `card`; CREATE TABLE `card` ( `card_id` int NOT NULL, `emp_id` int NULL DEFAULT NULL COMMENT '会员id', `card_number` int NULL DEFAULT NULL COMMENT '会员卡号', `card_create_date` datetime NULL DEFAULT NULL COMMENT '会员注册日期', `card_end_date` datetime NULL DEFAULT NULL COMMENT '会员截止日期', `card_recharge` int NULL DEFAULT NULL COMMENT '会员充值金额', `card_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '会员卡挂失', PRIMARY KEY (`card_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of card -- ---------------------------- INSERT INTO `card` VALUES (2, 2, 202310001, '2023-10-24 09:28:07', '2024-01-24 09:28:10', 8563, '2'); INSERT INTO `card` VALUES (3, 3, 202310002, '2023-10-24 09:28:07', '2024-10-24 09:28:10', 7944, '1'); INSERT INTO `card` VALUES (4, 4, 202310003, '2023-10-24 09:28:07', '2023-11-24 09:28:10', 3033, '2'); INSERT INTO `card` VALUES (5, 5, 202310004, '2023-10-24 09:28:07', '2024-10-24 09:28:10', 5139, '1'); INSERT INTO `card` VALUES (6, 6, 202310005, '2023-10-24 09:28:07', '2023-11-24 09:28:10', 4619, '1'); INSERT INTO `card` VALUES (7, 7, 202310006, '2023-10-24 09:28:07', '2024-10-24 09:28:10', 2012, '2'); INSERT INTO `card` VALUES (8, 8, 202310007, '2023-10-24 09:28:07', '2023-11-24 09:28:10', 800, '2'); INSERT INTO `card` VALUES (9, 9, 202310008, '2023-10-24 09:28:07', '2024-01-24 09:28:10', 3000, '1'); INSERT INTO `card` VALUES (10, 10, 202310009, '2023-10-24 09:28:07', '2023-11-24 09:28:10', 1211, '2'); INSERT INTO `card` VALUES (11, 19, 202310010, '2023-10-24 09:28:07', '2024-10-24 09:28:10', 4369, '1'); INSERT INTO `card` VALUES (12, 12, 202310011, '2023-10-24 09:28:07', '2023-11-24 09:28:10', 4369, '1'); INSERT INTO `card` VALUES (13, 13, 202310012, '2023-10-24 09:28:07', '2024-10-24 09:28:10', 4369, '1'); INSERT INTO `card` VALUES (14, 14, 202310013, '2023-10-24 09:28:07', '2024-01-24 09:28:10', 4369, '2'); INSERT INTO `card` VALUES (15, 15, 202310014, '2023-10-24 09:28:07', '2023-10-24 09:28:07', 1345, '1'); INSERT INTO `card` VALUES (16, 16, 202310015, '2023-10-24 09:42:35', '2023-11-24 09:42:49', 4545, '2'); INSERT INTO `card` VALUES (17, 17, 202310016, '2023-10-24 09:28:07', '2023-11-24 09:42:49', 5344, '1'); INSERT INTO `card` VALUES (18, 18, 202310017, '2023-10-24 09:28:07', '2023-11-24 09:42:49', 5344, '1'); INSERT INTO `card` VALUES (23102557, 23102557, 23102557, '2023-10-25 07:57:26', '2024-10-02 01:40:26', 4295, '1'); INSERT INTO `card` VALUES (23116452, 23116452, 23116452, '2023-11-06 08:45:23', '2024-11-06 00:12:43', 0, '1'); INSERT INTO `card` VALUES (23116504, 23116504, 23116504, '2023-11-06 08:50:41', '2024-11-06 00:05:40', 940, '1'); INSERT INTO `card` VALUES (24035471, 24035471, 24035471, '2024-03-05 08:47:12', '2025-03-05 00:15:52', 170, '2'); -- ---------------------------- -- Table structure for course -- ---------------------------- DROP TABLE IF EXISTS `course`; CREATE TABLE `course` ( `course_id` int NOT NULL AUTO_INCREMENT COMMENT '课程id', `course_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '课程姓名', `course_time` int NULL DEFAULT NULL COMMENT '课程时常', `course_recharge` int NULL DEFAULT NULL COMMENT '课程预约费用', `course_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '课程图片', PRIMARY KEY (`course_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of course -- ---------------------------- INSERT INTO `course` VALUES (1, '健身房力量训练课', 60, 60, 'D:\\hccch\\learn-system-project\\src\\assets\\course\\course1.jpg'); INSERT INTO `course` VALUES (2, '羽毛球基础训练课', 120, 100, 'D:\\hccch\\learn-system-project\\src\\assets\\course\\course5.jpg'); INSERT INTO `course` VALUES (3, '篮球战术实践课', 120, 60, 'D:\\hccch\\learn-system-project\\src\\assets\\course\\course3.jpg'); INSERT INTO `course` VALUES (4, '舞蹈基础教学课', 150, 100, 'D:\\hccch\\learn-system-project\\src\\assets\\course\\course7.jpg'); INSERT INTO `course` VALUES (5, '瑜伽动作教学课', 100, 100, 'D:\\hccch\\learn-system-project\\src\\assets\\course\\course9.jpg'); INSERT INTO `course` VALUES (6, '动感单车减脂课', 120, 100, 'D:\\hccch\\learn-system-project\\src\\assets\\course\\course6.jpg'); INSERT INTO `course` VALUES (11, '有氧舞蹈教学课', 120, 100, NULL); INSERT INTO `course` VALUES (12, '身体平衡训练课', 60, 80, NULL); INSERT INTO `course` VALUES (13, '健美操训练课', 90, 80, NULL); INSERT INTO `course` VALUES (14, '跳绳减脂暴瘦课', 120, 50, NULL); INSERT INTO `course` VALUES (15, '静态拉伸练习课程', 120, 50, NULL); -- ---------------------------- -- Table structure for dept -- ---------------------------- DROP TABLE IF EXISTS `dept`; CREATE TABLE `dept` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID', `d_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '部门名称', `create_time` datetime NOT NULL COMMENT '创建时间', `update_time` datetime NOT NULL COMMENT '修改时间', `custodian` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '管理人', `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '部门人数', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name`(`d_name` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of dept -- ---------------------------- INSERT INTO `dept` VALUES (1, '张瑞华', '2023-09-03 08:00:00', '2024-09-25 08:00:00', '李华', '13653585145'); INSERT INTO `dept` VALUES (2, '王梦瑶', '2023-09-23 08:00:00', '2024-09-12 08:00:00', '耳翁', '15535462123'); INSERT INTO `dept` VALUES (3, '刘志强', '2023-09-23 08:00:00', '2024-09-19 08:00:00', '魏武', '16635452156'); INSERT INTO `dept` VALUES (4, '程婷婷', '2023-09-25 08:00:00', '2023-09-25 08:00:00', '青蛙', '123542152156'); INSERT INTO `dept` VALUES (5, '孙阳', '2023-09-23 08:00:00', '2023-09-23 08:00:00', '球球', '25545452156'); INSERT INTO `dept` VALUES (6, '周昊', '2023-09-23 08:00:00', '2023-09-25 08:00:00', '小喜', '16645452156'); INSERT INTO `dept` VALUES (7, '谢雨琴', '2020-11-24 08:00:00', '2023-01-23 08:00:00', '塞俄', '14635452156'); INSERT INTO `dept` VALUES (8, '刘军', '2020-11-24 08:00:00', '2023-01-23 08:00:00', '巍峨', '16635452156'); INSERT INTO `dept` VALUES (9, '张武', '2001-12-20 08:00:00', '2023-12-30 08:00:00', '微微', '16635452156'); INSERT INTO `dept` VALUES (10, '何建军', '2001-11-22 08:00:00', '2003-11-22 08:00:00', '飒飒', '16635452156'); INSERT INTO `dept` VALUES (11, '王佳俊', '2003-01-22 08:00:00', '2006-01-03 08:00:00', '安安', '166354521566'); INSERT INTO `dept` VALUES (31, '李宗盛', '2023-10-11 08:00:00', '2023-10-19 08:00:00', '王企阀', '166354521566'); -- ---------------------------- -- Table structure for dept_emp -- ---------------------------- DROP TABLE IF EXISTS `dept_emp`; CREATE TABLE `dept_emp` ( ` id` in