/* Navicat Premium Data Transfer Source Server : local Source Server Type : MySQL Source Server Version : 80016 (8.0.16) Source Host : 127.0.0.1:13306 Source Schema : eas Target Server Type : MySQL Target Server Version : 80016 (8.0.16) File Encoding : 65001 Date: 08/09/2023 16:53:40 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for eas_arc_archives -- ---------------------------- DROP TABLE IF EXISTS `eas_arc_archives`; CREATE TABLE `eas_arc_archives` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `archive_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '文件电子档案号', `student_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '当前电子档案归属那一个学员档案下', `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '文件存储的路径', `arctype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '档案类型', `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '文件备注', `filetype` enum('other','attendance','scores','prefile','avatar') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '文件类型', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `validity_time` datetime NULL DEFAULT NULL COMMENT '档案有效期截至时间', `manager_id` int(11) NULL DEFAULT NULL COMMENT '档案归属负责人', `create_date` date NULL DEFAULT NULL COMMENT '档案创建时间, 用于文件归档用', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 202 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '文件档案表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_arc_archives -- ---------------------------- INSERT INTO `eas_arc_archives` VALUES (147, 'SAXB9BD493416974823732714', 'STXB9BD493436M202710212b5', 'C:\\Users\\lc/archivesFiles\\STXB9BD493436M202710212b5\\SAXB9BD493416974823732714.xlsx', 'XLSX', NULL, 'scores', '2023-09-01 13:31:50', '2023-09-01 13:31:50', '2025-05-01 08:00:00', 0, NULL, 0); INSERT INTO `eas_arc_archives` VALUES (148, 'SAX630A821316974823745314', 'STX630A821336M20261021224', 'C:\\Users\\lc/archivesFiles\\STX630A821336M20261021224\\SAX630A821316974823745314.xlsx', 'XLSX', NULL, 'scores', '2023-09-01 13:31:50', '2023-09-01 13:31:50', '2025-05-01 08:00:00', 0, NULL, 0); INSERT INTO `eas_arc_archives` VALUES (150, 'SAXCA7A837916974823757114', 'STXCA7A837920M20271021212', 'C:\\Users\\lc/archivesFiles\\STXCA7A837920M20271021212\\SAXCA7A837916974823757114.xlsx', 'XLSX', NULL, 'scores', '2023-09-01 13:31:51', '2023-09-01 13:31:51', '2025-05-01 08:00:00', 0, NULL, 0); INSERT INTO `eas_arc_archives` VALUES (151, 'SAXB9BD493416974823761014', 'STXB9BD493436M202710212b5', 'C:\\Users\\lc/archivesFiles\\STXB9BD493436M202710212b5\\SAXB9BD493416974823761014.xlsx', 'XLSX', NULL, 'attendance', '2023-09-01 13:31:51', '2023-09-01 13:31:51', '2025-05-01 08:00:00', 0, NULL, 0); INSERT INTO `eas_arc_archives` VALUES (152, 'SAX630A821316974823765514', 'STX630A821336M20261021224', 'C:\\Users\\lc/archivesFiles\\STX630A821336M20261021224\\SAX630A821316974823765514.xlsx', 'XLSX', NULL, 'attendance', '2023-09-01 13:31:51', '2023-09-01 13:31:51', '2025-05-01 08:00:00', 0, NULL, 0); INSERT INTO `eas_arc_archives` VALUES (154, 'SAXCA7A837916974823773014', 'STXCA7A837920M20271021212', 'C:\\Users\\lc/archivesFiles\\STXCA7A837920M20271021212\\SAXCA7A837916974823773014.xlsx', 'XLSX', NULL, 'attendance', '2023-09-01 13:31:51', '2023-09-01 13:31:51', '2025-05-01 08:00:00', 0, NULL, 0); INSERT INTO `eas_arc_archives` VALUES (155, 'SAXB9BD493416974823788615', 'STXB9BD493436M202710212b5', 'C:\\Users\\lc/archivesFiles\\STXB9BD493436M202710212b5\\SAXB9BD493416974823788615.docx', 'DOCX', NULL, 'prefile', NULL, '2023-09-01 13:31:52', '2028-09-01 13:31:52', NULL, '2023-09-01', 0); INSERT INTO `eas_arc_archives` VALUES (156, 'SAX630A821316974823794015', 'STX630A821336M20261021224', 'C:\\Users\\lc/archivesFiles\\STX630A821336M20261021224\\SAX630A821316974823794015.docx', 'DOCX', NULL, 'prefile', NULL, '2023-09-01 13:31:52', '2028-09-01 13:31:52', 1, '2023-09-01', 0); INSERT INTO `eas_arc_archives` VALUES (162, 'SAXCA7A837916974823805115', 'STXCA7A837920M20271021212', 'C:\\Users\\lc/archivesFiles\\STXCA7A837920M20271021212\\SAXCA7A837916974823805115.pdf', 'PDF', NULL, 'other', '2023-09-01 10:51:30', '2023-09-01 10:59:06', NULL, NULL, NULL, NULL); INSERT INTO `eas_arc_archives` VALUES (167, 'SAXD6E3367516987373344831', 'STXD6E3367536M2026102128b', 'C:\\Users\\lc/archivesFiles\\STXD6E3367536M2026102128b\\other\\SAXD6E3367516987373344831.jpg', 'IMAGE', '烦烦烦', 'other', '2023-09-05 00:38:41', '2023-09-05 00:38:41', NULL, 0, '2023-09-05', 0); INSERT INTO `eas_arc_archives` VALUES (168, 'SAXD6E3367516987396463313', 'STXD6E3367536M2026102128b', 'C:\\Users\\lc/archivesFiles\\STXD6E3367536M2026102128b\\other\\SAXD6E3367516987396463313.pptx', 'PPTX', 'pptx', 'other', '2023-09-05 00:48:01', '2023-09-05 00:48:01', NULL, 0, '2023-09-05', 0); INSERT INTO `eas_arc_archives` VALUES (169, 'SAXD6E3367516987398128043', 'STXD6E3367536M2026102128b', 'C:\\Users\\lc/archivesFiles\\STXD6E3367536M2026102128b\\other\\SAXD6E3367516987398128043.rar', 'RAR', 'rar', 'other', '2023-09-05 00:48:34', '2023-09-05 00:48:34', NULL, 0, '2023-09-05', 0); INSERT INTO `eas_arc_archives` VALUES (171, 'SAXF5FC7E3E16998192325015', 'STXF5FC7E3E36M20271021216', 'C:\\Users\\lc/archivesFiles\\STXF5FC7E3E36M20271021216\\SAXF5FC7E3E16998192325215.docx', 'DOCX', NULL, 'prefile', NULL, '2023-09-08 00:17:41', '2028-09-08 00:17:41', NULL, '2023-09-08', 1); INSERT INTO `eas_arc_archives` VALUES (172, 'SAX7203D17816998199899215', 'STX7203D17836M20271021216', 'C:\\Users\\lc/archivesFiles\\STX7203D17836M20271021216\\SAX7203D17816998199899315.docx', 'DOCX', NULL, 'prefile', NULL, '2023-09-08 00:20:42', '2028-09-08 00:20:42', NULL, '2023-09-08', 1); INSERT INTO `eas_arc_archives` VALUES (176, 'SAXCA7A837916998565840615', 'STXCA7A837920M20271021212', 'C:\\Users\\lc/archivesFiles\\STXCA7A837920M20271021212\\SAXCA7A837916998565840615.docx', 'DOCX', NULL, 'prefile', NULL, '2023-09-08 02:46:06', '2028-09-08 02:46:06', 1, '2023-09-08', 1); INSERT INTO `eas_arc_archives` VALUES (177, 'SAXCA7A837916998565813535', 'STXCA7A837920M20271021212', 'C:\\Users\\lc/archivesFiles\\STXCA7A837920M20271021212\\other\\SAXCA7A837916998565813535.png', 'IMAGE', '帅', 'avatar', '2023-09-08 02:46:07', '2023-09-08 02:46:07', '2025-05-08 00:00:00', 1, '2023-09-08', 1); INSERT INTO `eas_arc_archives` VALUES (198, 'SAXD6E3367516998834632436', 'STXD6E3367536M2026102128b', 'C:\\Users\\lc/archivesFiles\\STXD6E3367536M2026102128b\\other\\SAXD6E3367516998834632436.jpeg', 'IMAGE', NULL, 'avatar', '2023-09-08 04:32:57', '2023-09-08 04:32:57', '2025-05-08 00:00:00', 1, '2023-09-08', 1); INSERT INTO `eas_arc_archives` VALUES (199, 'SAXD6E3367516998840079014', 'STXD6E3367536M2026102128b', 'C:\\Users\\lc/archivesFiles\\STXD6E3367536M2026102128b\\SAXD6E3367516998840079014.xlsx', 'XLSX', NULL, 'scores', '2023-09-08 04:35:05', '2023-09-08 04:35:05', '2025-05-08 00:00:00', 1, NULL, 1); INSERT INTO `eas_arc_archives` VALUES (200, 'SAXD6E3367516998840086414', 'STXD6E3367536M2026102128b', 'C:\\Users\\lc/archivesFiles\\STXD6E3367536M2026102128b\\SAXD6E3367516998840086414.xlsx', 'XLSX', NULL, 'attendance', '2023-09-08 04:35:05', '2023-09-08 04:35:05', '2025-05-08 00:00:00', 1, NULL, 1); INSERT INTO `eas_arc_archives` VALUES (201, 'SAXD6E3367516998840091115', 'STXD6E3367536M2026102128b', 'C:\\Users\\lc/archivesFiles\\STXD6E3367536M2026102128b\\SAXD6E3367516998840091115.docx', 'DOCX', NULL, 'prefile', NULL, '2023-09-08 04:35:05', '2028-09-08 04:35:05', 1, '2023-09-08', 1); -- ---------------------------- -- Table structure for eas_arc_tls_attendance -- ---------------------------- DROP TABLE IF EXISTS `eas_arc_tls_attendance`; CREATE TABLE `eas_arc_tls_attendance` ( `id` bigint(10) UNSIGNED NOT NULL AUTO_INCREMENT, `checkin_date` date NULL DEFAULT NULL COMMENT '签到日期', `schedule_id` int(11) NULL DEFAULT NULL COMMENT '排课ID', `month` int(10) NULL DEFAULT NULL COMMENT '月份', `morning` enum('a','b','c','d','e') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'a 表示正常出勤, b 表示迟到、早退, c 表示旷课, d 表示请假, e表示无效', `afternoon` enum('a','b','c','d','e') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'a 表示正常出勤, b 表示迟到、早退, c 表示旷课, d 表示请假, e表示无效', `student_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学员姓名', `student_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学生档案号', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '出勤档案表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_arc_tls_attendance -- ---------------------------- INSERT INTO `eas_arc_tls_attendance` VALUES (1, '2023-08-25', 23, 8, 'b', 'b', '岁月', 'STXB9BD493436M202710212b5', 1, '2023-08-28 15:18:00', '2023-08-29 08:02:08'); INSERT INTO `eas_arc_tls_attendance` VALUES (2, '2023-08-25', 23, 8, 'd', 'c', '陈坤', 'STX630A821336M20261021224', 1, '2023-08-28 15:18:44', '2023-08-29 08:02:10'); INSERT INTO `eas_arc_tls_attendance` VALUES (3, '2023-08-25', 23, 8, 'c', 'e', '刘德华', 'STXD6E3367536M2026102128b', 1, '2023-08-28 17:23:00', '2023-08-29 08:02:11'); INSERT INTO `eas_arc_tls_attendance` VALUES (4, '2023-08-25', 24, 8, 'a', 'a', '岁月', 'STXB9BD493436M202710212b5', 1, '2023-08-29 16:29:13', '2023-08-29 16:29:13'); INSERT INTO `eas_arc_tls_attendance` VALUES (5, '2023-08-25', 24, 8, 'c', 'e', '陈坤', 'STX630A821336M20261021224', 1, '2023-08-29 16:33:34', '2023-08-29 16:33:34'); INSERT INTO `eas_arc_tls_attendance` VALUES (6, '2023-08-25', 24, 8, 'b', 'd', '刘德华', 'STXD6E3367536M2026102128b', 1, '2023-09-01 13:38:11', '2023-09-01 13:38:11'); INSERT INTO `eas_arc_tls_attendance` VALUES (7, '2023-08-26', 22, 8, 'c', 'c', '陈坤', 'STX630A821336M20261021224', 1, '2023-08-29 09:26:00', '2023-08-29 08:02:15'); INSERT INTO `eas_arc_tls_attendance` VALUES (8, '2023-08-26', 22, 8, 'd', 'a', '刘德华', 'STXD6E3367536M2026102128b', 1, '2023-08-29 09:26:00', '2023-08-29 08:02:18'); INSERT INTO `eas_arc_tls_attendance` VALUES (9, '2023-09-01', 22, 8, 'c', 'd', '武恒', 'STXCA7A837920M20271021212', 1, '2023-08-31 18:21:05', '2023-09-01 02:20:59'); INSERT INTO `eas_arc_tls_attendance` VALUES (10, '2023-09-08', 25, 9, 'a', 'b', '刘德华', 'STXD6E3367536M2026102128b', 3, '2023-09-07 14:16:16', '2023-09-08 03:18:26'); -- ---------------------------- -- Table structure for eas_arc_tls_scores -- ---------------------------- DROP TABLE IF EXISTS `eas_arc_tls_scores`; CREATE TABLE `eas_arc_tls_scores` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', `student_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '学员档案', `category_id` int(11) NOT NULL COMMENT '类目ID', `subject_id` int(11) NOT NULL COMMENT '科目ID', `test_date` datetime NOT NULL COMMENT '考试时间', `score` decimal(5, 2) NULL DEFAULT NULL COMMENT '分数', `pass_rate` decimal(5, 2) NULL DEFAULT NULL COMMENT '通过率', `excel_rate` decimal(5, 2) NULL DEFAULT NULL COMMENT '及格率', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '考试备注信息 如 第二次考试 第三次考试', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '学员成绩档案表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_arc_tls_scores -- ---------------------------- INSERT INTO `eas_arc_tls_scores` VALUES (2, 'STXB9BD493436M202710212b5', 1, 20, '2023-08-31 16:45:00', 122.00, NULL, NULL, '2023-08-31 16:46:16', '2023-08-31 16:46:16', NULL, '222222222222222'); INSERT INTO `eas_arc_tls_scores` VALUES (3, 'STXD6E3367536M2026102128b', 1, 12, '2023-08-31 16:53:00', 100.00, NULL, NULL, '2023-08-31 16:53:36', '2023-08-31 16:53:36', 0, '好好学习 天天向上'); INSERT INTO `eas_arc_tls_scores` VALUES (4, 'STX630A821336M20261021224', 1, 12, '2023-08-31 16:55:00', 90.00, NULL, NULL, '2023-08-31 16:55:58', '2023-08-31 08:59:07', 0, '继续努力'); INSERT INTO `eas_arc_tls_scores` VALUES (7, 'STXD6E3367536M2026102128b', 1, 20, '2023-08-31 17:07:47', 90.00, NULL, NULL, '2023-08-31 17:07:47', '2023-08-31 17:07:47', 0, '加油吧'); INSERT INTO `eas_arc_tls_scores` VALUES (8, 'STX630A821336M20261021224', 1, 20, '2023-08-31 18:27:01', 100.00, NULL, NULL, '2023-08-31 18:27:01', '2023-08-31 18:27:01', 1, '学的非常号'); INSERT INTO `eas_arc_tls_scores` VALUES (9, 'STXD6E3367536M2026102128b', 1, 16, '2023-09-01 13:39:00', 90.00, NULL, NULL, '2023-09-01 13:39:00', '2023-09-01 13:39:00', 1, '非常好'); -- ---------------------------- -- Table structure for eas_arc_tls_students -- ---------------------------- DROP TABLE IF EXISTS `eas_arc_tls_students`; CREATE TABLE `eas_arc_tls_students` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', `archive_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '对应的文件档案号', `student_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '归属的学员档案号', `student_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生姓名', `gender` enum('M','F') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生性别', `birthdate` date NOT NULL COMMENT '学生出生日期', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生居住地址', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生联系电话', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生电子邮箱', `enrollment_date` date NOT NULL COMMENT '学生入学进入培训班日期', `graduation_date` date NULL DEFAULT NULL COMMENT '学生在培训班毕业日期', `grade` int(11) NULL DEFAULT NULL COMMENT '学生年级', `major` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学生专业', `minor` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学生辅修专业', `university` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学生所在学校', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `admissions_id` int(11) NULL DEFAULT NULL COMMENT '招生老师', `manager_id` int(11) NULL DEFAULT NULL COMMENT '直属负责人ID', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `student_idnumber` varchar(18) CHARACTER SET armscii8 COLLATE armscii8_general_ci NOT NULL DEFAULT '' COMMENT '学生身份证号', `graduation` enum('Y','N') CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'N', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '学员基本信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_arc_tls_students -- ---------------------------- INSERT INTO `eas_arc_tls_students` VALUES (9, 'SA212619870230819153454315', 'STXB9BD493436M202710212b5', '岁月', 'M', '2023-08-24', '佳木斯', '13312341234', 'qq@qq.com', '2023-08-10', '2023-08-03', NULL, NULL, NULL, '黑龙江大学', NULL, '2023-09-01 06:52:36', 1, 1, NULL, '232126198703194770', 'N'); INSERT INTO `eas_arc_tls_students` VALUES (14, 'SA212619870230821175332815', 'STX630A821336M20261021224', '陈坤', 'M', '1987-02-20', '南岗区 128号', '13312341234', '123@qq.com', '2022-12-12', '2022-12-12', NULL, '计算机应用', '财会', '黑龙江大学', NULL, NULL, 1, 1, NULL, '232126198703194770', 'N'); INSERT INTO `eas_arc_tls_students` VALUES (16, 'SA212619870230822164322015', 'STXD6E3367536M2026102128b', '刘德华', 'M', '1987-02-20', '南岗区 128号', '13312341234', '123@qq.com', '2022-12-12', '2022-12-12', NULL, '计算机应用', '财会', '黑龙江大学', NULL, '2023-09-07 15:35:40', 1, 1, NULL, '232126198703194770', 'Y'); INSERT INTO `eas_arc_tls_students` VALUES (17, 'SA2126200302308281111160615', 'STXCA7A837920M20271021212', '武恒', 'F', '2023-08-28', '西大直街 118号', '15312344321', '112288@163.com', '2023-08-31', '2023-08-31', NULL, NULL, NULL, '黑龙江大学', NULL, '2023-09-07 20:12:00', 1, 1, NULL, '232126200303134770', 'N'); -- ---------------------------- -- Table structure for eas_edu_category -- ---------------------------- DROP TABLE IF EXISTS `eas_edu_category`; CREATE TABLE `eas_edu_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学科名称', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学科描述', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `disabled` enum('Y','N') CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name`(`name` ASC) USING BTREE, UNIQUE INDEX `id`(`id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '课程类别表 比如 前端 后端 大数据' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_edu_category -- ---------------------------- INSERT INTO `eas_edu_category` VALUES (1, '后端', '后端Java技术', '2023-08-22 10:42:00', '2023-08-22 10:42:00', NULL, 'N'); INSERT INTO `eas_edu_category` VALUES (2, '前端', '前端技术栈', '2023-08-30 13:53:25', '2023-08-30 13:53:25', NULL, 'N'); -- ---------------------------- -- Table structure for eas_edu_class -- ---------------------------- DROP TABLE IF EXISTS `eas_edu_class`; CREATE TABLE `eas_edu_class` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '班级ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '班级名称', `manage_id` int(11) NOT NULL COMMENT '班级负责人ID', `assistant_id` int(11) NULL DEFAULT NULL COMMENT '助教老师ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `disabled` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '班级表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_edu_class -- ---------------------------- INSERT INTO `eas_edu_class` VALUES (1, 'VIP21', 1, NULL, '2023-08-21 13:25:00', '2023-08-24 09:28:26', 1, 'N'); INSERT INTO `eas_edu_class` VALUES (3, 'VIP20', 2, NULL, '2023-08-21 23:52:44', '2023-08-21 23:52:44', 1, 'N'); INSERT INTO `eas_edu_class` VALUES (4, 'VIP21', 2, NULL, '2023-09-07 14:21:23', '2023-09-07 14:21:23', 2, 'N'); -- ---------------------------- -- Table structure for eas_edu_classroom -- ---------------------------- DROP TABLE IF EXISTS `eas_edu_classroom`; CREATE TABLE `eas_edu_classroom` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '教室名', `manager_id` int(11) NULL DEFAULT NULL COMMENT '教室负责人ID', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '教室所在地址', `manager` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '教室负责人', `floor` int(11) NULL DEFAULT 0 COMMENT '教室所在楼层', `capacity` int(11) NULL DEFAULT 0 COMMENT '教室的容量', `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注信息', `disabled` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '是否禁用', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '教室信息表\r\n' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_edu_classroom -- ---------------------------- INSERT INTO `eas_edu_classroom` VALUES (1, '哈特五楼', 1, '中央大街11号', NULL, 12, 20, '1到3楼不能坐电梯', 'N', '2023-08-22 03:17:00', '2023-08-22 11:29:32', 1); INSERT INTO `eas_edu_classroom` VALUES (2, '邮政4楼', 2, '南岗区邮政大街 608号', NULL, 40, 20, '附近不能停车', 'Y', '2023-08-22 11:31:00', '2023-08-28 10:10:33', 1); INSERT INTO `eas_edu_classroom` VALUES (3, '红旗家具城3楼', 1, '红旗大街 123号', NULL, 12, 22, '空 没有人', 'N', '2023-08-22 13:44:40', '2023-08-22 13:44:40', 1); -- ---------------------------- -- Table structure for eas_edu_clt_relation -- ---------------------------- DROP TABLE IF EXISTS `eas_edu_clt_relation`; CREATE TABLE `eas_edu_clt_relation` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `class_id` bigint(20) NOT NULL COMMENT '班级ID', `student_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '学员ID', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `type` enum('正式','旁听','留级','休学','暂停','其他') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '正式' COMMENT '类别', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '班级关联学员表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_edu_clt_relation -- ---------------------------- INSERT INTO `eas_edu_clt_relation` VALUES (90, 3, 16, '2023-08-28 10:07:55', NULL, 0, '正式'); INSERT INTO `eas_edu_clt_relation` VALUES (91, 3, 14, '2023-08-28 10:07:55', NULL, 0, '正式'); INSERT INTO `eas_edu_clt_relation` VALUES (92, 1, 16, '2023-08-28 10:08:00', '2023-08-28 02:08:45', 0, '旁听'); INSERT INTO `eas_edu_clt_relation` VALUES (93, 1, 14, '2023-08-28 10:08:00', '2023-08-28 02:08:50', 0, '留级'); INSERT INTO `eas_edu_clt_relation` VALUES (94, 1, 9, '2023-08-28 10:09:00', NULL, 0, '正式'); INSERT INTO `eas_edu_clt_relation` VALUES (95, 3, 17, '2023-08-31 18:16:02', '2023-09-06 08:16:55', 1, '旁听'); INSERT INTO `eas_edu_clt_relation` VALUES (96, 4, 17, '2023-09-07 14:34:48', NULL, 2, '正式'); -- ---------------------------- -- Table structure for eas_edu_schedule -- ---------------------------- DROP TABLE IF EXISTS `eas_edu_schedule`; CREATE TABLE `eas_edu_schedule` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `week` int(11) NULL DEFAULT NULL COMMENT '当周周几', `start_time` datetime NULL DEFAULT NULL COMMENT '起始时间', `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间', `room_id` int(11) NULL DEFAULT NULL COMMENT '教室ID', `class_id` int(11) NULL DEFAULT NULL COMMENT '班级ID', `assistant_id` int(11) NULL DEFAULT NULL COMMENT '助教ID', `teacher_id` int(11) NULL DEFAULT NULL COMMENT '教师ID', `category_id` int(11) NULL DEFAULT NULL COMMENT '授课类别', `subjects_id` int(11) NULL DEFAULT NULL COMMENT '授课内容', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `disabled` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `INDEX_SCHEDULE_START_TIME_TEACHER`(`start_time` ASC, `teacher_id` ASC, `room_id` ASC) USING BTREE COMMENT '教师同一个时间不能重复' ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '排课信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_edu_schedule -- ---------------------------- INSERT INTO `eas_edu_schedule` VALUES (22, 6, '2023-08-26 11:00:00', '2023-08-26 12:00:00', 2, 3, 1, 2, 1, 16, '2023-08-28 12:40:13', '2023-08-31 07:01:28', 0, 'N'); INSERT INTO `eas_edu_schedule` VALUES (24, 5, '2023-08-25 09:00:00', '2023-08-25 10:00:00', 3, 1, 2, 2, 1, 20, '2023-08-28 12:42:22', '2023-08-28 12:42:22', 0, 'N'); INSERT INTO `eas_edu_schedule` VALUES (25, 4, '2023-08-24 09:30:00', '2023-08-24 09:50:00', 1, 3, 1, 1, 1, 12, '2023-08-24 11:53:25', '2023-09-07 20:14:15', 0, 'N'); -- ---------------------------- -- Table structure for eas_edu_subjects -- ---------------------------- DROP TABLE IF EXISTS `eas_edu_subjects`; CREATE TABLE `eas_edu_subjects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学科名称', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学科描述', `category_id` int(11) NULL DEFAULT NULL COMMENT '学科分类', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `disabled` enum('Y','N') CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name`(`name` ASC) USING BTREE, UNIQUE INDEX `id`(`id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '科目表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_edu_subjects -- ---------------------------- INSERT INTO `eas_edu_subjects` VALUES (12, 'Java 基础', 'Java 基础', 1, '2023-08-01 14:23:00', '2023-08-30 06:29:35', NULL, 'N'); INSERT INTO `eas_edu_subjects` VALUES (13, 'Java 高级', 'Java 高级', 1, '2023-08-02 14:23:00', '2023-08-30 06:29:37', NULL, 'N'); INSERT INTO `eas_edu_subjects` VALUES (15, 'Java Spring', 'Java Spring', 1, '2023-08-04 14:23:00', '2023-08-30 06:29:40', NULL, 'N'); INSERT INTO `eas_edu_subjects` VALUES (16, 'Java Redis', 'Java Redis', 1, '2023-08-04 14:23:00', '2023-08-30 06:29:42', NULL, 'N'); INSERT INTO `eas_edu_subjects` VALUES (20, 'Java 微服务', 'Java 微服务', 1, '2023-08-05 14:23:00', '2023-08-30 06:29:45', NULL, 'N'); INSERT INTO `eas_edu_subjects` VALUES (22, 'React 技术栈', 'React 技术栈 全家桶', 2, '2023-08-30 14:42:27', '2023-08-30 14:42:27', NULL, 'N'); INSERT INTO `eas_edu_subjects` VALUES (23, 'Vue3 课程', 'Vue3 课程', 2, '2023-08-30 17:51:35', '2023-08-30 17:51:35', NULL, 'N'); INSERT INTO `eas_edu_subjects` VALUES (24, 'HTML 基础', 'HTML 基础', 2, '2023-08-31 18:24:57', '2023-08-31 18:24:57', NULL, 'N'); -- ---------------------------- -- Table structure for eas_sys_dep_relation -- ---------------------------- DROP TABLE IF EXISTS `eas_sys_dep_relation`; CREATE TABLE `eas_sys_dep_relation` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', `department_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '部门ID', `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID', `student_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '学员ID', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '部门和用户关系表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_sys_dep_relation -- ---------------------------- INSERT INTO `eas_sys_dep_relation` VALUES (1, 1, 1, 0, '2023-07-28 08:38:41', 1); INSERT INTO `eas_sys_dep_relation` VALUES (3, 3, 3, 0, '2023-09-07 06:13:57', 1); INSERT INTO `eas_sys_dep_relation` VALUES (11, 2, 2, 0, NULL, 1); INSERT INTO `eas_sys_dep_relation` VALUES (18, 4, 0, 17, NULL, 1); INSERT INTO `eas_sys_dep_relation` VALUES (19, 4, 0, 14, NULL, 1); INSERT INTO `eas_sys_dep_relation` VALUES (20, 4, 0, 9, NULL, 1); -- ---------------------------- -- Table structure for eas_sys_department -- ---------------------------- DROP TABLE IF EXISTS `eas_sys_department`; CREATE TABLE `eas_sys_department` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `depname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '部门名称', `authority` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '权限名', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '部门地址', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '部门电话', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '部门电子邮箱', `manager` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '部门负责人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `disabled` enum('Y','N') CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `depname`(`depname` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_sys_department -- ---------------------------- INSERT INTO `eas_sys_department` VALUES (1, '系统开发组', 'admin', '哈特大厦6楼', NULL, NULL, NULL, '2023-09-07 06:12:00', '2023-09-07 15:15:00', NULL, 'N'); INSERT INTO `eas_sys_department` VALUES (2, '教务管理组', 'easgroup', '哈特大厦6楼', NULL, NULL, NULL, '2023-08-22 10:42:00', '2023-09-07 06:12:58', 1, 'N'); INSERT INTO `eas_sys_department` VALUES (3, '教学讲师组', 'teacher', '中国 黑龙江省 哈尔滨市 南岗区', NULL, NULL, NULL, '2023-07-28 08:51:00', '2023-09-07 17:19:09', 1, 'N'); INSERT INTO `eas_sys_department` VALUES (4, '爱扣订学员', 'student', '哈特大厦6楼', NULL, NULL, NULL, '2023-09-05 02:06:03', '2023-09-07 06:12:56', 1, 'N'); -- ---------------------------- -- Table structure for eas_sys_logs -- ---------------------------- DROP TABLE IF EXISTS `eas_sys_logs`; CREATE TABLE `eas_sys_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增的主键', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录日志的时间戳', `level` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '日志级别', `logger` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '记录日志的代码名称或类名', `message` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '日志信息', `exception` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '如果日志记录了异常信息，可以将其存储在此列中', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '系统日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_sys_logs -- ---------------------------- -- ---------------------------- -- Table structure for eas_sys_student -- ---------------------------- DROP TABLE IF EXISTS `eas_sys_student`; CREATE TABLE `eas_sys_student` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `student_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学员档案号', `student_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生姓名', `gender` enum('M','F') CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学生性别', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学生联系电话', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学生电子邮箱', `enrollment_date` date NULL DEFAULT NULL COMMENT '学生入学日期', `passwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学生密码', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学员头像', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `admissions_id` int(11) NULL DEFAULT NULL COMMENT '招生老师', `manager_id` int(11) NULL DEFAULT NULL COMMENT '直属负责人ID', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `disabled` enum('Y','N') CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '学员基本信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_sys_student -- ---------------------------- INSERT INTO `eas_sys_student` VALUES (9, 'STXB9BD493436M202710212b5', '岁月', 'M', '13312341234', 'qq@qq.com', '2023-08-10', '$2a$10$xX7HrI4MdOUhhZ1sF0djzeEw0mpAWail8jbK8ptE9VWVwsXv.fSta', '占位图片.jpg', NULL, '2023-09-07 08:05:40', 1, 1, 1, 'N'); INSERT INTO `eas_sys_student` VALUES (14, 'STX630A821336M20261021224', '陈坤', 'M', '13312341234', '123@qq.com', '2022-12-12', '$2a$10$QOEK92mCzZZ8DACPv8Tb4ekc9uQlfchEXcowM/aJZrJ90kJOAtSP2', '占位图片.jpg', NULL, '2023-08-24 08:55:24', 1, 1, 1, 'N'); INSERT INTO `eas_sys_student` VALUES (16, 'STXD6E3367536M2026102128b', '刘德华', 'M', '13312341234', '123@qq.com', '2022-12-12', '$2a$10$NckqU0xLqWWbppDEKJ04cutdtxL2N2E3loZbDmG8tmSp4irFVAtty', 'C:\\Users\\lc/archivesCache\\STXD6E3367536M2026102128b\\SAXD6E3367516998834632436.jpeg', NULL, '2023-09-07 20:32:54', 1, 1, 1, 'N'); INSERT INTO `eas_sys_student` VALUES (17, 'STXCA7A837920M20271021212', '武恒', 'F', '15312344321', '112288@163.com', '2023-08-31', '$2a$10$8gYhWz7JoAmPtnLdW0E.eeGYDvxdcIBD568f8d0L3aR4Kb2jxY43m', 'C:\\Users\\lc/archivesFiles\\STXCA7A837920M20271021212\\other\\SAXCA7A837916998565813535.png', NULL, '2023-09-07 18:46:05', 1, 1, 1, 'N'); -- ---------------------------- -- Table structure for eas_sys_university -- ---------------------------- DROP TABLE IF EXISTS `eas_sys_university`; CREATE TABLE `eas_sys_university` ( `university_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '大学编码', `university_title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '学校名', PRIMARY KEY (`university_code`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of eas_sys_university -- ---------------------------- -- ---------------------------- -- Table structure for eas_sys_userinfo -- ---------------------------- DROP TABLE IF EXISTS `eas_sys_userinfo`; CREATE TABLE `eas_sys_userinfo` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户名', `passwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '电子邮件', `relname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '姓名', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '电话', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '地址', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modify_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_uid` int(11) NULL DEFAULT NULL COMMENT '创建用户ID', `disabled` enum('Y','N') CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `username`(`username` ASC) USING BTREE, UNIQUE INDEX `email`(`email` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of eas_sys_userinfo -- ---------------------------- INSERT INTO `eas_sys_userinfo` VALUES (1, 'admin', '$2a$10$SEw8IaWh7.3NO1snYSNQEubQfK67Ir/qhawST9uzTEaAuQetbt/qu', 'dev@edu.koobietech.com', '爱扣钉', '13836159637', '朗威大厦', '2023-07-28 08:38:00', '2023-09-07 17:04:39', 1, 'N'); INSERT INTO `eas_sys_userinfo` VALUES (2, 'wangyan', '$2a$10$yPKOK3GuSuvaUQ0SwEhMXeXoWGpftLEEXX5CRB5REP0CRSKql.44O', 'wangyan@qq.com', '王雁', '13366613570', NULL, '2023-09-07 14:05:22', '2023-09-07 12:26:00', 1, 'N'); INSERT INTO `eas_sys_userinfo` VALUES (3, 'chenchen', '$2a$10$DEi4cj4Sg6ruGkLmDWV7cO7AK2XzJO.6J2VfVZgyMGVyhrmfCars2', 'chenchen@qq.com', '陈晨', '13366613579', NULL, '2023-09-07 14:05:43', '2023-09-07 12:26:02', 1, 'N'); -- ---------------------------- -- View structure for eas_sys_roleusers -- ---------------------------- DROP VIEW IF EXISTS `eas_sys_roleusers`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `eas_sys_roleusers` AS select `eas_sys_userinfo`.`id` AS `id`,'用户' AS `type`,`eas_sys_userinfo`.`relname` AS `username` from `eas_sys_userinfo` where (`eas_sys_userinfo`.`disabled` = 'N') union all select `eas_sys_student`.`id` AS `id`,'学生' AS `type`,`eas_sys_student`.`student_name` AS `username` from `eas_sys_student` where (`eas_sys_student`.`disabled` = 'N'); SET FOREIGN_KEY_CHECKS = 1;