/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80025
 Source Host           : localhost:3306
 Source Schema         : stu_score

 Target Server Type    : MySQL
 Target Server Version : 80025
 File Encoding         : 65001

 Date: 22/04/2023 23:32:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin`  (
  `admin_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `admin_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `admin_pwd` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int NULL DEFAULT 0,
  PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('gly202301', '管理员', '$2a$10$eDYSVlefm7YNteOlqn2Roevgl0S5i.gv42WRsf2TeOwbD.jbTLdhG', '2023-04-02 15:34:29', 0);

-- ----------------------------
-- Table structure for t_choose_course
-- ----------------------------
DROP TABLE IF EXISTS `t_choose_course`;
CREATE TABLE `t_choose_course`  (
  `choose_course_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `stu_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `course_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `state` int NULL DEFAULT 0,
  `stu_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `course_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `major_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `course_period` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `if_degree` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0',
  PRIMARY KEY (`choose_course_id`) USING BTREE,
  INDEX `f12`(`stu_id`) USING BTREE,
  INDEX `f13`(`course_id`) USING BTREE,
  CONSTRAINT `f12` FOREIGN KEY (`stu_id`) REFERENCES `t_student` (`stu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `f13` FOREIGN KEY (`course_id`) REFERENCES `t_course` (`course_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_choose_course
-- ----------------------------
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0101', '201901101', 'course0101', '2023-04-15 00:41:13', 1, '丁仁亮', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0102', '201901101', 'course0102', '2023-04-15 00:41:13', 1, '丁仁亮', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0103', '201901101', 'course0103', '2023-04-15 00:41:13', 1, '丁仁亮', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0104', '201901101', 'course0104', '2023-04-15 00:41:13', 1, '丁仁亮', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0105', '201901101', 'course0105', '2023-04-15 00:41:13', 1, '丁仁亮', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0106', '201901101', 'course0106', '2023-04-15 00:41:13', 1, '丁仁亮', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0107', '201901101', 'course0107', '2023-04-15 00:41:13', 1, '丁仁亮', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0109', '201901101', 'course0109', '2023-04-15 00:41:13', 1, '丁仁亮', '毕业实习I', '计算机科学与技术', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201901101choosecourse0110', '201901101', 'course0110', '2023-04-15 00:41:13', 1, '丁仁亮', '毕业设计I', '计算机科学与技术', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0101', '201901102', 'course0101', '2023-04-15 00:41:13', 1, '孙传文', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0102', '201901102', 'course0102', '2023-04-15 00:41:13', 1, '孙传文', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0103', '201901102', 'course0103', '2023-04-15 00:41:13', 1, '孙传文', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0104', '201901102', 'course0104', '2023-04-15 00:41:13', 1, '孙传文', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0105', '201901102', 'course0105', '2023-04-15 00:41:13', 1, '孙传文', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0106', '201901102', 'course0106', '2023-04-15 00:41:13', 1, '孙传文', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0107', '201901102', 'course0107', '2023-04-15 00:41:13', 1, '孙传文', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0109', '201901102', 'course0109', '2023-04-15 00:41:13', 1, '孙传文', '毕业实习I', '计算机科学与技术', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201901102choosecourse0110', '201901102', 'course0110', '2023-04-15 00:41:13', 1, '孙传文', '毕业设计I', '计算机科学与技术', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0101', '201901103', 'course0101', '2023-04-15 00:41:13', 1, '刘雪娇', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0102', '201901103', 'course0102', '2023-04-15 00:41:13', 1, '刘雪娇', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0103', '201901103', 'course0103', '2023-04-15 00:41:13', 1, '刘雪娇', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0104', '201901103', 'course0104', '2023-04-15 00:41:13', 1, '刘雪娇', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0105', '201901103', 'course0105', '2023-04-15 00:41:13', 1, '刘雪娇', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0106', '201901103', 'course0106', '2023-04-15 00:41:13', 1, '刘雪娇', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0107', '201901103', 'course0107', '2023-04-15 00:41:13', 1, '刘雪娇', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0109', '201901103', 'course0109', '2023-04-15 00:41:13', 1, '刘雪娇', '毕业实习I', '计算机科学与技术', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201901103choosecourse0110', '201901103', 'course0110', '2023-04-15 00:41:13', 1, '刘雪娇', '毕业设计I', '计算机科学与技术', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0101', '201901201', 'course0101', '2023-04-15 00:41:13', 1, '许双喜', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0102', '201901201', 'course0102', '2023-04-15 00:41:13', 1, '许双喜', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0103', '201901201', 'course0103', '2023-04-15 00:41:13', 1, '许双喜', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0104', '201901201', 'course0104', '2023-04-15 00:41:13', 1, '许双喜', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0105', '201901201', 'course0105', '2023-04-15 00:41:13', 1, '许双喜', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0106', '201901201', 'course0106', '2023-04-15 00:41:13', 1, '许双喜', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0107', '201901201', 'course0107', '2023-04-15 00:41:13', 1, '许双喜', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0109', '201901201', 'course0109', '2023-04-15 00:41:13', 1, '许双喜', '毕业实习I', '计算机科学与技术', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201901201choosecourse0110', '201901201', 'course0110', '2023-04-15 00:41:13', 1, '许双喜', '毕业设计I', '计算机科学与技术', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0101', '201901202', 'course0101', '2023-04-15 00:41:13', 1, '赵胜华', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0102', '201901202', 'course0102', '2023-04-15 00:41:13', 1, '赵胜华', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0103', '201901202', 'course0103', '2023-04-15 00:41:13', 1, '赵胜华', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0104', '201901202', 'course0104', '2023-04-15 00:41:13', 1, '赵胜华', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0105', '201901202', 'course0105', '2023-04-15 00:41:13', 1, '赵胜华', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0106', '201901202', 'course0106', '2023-04-15 00:41:13', 1, '赵胜华', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0107', '201901202', 'course0107', '2023-04-15 00:41:13', 1, '赵胜华', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0109', '201901202', 'course0109', '2023-04-15 00:41:13', 1, '赵胜华', '毕业实习I', '计算机科学与技术', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201901202choosecourse0110', '201901202', 'course0110', '2023-04-15 00:41:13', 1, '赵胜华', '毕业设计I', '计算机科学与技术', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0101', '201901203', 'course0101', '2023-04-15 00:41:13', 1, '李长宇', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0102', '201901203', 'course0102', '2023-04-15 00:41:13', 1, '李长宇', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0103', '201901203', 'course0103', '2023-04-15 00:41:13', 1, '李长宇', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0104', '201901203', 'course0104', '2023-04-15 00:41:13', 1, '李长宇', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0105', '201901203', 'course0105', '2023-04-15 00:41:13', 1, '李长宇', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0106', '201901203', 'course0106', '2023-04-15 00:41:13', 1, '李长宇', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0107', '201901203', 'course0107', '2023-04-15 00:41:13', 1, '李长宇', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0109', '201901203', 'course0109', '2023-04-15 00:41:13', 1, '李长宇', '毕业实习I', '计算机科学与技术', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201901203choosecourse0110', '201901203', 'course0110', '2023-04-15 00:41:13', 1, '李长宇', '毕业设计I', '计算机科学与技术', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0201', '201902101', 'course0201', '2023-04-15 00:41:14', 1, '胡颖茹', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0202', '201902101', 'course0202', '2023-04-15 00:41:14', 1, '胡颖茹', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0203', '201902101', 'course0203', '2023-04-15 00:41:14', 1, '胡颖茹', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0204', '201902101', 'course0204', '2023-04-15 00:41:14', 1, '胡颖茹', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0205', '201902101', 'course0205', '2023-04-15 00:41:14', 1, '胡颖茹', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0206', '201902101', 'course0206', '2023-04-15 00:41:14', 1, '胡颖茹', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0208', '201902101', 'course0208', '2023-04-15 00:41:14', 1, '胡颖茹', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0209', '201902101', 'course0209', '2023-04-15 00:41:14', 1, '胡颖茹', '毕业实习II', '土木工程', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201902101choosecourse0210', '201902101', 'course0210', '2023-04-15 00:41:14', 1, '胡颖茹', '毕业设计II', '土木工程', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0201', '201902102', 'course0201', '2023-04-15 00:41:14', 1, '万传春', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0202', '201902102', 'course0202', '2023-04-15 00:41:14', 1, '万传春', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0203', '201902102', 'course0203', '2023-04-15 00:41:14', 1, '万传春', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0204', '201902102', 'course0204', '2023-04-15 00:41:14', 1, '万传春', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0205', '201902102', 'course0205', '2023-04-15 00:41:14', 1, '万传春', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0206', '201902102', 'course0206', '2023-04-15 00:41:14', 1, '万传春', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0208', '201902102', 'course0208', '2023-04-15 00:41:14', 1, '万传春', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0209', '201902102', 'course0209', '2023-04-15 00:41:14', 1, '万传春', '毕业实习II', '土木工程', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201902102choosecourse0210', '201902102', 'course0210', '2023-04-15 00:41:14', 1, '万传春', '毕业设计II', '土木工程', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0201', '201902103', 'course0201', '2023-04-15 00:41:14', 1, '张开平', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0202', '201902103', 'course0202', '2023-04-15 00:41:14', 1, '张开平', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0203', '201902103', 'course0203', '2023-04-15 00:41:14', 1, '张开平', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0204', '201902103', 'course0204', '2023-04-15 00:41:14', 1, '张开平', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0205', '201902103', 'course0205', '2023-04-15 00:41:14', 1, '张开平', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0206', '201902103', 'course0206', '2023-04-15 00:41:14', 1, '张开平', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0208', '201902103', 'course0208', '2023-04-15 00:41:14', 1, '张开平', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0209', '201902103', 'course0209', '2023-04-15 00:41:14', 1, '张开平', '毕业实习II', '土木工程', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201902103choosecourse0210', '201902103', 'course0210', '2023-04-15 00:41:14', 1, '张开平', '毕业设计II', '土木工程', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0201', '201902201', 'course0201', '2023-04-15 00:41:14', 1, '王本政', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0202', '201902201', 'course0202', '2023-04-15 00:41:14', 1, '王本政', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0203', '201902201', 'course0203', '2023-04-15 00:41:14', 1, '王本政', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0204', '201902201', 'course0204', '2023-04-15 00:41:14', 1, '王本政', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0205', '201902201', 'course0205', '2023-04-15 00:41:14', 1, '王本政', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0206', '201902201', 'course0206', '2023-04-15 00:41:14', 1, '王本政', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0208', '201902201', 'course0208', '2023-04-15 00:41:14', 1, '王本政', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0209', '201902201', 'course0209', '2023-04-15 00:41:14', 1, '王本政', '毕业实习II', '土木工程', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201902201choosecourse0210', '201902201', 'course0210', '2023-04-15 00:41:14', 1, '王本政', '毕业设计II', '土木工程', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0201', '201902202', 'course0201', '2023-04-15 00:41:14', 1, '李兆瑞', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0202', '201902202', 'course0202', '2023-04-15 00:41:14', 1, '李兆瑞', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0203', '201902202', 'course0203', '2023-04-15 00:41:14', 1, '李兆瑞', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0204', '201902202', 'course0204', '2023-04-15 00:41:14', 1, '李兆瑞', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0205', '201902202', 'course0205', '2023-04-15 00:41:14', 1, '李兆瑞', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0206', '201902202', 'course0206', '2023-04-15 00:41:14', 1, '李兆瑞', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0208', '201902202', 'course0208', '2023-04-15 00:41:14', 1, '李兆瑞', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0209', '201902202', 'course0209', '2023-04-15 00:41:14', 1, '李兆瑞', '毕业实习II', '土木工程', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201902202choosecourse0210', '201902202', 'course0210', '2023-04-15 00:41:14', 1, '李兆瑞', '毕业设计II', '土木工程', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0201', '201902203', 'course0201', '2023-04-15 00:41:14', 1, '杨茂林', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0202', '201902203', 'course0202', '2023-04-15 00:41:14', 1, '杨茂林', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0203', '201902203', 'course0203', '2023-04-15 00:41:14', 1, '杨茂林', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0204', '201902203', 'course0204', '2023-04-15 00:41:14', 1, '杨茂林', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0205', '201902203', 'course0205', '2023-04-15 00:41:14', 1, '杨茂林', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0206', '201902203', 'course0206', '2023-04-15 00:41:14', 1, '杨茂林', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0208', '201902203', 'course0208', '2023-04-15 00:41:14', 1, '杨茂林', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0209', '201902203', 'course0209', '2023-04-15 00:41:14', 1, '杨茂林', '毕业实习II', '土木工程', '大四上', '1');
INSERT INTO `t_choose_course` VALUES ('201902203choosecourse0210', '201902203', 'course0210', '2023-04-15 00:41:14', 1, '杨茂林', '毕业设计II', '土木工程', '大四下', '1');
INSERT INTO `t_choose_course` VALUES ('202001101choosecourse0101', '202001101', 'course0101', '2023-04-15 00:41:13', 1, '史程杰', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001101choosecourse0102', '202001101', 'course0102', '2023-04-15 00:41:13', 1, '史程杰', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001101choosecourse0103', '202001101', 'course0103', '2023-04-15 00:41:13', 1, '史程杰', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001101choosecourse0104', '202001101', 'course0104', '2023-04-15 00:41:13', 1, '史程杰', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001101choosecourse0105', '202001101', 'course0105', '2023-04-15 00:41:13', 1, '史程杰', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202001101choosecourse0106', '202001101', 'course0106', '2023-04-15 00:41:13', 1, '史程杰', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202001101choosecourse0107', '202001101', 'course0107', '2023-04-15 00:41:13', 1, '史程杰', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('202001102choosecourse0101', '202001102', 'course0101', '2023-04-15 00:41:13', 1, '李海鹰', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001102choosecourse0102', '202001102', 'course0102', '2023-04-15 00:41:13', 1, '李海鹰', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001102choosecourse0103', '202001102', 'course0103', '2023-04-15 00:41:13', 1, '李海鹰', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001102choosecourse0104', '202001102', 'course0104', '2023-04-15 00:41:13', 1, '李海鹰', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001102choosecourse0105', '202001102', 'course0105', '2023-04-15 00:41:13', 1, '李海鹰', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202001102choosecourse0106', '202001102', 'course0106', '2023-04-15 00:41:13', 1, '李海鹰', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202001102choosecourse0107', '202001102', 'course0107', '2023-04-15 00:41:13', 1, '李海鹰', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('202001103choosecourse0101', '202001103', 'course0101', '2023-04-15 00:41:13', 1, '李启龙', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001103choosecourse0102', '202001103', 'course0102', '2023-04-15 00:41:13', 1, '李启龙', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001103choosecourse0103', '202001103', 'course0103', '2023-04-15 00:41:13', 1, '李启龙', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001103choosecourse0104', '202001103', 'course0104', '2023-04-15 00:41:13', 1, '李启龙', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001103choosecourse0105', '202001103', 'course0105', '2023-04-15 00:41:13', 1, '李启龙', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202001103choosecourse0106', '202001103', 'course0106', '2023-04-15 00:41:13', 1, '李启龙', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202001103choosecourse0107', '202001103', 'course0107', '2023-04-15 00:41:13', 1, '李启龙', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('202001201choosecourse0101', '202001201', 'course0101', '2023-04-15 00:41:13', 1, '刘英华', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001201choosecourse0102', '202001201', 'course0102', '2023-04-15 00:41:13', 1, '刘英华', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001201choosecourse0103', '202001201', 'course0103', '2023-04-15 00:41:13', 1, '刘英华', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001201choosecourse0104', '202001201', 'course0104', '2023-04-15 00:41:13', 1, '刘英华', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001201choosecourse0105', '202001201', 'course0105', '2023-04-15 00:41:13', 1, '刘英华', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202001201choosecourse0106', '202001201', 'course0106', '2023-04-15 00:41:13', 1, '刘英华', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202001201choosecourse0107', '202001201', 'course0107', '2023-04-15 00:41:13', 1, '刘英华', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('202001202choosecourse0101', '202001202', 'course0101', '2023-04-15 00:41:13', 1, '陈周胜', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001202choosecourse0102', '202001202', 'course0102', '2023-04-15 00:41:13', 1, '陈周胜', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001202choosecourse0103', '202001202', 'course0103', '2023-04-15 00:41:13', 1, '陈周胜', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001202choosecourse0104', '202001202', 'course0104', '2023-04-15 00:41:13', 1, '陈周胜', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001202choosecourse0105', '202001202', 'course0105', '2023-04-15 00:41:13', 1, '陈周胜', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202001202choosecourse0106', '202001202', 'course0106', '2023-04-15 00:41:13', 1, '陈周胜', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202001202choosecourse0107', '202001202', 'course0107', '2023-04-15 00:41:13', 1, '陈周胜', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('202001203choosecourse0101', '202001203', 'course0101', '2023-04-15 00:41:13', 1, '蔡宗仁', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001203choosecourse0102', '202001203', 'course0102', '2023-04-15 00:41:13', 1, '蔡宗仁', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001203choosecourse0103', '202001203', 'course0103', '2023-04-15 00:41:13', 1, '蔡宗仁', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202001203choosecourse0104', '202001203', 'course0104', '2023-04-15 00:41:13', 1, '蔡宗仁', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202001203choosecourse0105', '202001203', 'course0105', '2023-04-15 00:41:13', 1, '蔡宗仁', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202001203choosecourse0106', '202001203', 'course0106', '2023-04-15 00:41:13', 1, '蔡宗仁', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202001203choosecourse0107', '202001203', 'course0107', '2023-04-15 00:41:13', 1, '蔡宗仁', '操作系统', '计算机科学与技术', '大三上', '1');
INSERT INTO `t_choose_course` VALUES ('202002101choosecourse0201', '202002101', 'course0201', '2023-04-15 00:41:14', 1, '黄天杰', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002101choosecourse0202', '202002101', 'course0202', '2023-04-15 00:41:14', 1, '黄天杰', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002101choosecourse0203', '202002101', 'course0203', '2023-04-15 00:41:14', 1, '黄天杰', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002101choosecourse0204', '202002101', 'course0204', '2023-04-15 00:41:14', 1, '黄天杰', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002101choosecourse0205', '202002101', 'course0205', '2023-04-15 00:41:14', 1, '黄天杰', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202002101choosecourse0206', '202002101', 'course0206', '2023-04-15 00:41:14', 1, '黄天杰', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202002101choosecourse0208', '202002101', 'course0208', '2023-04-15 00:41:14', 1, '黄天杰', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('202002102choosecourse0201', '202002102', 'course0201', '2023-04-15 00:41:14', 1, '王海辉', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002102choosecourse0202', '202002102', 'course0202', '2023-04-15 00:41:14', 1, '王海辉', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002102choosecourse0203', '202002102', 'course0203', '2023-04-15 00:41:14', 1, '王海辉', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002102choosecourse0204', '202002102', 'course0204', '2023-04-15 00:41:14', 1, '王海辉', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002102choosecourse0205', '202002102', 'course0205', '2023-04-15 00:41:14', 1, '王海辉', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202002102choosecourse0206', '202002102', 'course0206', '2023-04-15 00:41:14', 1, '王海辉', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202002102choosecourse0208', '202002102', 'course0208', '2023-04-15 00:41:14', 1, '王海辉', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('202002103choosecourse0201', '202002103', 'course0201', '2023-04-15 00:41:14', 1, '孙永明', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002103choosecourse0202', '202002103', 'course0202', '2023-04-15 00:41:14', 1, '孙永明', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002103choosecourse0203', '202002103', 'course0203', '2023-04-15 00:41:14', 1, '孙永明', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002103choosecourse0204', '202002103', 'course0204', '2023-04-15 00:41:14', 1, '孙永明', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002103choosecourse0205', '202002103', 'course0205', '2023-04-15 00:41:14', 1, '孙永明', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202002103choosecourse0206', '202002103', 'course0206', '2023-04-15 00:41:14', 1, '孙永明', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202002103choosecourse0208', '202002103', 'course0208', '2023-04-15 00:41:14', 1, '孙永明', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('202002201choosecourse0201', '202002201', 'course0201', '2023-04-15 00:41:14', 1, '赵小强', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002201choosecourse0202', '202002201', 'course0202', '2023-04-15 00:41:14', 1, '赵小强', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002201choosecourse0203', '202002201', 'course0203', '2023-04-15 00:41:14', 1, '赵小强', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002201choosecourse0204', '202002201', 'course0204', '2023-04-15 00:41:14', 1, '赵小强', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002201choosecourse0205', '202002201', 'course0205', '2023-04-15 00:41:14', 1, '赵小强', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202002201choosecourse0206', '202002201', 'course0206', '2023-04-15 00:41:14', 1, '赵小强', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202002201choosecourse0208', '202002201', 'course0208', '2023-04-15 00:41:14', 1, '赵小强', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('202002202choosecourse0201', '202002202', 'course0201', '2023-04-15 00:41:14', 1, '严晓庆', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002202choosecourse0202', '202002202', 'course0202', '2023-04-15 00:41:14', 1, '严晓庆', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002202choosecourse0203', '202002202', 'course0203', '2023-04-15 00:41:14', 1, '严晓庆', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002202choosecourse0204', '202002202', 'course0204', '2023-04-15 00:41:14', 1, '严晓庆', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002202choosecourse0205', '202002202', 'course0205', '2023-04-15 00:41:14', 1, '严晓庆', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202002202choosecourse0206', '202002202', 'course0206', '2023-04-15 00:41:14', 1, '严晓庆', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202002202choosecourse0208', '202002202', 'course0208', '2023-04-15 00:41:14', 1, '严晓庆', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('202002203choosecourse0201', '202002203', 'course0201', '2023-04-15 00:41:14', 1, '张鸿云', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002203choosecourse0202', '202002203', 'course0202', '2023-04-15 00:41:14', 1, '张鸿云', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002203choosecourse0203', '202002203', 'course0203', '2023-04-15 00:41:14', 1, '张鸿云', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202002203choosecourse0204', '202002203', 'course0204', '2023-04-15 00:41:14', 1, '张鸿云', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202002203choosecourse0205', '202002203', 'course0205', '2023-04-15 00:41:14', 1, '张鸿云', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202002203choosecourse0206', '202002203', 'course0206', '2023-04-15 00:41:14', 1, '张鸿云', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202002203choosecourse0208', '202002203', 'course0208', '2023-04-15 00:41:14', 1, '张鸿云', '荷载与结构设计原理', '土木工程', '大三下', '1');
INSERT INTO `t_choose_course` VALUES ('202101101choosecourse0101', '202101101', 'course0101', '2023-04-15 00:41:13', 1, '陈顺莉', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101101choosecourse0102', '202101101', 'course0102', '2023-04-15 00:41:13', 1, '陈顺莉', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101101choosecourse0103', '202101101', 'course0103', '2023-04-15 00:41:13', 1, '陈顺莉', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101101choosecourse0104', '202101101', 'course0104', '2023-04-15 00:41:13', 1, '陈顺莉', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101101choosecourse0105', '202101101', 'course0105', '2023-04-15 00:41:13', 1, '陈顺莉', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202101101choosecourse0106', '202101101', 'course0106', '2023-04-15 00:41:13', 1, '陈顺莉', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202101102choosecourse0101', '202101102', 'course0101', '2023-04-15 00:41:13', 1, '任江涛', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101102choosecourse0102', '202101102', 'course0102', '2023-04-15 00:41:13', 1, '任江涛', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101102choosecourse0103', '202101102', 'course0103', '2023-04-15 00:41:13', 1, '任江涛', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101102choosecourse0104', '202101102', 'course0104', '2023-04-15 00:41:13', 1, '任江涛', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101102choosecourse0105', '202101102', 'course0105', '2023-04-15 00:41:13', 1, '任江涛', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202101102choosecourse0106', '202101102', 'course0106', '2023-04-15 00:41:13', 1, '任江涛', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202101103choosecourse0101', '202101103', 'course0101', '2023-04-15 00:41:13', 1, '吴冰冰', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101103choosecourse0102', '202101103', 'course0102', '2023-04-15 00:41:13', 1, '吴冰冰', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101103choosecourse0103', '202101103', 'course0103', '2023-04-15 00:41:13', 1, '吴冰冰', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101103choosecourse0104', '202101103', 'course0104', '2023-04-15 00:41:13', 1, '吴冰冰', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101103choosecourse0105', '202101103', 'course0105', '2023-04-15 00:41:14', 1, '吴冰冰', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202101103choosecourse0106', '202101103', 'course0106', '2023-04-15 00:41:14', 1, '吴冰冰', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202101201choosecourse0101', '202101201', 'course0101', '2023-04-15 00:41:14', 1, '邹志伟', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101201choosecourse0102', '202101201', 'course0102', '2023-04-15 00:41:14', 1, '邹志伟', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101201choosecourse0103', '202101201', 'course0103', '2023-04-15 00:41:14', 1, '邹志伟', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101201choosecourse0104', '202101201', 'course0104', '2023-04-15 00:41:14', 1, '邹志伟', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101201choosecourse0105', '202101201', 'course0105', '2023-04-15 00:41:14', 1, '邹志伟', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202101201choosecourse0106', '202101201', 'course0106', '2023-04-15 00:41:14', 1, '邹志伟', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202101202choosecourse0101', '202101202', 'course0101', '2023-04-15 00:41:14', 1, '张永山', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101202choosecourse0102', '202101202', 'course0102', '2023-04-15 00:41:14', 1, '张永山', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101202choosecourse0103', '202101202', 'course0103', '2023-04-15 00:41:14', 1, '张永山', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101202choosecourse0104', '202101202', 'course0104', '2023-04-15 00:41:14', 1, '张永山', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101202choosecourse0105', '202101202', 'course0105', '2023-04-15 00:41:14', 1, '张永山', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202101202choosecourse0106', '202101202', 'course0106', '2023-04-15 00:41:14', 1, '张永山', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202101203choosecourse0101', '202101203', 'course0101', '2023-04-15 00:41:14', 1, '陆春华', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101203choosecourse0102', '202101203', 'course0102', '2023-04-15 00:41:14', 1, '陆春华', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101203choosecourse0103', '202101203', 'course0103', '2023-04-15 00:41:14', 1, '陆春华', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202101203choosecourse0104', '202101203', 'course0104', '2023-04-15 00:41:14', 1, '陆春华', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202101203choosecourse0105', '202101203', 'course0105', '2023-04-15 00:41:14', 1, '陆春华', '数据结构', '计算机科学与技术', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202101203choosecourse0106', '202101203', 'course0106', '2023-04-15 00:41:14', 1, '陆春华', '算法设计与分析', '计算机科学与技术', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202102101choosecourse0201', '202102101', 'course0201', '2023-04-15 00:41:14', 1, '郭春杰', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102101choosecourse0202', '202102101', 'course0202', '2023-04-15 00:41:14', 1, '郭春杰', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102101choosecourse0203', '202102101', 'course0203', '2023-04-15 00:41:14', 1, '郭春杰', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102101choosecourse0204', '202102101', 'course0204', '2023-04-15 00:41:14', 1, '郭春杰', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102101choosecourse0205', '202102101', 'course0205', '2023-04-15 00:41:14', 1, '郭春杰', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202102101choosecourse0206', '202102101', 'course0206', '2023-04-15 00:41:14', 1, '郭春杰', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202102102choosecourse0201', '202102102', 'course0201', '2023-04-15 00:41:14', 1, '李阳宇', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102102choosecourse0202', '202102102', 'course0202', '2023-04-15 00:41:14', 1, '李阳宇', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102102choosecourse0203', '202102102', 'course0203', '2023-04-15 00:41:14', 1, '李阳宇', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102102choosecourse0204', '202102102', 'course0204', '2023-04-15 00:41:14', 1, '李阳宇', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102102choosecourse0205', '202102102', 'course0205', '2023-04-15 00:41:14', 1, '李阳宇', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202102102choosecourse0206', '202102102', 'course0206', '2023-04-15 00:41:14', 1, '李阳宇', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202102103choosecourse0201', '202102103', 'course0201', '2023-04-15 00:41:14', 1, '吴波涛', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102103choosecourse0202', '202102103', 'course0202', '2023-04-15 00:41:14', 1, '吴波涛', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102103choosecourse0203', '202102103', 'course0203', '2023-04-15 00:41:14', 1, '吴波涛', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102103choosecourse0204', '202102103', 'course0204', '2023-04-15 00:41:14', 1, '吴波涛', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102103choosecourse0205', '202102103', 'course0205', '2023-04-15 00:41:14', 1, '吴波涛', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202102103choosecourse0206', '202102103', 'course0206', '2023-04-15 00:41:14', 1, '吴波涛', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202102201choosecourse0201', '202102201', 'course0201', '2023-04-15 00:41:14', 1, '朱军伟', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102201choosecourse0202', '202102201', 'course0202', '2023-04-15 00:41:14', 1, '朱军伟', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102201choosecourse0203', '202102201', 'course0203', '2023-04-15 00:41:14', 1, '朱军伟', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102201choosecourse0204', '202102201', 'course0204', '2023-04-15 00:41:14', 1, '朱军伟', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102201choosecourse0205', '202102201', 'course0205', '2023-04-15 00:41:14', 1, '朱军伟', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202102201choosecourse0206', '202102201', 'course0206', '2023-04-15 00:41:14', 1, '朱军伟', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202102202choosecourse0201', '202102202', 'course0201', '2023-04-15 00:41:14', 1, '王桂红', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102202choosecourse0202', '202102202', 'course0202', '2023-04-15 00:41:14', 1, '王桂红', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102202choosecourse0203', '202102202', 'course0203', '2023-04-15 00:41:14', 1, '王桂红', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102202choosecourse0204', '202102202', 'course0204', '2023-04-15 00:41:14', 1, '王桂红', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102202choosecourse0205', '202102202', 'course0205', '2023-04-15 00:41:14', 1, '王桂红', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202102202choosecourse0206', '202102202', 'course0206', '2023-04-15 00:41:14', 1, '王桂红', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202102203choosecourse0201', '202102203', 'course0201', '2023-04-15 00:41:14', 1, '马玉玲', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102203choosecourse0202', '202102203', 'course0202', '2023-04-15 00:41:14', 1, '马玉玲', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102203choosecourse0203', '202102203', 'course0203', '2023-04-15 00:41:14', 1, '马玉玲', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202102203choosecourse0204', '202102203', 'course0204', '2023-04-15 00:41:14', 1, '马玉玲', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202102203choosecourse0205', '202102203', 'course0205', '2023-04-15 00:41:14', 1, '马玉玲', '结构力学', '土木工程', '大二上', '1');
INSERT INTO `t_choose_course` VALUES ('202102203choosecourse0206', '202102203', 'course0206', '2023-04-15 00:41:14', 1, '马玉玲', '流体力学', '土木工程', '大二下', '1');
INSERT INTO `t_choose_course` VALUES ('202201101choosecourse0101', '202201101', 'course0101', '2023-04-15 00:41:14', 1, '王长江', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201101choosecourse0102', '202201101', 'course0102', '2023-04-15 00:41:14', 1, '王长江', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201101choosecourse0103', '202201101', 'course0103', '2023-04-15 00:41:14', 1, '王长江', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201101choosecourse0104', '202201101', 'course0104', '2023-04-15 00:41:14', 1, '王长江', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201102choosecourse0101', '202201102', 'course0101', '2023-04-15 00:41:14', 1, '卓志文', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201102choosecourse0102', '202201102', 'course0102', '2023-04-15 00:41:14', 1, '卓志文', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201102choosecourse0103', '202201102', 'course0103', '2023-04-15 00:41:14', 1, '卓志文', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201102choosecourse0104', '202201102', 'course0104', '2023-04-15 00:41:14', 1, '卓志文', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201103choosecourse0101', '202201103', 'course0101', '2023-04-15 00:41:14', 1, '朱荣达', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201103choosecourse0102', '202201103', 'course0102', '2023-04-15 00:41:14', 1, '朱荣达', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201103choosecourse0103', '202201103', 'course0103', '2023-04-15 00:41:14', 1, '朱荣达', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201103choosecourse0104', '202201103', 'course0104', '2023-04-15 00:41:14', 1, '朱荣达', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201201choosecourse0101', '202201201', 'course0101', '2023-04-15 00:41:14', 1, '孟德欣', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201201choosecourse0102', '202201201', 'course0102', '2023-04-15 00:41:14', 1, '孟德欣', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201201choosecourse0103', '202201201', 'course0103', '2023-04-15 00:41:14', 1, '孟德欣', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201201choosecourse0104', '202201201', 'course0104', '2023-04-15 00:41:14', 1, '孟德欣', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201202choosecourse0101', '202201202', 'course0101', '2023-04-15 00:41:14', 1, '陈天华', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201202choosecourse0102', '202201202', 'course0102', '2023-04-15 00:41:14', 1, '陈天华', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201202choosecourse0103', '202201202', 'course0103', '2023-04-15 00:41:14', 1, '陈天华', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201202choosecourse0104', '202201202', 'course0104', '2023-04-15 00:41:14', 1, '陈天华', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201203choosecourse0101', '202201203', 'course0101', '2023-04-15 00:41:14', 1, '毕伟民', '高等数学I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201203choosecourse0102', '202201203', 'course0102', '2023-04-15 00:41:14', 1, '毕伟民', '高等数学I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202201203choosecourse0103', '202201203', 'course0103', '2023-04-15 00:41:14', 1, '毕伟民', '大学英语I(上)', '计算机科学与技术', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202201203choosecourse0104', '202201203', 'course0104', '2023-04-15 00:41:14', 1, '毕伟民', '大学英语I(下)', '计算机科学与技术', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202101choosecourse0201', '202202101', 'course0201', '2023-04-15 00:41:14', 1, '周孝为', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202101choosecourse0202', '202202101', 'course0202', '2023-04-15 00:41:14', 1, '周孝为', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202101choosecourse0203', '202202101', 'course0203', '2023-04-15 00:41:14', 1, '周孝为', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202101choosecourse0204', '202202101', 'course0204', '2023-04-15 00:41:14', 1, '周孝为', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202102choosecourse0201', '202202102', 'course0201', '2023-04-15 00:41:14', 1, '徐新玉', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202102choosecourse0202', '202202102', 'course0202', '2023-04-15 00:41:14', 1, '徐新玉', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202102choosecourse0203', '202202102', 'course0203', '2023-04-15 00:41:14', 1, '徐新玉', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202102choosecourse0204', '202202102', 'course0204', '2023-04-15 00:41:14', 1, '徐新玉', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202103choosecourse0201', '202202103', 'course0201', '2023-04-15 00:41:14', 1, '孙宏芳', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202103choosecourse0202', '202202103', 'course0202', '2023-04-15 00:41:14', 1, '孙宏芳', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202103choosecourse0203', '202202103', 'course0203', '2023-04-15 00:41:14', 1, '孙宏芳', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202103choosecourse0204', '202202103', 'course0204', '2023-04-15 00:41:14', 1, '孙宏芳', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202201choosecourse0201', '202202201', 'course0201', '2023-04-15 00:41:14', 1, '朱兴文', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202201choosecourse0202', '202202201', 'course0202', '2023-04-15 00:41:14', 1, '朱兴文', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202201choosecourse0203', '202202201', 'course0203', '2023-04-15 00:41:14', 1, '朱兴文', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202201choosecourse0204', '202202201', 'course0204', '2023-04-15 00:41:14', 1, '朱兴文', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202202choosecourse0201', '202202202', 'course0201', '2023-04-15 00:41:14', 1, '王慧峰', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202202choosecourse0202', '202202202', 'course0202', '2023-04-15 00:41:14', 1, '王慧峰', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202202choosecourse0203', '202202202', 'course0203', '2023-04-15 00:41:14', 1, '王慧峰', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202202choosecourse0204', '202202202', 'course0204', '2023-04-15 00:41:14', 1, '王慧峰', '大学英语II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202203choosecourse0201', '202202203', 'course0201', '2023-04-15 00:41:14', 1, '周玉霞', '高等数学II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202203choosecourse0202', '202202203', 'course0202', '2023-04-15 00:41:14', 1, '周玉霞', '高等数学II(下)', '土木工程', '大一下', '1');
INSERT INTO `t_choose_course` VALUES ('202202203choosecourse0203', '202202203', 'course0203', '2023-04-15 00:41:14', 1, '周玉霞', '大学英语II(上)', '土木工程', '大一上', '1');
INSERT INTO `t_choose_course` VALUES ('202202203choosecourse0204', '202202203', 'course0204', '2023-04-15 00:41:14', 1, '周玉霞', '大学英语II(下)', '土木工程', '大一下', '1');

-- ----------------------------
-- Table structure for t_class
-- ----------------------------
DROP TABLE IF EXISTS `t_class`;
CREATE TABLE `t_class`  (
  `class_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `major_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `class_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `major_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `stu_total` int NULL DEFAULT 0,
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `class_year` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `tea_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  PRIMARY KEY (`class_id`) USING BTREE,
  INDEX `FK_Reference_7`(`major_id`) USING BTREE,
  CONSTRAINT `FK_Reference_7` FOREIGN KEY (`major_id`) REFERENCES `t_major` (`major_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_class
-- ----------------------------
INSERT INTO `t_class` VALUES ('2019011', '01', '2019级计算机科学与技术1班', '计算机科学与技术', 3, '2023-04-04 22:13:00', '2019', '郑兴国');
INSERT INTO `t_class` VALUES ('2019012', '01', '2019级计算机科学与技术2班', '计算机科学与技术', 3, '2023-04-04 22:13:07', '2019', '陈庆凯');
INSERT INTO `t_class` VALUES ('2019021', '02', '2019级土木工程1班', '土木工程', 3, '2023-04-04 22:13:11', '2019', '赵继华');
INSERT INTO `t_class` VALUES ('2019022', '02', '2019级土木工程2班', '土木工程', 3, '2023-04-04 22:13:14', '2019', '羊岳君');
INSERT INTO `t_class` VALUES ('2020011', '01', '2020级计算机科学与技术1班', '计算机科学与技术', 3, '2023-04-04 22:13:19', '2020', '罗红春');
INSERT INTO `t_class` VALUES ('2020012', '01', '2020级计算机科学与技术2班', '计算机科学与技术', 3, '2023-04-04 22:13:33', '2020', '施圣达');
INSERT INTO `t_class` VALUES ('2020021', '02', '2020级土木工程1班', '土木工程', 3, '2023-04-04 22:13:23', '2020', '张子云');
INSERT INTO `t_class` VALUES ('2020022', '02', '2020级土木工程2班', '土木工程', 3, '2023-04-04 22:13:36', '2020', '蒋科俊');
INSERT INTO `t_class` VALUES ('2021011', '01', '2021级计算机科学与技术1班', '计算机科学与技术', 3, '2023-04-04 22:13:42', '2021', '钟伟昌');
INSERT INTO `t_class` VALUES ('2021012', '01', '2021级计算机科学与技术2班', '计算机科学与技术', 3, '2023-04-04 22:16:49', '2021', '张启跃');
INSERT INTO `t_class` VALUES ('2021021', '02', '2021级土木工程1班', '土木工程', 3, '2023-04-04 22:13:51', '2021', '胡梦林');
INSERT INTO `t_class` VALUES ('2021022', '02', '2021级土木工程2班', '土木工程', 3, '2023-04-04 22:13:57', '2021', '周宗格');
INSERT INTO `t_class` VALUES ('2022011', '01', '2022级计算机科学与技术1班', '计算机科学与技术', 3, '2023-04-04 22:14:00', '2022', '马志鹏');
INSERT INTO `t_class` VALUES ('2022012', '01', '2022级计算机科学与技术2班', '计算机科学与技术', 3, '2023-04-04 22:14:08', '2022', '杨永德');
INSERT INTO `t_class` VALUES ('2022021', '02', '2022级土木工程1班', '土木工程', 3, '2023-04-04 22:14:05', '2022', '楚虹阳');
INSERT INTO `t_class` VALUES ('2022022', '02', '2022级土木工程2班', '土木工程', 3, '2023-04-04 22:14:12', '2022', '赵元丰');

-- ----------------------------
-- Table structure for t_course
-- ----------------------------
DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course`  (
  `course_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `major_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `course_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `if_degree` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0',
  `major_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `course_period` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `stu_choose_num` int NULL DEFAULT 0,
  PRIMARY KEY (`course_id`) USING BTREE,
  INDEX `FK_Reference_11`(`major_id`) USING BTREE,
  CONSTRAINT `FK_Reference_11` FOREIGN KEY (`major_id`) REFERENCES `t_major` (`major_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course
-- ----------------------------
INSERT INTO `t_course` VALUES ('course0101', '01', '高等数学I(上)', '1', '计算机科学与技术', '2023-04-03 23:15:15', '大一上', 24);
INSERT INTO `t_course` VALUES ('course0102', '01', '高等数学I(下)', '1', '计算机科学与技术', '2023-04-03 23:15:29', '大一下', 24);
INSERT INTO `t_course` VALUES ('course0103', '01', '大学英语I(上)', '1', '计算机科学与技术', '2023-04-03 23:15:42', '大一上', 24);
INSERT INTO `t_course` VALUES ('course0104', '01', '大学英语I(下)', '1', '计算机科学与技术', '2023-04-03 23:16:05', '大一下', 24);
INSERT INTO `t_course` VALUES ('course0105', '01', '数据结构', '1', '计算机科学与技术', '2023-04-03 23:20:39', '大二上', 18);
INSERT INTO `t_course` VALUES ('course0106', '01', '算法设计与分析', '1', '计算机科学与技术', '2023-04-03 23:21:01', '大二下', 18);
INSERT INTO `t_course` VALUES ('course0107', '01', '操作系统', '1', '计算机科学与技术', '2023-04-03 23:21:14', '大三上', 12);
INSERT INTO `t_course` VALUES ('course0108', '01', '计算机图形学', '0', '计算机科学与技术', '2023-04-03 23:21:36', '大三下', 0);
INSERT INTO `t_course` VALUES ('course0109', '01', '毕业实习I', '1', '计算机科学与技术', '2023-04-03 23:26:20', '大四上', 6);
INSERT INTO `t_course` VALUES ('course0110', '01', '毕业设计I', '1', '计算机科学与技术', '2023-04-03 23:27:20', '大四下', 6);
INSERT INTO `t_course` VALUES ('course0201', '02', '高等数学II(上)', '1', '土木工程', '2023-04-03 23:30:10', '大一上', 24);
INSERT INTO `t_course` VALUES ('course0202', '02', '高等数学II(下)', '1', '土木工程', '2023-04-03 23:30:25', '大一下', 24);
INSERT INTO `t_course` VALUES ('course0203', '02', '大学英语II(上)', '1', '土木工程', '2023-04-03 23:30:49', '大一上', 24);
INSERT INTO `t_course` VALUES ('course0204', '02', '大学英语II(下)', '1', '土木工程', '2023-04-03 23:31:12', '大一下', 24);
INSERT INTO `t_course` VALUES ('course0205', '02', '结构力学', '1', '土木工程', '2023-04-03 23:35:54', '大二上', 18);
INSERT INTO `t_course` VALUES ('course0206', '02', '流体力学', '1', '土木工程', '2023-04-03 23:36:07', '大二下', 18);
INSERT INTO `t_course` VALUES ('course0207', '02', '建筑结构抗震 ', '0', '土木工程', '2023-04-03 23:36:24', '大三上', 0);
INSERT INTO `t_course` VALUES ('course0208', '02', '荷载与结构设计原理', '1', '土木工程', '2023-04-03 23:36:36', '大三下', 12);
INSERT INTO `t_course` VALUES ('course0209', '02', '毕业实习II', '1', '土木工程', '2023-04-03 23:36:54', '大四上', 6);
INSERT INTO `t_course` VALUES ('course0210', '02', '毕业设计II', '1', '土木工程', '2023-04-03 23:37:05', '大四下', 6);

-- ----------------------------
-- Table structure for t_major
-- ----------------------------
DROP TABLE IF EXISTS `t_major`;
CREATE TABLE `t_major`  (
  `major_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `major_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `class_total` int NULL DEFAULT 0,
  `course_total` int NULL DEFAULT 0,
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `stu_total` int NULL DEFAULT 0,
  `tea_total` int NULL DEFAULT 0,
  PRIMARY KEY (`major_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_major
-- ----------------------------
INSERT INTO `t_major` VALUES ('01', '计算机科学与技术', 8, 10, '2023-04-02 19:50:24', 24, 8);
INSERT INTO `t_major` VALUES ('02', '土木工程', 8, 10, '2023-04-02 20:11:35', 24, 8);

-- ----------------------------
-- Table structure for t_score
-- ----------------------------
DROP TABLE IF EXISTS `t_score`;
CREATE TABLE `t_score`  (
  `score_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `choose_course_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `stu_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `score` int NOT NULL,
  `course_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `stu_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`score_id`) USING BTREE,
  INDEX `FK_Reference_1`(`stu_id`) USING BTREE,
  INDEX `f14`(`choose_course_id`) USING BTREE,
  CONSTRAINT `f14` FOREIGN KEY (`choose_course_id`) REFERENCES `t_choose_course` (`choose_course_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_Reference_1` FOREIGN KEY (`stu_id`) REFERENCES `t_student` (`stu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_score
-- ----------------------------
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0101', '201901101choosecourse0101', '201901101', 56, '高等数学I(上)', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0102', '201901101choosecourse0102', '201901101', 4, '高等数学I(下)', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0103', '201901101choosecourse0103', '201901101', 67, '大学英语I(上)', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0104', '201901101choosecourse0104', '201901101', 14, '大学英语I(下)', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0105', '201901101choosecourse0105', '201901101', 70, '数据结构', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0106', '201901101choosecourse0106', '201901101', 73, '算法设计与分析', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0107', '201901101choosecourse0107', '201901101', 77, '操作系统', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0109', '201901101choosecourse0109', '201901101', 92, '毕业实习I', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901101-201901101choosecourse0110', '201901101choosecourse0110', '201901101', 93, '毕业设计I', '丁仁亮', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0101', '201901102choosecourse0101', '201901102', 72, '高等数学I(上)', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0102', '201901102choosecourse0102', '201901102', 43, '高等数学I(下)', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0103', '201901102choosecourse0103', '201901102', 34, '大学英语I(上)', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0104', '201901102choosecourse0104', '201901102', 4, '大学英语I(下)', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0105', '201901102choosecourse0105', '201901102', 50, '数据结构', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0106', '201901102choosecourse0106', '201901102', 90, '算法设计与分析', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0107', '201901102choosecourse0107', '201901102', 0, '操作系统', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0109', '201901102choosecourse0109', '201901102', 65, '毕业实习I', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901102-201901102choosecourse0110', '201901102choosecourse0110', '201901102', 20, '毕业设计I', '孙传文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0101', '201901103choosecourse0101', '201901103', 95, '高等数学I(上)', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0102', '201901103choosecourse0102', '201901103', 65, '高等数学I(下)', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0103', '201901103choosecourse0103', '201901103', 5, '大学英语I(上)', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0104', '201901103choosecourse0104', '201901103', 73, '大学英语I(下)', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0105', '201901103choosecourse0105', '201901103', 79, '数据结构', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0106', '201901103choosecourse0106', '201901103', 19, '算法设计与分析', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0107', '201901103choosecourse0107', '201901103', 35, '操作系统', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0109', '201901103choosecourse0109', '201901103', 19, '毕业实习I', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901103-201901103choosecourse0110', '201901103choosecourse0110', '201901103', 71, '毕业设计I', '刘雪娇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0101', '201901201choosecourse0101', '201901201', 95, '高等数学I(上)', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0102', '201901201choosecourse0102', '201901201', 36, '高等数学I(下)', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0103', '201901201choosecourse0103', '201901201', 95, '大学英语I(上)', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0104', '201901201choosecourse0104', '201901201', 77, '大学英语I(下)', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0105', '201901201choosecourse0105', '201901201', 49, '数据结构', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0106', '201901201choosecourse0106', '201901201', 46, '算法设计与分析', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0107', '201901201choosecourse0107', '201901201', 75, '操作系统', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0109', '201901201choosecourse0109', '201901201', 10, '毕业实习I', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901201-201901201choosecourse0110', '201901201choosecourse0110', '201901201', 70, '毕业设计I', '许双喜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0101', '201901202choosecourse0101', '201901202', 68, '高等数学I(上)', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0102', '201901202choosecourse0102', '201901202', 34, '高等数学I(下)', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0103', '201901202choosecourse0103', '201901202', 27, '大学英语I(上)', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0104', '201901202choosecourse0104', '201901202', 12, '大学英语I(下)', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0105', '201901202choosecourse0105', '201901202', 11, '数据结构', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0106', '201901202choosecourse0106', '201901202', 12, '算法设计与分析', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0107', '201901202choosecourse0107', '201901202', 100, '操作系统', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0109', '201901202choosecourse0109', '201901202', 65, '毕业实习I', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901202-201901202choosecourse0110', '201901202choosecourse0110', '201901202', 1, '毕业设计I', '赵胜华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0101', '201901203choosecourse0101', '201901203', 22, '高等数学I(上)', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0102', '201901203choosecourse0102', '201901203', 19, '高等数学I(下)', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0103', '201901203choosecourse0103', '201901203', 46, '大学英语I(上)', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0104', '201901203choosecourse0104', '201901203', 84, '大学英语I(下)', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0105', '201901203choosecourse0105', '201901203', 76, '数据结构', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0106', '201901203choosecourse0106', '201901203', 93, '算法设计与分析', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0107', '201901203choosecourse0107', '201901203', 53, '操作系统', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0109', '201901203choosecourse0109', '201901203', 91, '毕业实习I', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201901203-201901203choosecourse0110', '201901203choosecourse0110', '201901203', 53, '毕业设计I', '李长宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0201', '201902101choosecourse0201', '201902101', 10, '高等数学II(上)', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0202', '201902101choosecourse0202', '201902101', 34, '高等数学II(下)', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0203', '201902101choosecourse0203', '201902101', 34, '大学英语II(上)', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0204', '201902101choosecourse0204', '201902101', 88, '大学英语II(下)', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0205', '201902101choosecourse0205', '201902101', 95, '结构力学', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0206', '201902101choosecourse0206', '201902101', 91, '流体力学', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0208', '201902101choosecourse0208', '201902101', 93, '荷载与结构设计原理', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0209', '201902101choosecourse0209', '201902101', 51, '毕业实习II', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902101-201902101choosecourse0210', '201902101choosecourse0210', '201902101', 74, '毕业设计II', '胡颖茹', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0201', '201902102choosecourse0201', '201902102', 0, '高等数学II(上)', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0202', '201902102choosecourse0202', '201902102', 72, '高等数学II(下)', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0203', '201902102choosecourse0203', '201902102', 32, '大学英语II(上)', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0204', '201902102choosecourse0204', '201902102', 59, '大学英语II(下)', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0205', '201902102choosecourse0205', '201902102', 27, '结构力学', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0206', '201902102choosecourse0206', '201902102', 44, '流体力学', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0208', '201902102choosecourse0208', '201902102', 73, '荷载与结构设计原理', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0209', '201902102choosecourse0209', '201902102', 36, '毕业实习II', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902102-201902102choosecourse0210', '201902102choosecourse0210', '201902102', 50, '毕业设计II', '万传春', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0201', '201902103choosecourse0201', '201902103', 12, '高等数学II(上)', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0202', '201902103choosecourse0202', '201902103', 92, '高等数学II(下)', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0203', '201902103choosecourse0203', '201902103', 76, '大学英语II(上)', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0204', '201902103choosecourse0204', '201902103', 72, '大学英语II(下)', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0205', '201902103choosecourse0205', '201902103', 99, '结构力学', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0206', '201902103choosecourse0206', '201902103', 33, '流体力学', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0208', '201902103choosecourse0208', '201902103', 66, '荷载与结构设计原理', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0209', '201902103choosecourse0209', '201902103', 69, '毕业实习II', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902103-201902103choosecourse0210', '201902103choosecourse0210', '201902103', 79, '毕业设计II', '张开平', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0201', '201902201choosecourse0201', '201902201', 2, '高等数学II(上)', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0202', '201902201choosecourse0202', '201902201', 76, '高等数学II(下)', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0203', '201902201choosecourse0203', '201902201', 77, '大学英语II(上)', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0204', '201902201choosecourse0204', '201902201', 17, '大学英语II(下)', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0205', '201902201choosecourse0205', '201902201', 1, '结构力学', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0206', '201902201choosecourse0206', '201902201', 3, '流体力学', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0208', '201902201choosecourse0208', '201902201', 76, '荷载与结构设计原理', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0209', '201902201choosecourse0209', '201902201', 83, '毕业实习II', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902201-201902201choosecourse0210', '201902201choosecourse0210', '201902201', 96, '毕业设计II', '王本政', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0201', '201902202choosecourse0201', '201902202', 93, '高等数学II(上)', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0202', '201902202choosecourse0202', '201902202', 93, '高等数学II(下)', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0203', '201902202choosecourse0203', '201902202', 3, '大学英语II(上)', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0204', '201902202choosecourse0204', '201902202', 61, '大学英语II(下)', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0205', '201902202choosecourse0205', '201902202', 15, '结构力学', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0206', '201902202choosecourse0206', '201902202', 4, '流体力学', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0208', '201902202choosecourse0208', '201902202', 18, '荷载与结构设计原理', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0209', '201902202choosecourse0209', '201902202', 36, '毕业实习II', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902202-201902202choosecourse0210', '201902202choosecourse0210', '201902202', 87, '毕业设计II', '李兆瑞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0201', '201902203choosecourse0201', '201902203', 50, '高等数学II(上)', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0202', '201902203choosecourse0202', '201902203', 67, '高等数学II(下)', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0203', '201902203choosecourse0203', '201902203', 90, '大学英语II(上)', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0204', '201902203choosecourse0204', '201902203', 50, '大学英语II(下)', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0205', '201902203choosecourse0205', '201902203', 44, '结构力学', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0206', '201902203choosecourse0206', '201902203', 62, '流体力学', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0208', '201902203choosecourse0208', '201902203', 47, '荷载与结构设计原理', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0209', '201902203choosecourse0209', '201902203', 81, '毕业实习II', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('201902203-201902203choosecourse0210', '201902203choosecourse0210', '201902203', 37, '毕业设计II', '杨茂林', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001101-202001101choosecourse0101', '202001101choosecourse0101', '202001101', 82, '高等数学I(上)', '史程杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001101-202001101choosecourse0102', '202001101choosecourse0102', '202001101', 29, '高等数学I(下)', '史程杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001101-202001101choosecourse0103', '202001101choosecourse0103', '202001101', 96, '大学英语I(上)', '史程杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001101-202001101choosecourse0104', '202001101choosecourse0104', '202001101', 89, '大学英语I(下)', '史程杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001101-202001101choosecourse0105', '202001101choosecourse0105', '202001101', 7, '数据结构', '史程杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001101-202001101choosecourse0106', '202001101choosecourse0106', '202001101', 73, '算法设计与分析', '史程杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001101-202001101choosecourse0107', '202001101choosecourse0107', '202001101', 73, '操作系统', '史程杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001102-202001102choosecourse0101', '202001102choosecourse0101', '202001102', 15, '高等数学I(上)', '李海鹰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001102-202001102choosecourse0102', '202001102choosecourse0102', '202001102', 100, '高等数学I(下)', '李海鹰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001102-202001102choosecourse0103', '202001102choosecourse0103', '202001102', 80, '大学英语I(上)', '李海鹰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001102-202001102choosecourse0104', '202001102choosecourse0104', '202001102', 36, '大学英语I(下)', '李海鹰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001102-202001102choosecourse0105', '202001102choosecourse0105', '202001102', 88, '数据结构', '李海鹰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001102-202001102choosecourse0106', '202001102choosecourse0106', '202001102', 6, '算法设计与分析', '李海鹰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001102-202001102choosecourse0107', '202001102choosecourse0107', '202001102', 87, '操作系统', '李海鹰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001103-202001103choosecourse0101', '202001103choosecourse0101', '202001103', 66, '高等数学I(上)', '李启龙', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001103-202001103choosecourse0102', '202001103choosecourse0102', '202001103', 1, '高等数学I(下)', '李启龙', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001103-202001103choosecourse0103', '202001103choosecourse0103', '202001103', 0, '大学英语I(上)', '李启龙', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001103-202001103choosecourse0104', '202001103choosecourse0104', '202001103', 75, '大学英语I(下)', '李启龙', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001103-202001103choosecourse0105', '202001103choosecourse0105', '202001103', 90, '数据结构', '李启龙', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001103-202001103choosecourse0106', '202001103choosecourse0106', '202001103', 16, '算法设计与分析', '李启龙', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001103-202001103choosecourse0107', '202001103choosecourse0107', '202001103', 23, '操作系统', '李启龙', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001201-202001201choosecourse0101', '202001201choosecourse0101', '202001201', 81, '高等数学I(上)', '刘英华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001201-202001201choosecourse0102', '202001201choosecourse0102', '202001201', 27, '高等数学I(下)', '刘英华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001201-202001201choosecourse0103', '202001201choosecourse0103', '202001201', 84, '大学英语I(上)', '刘英华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001201-202001201choosecourse0104', '202001201choosecourse0104', '202001201', 96, '大学英语I(下)', '刘英华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001201-202001201choosecourse0105', '202001201choosecourse0105', '202001201', 27, '数据结构', '刘英华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001201-202001201choosecourse0106', '202001201choosecourse0106', '202001201', 53, '算法设计与分析', '刘英华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001201-202001201choosecourse0107', '202001201choosecourse0107', '202001201', 91, '操作系统', '刘英华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001202-202001202choosecourse0101', '202001202choosecourse0101', '202001202', 59, '高等数学I(上)', '陈周胜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001202-202001202choosecourse0102', '202001202choosecourse0102', '202001202', 14, '高等数学I(下)', '陈周胜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001202-202001202choosecourse0103', '202001202choosecourse0103', '202001202', 99, '大学英语I(上)', '陈周胜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001202-202001202choosecourse0104', '202001202choosecourse0104', '202001202', 0, '大学英语I(下)', '陈周胜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001202-202001202choosecourse0105', '202001202choosecourse0105', '202001202', 94, '数据结构', '陈周胜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001202-202001202choosecourse0106', '202001202choosecourse0106', '202001202', 29, '算法设计与分析', '陈周胜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001202-202001202choosecourse0107', '202001202choosecourse0107', '202001202', 49, '操作系统', '陈周胜', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001203-202001203choosecourse0101', '202001203choosecourse0101', '202001203', 62, '高等数学I(上)', '蔡宗仁', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001203-202001203choosecourse0102', '202001203choosecourse0102', '202001203', 72, '高等数学I(下)', '蔡宗仁', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001203-202001203choosecourse0103', '202001203choosecourse0103', '202001203', 46, '大学英语I(上)', '蔡宗仁', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001203-202001203choosecourse0104', '202001203choosecourse0104', '202001203', 78, '大学英语I(下)', '蔡宗仁', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001203-202001203choosecourse0105', '202001203choosecourse0105', '202001203', 18, '数据结构', '蔡宗仁', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001203-202001203choosecourse0106', '202001203choosecourse0106', '202001203', 79, '算法设计与分析', '蔡宗仁', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202001203-202001203choosecourse0107', '202001203choosecourse0107', '202001203', 84, '操作系统', '蔡宗仁', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002101-202002101choosecourse0201', '202002101choosecourse0201', '202002101', 26, '高等数学II(上)', '黄天杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002101-202002101choosecourse0202', '202002101choosecourse0202', '202002101', 27, '高等数学II(下)', '黄天杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002101-202002101choosecourse0203', '202002101choosecourse0203', '202002101', 46, '大学英语II(上)', '黄天杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002101-202002101choosecourse0204', '202002101choosecourse0204', '202002101', 9, '大学英语II(下)', '黄天杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002101-202002101choosecourse0205', '202002101choosecourse0205', '202002101', 53, '结构力学', '黄天杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002101-202002101choosecourse0206', '202002101choosecourse0206', '202002101', 78, '流体力学', '黄天杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002101-202002101choosecourse0208', '202002101choosecourse0208', '202002101', 93, '荷载与结构设计原理', '黄天杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002102-202002102choosecourse0201', '202002102choosecourse0201', '202002102', 23, '高等数学II(上)', '王海辉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002102-202002102choosecourse0202', '202002102choosecourse0202', '202002102', 8, '高等数学II(下)', '王海辉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002102-202002102choosecourse0203', '202002102choosecourse0203', '202002102', 54, '大学英语II(上)', '王海辉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002102-202002102choosecourse0204', '202002102choosecourse0204', '202002102', 26, '大学英语II(下)', '王海辉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002102-202002102choosecourse0205', '202002102choosecourse0205', '202002102', 49, '结构力学', '王海辉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002102-202002102choosecourse0206', '202002102choosecourse0206', '202002102', 31, '流体力学', '王海辉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002102-202002102choosecourse0208', '202002102choosecourse0208', '202002102', 7, '荷载与结构设计原理', '王海辉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002103-202002103choosecourse0201', '202002103choosecourse0201', '202002103', 72, '高等数学II(上)', '孙永明', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002103-202002103choosecourse0202', '202002103choosecourse0202', '202002103', 60, '高等数学II(下)', '孙永明', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002103-202002103choosecourse0203', '202002103choosecourse0203', '202002103', 66, '大学英语II(上)', '孙永明', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002103-202002103choosecourse0204', '202002103choosecourse0204', '202002103', 7, '大学英语II(下)', '孙永明', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002103-202002103choosecourse0205', '202002103choosecourse0205', '202002103', 96, '结构力学', '孙永明', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002103-202002103choosecourse0206', '202002103choosecourse0206', '202002103', 31, '流体力学', '孙永明', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002103-202002103choosecourse0208', '202002103choosecourse0208', '202002103', 46, '荷载与结构设计原理', '孙永明', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002201-202002201choosecourse0201', '202002201choosecourse0201', '202002201', 3, '高等数学II(上)', '赵小强', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002201-202002201choosecourse0202', '202002201choosecourse0202', '202002201', 3, '高等数学II(下)', '赵小强', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002201-202002201choosecourse0203', '202002201choosecourse0203', '202002201', 56, '大学英语II(上)', '赵小强', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002201-202002201choosecourse0204', '202002201choosecourse0204', '202002201', 74, '大学英语II(下)', '赵小强', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002201-202002201choosecourse0205', '202002201choosecourse0205', '202002201', 78, '结构力学', '赵小强', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002201-202002201choosecourse0206', '202002201choosecourse0206', '202002201', 24, '流体力学', '赵小强', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002201-202002201choosecourse0208', '202002201choosecourse0208', '202002201', 83, '荷载与结构设计原理', '赵小强', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002202-202002202choosecourse0201', '202002202choosecourse0201', '202002202', 77, '高等数学II(上)', '严晓庆', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002202-202002202choosecourse0202', '202002202choosecourse0202', '202002202', 21, '高等数学II(下)', '严晓庆', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002202-202002202choosecourse0203', '202002202choosecourse0203', '202002202', 17, '大学英语II(上)', '严晓庆', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002202-202002202choosecourse0204', '202002202choosecourse0204', '202002202', 8, '大学英语II(下)', '严晓庆', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002202-202002202choosecourse0205', '202002202choosecourse0205', '202002202', 98, '结构力学', '严晓庆', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002202-202002202choosecourse0206', '202002202choosecourse0206', '202002202', 78, '流体力学', '严晓庆', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002202-202002202choosecourse0208', '202002202choosecourse0208', '202002202', 71, '荷载与结构设计原理', '严晓庆', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002203-202002203choosecourse0201', '202002203choosecourse0201', '202002203', 94, '高等数学II(上)', '张鸿云', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002203-202002203choosecourse0202', '202002203choosecourse0202', '202002203', 63, '高等数学II(下)', '张鸿云', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002203-202002203choosecourse0203', '202002203choosecourse0203', '202002203', 44, '大学英语II(上)', '张鸿云', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002203-202002203choosecourse0204', '202002203choosecourse0204', '202002203', 9, '大学英语II(下)', '张鸿云', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002203-202002203choosecourse0205', '202002203choosecourse0205', '202002203', 84, '结构力学', '张鸿云', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002203-202002203choosecourse0206', '202002203choosecourse0206', '202002203', 52, '流体力学', '张鸿云', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202002203-202002203choosecourse0208', '202002203choosecourse0208', '202002203', 73, '荷载与结构设计原理', '张鸿云', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101101-202101101choosecourse0101', '202101101choosecourse0101', '202101101', 76, '高等数学I(上)', '陈顺莉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101101-202101101choosecourse0102', '202101101choosecourse0102', '202101101', 15, '高等数学I(下)', '陈顺莉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101101-202101101choosecourse0103', '202101101choosecourse0103', '202101101', 80, '大学英语I(上)', '陈顺莉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101101-202101101choosecourse0104', '202101101choosecourse0104', '202101101', 84, '大学英语I(下)', '陈顺莉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101101-202101101choosecourse0105', '202101101choosecourse0105', '202101101', 56, '数据结构', '陈顺莉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101101-202101101choosecourse0106', '202101101choosecourse0106', '202101101', 63, '算法设计与分析', '陈顺莉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101102-202101102choosecourse0101', '202101102choosecourse0101', '202101102', 90, '高等数学I(上)', '任江涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101102-202101102choosecourse0102', '202101102choosecourse0102', '202101102', 48, '高等数学I(下)', '任江涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101102-202101102choosecourse0103', '202101102choosecourse0103', '202101102', 67, '大学英语I(上)', '任江涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101102-202101102choosecourse0104', '202101102choosecourse0104', '202101102', 1, '大学英语I(下)', '任江涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101102-202101102choosecourse0105', '202101102choosecourse0105', '202101102', 62, '数据结构', '任江涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101102-202101102choosecourse0106', '202101102choosecourse0106', '202101102', 35, '算法设计与分析', '任江涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101103-202101103choosecourse0101', '202101103choosecourse0101', '202101103', 46, '高等数学I(上)', '吴冰冰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101103-202101103choosecourse0102', '202101103choosecourse0102', '202101103', 42, '高等数学I(下)', '吴冰冰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101103-202101103choosecourse0103', '202101103choosecourse0103', '202101103', 23, '大学英语I(上)', '吴冰冰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101103-202101103choosecourse0104', '202101103choosecourse0104', '202101103', 56, '大学英语I(下)', '吴冰冰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101103-202101103choosecourse0105', '202101103choosecourse0105', '202101103', 17, '数据结构', '吴冰冰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101103-202101103choosecourse0106', '202101103choosecourse0106', '202101103', 46, '算法设计与分析', '吴冰冰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101201-202101201choosecourse0101', '202101201choosecourse0101', '202101201', 52, '高等数学I(上)', '邹志伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101201-202101201choosecourse0102', '202101201choosecourse0102', '202101201', 98, '高等数学I(下)', '邹志伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101201-202101201choosecourse0103', '202101201choosecourse0103', '202101201', 48, '大学英语I(上)', '邹志伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101201-202101201choosecourse0104', '202101201choosecourse0104', '202101201', 85, '大学英语I(下)', '邹志伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101201-202101201choosecourse0105', '202101201choosecourse0105', '202101201', 71, '数据结构', '邹志伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101201-202101201choosecourse0106', '202101201choosecourse0106', '202101201', 25, '算法设计与分析', '邹志伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101202-202101202choosecourse0101', '202101202choosecourse0101', '202101202', 60, '高等数学I(上)', '张永山', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101202-202101202choosecourse0102', '202101202choosecourse0102', '202101202', 1, '高等数学I(下)', '张永山', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101202-202101202choosecourse0103', '202101202choosecourse0103', '202101202', 95, '大学英语I(上)', '张永山', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101202-202101202choosecourse0104', '202101202choosecourse0104', '202101202', 42, '大学英语I(下)', '张永山', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101202-202101202choosecourse0105', '202101202choosecourse0105', '202101202', 63, '数据结构', '张永山', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101202-202101202choosecourse0106', '202101202choosecourse0106', '202101202', 11, '算法设计与分析', '张永山', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101203-202101203choosecourse0101', '202101203choosecourse0101', '202101203', 21, '高等数学I(上)', '陆春华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101203-202101203choosecourse0102', '202101203choosecourse0102', '202101203', 8, '高等数学I(下)', '陆春华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101203-202101203choosecourse0103', '202101203choosecourse0103', '202101203', 75, '大学英语I(上)', '陆春华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101203-202101203choosecourse0104', '202101203choosecourse0104', '202101203', 79, '大学英语I(下)', '陆春华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101203-202101203choosecourse0105', '202101203choosecourse0105', '202101203', 54, '数据结构', '陆春华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202101203-202101203choosecourse0106', '202101203choosecourse0106', '202101203', 1, '算法设计与分析', '陆春华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102101-202102101choosecourse0201', '202102101choosecourse0201', '202102101', 10, '高等数学II(上)', '郭春杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102101-202102101choosecourse0202', '202102101choosecourse0202', '202102101', 41, '高等数学II(下)', '郭春杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102101-202102101choosecourse0203', '202102101choosecourse0203', '202102101', 35, '大学英语II(上)', '郭春杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102101-202102101choosecourse0204', '202102101choosecourse0204', '202102101', 66, '大学英语II(下)', '郭春杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102101-202102101choosecourse0205', '202102101choosecourse0205', '202102101', 6, '结构力学', '郭春杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102101-202102101choosecourse0206', '202102101choosecourse0206', '202102101', 39, '流体力学', '郭春杰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102102-202102102choosecourse0201', '202102102choosecourse0201', '202102102', 2, '高等数学II(上)', '李阳宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102102-202102102choosecourse0202', '202102102choosecourse0202', '202102102', 4, '高等数学II(下)', '李阳宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102102-202102102choosecourse0203', '202102102choosecourse0203', '202102102', 69, '大学英语II(上)', '李阳宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102102-202102102choosecourse0204', '202102102choosecourse0204', '202102102', 10, '大学英语II(下)', '李阳宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102102-202102102choosecourse0205', '202102102choosecourse0205', '202102102', 83, '结构力学', '李阳宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102102-202102102choosecourse0206', '202102102choosecourse0206', '202102102', 55, '流体力学', '李阳宇', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102103-202102103choosecourse0201', '202102103choosecourse0201', '202102103', 97, '高等数学II(上)', '吴波涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102103-202102103choosecourse0202', '202102103choosecourse0202', '202102103', 6, '高等数学II(下)', '吴波涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102103-202102103choosecourse0203', '202102103choosecourse0203', '202102103', 77, '大学英语II(上)', '吴波涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102103-202102103choosecourse0204', '202102103choosecourse0204', '202102103', 55, '大学英语II(下)', '吴波涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102103-202102103choosecourse0205', '202102103choosecourse0205', '202102103', 100, '结构力学', '吴波涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102103-202102103choosecourse0206', '202102103choosecourse0206', '202102103', 89, '流体力学', '吴波涛', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102201-202102201choosecourse0201', '202102201choosecourse0201', '202102201', 83, '高等数学II(上)', '朱军伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102201-202102201choosecourse0202', '202102201choosecourse0202', '202102201', 34, '高等数学II(下)', '朱军伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102201-202102201choosecourse0203', '202102201choosecourse0203', '202102201', 95, '大学英语II(上)', '朱军伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102201-202102201choosecourse0204', '202102201choosecourse0204', '202102201', 51, '大学英语II(下)', '朱军伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102201-202102201choosecourse0205', '202102201choosecourse0205', '202102201', 63, '结构力学', '朱军伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102201-202102201choosecourse0206', '202102201choosecourse0206', '202102201', 35, '流体力学', '朱军伟', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102202-202102202choosecourse0201', '202102202choosecourse0201', '202102202', 50, '高等数学II(上)', '王桂红', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102202-202102202choosecourse0202', '202102202choosecourse0202', '202102202', 83, '高等数学II(下)', '王桂红', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102202-202102202choosecourse0203', '202102202choosecourse0203', '202102202', 59, '大学英语II(上)', '王桂红', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102202-202102202choosecourse0204', '202102202choosecourse0204', '202102202', 26, '大学英语II(下)', '王桂红', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102202-202102202choosecourse0205', '202102202choosecourse0205', '202102202', 61, '结构力学', '王桂红', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102202-202102202choosecourse0206', '202102202choosecourse0206', '202102202', 39, '流体力学', '王桂红', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102203-202102203choosecourse0201', '202102203choosecourse0201', '202102203', 34, '高等数学II(上)', '马玉玲', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102203-202102203choosecourse0202', '202102203choosecourse0202', '202102203', 28, '高等数学II(下)', '马玉玲', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102203-202102203choosecourse0203', '202102203choosecourse0203', '202102203', 14, '大学英语II(上)', '马玉玲', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102203-202102203choosecourse0204', '202102203choosecourse0204', '202102203', 93, '大学英语II(下)', '马玉玲', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102203-202102203choosecourse0205', '202102203choosecourse0205', '202102203', 29, '结构力学', '马玉玲', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202102203-202102203choosecourse0206', '202102203choosecourse0206', '202102203', 48, '流体力学', '马玉玲', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201101-202201101choosecourse0101', '202201101choosecourse0101', '202201101', 18, '高等数学I(上)', '王长江', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201101-202201101choosecourse0102', '202201101choosecourse0102', '202201101', 98, '高等数学I(下)', '王长江', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201101-202201101choosecourse0103', '202201101choosecourse0103', '202201101', 11, '大学英语I(上)', '王长江', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201101-202201101choosecourse0104', '202201101choosecourse0104', '202201101', 38, '大学英语I(下)', '王长江', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201102-202201102choosecourse0101', '202201102choosecourse0101', '202201102', 81, '高等数学I(上)', '卓志文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201102-202201102choosecourse0102', '202201102choosecourse0102', '202201102', 76, '高等数学I(下)', '卓志文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201102-202201102choosecourse0103', '202201102choosecourse0103', '202201102', 50, '大学英语I(上)', '卓志文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201102-202201102choosecourse0104', '202201102choosecourse0104', '202201102', 24, '大学英语I(下)', '卓志文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201103-202201103choosecourse0101', '202201103choosecourse0101', '202201103', 9, '高等数学I(上)', '朱荣达', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201103-202201103choosecourse0102', '202201103choosecourse0102', '202201103', 72, '高等数学I(下)', '朱荣达', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201103-202201103choosecourse0103', '202201103choosecourse0103', '202201103', 17, '大学英语I(上)', '朱荣达', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201103-202201103choosecourse0104', '202201103choosecourse0104', '202201103', 67, '大学英语I(下)', '朱荣达', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201201-202201201choosecourse0101', '202201201choosecourse0101', '202201201', 87, '高等数学I(上)', '孟德欣', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201201-202201201choosecourse0102', '202201201choosecourse0102', '202201201', 36, '高等数学I(下)', '孟德欣', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201201-202201201choosecourse0103', '202201201choosecourse0103', '202201201', 98, '大学英语I(上)', '孟德欣', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201201-202201201choosecourse0104', '202201201choosecourse0104', '202201201', 38, '大学英语I(下)', '孟德欣', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201202-202201202choosecourse0101', '202201202choosecourse0101', '202201202', 56, '高等数学I(上)', '陈天华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201202-202201202choosecourse0102', '202201202choosecourse0102', '202201202', 85, '高等数学I(下)', '陈天华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201202-202201202choosecourse0103', '202201202choosecourse0103', '202201202', 50, '大学英语I(上)', '陈天华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201202-202201202choosecourse0104', '202201202choosecourse0104', '202201202', 75, '大学英语I(下)', '陈天华', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201203-202201203choosecourse0101', '202201203choosecourse0101', '202201203', 63, '高等数学I(上)', '毕伟民', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201203-202201203choosecourse0102', '202201203choosecourse0102', '202201203', 37, '高等数学I(下)', '毕伟民', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201203-202201203choosecourse0103', '202201203choosecourse0103', '202201203', 6, '大学英语I(上)', '毕伟民', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202201203-202201203choosecourse0104', '202201203choosecourse0104', '202201203', 25, '大学英语I(下)', '毕伟民', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202101-202202101choosecourse0201', '202202101choosecourse0201', '202202101', 27, '高等数学II(上)', '周孝为', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202101-202202101choosecourse0202', '202202101choosecourse0202', '202202101', 61, '高等数学II(下)', '周孝为', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202101-202202101choosecourse0203', '202202101choosecourse0203', '202202101', 24, '大学英语II(上)', '周孝为', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202101-202202101choosecourse0204', '202202101choosecourse0204', '202202101', 78, '大学英语II(下)', '周孝为', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202102-202202102choosecourse0201', '202202102choosecourse0201', '202202102', 67, '高等数学II(上)', '徐新玉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202102-202202102choosecourse0202', '202202102choosecourse0202', '202202102', 12, '高等数学II(下)', '徐新玉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202102-202202102choosecourse0203', '202202102choosecourse0203', '202202102', 12, '大学英语II(上)', '徐新玉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202102-202202102choosecourse0204', '202202102choosecourse0204', '202202102', 40, '大学英语II(下)', '徐新玉', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202103-202202103choosecourse0201', '202202103choosecourse0201', '202202103', 73, '高等数学II(上)', '孙宏芳', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202103-202202103choosecourse0202', '202202103choosecourse0202', '202202103', 70, '高等数学II(下)', '孙宏芳', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202103-202202103choosecourse0203', '202202103choosecourse0203', '202202103', 97, '大学英语II(上)', '孙宏芳', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202103-202202103choosecourse0204', '202202103choosecourse0204', '202202103', 68, '大学英语II(下)', '孙宏芳', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202201-202202201choosecourse0201', '202202201choosecourse0201', '202202201', 36, '高等数学II(上)', '朱兴文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202201-202202201choosecourse0202', '202202201choosecourse0202', '202202201', 59, '高等数学II(下)', '朱兴文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202201-202202201choosecourse0203', '202202201choosecourse0203', '202202201', 62, '大学英语II(上)', '朱兴文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202201-202202201choosecourse0204', '202202201choosecourse0204', '202202201', 95, '大学英语II(下)', '朱兴文', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202202-202202202choosecourse0201', '202202202choosecourse0201', '202202202', 89, '高等数学II(上)', '王慧峰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202202-202202202choosecourse0202', '202202202choosecourse0202', '202202202', 10, '高等数学II(下)', '王慧峰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202202-202202202choosecourse0203', '202202202choosecourse0203', '202202202', 3, '大学英语II(上)', '王慧峰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202202-202202202choosecourse0204', '202202202choosecourse0204', '202202202', 83, '大学英语II(下)', '王慧峰', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202203-202202203choosecourse0201', '202202203choosecourse0201', '202202203', 66, '高等数学II(上)', '周玉霞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202203-202202203choosecourse0202', '202202203choosecourse0202', '202202203', 75, '高等数学II(下)', '周玉霞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202203-202202203choosecourse0203', '202202203choosecourse0203', '202202203', 97, '大学英语II(上)', '周玉霞', '2023-04-15 00:41:15');
INSERT INTO `t_score` VALUES ('202202203-202202203choosecourse0204', '202202203choosecourse0204', '202202203', 95, '大学英语II(下)', '周玉霞', '2023-04-15 00:41:15');

-- ----------------------------
-- Table structure for t_stu_message
-- ----------------------------
DROP TABLE IF EXISTS `t_stu_message`;
CREATE TABLE `t_stu_message`  (
  `msg_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `stu_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `tea_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `msg_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `msg_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_state` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '未读',
  PRIMARY KEY (`msg_id`) USING BTREE,
  INDEX `FK_Reference_5`(`tea_id`) USING BTREE,
  INDEX `FK_Reference_6`(`stu_id`) USING BTREE,
  CONSTRAINT `FK_Reference_5` FOREIGN KEY (`tea_id`) REFERENCES `t_teacher` (`tea_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_Reference_6` FOREIGN KEY (`stu_id`) REFERENCES `t_student` (`stu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_stu_message
-- ----------------------------
INSERT INTO `t_stu_message` VALUES ('tea2019011msg2019011011c71f25f-0483-48f0-9dba-f6cb638bce9a', '201901101', 'tea2019011', '再不努力小心叫家长', '2023-04-12 18:25:05', '已读');
INSERT INTO `t_stu_message` VALUES ('tea2019011msg201901103ae6a5b56-127b-4f46-b1f0-3e14e6ada779', '201901103', 'tea2019011', '好好保持，说不定能保研', '2023-04-12 18:25:33', '未读');

-- ----------------------------
-- Table structure for t_student
-- ----------------------------
DROP TABLE IF EXISTS `t_student`;
CREATE TABLE `t_student`  (
  `stu_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `tea_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `class_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `major_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `stu_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `admission_year` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `class_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `stu_ID_card` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `stu_pwd` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `class_no` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `major_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `tea_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `message_num` int NULL DEFAULT 0,
  `deleted` int NULL DEFAULT 0,
  PRIMARY KEY (`stu_id`) USING BTREE,
  INDEX `FK_Reference_10`(`major_id`) USING BTREE,
  INDEX `FK_Reference_8`(`class_id`) USING BTREE,
  CONSTRAINT `FK_Reference_10` FOREIGN KEY (`major_id`) REFERENCES `t_major` (`major_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_Reference_8` FOREIGN KEY (`class_id`) REFERENCES `t_class` (`class_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_student
-- ----------------------------
INSERT INTO `t_student` VALUES ('201901101', 'tea2019011', '2019011', '01', '丁仁亮', '2019', '2019级计算机科学与技术1班', '340203197807094379', '$2a$10$YOVYoDl2vFo0gQtLNFMhUeroWYOBKJnaZ9gGlZ/p/6BgkdzGTb0WK', '1', '计算机科学与技术', '2023-04-04 22:21:00', '郑兴国', 1, 0);
INSERT INTO `t_student` VALUES ('201901102', 'tea2019011', '2019011', '01', '孙传文', '2019', '2019级计算机科学与技术1班', '33102319850422623X', '$2a$10$YCOO240XoXXQ053tyJnAgeRrdTUV5Q4AuhT1dAYASn8dIad17OHM2', '1', '计算机科学与技术', '2023-04-04 22:22:06', '郑兴国', 0, 0);
INSERT INTO `t_student` VALUES ('201901103', 'tea2019011', '2019011', '01', '刘雪娇', '2019', '2019级计算机科学与技术1班', '211011198810230453', '$2a$10$U8tQzvbqJUbBn3wXHigVMeBHUWKSmZ8kyxBC3sYTAIj80HbLp/.Da', '1', '计算机科学与技术', '2023-04-04 22:22:19', '郑兴国', 1, 0);
INSERT INTO `t_student` VALUES ('201901201', 'tea2019012', '2019012', '01', '许双喜', '2019', '2019级计算机科学与技术2班', '371402198704102538', '$2a$10$oiybj.AkWGkHLWTjG5TNkueEdOj5mdKAVeO7MdTXqAU753t3/nwOm', '2', '计算机科学与技术', '2023-04-04 22:22:44', '陈庆凯', 0, 0);
INSERT INTO `t_student` VALUES ('201901202', 'tea2019012', '2019012', '01', '赵胜华', '2019', '2019级计算机科学与技术2班', '230716198502174616', '$2a$10$xUDeLDaTkEMiZm9ukfbPIeV4pApTGHmTrVlMNDskxd1JH8WjqeT7G', '2', '计算机科学与技术', '2023-04-04 22:23:02', '陈庆凯', 0, 0);
INSERT INTO `t_student` VALUES ('201901203', 'tea2019012', '2019012', '01', '李长宇', '2019', '2019级计算机科学与技术2班', '350122198705124055', '$2a$10$a7xEyMYMUIkEkdsVNTpVdeqOwYLnz3FwkSXn0XteqCaTaRO29uFVy', '2', '计算机科学与技术', '2023-04-04 22:23:13', '陈庆凯', 0, 0);
INSERT INTO `t_student` VALUES ('201902101', 'tea2019021', '2019021', '02', '胡颖茹', '2019', '2019级土木工程1班', '150727199101162343', '$2a$10$LM87GnlgQ50ySDDDmwwUquP2GgudRl2ddzUbO/AHXyvtHkqo3gsky', '1', '土木工程', '2023-04-04 22:23:47', '赵继华', 0, 0);
INSERT INTO `t_student` VALUES ('201902102', 'tea2019021', '2019021', '02', '万传春', '2019', '2019级土木工程1班', '350122198312197237', '$2a$10$ZQtShyo5pr.Rye5Pno9.nuDCjPPT48OwLt6vaTBreXCa8tff1MTZy', '1', '土木工程', '2023-04-04 22:24:26', '赵继华', 0, 0);
INSERT INTO `t_student` VALUES ('201902103', 'tea2019021', '2019021', '02', '张开平', '2019', '2019级土木工程1班', '320405197312281498', '$2a$10$hR19gfnIGqBAyHoIr3X1BO2bd1Nrk7hJzbj52LXX3dw7dHqIKX7si', '1', '土木工程', '2023-04-04 22:24:41', '赵继华', 0, 0);
INSERT INTO `t_student` VALUES ('201902201', 'tea2019022', '2019022', '02', '王本政', '2019', '2019级土木工程2班', '21138119851020403X', '$2a$10$qkD2lxbcmuCTMt0zIQhtku3UY9ZzpxvoU4Dv6Sc9tdFeNKJIuroUi', '2', '土木工程', '2023-04-04 22:24:56', '羊岳君', 0, 0);
INSERT INTO `t_student` VALUES ('201902202', 'tea2019022', '2019022', '02', '李兆瑞', '2019', '2019级土木工程2班', '340822197812018452', '$2a$10$Q3Bz9Pw9Ujm1ZLh3qtSDq.v3Wpnb0yEhm1twV9MNWE5l2J2cCXl.K', '2', '土木工程', '2023-04-04 22:25:09', '羊岳君', 0, 0);
INSERT INTO `t_student` VALUES ('201902203', 'tea2019022', '2019022', '02', '杨茂林', '2019', '2019级土木工程2班', '150725199411307170', '$2a$10$gsyaSnBIG/FQTkr5zssDyuN6LPpsuEK2YW02VblCZSoPX4OnZbdbS', '2', '土木工程', '2023-04-06 02:38:00', '羊岳君', 0, 0);
INSERT INTO `t_student` VALUES ('202001101', 'tea2020011', '2020011', '01', '史程杰', '2020', '2020级计算机科学与技术1班', '411402197405276878', '$2a$10$EaDG/owVUfzyQ6JNwAeRe.JAG9Iz6MG4BYD1RSo2rMuH6T402Y7fq', '1', '计算机科学与技术', '2023-04-04 22:25:28', '罗红春', 0, 0);
INSERT INTO `t_student` VALUES ('202001102', 'tea2020011', '2020011', '01', '李海鹰', '2020', '2020级计算机科学与技术1班', '130421198712318834', '$2a$10$e0dUWQys.peVE4K9DEv.suFU.NjZci3INeY5ZOZq.ZEIRb0V6JewG', '1', '计算机科学与技术', '2023-04-04 22:25:43', '罗红春', 0, 0);
INSERT INTO `t_student` VALUES ('202001103', 'tea2020011', '2020011', '01', '李启龙', '2020', '2020级计算机科学与技术1班', '140123199211057632', '$2a$10$KSDwhGDQWhhkimC4UgPjx.TLZFXZXSwwJwNN5y23OrgSB1mXGJrCK', '1', '计算机科学与技术', '2023-04-04 22:25:55', '罗红春', 0, 0);
INSERT INTO `t_student` VALUES ('202001201', 'tea2020012', '2020012', '01', '刘英华', '2020', '2020级计算机科学与技术2班', '411402197802242313', '$2a$10$P.ytXAtbEVysFDRTIEfhxelMJrk95ZoP3eNs8kOkZDqGEIsYCECpu', '2', '计算机科学与技术', '2023-04-04 22:26:08', '施圣达', 0, 0);
INSERT INTO `t_student` VALUES ('202001202', 'tea2020012', '2020012', '01', '陈周胜', '2020', '2020级计算机科学与技术2班', '211381197308013956', '$2a$10$TrPNqoctTEzkW27yNz39XOaD8JdI4JULRLnEdA8s38EDzpxdC192q', '2', '计算机科学与技术', '2023-04-04 22:29:44', '施圣达', 0, 0);
INSERT INTO `t_student` VALUES ('202001203', 'tea2020012', '2020012', '01', '蔡宗仁', '2020', '2020级计算机科学与技术2班', '150802198509284399', '$2a$10$aExSZThnjmvx76AqwJvX2ObSvkpjFXuHkfyLEGeCPbJRbGVjGUk4G', '2', '计算机科学与技术', '2023-04-04 22:30:10', '施圣达', 0, 0);
INSERT INTO `t_student` VALUES ('202002101', 'tea2020021', '2020021', '02', '黄天杰', '2020', '2020级土木工程1班', '370103198903247632', '$2a$10$5oUqfBxmit955oJKqaNbmeBtGbqh3pti6biRkUzsYCY3T3OoBJk/i', '1', '土木工程', '2023-04-04 22:31:00', '张子云', 0, 0);
INSERT INTO `t_student` VALUES ('202002102', 'tea2020021', '2020021', '02', '王海辉', '2020', '2020级土木工程1班', '130629198302085574', '$2a$10$1Pop4VI3WJfLVptZM8WE3OHZkad8seoUE1cLZ.ShPcB4pZG/28iV.', '1', '土木工程', '2023-04-04 22:31:20', '张子云', 0, 0);
INSERT INTO `t_student` VALUES ('202002103', 'tea2020021', '2020021', '02', '孙永明', '2020', '2020级土木工程1班', '370103198802159473', '$2a$10$J6YZCrOuJZQj64/dQjq.DOEwa2SfOS7n0TDZIMWXxgvctRWWOrOt.', '1', '土木工程', '2023-04-04 22:31:32', '张子云', 0, 0);
INSERT INTO `t_student` VALUES ('202002201', 'tea2020022', '2020022', '02', '赵小强', '2020', '2020级土木工程2班', '130133199106190213', '$2a$10$0YPyGiNj/9g3Bm4c6DCPc.TR1dIbXV7fgm8ZKoDGHOW9W701NrSee', '2', '土木工程', '2023-04-04 22:31:47', '蒋科俊', 0, 0);
INSERT INTO `t_student` VALUES ('202002202', 'tea2020022', '2020022', '02', '严晓庆', '2020', '2020级土木工程2班', '230127198502175818', '$2a$10$Vh0P4ek09.2VFIDjpXbzAuCCcaVgrDRcNrXvumEXGMpju7rP9IRqW', '2', '土木工程', '2023-04-04 22:32:02', '蒋科俊', 0, 0);
INSERT INTO `t_student` VALUES ('202002203', 'tea2020022', '2020022', '02', '张鸿云', '2020', '2020级土木工程2班', '130322199405127398', '$2a$10$43s0u023LGzIOXAmYzNduumyHV/Ii4R7FfhyTxvw50/ZPt5cZFjmW', '2', '土木工程', '2023-04-04 22:32:17', '蒋科俊', 0, 0);
INSERT INTO `t_student` VALUES ('202101101', 'tea2021011', '2021011', '01', '陈顺莉', '2021', '2021级计算机科学与技术1班', '330185199403143003', '$2a$10$Ov4hgT73yT0GoVJLE4DJSORixsMgDQ1jU/oV9CaPr9DVyomBCP1Ke', '1', '计算机科学与技术', '2023-04-04 22:32:37', '钟伟昌', 0, 0);
INSERT INTO `t_student` VALUES ('202101102', 'tea2021011', '2021011', '01', '任江涛', '2021', '2021级计算机科学与技术1班', '21021119750625187X', '$2a$10$PN.z8UyE8NtiVH3Ol2l/ke6r89UQViPVeFctCLG9GY.jQnTQys1ly', '1', '计算机科学与技术', '2023-04-04 22:32:59', '钟伟昌', 0, 0);
INSERT INTO `t_student` VALUES ('202101103', 'tea2021011', '2021011', '01', '吴冰冰', '2021', '2021级计算机科学与技术1班', '150825198608264486', '$2a$10$YgLzKloOC2cisEwmUDqim.7A5M1BKRf3zEwo8G10JGp6jZ0Zlh9w2', '1', '计算机科学与技术', '2023-04-04 22:33:12', '钟伟昌', 0, 0);
INSERT INTO `t_student` VALUES ('202101201', 'tea2021012', '2021012', '01', '邹志伟', '2021', '2021级计算机科学与技术2班', '370124198904298265', '$2a$10$u5PZy3S00aZy.h5GwdZ00umPQMi3RZXteqUZEZ11SKQTzeAbUmsMG', '2', '计算机科学与技术', '2023-04-04 22:33:34', '张启跃', 0, 0);
INSERT INTO `t_student` VALUES ('202101202', 'tea2021012', '2021012', '01', '张永山', '2021', '2021级计算机科学与技术2班', '150921197403105890', '$2a$10$6cZdlai8x3FZvh2SNAbuL.INp3N4f7Z2ZkvxJN3t9vfOf1AVqZf2e', '2', '计算机科学与技术', '2023-04-04 22:33:57', '张启跃', 0, 0);
INSERT INTO `t_student` VALUES ('202101203', 'tea2021012', '2021012', '01', '陆春华', '2021', '2021级计算机科学与技术2班', '220181198905256651', '$2a$10$g.fDCxy5b5Ti8Y3uCG8CuuOp1KGkc4kThdW6PrXzBgy8mXLT4ptWe', '2', '计算机科学与技术', '2023-04-04 22:34:17', '张启跃', 0, 0);
INSERT INTO `t_student` VALUES ('202102101', 'tea2021021', '2021021', '02', '郭春杰', '2021', '2021级土木工程1班', '140223199109059450', '$2a$10$PntsjxivjUHuFjRjR.57FOj6OwUxCLrEcmvXd09jGx6oYr0kfjNgO', '1', '土木工程', '2023-04-04 22:34:49', '胡梦林', 0, 0);
INSERT INTO `t_student` VALUES ('202102102', 'tea2021021', '2021021', '02', '李阳宇', '2021', '2021级土木工程1班', '22028319900219443X', '$2a$10$KKS.u9TJF0POcPPyf6CSVO.682MuFlWVe1.O/QrSlnwstjPxp62/e', '1', '土木工程', '2023-04-04 22:34:59', '胡梦林', 0, 0);
INSERT INTO `t_student` VALUES ('202102103', 'tea2021021', '2021021', '02', '吴波涛', '2021', '2021级土木工程1班', '320206199009259858', '$2a$10$uePgg8sQXb9PQeMjY5Sd1OqpppvGmNfvbX0DyJIT1mkMp5b6K7XfK', '1', '土木工程', '2023-04-04 22:35:30', '胡梦林', 0, 0);
INSERT INTO `t_student` VALUES ('202102201', 'tea2021022', '2021022', '02', '朱军伟', '2021', '2021级土木工程2班', '230716198109129616', '$2a$10$h0o9q0TTdfExXgtNlb/YNOY3ybyUXmYL6qlhUq.W3VGAUVS8YbqDW', '2', '土木工程', '2023-04-04 22:35:52', '周宗格', 0, 0);
INSERT INTO `t_student` VALUES ('202102202', 'tea2021022', '2021022', '02', '王桂红', '2021', '2021级土木工程2班', '130529198112188438', '$2a$10$vOpJOZOctbF1OtYsFOvqoe94axF6A5qEpCFJf9RhB86DuJmLrlBMq', '2', '土木工程', '2023-04-04 22:36:16', '周宗格', 0, 0);
INSERT INTO `t_student` VALUES ('202102203', 'tea2021022', '2021022', '02', '马玉玲', '2021', '2021级土木工程2班', '230403197901200460', '$2a$10$LJHjmMNkf5FQawmRbHhVbuHzgCFieTNQw0msCQ2CC/sPdtPeg4tZy', '2', '土木工程', '2023-04-04 22:36:31', '周宗格', 0, 0);
INSERT INTO `t_student` VALUES ('202201101', 'tea2022011', '2022011', '01', '王长江', '2022', '2022级计算机科学与技术1班', '340181199012112193', '$2a$10$nUmApH3.fkK.tVStnyxZmepzTwO3XxK7ypHj7jAgghJl/CQlEJF6i', '1', '计算机科学与技术', '2023-04-04 22:37:26', '马志鹏', 0, 0);
INSERT INTO `t_student` VALUES ('202201102', 'tea2022011', '2022011', '01', '卓志文', '2022', '2022级计算机科学与技术1班', '350723197501063734', '$2a$10$YQX2GtXFCqS5o4MvIy9/KuVAuVoKtOINqkrI1KdmusEfFR5EqvDui', '1', '计算机科学与技术', '2023-04-04 22:37:37', '马志鹏', 0, 0);
INSERT INTO `t_student` VALUES ('202201103', 'tea2022011', '2022011', '01', '朱荣达', '2022', '2022级计算机科学与技术1班', '150725198312013156', '$2a$10$TVHGBUXBwr4fui//Wvw/0O4P7.ChERKboNKCo6Kz4OBJToxzqiu0i', '1', '计算机科学与技术', '2023-04-04 22:38:11', '马志鹏', 0, 0);
INSERT INTO `t_student` VALUES ('202201201', 'tea2022012', '2022012', '01', '孟德欣', '2022', '2022级计算机科学与技术2班', '23071619931201259X', '$2a$10$GIbybTn5Q3.warw9QjgMwes7heiO04.jiAJgEcNec6RVK0Di6zz2C', '2', '计算机科学与技术', '2023-04-04 22:38:23', '杨永德', 0, 0);
INSERT INTO `t_student` VALUES ('202201202', 'tea2022012', '2022012', '01', '陈天华', '2022', '2022级计算机科学与技术2班', '211011197911225579', '$2a$10$uzn5N7U8Vnjg6XzTAlcAxuAiI3sM8xWyy5G1pCHW/wohfcwfyQ0NC', '2', '计算机科学与技术', '2023-04-04 22:38:33', '杨永德', 0, 0);
INSERT INTO `t_student` VALUES ('202201203', 'tea2022012', '2022012', '01', '毕伟民', '2022', '2022级计算机科学与技术2班', '130629197803162633', '$2a$10$SteXu1L6fv/HKKkd0fmIvOi5.D/E0NTKi9QhdPgw4LWDzqyTw0C4W', '2', '计算机科学与技术', '2023-04-04 22:38:47', '杨永德', 0, 0);
INSERT INTO `t_student` VALUES ('202202101', 'tea2022021', '2022021', '02', '周孝为', '2022', '2022级土木工程1班', '150802198603203938', '$2a$10$nqIW9/EZL65AXXI0hUBrL.RBUa0zAmQnGp89bUceqkahWdocjG/Xu', '1', '土木工程', '2023-04-04 22:39:02', '楚虹阳', 0, 0);
INSERT INTO `t_student` VALUES ('202202102', 'tea2022021', '2022021', '02', '徐新玉', '2022', '2022级土木工程1班', '230882198212142375', '$2a$10$ul4rxWJF4EcKw583krARQO1WZChuiMG.XgyvvqNYFH/JGAmmoKkSK', '1', '土木工程', '2023-04-04 22:39:29', '楚虹阳', 0, 0);
INSERT INTO `t_student` VALUES ('202202103', 'tea2022021', '2022021', '02', '孙宏芳', '2022', '2022级土木工程1班', '341203198810193138', '$2a$10$HOMa7lE9NRDC7FoqpGumZuLYftR8mOvwq8lEFkIfYNdXXJ66KtfRi', '1', '土木工程', '2023-04-04 22:39:39', '楚虹阳', 0, 0);
INSERT INTO `t_student` VALUES ('202202201', 'tea2022022', '2022022', '02', '朱兴文', '2022', '2022级土木工程2班', '330421197306107698', '$2a$10$IzyBw5BREo9ORxDDB8PeAeSVkwo9LT0SOZtA5cYW2ly088oINEiOG', '2', '土木工程', '2023-04-04 22:40:02', '赵元丰', 0, 0);
INSERT INTO `t_student` VALUES ('202202202', 'tea2022022', '2022022', '02', '王慧峰', '2022', '2022级土木工程2班', '36110219741015097X', '$2a$10$qYqeCKLziKmYmnIrx6HJVu73n5IX3sg6a2nR3uJDfFNnmide0M2i6', '2', '土木工程', '2023-04-04 22:40:17', '赵元丰', 0, 0);
INSERT INTO `t_student` VALUES ('202202203', 'tea2022022', '2022022', '02', '周玉霞', '2022', '2022级土木工程2班', '210505197706052428', '$2a$10$sm1WI04A.aFVj.kSkdPO5.30/yZJ1mbQkF0SKwNadmRbgHgy2jhQy', '2', '土木工程', '2023-04-04 22:40:50', '赵元丰', 0, 0);

-- ----------------------------
-- Table structure for t_tea_message
-- ----------------------------
DROP TABLE IF EXISTS `t_tea_message`;
CREATE TABLE `t_tea_message`  (
  `msg_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `tea_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `stu_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `msg_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `msg_time` datetime NULL DEFAULT NULL,
  INDEX `f15`(`stu_id`) USING BTREE,
  INDEX `f16`(`tea_id`) USING BTREE,
  CONSTRAINT `f15` FOREIGN KEY (`stu_id`) REFERENCES `t_student` (`stu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `f16` FOREIGN KEY (`tea_id`) REFERENCES `t_teacher` (`tea_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_tea_message
-- ----------------------------
INSERT INTO `t_tea_message` VALUES ('tea2019011msg201901101a0665fe6-530d-4e29-bb29-22c0af634c38', 'tea2019011', '201901101', '再不努力小心叫家长', '2023-04-12 18:25:05');
INSERT INTO `t_tea_message` VALUES ('tea2019011msg20190110344cc001d-5e19-4c72-89fb-9fd11a61e474', 'tea2019011', '201901103', '好好保持，说不定能保研', '2023-04-12 18:25:33');

-- ----------------------------
-- Table structure for t_teacher
-- ----------------------------
DROP TABLE IF EXISTS `t_teacher`;
CREATE TABLE `t_teacher`  (
  `tea_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `major_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `tea_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `class_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `tea_pwd` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `tea_ID_card` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL,
  `class_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `major_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `class_no` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `class_year` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`tea_id`) USING BTREE,
  INDEX `FK_Reference_3`(`class_id`) USING BTREE,
  INDEX `FK_Reference_4`(`major_id`) USING BTREE,
  CONSTRAINT `FK_Reference_3` FOREIGN KEY (`class_id`) REFERENCES `t_class` (`class_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_Reference_4` FOREIGN KEY (`major_id`) REFERENCES `t_major` (`major_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_teacher
-- ----------------------------
INSERT INTO `t_teacher` VALUES ('tea2019011', '01', '郑兴国', '2019级计算机科学与技术1班', '$2a$10$GwKBtMZ0WbtmoYAqm6uV0OPBW7KGR8q4UkZqxBjk7g.mefgZwA6b2', '230716198508113312', '2023-04-04 22:15:21', '2019011', '计算机科学与技术', '1', '2019');
INSERT INTO `t_teacher` VALUES ('tea2019012', '01', '陈庆凯', '2019级计算机科学与技术2班', '$2a$10$wUTTiBJVa889iZOpz5JDLeUtzGMt8cmNlmMMM9dRoc4YtGRup.YLu', '14012319881208499X', '2023-04-04 22:15:42', '2019012', '计算机科学与技术', '2', '2019');
INSERT INTO `t_teacher` VALUES ('tea2019021', '02', '赵继华', '2019级土木工程1班', '$2a$10$JpXd/ELdfg7SSp5pVz1H/OgsXA4Z0j9PMVROniBs6OgJ3/y9VW1AK', '220181198411232094', '2023-04-04 22:17:31', '2019021', '土木工程', '1', '2019');
INSERT INTO `t_teacher` VALUES ('tea2019022', '02', '羊岳君', '2019级土木工程2班', '$2a$10$o06VbvRuZRFX3fRPXypqcemIoBvHhDOJDyK1DMjsEhe9kcMRX0VnO', '230716198803293133', '2023-04-04 22:17:43', '2019022', '土木工程', '2', '2019');
INSERT INTO `t_teacher` VALUES ('tea2020011', '01', '罗红春', '2020级计算机科学与技术1班', '$2a$10$qSzT7jogGq3vuvyMpw1O3.4JXwt024idH2zR4E0VooRk75TLXucsm', '130629198807257175', '2023-04-04 22:18:04', '2020011', '计算机科学与技术', '1', '2020');
INSERT INTO `t_teacher` VALUES ('tea2020012', '01', '施圣达', '2020级计算机科学与技术2班', '$2a$10$6qCTJi0OVP6MCj7iyD8uguZbk8VIW5Bu17d6Ji1i.bMVjuZyhH5JS', '211011197908073738', '2023-04-04 22:18:36', '2020012', '计算机科学与技术', '2', '2020');
INSERT INTO `t_teacher` VALUES ('tea2020021', '02', '张子云', '2020级土木工程1班', '$2a$10$LqcfWGQ/KDSV1wp/HbDlwe7qWNLiq.nL45hLLCUtLzOlzUCLGnPsK', '320206198001244235', '2023-04-04 22:18:18', '2020021', '土木工程', '1', '2020');
INSERT INTO `t_teacher` VALUES ('tea2020022', '02', '蒋科俊', '2020级土木工程2班', '$2a$10$kU7iEcHQ1EhcGHDJZLhCoexUcugCmRSaW8b.bD4ijlSvyu9uuV81a', '411402198204281851', '2023-04-04 22:19:12', '2020022', '土木工程', '2', '2020');
INSERT INTO `t_teacher` VALUES ('tea2021011', '01', '钟伟昌', '2021级计算机科学与技术1班', '$2a$10$ud9u3UGAqfvCrG4G99P8AubG7JMXZg/pKaoeKVuIY.qd8owh50cwO', '230421198812100174', '2023-04-04 22:19:25', '2021011', '计算机科学与技术', '1', '2021');
INSERT INTO `t_teacher` VALUES ('tea2021012', '01', '张启跃', '2021级计算机科学与技术2班', '$2a$10$qVIm0R37nJ827x0GjKTL/.0rWyJmtnooWfQ8rsxBe8AseX8X1WlMe', '130703198711115975', '2023-04-04 22:19:56', '2021012', '计算机科学与技术', '2', '2021');
INSERT INTO `t_teacher` VALUES ('tea2021021', '02', '胡梦林', '2021级土木工程1班', '$2a$10$8PIIv0b62xypbWpC5.h5eeYIKv6h5gaqvHmYd4gjyQKTkezMgNQeO', '150725197310110310', '2023-04-04 22:19:43', '2021021', '土木工程', '1', '2021');
INSERT INTO `t_teacher` VALUES ('tea2021022', '02', '周宗格', '2021级土木工程2班', '$2a$10$dRjbXCH5EslH4OLNTA2hYeYc74b9jad.EfuHhCbWCfoyNBILjpzbK', '350402198906037952', '2023-04-04 22:20:07', '2021022', '土木工程', '2', '2021');
INSERT INTO `t_teacher` VALUES ('tea2022011', '01', '马志鹏', '2022级计算机科学与技术1班', '$2a$10$ey6/1Qc.pTTwudkjrHPLI.j20hj45ltJsw/2oPj.5yKY0LIOCNoky', '320405197902145912', '2023-04-04 22:20:25', '2022011', '计算机科学与技术', '1', '2022');
INSERT INTO `t_teacher` VALUES ('tea2022012', '01', '杨永德', '2022级计算机科学与技术2班', '$2a$10$AnRQt4mk5/YexeZlM8vggehHvqyACAmPL.CPscDen3c0PGdjICuOW', '150725197812285292', '2023-04-04 22:20:59', '2022012', '计算机科学与技术', '2', '2022');
INSERT INTO `t_teacher` VALUES ('tea2022021', '02', '楚虹阳', '2022级土木工程1班', '$2a$10$Aa2c6EDxqduylnB23bfANeabd8dKFfqbSnKTolZD3bDO/ATOUbc86', '130529197710246373', '2023-04-04 22:20:42', '2022021', '土木工程', '1', '2022');
INSERT INTO `t_teacher` VALUES ('tea2022022', '02', '赵元丰', '2022级土木工程2班', '$2a$10$d1dtSEVJuYv2.jtfRaSdnO4LTzgoy.INHDnoCyZJu3X0CCXAFLyjy', '331023199008094770', '2023-04-04 22:21:10', '2022022', '土木工程', '2', '2022');

SET FOREIGN_KEY_CHECKS = 1;