userclass/UserclassService
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
UserclassService/sqlscript/dbschoolclass.sql
T
Allen 66cd0f1515 refactor: 项目重构为 bschclassmanage 包结构，修复启动/CORS/路由问题 
- 根包 com.bestsch.classicalchinese 重命名为 com.bestsch.bschclassmanage
- 修复 CORS 启动失败：allowCredentials=true 时 allowedOrigins 不能含 "*"，
  23 个 Controller 的 @CrossOrigin 改用语义等价的 originPatterns
- 修复 /api/* 与 /oapi/* 接口 404：API_PATH/OAPI 常量去掉尾斜杠，
  消除 Spring Boot 2.7 PathPattern 下的双斜杠(/api//subject/) 导致的匹配失败
- UserSysRoleArgumentResolver 增加从 URL 参数 currentrole 回退解析(便于本地调试)，
  原请求头 currentrole 注入方式保持不变
2026-08-12 16:59:57 +08:00

501 lines
30 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
/*
Navicat Premium Data Transfer
Source Server : 本地
Source Server Type : MySQL
Source Server Version : 80044
Source Host : localhost:3306
Source Schema : dbschoolclass
Target Server Type : MySQL
Target Server Version : 80044
File Encoding : 65001
Date: 17/06/2026 10:30:52
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for base_dic_grade
-- ----------------------------
DROP TABLE IF EXISTS `base_dic_grade`;
CREATE TABLE `base_dic_grade` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`code` int(0) NULL DEFAULT NULL COMMENT '年级编码',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '年级名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of base_dic_grade
-- ----------------------------
INSERT INTO `base_dic_grade` VALUES (1, 1, '一年级');
INSERT INTO `base_dic_grade` VALUES (2, 2, '二年级');
INSERT INTO `base_dic_grade` VALUES (3, 3, '三年级');
INSERT INTO `base_dic_grade` VALUES (4, 4, '四年级');
INSERT INTO `base_dic_grade` VALUES (5, 5, '五年级');
INSERT INTO `base_dic_grade` VALUES (6, 6, '六年级');
INSERT INTO `base_dic_grade` VALUES (7, 7, '初一');
INSERT INTO `base_dic_grade` VALUES (8, 8, '初二');
INSERT INTO `base_dic_grade` VALUES (9, 9, '初三');
INSERT INTO `base_dic_grade` VALUES (10, 10, '高一');
INSERT INTO `base_dic_grade` VALUES (11, 11, '高二');
INSERT INTO `base_dic_grade` VALUES (12, 12, '高三');
INSERT INTO `base_dic_grade` VALUES (13, -4, '幼托');
INSERT INTO `base_dic_grade` VALUES (14, -3, '幼小');
INSERT INTO `base_dic_grade` VALUES (15, -2, '幼中');
INSERT INTO `base_dic_grade` VALUES (16, -1, '幼大');
-- ----------------------------
-- Table structure for base_dic_subject
-- ----------------------------
DROP TABLE IF EXISTS `base_dic_subject`;
CREATE TABLE `base_dic_subject` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编码',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
`sort` int(0) NULL DEFAULT NULL COMMENT '序号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of base_dic_subject
-- ----------------------------
INSERT INTO `base_dic_subject` VALUES (1, 'SUB01', '语文', 1);
INSERT INTO `base_dic_subject` VALUES (2, 'SUB02', '数学', 2);
INSERT INTO `base_dic_subject` VALUES (3, 'SUB03', '英语', 3);
INSERT INTO `base_dic_subject` VALUES (4, 'SUB04', '物理', 4);
INSERT INTO `base_dic_subject` VALUES (5, 'SUB05', '化学', 5);
INSERT INTO `base_dic_subject` VALUES (6, 'SUB06', '生物', 6);
INSERT INTO `base_dic_subject` VALUES (7, 'SUB07', '历史', 7);
INSERT INTO `base_dic_subject` VALUES (8, 'SUB08', '地理', 8);
INSERT INTO `base_dic_subject` VALUES (9, 'SUB09', '政治', 9);
INSERT INTO `base_dic_subject` VALUES (10, 'SUB10', '艺术', 10);
INSERT INTO `base_dic_subject` VALUES (11, 'SUB11', '体育', 11);
INSERT INTO `base_dic_subject` VALUES (12, 'SUB12', '心理', 12);
INSERT INTO `base_dic_subject` VALUES (13, 'SUB13', '信息', 13);
INSERT INTO `base_dic_subject` VALUES (14, 'SUB14', '劳技', 14);
INSERT INTO `base_dic_subject` VALUES (15, 'SUB15', '跨学科', 15);
INSERT INTO `base_dic_subject` VALUES (16, 'SUB16', '美术', 16);
INSERT INTO `base_dic_subject` VALUES (17, 'SUB17', '音乐', 17);
-- ----------------------------
-- Table structure for base_sch_system
-- ----------------------------
DROP TABLE IF EXISTS `base_sch_system`;
CREATE TABLE `base_sch_system` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称 ',
`academic_stage` int(0) NULL DEFAULT NULL COMMENT '学段（0学前 1小学 2初中 3高中 4高等）',
`start_grade_code` int(0) NULL DEFAULT NULL COMMENT '开班年级编码',
`end_grade_code` int(0) NULL DEFAULT NULL COMMENT '毕业年级编码',
`graduation_leng` int(0) NULL DEFAULT NULL COMMENT '毕业年长度',
`type` int(0) NULL DEFAULT NULL COMMENT '类型（1学前教育 2职业教育）',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of base_sch_system
-- ----------------------------
INSERT INTO `base_sch_system` VALUES (1, '学前教育', 0, -3, -1, 3, 1);
INSERT INTO `base_sch_system` VALUES (2, '学前4年', 0, -4, -1, 4, 1);
INSERT INTO `base_sch_system` VALUES (3, '小学六年', 1, 1, 6, 6, 1);
INSERT INTO `base_sch_system` VALUES (4, '小学五年', 1, 1, 5, 5, 1);
INSERT INTO `base_sch_system` VALUES (5, '初中三年', 2, 7, 9, 3, 1);
INSERT INTO `base_sch_system` VALUES (6, '初中四年', 2, 6, 9, 4, 1);
INSERT INTO `base_sch_system` VALUES (7, '九年一贯制', 2, 1, 9, 9, 1);
INSERT INTO `base_sch_system` VALUES (8, '高中三年', 3, 10, 12, 3, 1);
INSERT INTO `base_sch_system` VALUES (9, '初高中七年制', 3, 6, 12, 7, 1);
INSERT INTO `base_sch_system` VALUES (10, '职高', 3, 0, 0, 3, 2);
INSERT INTO `base_sch_system` VALUES (11, '\r\n专科三年制', 4, 0, 0, 3, 2);
INSERT INTO `base_sch_system` VALUES (12, '\r\n专科五年制', 4, 0, 0, 5, 2);
-- ----------------------------
-- Table structure for base_sch_system_grade
-- ----------------------------
DROP TABLE IF EXISTS `base_sch_system_grade`;
CREATE TABLE `base_sch_system_grade` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`grade_id` int(0) NULL DEFAULT NULL COMMENT '年级id',
`grade_nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '年级别名',
`sch_system_id` int(0) NULL DEFAULT NULL COMMENT '学制id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of base_sch_system_grade
-- ----------------------------
INSERT INTO `base_sch_system_grade` VALUES (1, -3, '幼小', 1);
INSERT INTO `base_sch_system_grade` VALUES (2, -2, '幼中', 1);
INSERT INTO `base_sch_system_grade` VALUES (3, -1, '幼大', 1);
INSERT INTO `base_sch_system_grade` VALUES (4, -4, '幼托', 2);
INSERT INTO `base_sch_system_grade` VALUES (5, -3, '幼小', 2);
INSERT INTO `base_sch_system_grade` VALUES (6, -2, '幼中', 2);
INSERT INTO `base_sch_system_grade` VALUES (7, -1, '幼大', 2);
INSERT INTO `base_sch_system_grade` VALUES (8, 1, '小一', 3);
INSERT INTO `base_sch_system_grade` VALUES (9, 2, '小二', 3);
INSERT INTO `base_sch_system_grade` VALUES (10, 3, '小三', 3);
INSERT INTO `base_sch_system_grade` VALUES (11, 4, '小四', 3);
INSERT INTO `base_sch_system_grade` VALUES (12, 5, '小五', 3);
INSERT INTO `base_sch_system_grade` VALUES (13, 6, '小六', 3);
INSERT INTO `base_sch_system_grade` VALUES (14, 1, '小一', 4);
INSERT INTO `base_sch_system_grade` VALUES (15, 2, '小二', 4);
INSERT INTO `base_sch_system_grade` VALUES (16, 3, '小三', 4);
INSERT INTO `base_sch_system_grade` VALUES (17, 4, '小四', 4);
INSERT INTO `base_sch_system_grade` VALUES (18, 5, '小五', 4);
INSERT INTO `base_sch_system_grade` VALUES (19, 7, '初一', 5);
INSERT INTO `base_sch_system_grade` VALUES (20, 8, '初二', 5);
INSERT INTO `base_sch_system_grade` VALUES (21, 9, '初三', 5);
INSERT INTO `base_sch_system_grade` VALUES (22, 6, '预备', 6);
INSERT INTO `base_sch_system_grade` VALUES (23, 7, '初一', 6);
INSERT INTO `base_sch_system_grade` VALUES (24, 8, '初二', 6);
INSERT INTO `base_sch_system_grade` VALUES (25, 9, '初三', 6);
INSERT INTO `base_sch_system_grade` VALUES (26, 1, '小一', 7);
INSERT INTO `base_sch_system_grade` VALUES (27, 2, '小二', 7);
INSERT INTO `base_sch_system_grade` VALUES (28, 3, '小三', 7);
INSERT INTO `base_sch_system_grade` VALUES (29, 4, '小四', 7);
INSERT INTO `base_sch_system_grade` VALUES (30, 5, '小五', 7);
INSERT INTO `base_sch_system_grade` VALUES (31, 6, '小六', 7);
INSERT INTO `base_sch_system_grade` VALUES (32, 7, '初一', 7);
INSERT INTO `base_sch_system_grade` VALUES (33, 8, '初二', 7);
INSERT INTO `base_sch_system_grade` VALUES (34, 9, '初三', 7);
INSERT INTO `base_sch_system_grade` VALUES (35, 10, '高一', 8);
INSERT INTO `base_sch_system_grade` VALUES (36, 11, '高二', 8);
INSERT INTO `base_sch_system_grade` VALUES (37, 12, '高三', 8);
INSERT INTO `base_sch_system_grade` VALUES (38, 6, '预备', 9);
INSERT INTO `base_sch_system_grade` VALUES (39, 7, '初一', 9);
INSERT INTO `base_sch_system_grade` VALUES (40, 8, '初二', 9);
INSERT INTO `base_sch_system_grade` VALUES (41, 9, '初三', 9);
INSERT INTO `base_sch_system_grade` VALUES (42, 10, '高一', 9);
INSERT INTO `base_sch_system_grade` VALUES (43, 11, '高二', 9);
INSERT INTO `base_sch_system_grade` VALUES (44, 12, '高三', 9);
-- ----------------------------
-- Table structure for base_year_term
-- ----------------------------
DROP TABLE IF EXISTS `base_year_term`;
CREATE TABLE `base_year_term` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`year` int(0) NULL DEFAULT NULL COMMENT '学年',
`year_start_date` date NULL DEFAULT NULL COMMENT '学年开始日期',
`year_end_date` date NULL DEFAULT NULL COMMENT '学年结束日期',
`first_term_start_date` date NULL DEFAULT NULL COMMENT '第一学期开始日期',
`first_term_end_date` date NULL DEFAULT NULL COMMENT '第一学期结束日期',
`second_term_start_date` date NOT NULL COMMENT '第二学期开始日期',
`second_term_end_date` date NULL DEFAULT NULL COMMENT '第二学期结束日期',
`upgrade_date` date NULL DEFAULT NULL COMMENT '毕业时间',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改日期',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`, `second_term_start_date`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of base_year_term
-- ----------------------------
INSERT INTO `base_year_term` VALUES (1, 2025, '2025-09-01', '2026-07-10', '2025-09-01', '2026-01-15', '2026-02-20', '2026-07-05', '2026-07-15', '2026-06-15 10:11:06', NULL, 100000, NULL);
INSERT INTO `base_year_term` VALUES (2, 2024, '2024-09-01', '2025-07-10', '2024-09-01', '2025-01-15', '2025-02-20', '2025-07-05', '2025-07-15', '2026-06-15 10:19:53', NULL, 100000, NULL);
INSERT INTO `base_year_term` VALUES (3, 2023, '2023-09-01', '2024-07-10', '2023-09-01', '2024-01-15', '2024-02-20', '2024-07-05', '2024-07-15', '2026-06-15 10:20:58', NULL, 100000, NULL);
INSERT INTO `base_year_term` VALUES (4, 2022, '2022-09-01', '2023-07-10', '2022-09-01', '2023-01-15', '2023-02-20', '2023-07-05', '2023-07-15', '2026-06-15 10:21:51', NULL, 100000, NULL);
INSERT INTO `base_year_term` VALUES (5, 2021, '2021-09-01', '2022-07-10', '2021-09-01', '2022-01-15', '2022-02-20', '2022-07-05', '2022-07-15', '2026-06-15 10:22:00', NULL, 100000, NULL);
INSERT INTO `base_year_term` VALUES (6, 2020, '2020-09-01', '2021-07-10', '2020-09-01', '2021-01-15', '2021-02-20', '2021-07-05', '2021-07-15', '2026-06-15 10:23:22', NULL, 100000, NULL);
-- ----------------------------
-- Table structure for sch_bin_sch_system
-- ----------------------------
DROP TABLE IF EXISTS `sch_bin_sch_system`;
CREATE TABLE `sch_bin_sch_system` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`sch_system_id` int(0) NOT NULL COMMENT '学制id',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sch_bin_sch_system
-- ----------------------------
INSERT INTO `sch_bin_sch_system` VALUES (5, 6, 3260, '2026-06-11 15:21:34', 100000, '2026-06-11 15:21:34', 100000);
INSERT INTO `sch_bin_sch_system` VALUES (6, 8, 3260, '2026-06-11 15:21:34', 100000, '2026-06-11 15:21:34', 100000);
-- ----------------------------
-- Table structure for sch_class
-- ----------------------------
DROP TABLE IF EXISTS `sch_class`;
CREATE TABLE `sch_class` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`code` int(10) UNSIGNED ZEROFILL NULL DEFAULT NULL COMMENT '编码',
`grade_id` int(0) NULL DEFAULT NULL COMMENT '年级id',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
`cname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '别称',
`group_class_id` int(0) UNSIGNED NOT NULL COMMENT '班级组id',
`group_grade_id` int(0) NOT NULL COMMENT '年级组id',
`first_teacher_id` int(0) NULL DEFAULT NULL COMMENT '班主任',
`second_teacher_id` int(0) NULL DEFAULT NULL COMMENT '副班主任',
`campus_id` int(0) NULL DEFAULT NULL COMMENT '校区',
`division_id` int(0) NULL DEFAULT NULL COMMENT '系部',
`majors_id` int(0) NULL DEFAULT NULL COMMENT '专业',
`graduate` bit(1) NULL DEFAULT NULL COMMENT '毕业',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改日期',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sch_class_teach
-- ----------------------------
DROP TABLE IF EXISTS `sch_class_teach`;
CREATE TABLE `sch_class_teach` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`grade_id` int(0) NULL DEFAULT NULL COMMENT '年级id',
`class_id` int(0) NULL DEFAULT NULL COMMENT '班级id',
`sub_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学科id',
`tea_id` int(0) NULL DEFAULT NULL COMMENT '教师id',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改日期',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sch_dic_campus
-- ----------------------------
DROP TABLE IF EXISTS `sch_dic_campus`;
CREATE TABLE `sch_dic_campus` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '校区',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`sort` int(0) NULL DEFAULT NULL COMMENT '序号',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '编辑日期',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '编辑用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sch_dic_campus
-- ----------------------------
INSERT INTO `sch_dic_campus` VALUES (1, '新渔区', 3260, 2, '2026-06-16 10:06:49', 209169, '2026-06-16 10:10:47', 209169);
INSERT INTO `sch_dic_campus` VALUES (2, '名宿区', 3260, 1, '2026-06-16 10:08:08', 209169, '2026-06-16 10:10:47', 209169);
-- ----------------------------
-- Table structure for sch_dic_course
-- ----------------------------
DROP TABLE IF EXISTS `sch_dic_course`;
CREATE TABLE `sch_dic_course` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编码',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程名称',
`nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '别名',
`type` int(0) NULL DEFAULT NULL COMMENT '类型（1基础课程 2选修课程 3专业课程）',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sch_dic_course
-- ----------------------------
INSERT INTO `sch_dic_course` VALUES (1, 'MATH101', '高等数学', '高数', 3, 3260, '2026-06-16 22:11:35', '2026-06-17 00:40:54', 209169, 209169);
INSERT INTO `sch_dic_course` VALUES (2, 'MATH102', '就业指导', NULL, 1, 3260, '2026-06-16 22:29:21', '2026-06-17 00:39:55', 209169, 209169);
INSERT INTO `sch_dic_course` VALUES (3, 'MATH103', '中餐冷菜制作', NULL, 2, 3260, '2026-06-16 22:30:02', '2026-06-17 00:39:15', 209169, 209169);
INSERT INTO `sch_dic_course` VALUES (4, NULL, '计算机应用基础', NULL, 1, 3260, '2026-06-16 22:30:17', '2026-06-16 22:30:17', 209169, 209169);
-- ----------------------------
-- Table structure for sch_dic_course_division
-- ----------------------------
DROP TABLE IF EXISTS `sch_dic_course_division`;
CREATE TABLE `sch_dic_course_division` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`course_id` int(0) NULL DEFAULT NULL,
`division_id` int(0) NULL DEFAULT NULL,
`sch_id` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sch_dic_course_division
-- ----------------------------
INSERT INTO `sch_dic_course_division` VALUES (3, 3, 5, 3260);
INSERT INTO `sch_dic_course_division` VALUES (4, 3, 6, 3260);
INSERT INTO `sch_dic_course_division` VALUES (5, 2, 3, 3260);
INSERT INTO `sch_dic_course_division` VALUES (6, 2, 4, 3260);
INSERT INTO `sch_dic_course_division` VALUES (9, 1, 1, 3260);
INSERT INTO `sch_dic_course_division` VALUES (10, 1, 2, 3260);
-- ----------------------------
-- Table structure for sch_dic_course_majors
-- ----------------------------
DROP TABLE IF EXISTS `sch_dic_course_majors`;
CREATE TABLE `sch_dic_course_majors` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`course_id` int(0) NULL DEFAULT NULL,
`majors_id` int(0) NULL DEFAULT NULL,
`sch_id` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sch_dic_course_majors
-- ----------------------------
INSERT INTO `sch_dic_course_majors` VALUES (2, 3, 4, 3260);
INSERT INTO `sch_dic_course_majors` VALUES (3, 2, 2, 3260);
INSERT INTO `sch_dic_course_majors` VALUES (6, 1, 1, 3260);
INSERT INTO `sch_dic_course_majors` VALUES (7, 1, 5, 3260);
-- ----------------------------
-- Table structure for sch_dic_division
-- ----------------------------
DROP TABLE IF EXISTS `sch_dic_division`;
CREATE TABLE `sch_dic_division` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '系部',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`sort` int(0) NULL DEFAULT NULL COMMENT '序号',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '修改日期',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sch_dic_division
-- ----------------------------
INSERT INTO `sch_dic_division` VALUES (1, '中文系', 3260, 6, '2026-06-16 10:33:45', 209169, '2026-06-16 10:41:12', 209169);
INSERT INTO `sch_dic_division` VALUES (2, '历史系', 3260, 5, '2026-06-16 10:34:02', 209169, '2026-06-16 10:41:12', 209169);
INSERT INTO `sch_dic_division` VALUES (3, '外国语学院', 3260, 4, '2026-06-16 10:34:23', 209169, '2026-06-16 10:41:12', 209169);
INSERT INTO `sch_dic_division` VALUES (4, '新闻传播学院', 3260, 3, '2026-06-16 10:34:32', 209169, '2026-06-16 10:41:12', 209169);
INSERT INTO `sch_dic_division` VALUES (5, '哲学系', 3260, 2, '2026-06-16 10:34:41', 209169, '2026-06-16 10:41:12', 209169);
INSERT INTO `sch_dic_division` VALUES (6, '经济学院', 3260, 1, '2026-06-16 10:34:49', 209169, '2026-06-16 10:41:12', 209169);
-- ----------------------------
-- Table structure for sch_dic_majors
-- ----------------------------
DROP TABLE IF EXISTS `sch_dic_majors`;
CREATE TABLE `sch_dic_majors` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专业 ',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`sort` int(0) NULL DEFAULT NULL COMMENT '序号',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改日期',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sch_dic_majors
-- ----------------------------
INSERT INTO `sch_dic_majors` VALUES (1, '哲学', 3260, 7, '2026-06-16 16:23:06', '2026-06-16 16:25:13', 209169, 209169);
INSERT INTO `sch_dic_majors` VALUES (2, '逻辑学', 3260, 6, '2026-06-16 16:23:31', '2026-06-16 16:25:13', 209169, 209169);
INSERT INTO `sch_dic_majors` VALUES (3, '宗教学', 3260, 5, '2026-06-16 16:23:44', '2026-06-16 16:25:13', 209169, 209169);
INSERT INTO `sch_dic_majors` VALUES (4, '经济学', 3260, 4, '2026-06-16 16:23:59', '2026-06-16 16:25:13', 209169, 209169);
INSERT INTO `sch_dic_majors` VALUES (5, '经济统计学', 3260, 3, '2026-06-16 16:24:12', '2026-06-16 16:25:13', 209169, 209169);
INSERT INTO `sch_dic_majors` VALUES (6, '法学', 3260, 2, '2026-06-16 16:24:24', '2026-06-16 16:25:13', 209169, 209169);
INSERT INTO `sch_dic_majors` VALUES (7, '新闻学', 3260, 1, '2026-06-16 16:24:38', '2026-06-16 16:25:13', 209169, 209169);
-- ----------------------------
-- Table structure for sch_dic_subject
-- ----------------------------
DROP TABLE IF EXISTS `sch_dic_subject`;
CREATE TABLE `sch_dic_subject` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编码',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学科',
`enable` bit(1) NULL DEFAULT NULL COMMENT '是否启用',
`sort` int(0) NULL DEFAULT NULL COMMENT '序号',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改日期',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
`source` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sch_dic_subject
-- ----------------------------
INSERT INTO `sch_dic_subject` VALUES (5, 'SUB1001', '机器人', b'1', 1, 3260, '2026-06-15 18:00:05', '2026-06-15 22:23:27', 209169, 209169, 1);
INSERT INTO `sch_dic_subject` VALUES (6, 'SUB1002', 'AI', b'1', 2, 3260, '2026-06-15 18:50:10', '2026-06-15 22:22:41', 209169, 209169, 1);
INSERT INTO `sch_dic_subject` VALUES (7, 'SUB01', '语文', b'0', 3, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (26, 'SUB02', '数学', b'0', 4, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (27, 'SUB03', '英语', b'0', 5, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (28, 'SUB04', '物理', b'0', 6, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (29, 'SUB05', '化学', b'0', 7, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (30, 'SUB06', '生物', b'0', 8, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (31, 'SUB07', '历史', b'0', 9, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (32, 'SUB08', '地理', b'0', 10, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (33, 'SUB09', '政治', b'0', 11, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (34, 'SUB10', '艺术', b'0', 12, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (35, 'SUB11', '体育', b'0', 13, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (36, 'SUB12', '心理', b'0', 14, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (37, 'SUB13', '信息', b'0', 15, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (38, 'SUB14', '劳技', b'0', 16, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (39, 'SUB15', '跨学科', b'0', 17, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (40, 'SUB16', '美术', b'0', 18, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
INSERT INTO `sch_dic_subject` VALUES (41, 'SUB17', '音乐', b'0', 19, 3260, '2026-06-15 22:04:42', '2026-06-15 22:22:41', 209169, 209169, 0);
-- ----------------------------
-- Table structure for sch_student
-- ----------------------------
DROP TABLE IF EXISTS `sch_student`;
CREATE TABLE `sch_student` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '账户',
`group_id` int(0) NULL DEFAULT NULL COMMENT '组id',
`class_id` int(0) NULL DEFAULT NULL COMMENT '班级id',
`stu_id` int(0) NOT NULL COMMENT '学生id',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学生',
`gender` int(0) NULL DEFAULT NULL COMMENT '性别',
`status` int(0) NULL DEFAULT NULL COMMENT '状态',
`abnormal_status` int(0) NULL DEFAULT NULL COMMENT '异常状态',
`invitation_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请码',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sch_teacher
-- ----------------------------
DROP TABLE IF EXISTS `sch_teacher`;
CREATE TABLE `sch_teacher` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '账户',
`group_id` int(0) NULL DEFAULT NULL COMMENT '组id',
`tea_id` int(0) NOT NULL COMMENT '教师id',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教师',
`tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话',
`gender` int(0) NULL DEFAULT NULL COMMENT '性别 0女 1男',
`status` int(0) NULL DEFAULT NULL COMMENT '状态 （0 禁用 1正常）',
`sch_id` int(0) NULL DEFAULT NULL COMMENT '学校id',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户',
`update_user_id` int(0) NULL DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink