-- MySQL dump 10.13  Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: student_ms
-- ------------------------------------------------------
-- Server version	8.0.41

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `student_ms`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `student_ms` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `student_ms`;

--
-- Table structure for table `classes`
--

DROP TABLE IF EXISTS `classes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `classes` (
  `class_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `grade_level` enum('大一','大二','大三','大四','研究生','博士','博士后') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `class_teacher_id` int DEFAULT NULL,
  `students_number` int DEFAULT NULL,
  PRIMARY KEY (`class_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='班级信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `classes`
--

LOCK TABLES `classes` WRITE;
/*!40000 ALTER TABLE `classes` DISABLE KEYS */;
INSERT INTO `classes` (`class_id`, `name`, `grade_level`, `class_teacher_id`, `students_number`) VALUES (1,'A1班','大一',11,45),(2,'A2班','大一',8,40),(3,'A3班','大一',12,38),(4,'B1班','大二',10,42),(5,'B2班','大二',6,39),(6,'B3班','大二',15,35),(7,'C1班','大三',4,43),(8,'C2班','大三',7,41),(9,'C3班','大三',16,43),(10,'D1班','大四',19,41),(11,'D2班','大四',5,43),(12,'D3班','大四',1,41),(13,'软件工程研究生班','研究生',3,20),(14,'软件工程博士班','博士',9,5),(15,'软件工程博士后班','博士后',20,3);
/*!40000 ALTER TABLE `classes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `courses`
--

DROP TABLE IF EXISTS `courses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses` (
  `course_id` int NOT NULL AUTO_INCREMENT,
  `course_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `course_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `credit` tinyint DEFAULT NULL,
  `capacity` int DEFAULT NULL,
  `enrolled` int DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`course_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='课程信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `courses`
--

LOCK TABLES `courses` WRITE;
/*!40000 ALTER TABLE `courses` DISABLE KEYS */;
INSERT INTO `courses` (`course_id`, `course_name`, `course_description`, `credit`, `capacity`, `enrolled`, `create_time`) VALUES (1,'程序设计基础','学习C语言编程基础，掌握结构化编程思想',3,120,115,'2025-04-14 15:02:19'),(2,'面向对象程序设计','Java语言实现面向对象三大特性及设计模式',4,100,98,'2025-04-14 15:02:19'),(3,'数据结构与算法','研究数据组织、存储和处理的算法设计',4,90,88,'2025-04-14 15:02:19'),(4,'计算机组成原理','理解计算机硬件系统结构与工作原理',3,100,95,'2025-04-14 15:02:19'),(5,'操作系统原理','学习进程管理、内存管理和文件系统实现',3,80,78,'2025-04-14 15:02:19'),(6,'计算机网络','掌握TCP/IP协议栈及网络编程技术',3,100,97,'2025-04-14 15:02:19'),(7,'软件工程导论','软件开发生命周期与过程模型',2,150,142,'2025-04-14 15:02:19'),(8,'软件需求工程','需求获取、分析与规格说明技术',3,80,76,'2025-04-14 15:02:19'),(9,'软件体系结构','软件系统高层结构设计与模式应用',3,70,68,'2025-04-14 15:02:19'),(10,'软件质量保证与测试','黑盒/白盒测试方法与自动化测试',3,90,87,'2025-04-14 15:02:19'),(11,'数据库系统原理','关系数据库设计与SQL语言实践',4,110,108,'2025-04-14 15:02:19'),(12,'大数据技术基础','Hadoop/Spark分布式计算框架',3,60,58,'2025-04-14 15:02:19'),(13,'人工智能基础','机器学习基础算法与智能系统设计',3,80,78,'2025-04-14 15:02:19'),(14,'云计算与分布式系统','容器技术与微服务架构实践',3,70,65,'2025-04-14 15:02:19'),(15,'移动应用开发','Android/iOS跨平台开发技术',3,60,58,'2025-04-14 15:02:19'),(16,'网络安全基础','密码学原理与系统安全防护技术',3,70,66,'2025-04-14 15:02:19'),(17,'Web前端开发','HTML5/CSS3/JavaScript全栈开发',3,80,77,'2025-04-14 15:02:19'),(18,'软件项目管理','敏捷开发与Scrum项目管理实践',2,50,48,'2025-04-14 15:02:19'),(19,'离散数学','为计算机科学提供数学基础理论',4,120,118,'2025-04-14 15:02:19'),(20,'编译原理','程序设计语言编译器实现原理',3,60,55,'2025-04-14 15:02:19'),(21,'人机交互设计','UI/UX设计原则与原型开发',2,40,38,'2025-04-14 15:02:19'),(22,'企业级应用开发','Spring Cloud微服务架构实践',3,50,47,'2025-04-14 15:02:19');
/*!40000 ALTER TABLE `courses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `select_course`
--

DROP TABLE IF EXISTS `select_course`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `select_course` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` int DEFAULT NULL,
  `course_id` int DEFAULT NULL,
  `enrollment_time` datetime DEFAULT NULL,
  `grade` decimal(4,1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `student_course_pk` (`student_id`,`course_id`) USING BTREE,
  KEY `student_course_courses_course_id_fk` (`course_id`) USING BTREE,
  CONSTRAINT `student_course_courses_course_id_fk` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `student_course_students_student_id_fk` FOREIGN KEY (`student_id`) REFERENCES `students` (`student_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='选课表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `select_course`
--

LOCK TABLES `select_course` WRITE;
/*!40000 ALTER TABLE `select_course` DISABLE KEYS */;
INSERT INTO `select_course` (`id`, `student_id`, `course_id`, `enrollment_time`, `grade`) VALUES (1,1,3,'2023-09-05 10:15:00',88.5),(2,1,15,'2023-09-12 14:20:00',62.0),(3,2,7,'2023-09-06 11:30:00',76.0),(4,3,22,'2023-09-07 09:45:00',92.5),(5,4,5,'2023-09-08 13:10:00',68.5),(6,5,18,'2023-09-09 15:25:00',71.5),(7,6,2,'2023-09-10 16:40:00',81.0),(8,7,9,'2023-09-11 10:05:00',94.5),(9,8,12,'2023-09-12 14:15:00',53.0),(10,9,1,'2023-09-13 08:30:00',58.8),(11,10,20,'2023-09-14 12:45:00',72.5),(12,11,6,'2023-09-15 09:20:00',89.0),(13,12,11,'2023-09-16 11:35:00',61.5),(14,13,4,'2023-09-17 13:50:00',97.0),(15,14,17,'2023-09-18 15:05:00',84.5),(16,15,8,'2023-09-19 10:25:00',79.5),(17,16,13,'2023-09-20 14:40:00',84.0),(18,17,10,'2023-09-21 16:55:00',58.5),(19,18,19,'2023-09-22 09:10:00',91.5),(20,19,14,'2023-09-23 12:25:00',66.6),(21,20,16,'2023-09-24 08:45:00',66.0),(22,1,8,'2024-03-01 10:00:00',82.5),(23,5,3,'2024-03-02 14:15:00',77.0),(24,10,5,'2024-03-03 09:30:00',93.3),(25,15,12,'2024-03-04 11:45:00',89.5),(26,20,7,'2024-03-05 13:00:00',73.0),(27,25,22,'2024-03-06 15:20:00',95.5),(28,30,18,'2024-03-07 16:35:00',48.5),(29,3,14,'2024-09-10 08:50:00',68.0),(30,7,6,'2024-09-11 12:05:00',87.5),(31,12,19,'2024-09-12 14:20:00',54.5),(32,18,2,'2024-09-13 16:35:00',81.2),(33,22,9,'2024-09-14 09:50:00',91.0),(34,27,16,'2024-09-15 11:05:00',63.5),(35,30,1,'2025-03-01 10:00:00',0.0),(36,15,22,'2025-03-02 14:15:00',100.0),(37,8,11,'2025-03-03 09:30:00',59.5),(38,20,4,'2025-03-04 11:45:00',59.9);
/*!40000 ALTER TABLE `select_course` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `students`
--

DROP TABLE IF EXISTS `students`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `students` (
  `student_id` int NOT NULL AUTO_INCREMENT,
  `student_number` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `student_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gender` enum('男','女') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `telephone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `domicile_place` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `class_id` int DEFAULT NULL,
  `enrollment_date` date DEFAULT NULL,
  `status` enum('在读','休学','已毕业') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`student_id`) USING BTREE,
  KEY `students_classes_class_id_fk` (`class_id`) USING BTREE,
  CONSTRAINT `students_classes_class_id_fk` FOREIGN KEY (`class_id`) REFERENCES `classes` (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='学生信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `students`
--

LOCK TABLES `students` WRITE;
/*!40000 ALTER TABLE `students` DISABLE KEYS */;
INSERT INTO `students` (`student_id`, `student_number`, `student_name`, `gender`, `birth_date`, `telephone`, `email`, `domicile_place`, `class_id`, `enrollment_date`, `status`) VALUES (1,'202300100001','张晓宇','男','2004-08-15','13811234567','zhangxy@university.edu.cn','北京市海淀区',1,'2023-09-01','在读'),(2,'202300100002','李若彤','女','2005-02-28','13912345678','lirtong@university.edu.cn','上海市浦东新区',1,'2023-09-01','在读'),(3,'202300100003','王浩然','男','2004-11-05','13623456789','wanghr@university.edu.cn','广东省深圳市南山区',1,'2023-09-01','在读'),(4,'202300200004','陈思雨','女','2003-12-24','13534567890','chensy@university.edu.cn','浙江省杭州市西湖区',2,'2023-09-01','休学'),(5,'202300200005','刘子轩','男','2004-06-18','15845678901','liuzx@university.edu.cn','江苏省南京市鼓楼区',2,'2023-09-01','在读'),(6,'202400100006','周雨泽','男','2006-03-12','18656789012','zhouyz@university.edu.cn','四川省成都市锦江区',3,'2024-09-01','在读'),(7,'202400100007','吴雨桐','女','2005-09-09','18767890123','wuyt@university.edu.cn','重庆市渝中区',3,'2024-09-01','在读'),(8,'202400300008','郑浩然','男','2005-07-22','18878901234','zheng@university.edu.cn','湖北省武汉市江汉区',4,'2024-09-01','在读'),(9,'202400300009','赵梦琪','女','2006-01-30','18989012345','zhaomq@university.edu.cn','陕西省西安市雁塔区',4,'2024-09-01','在读'),(10,'202200400010','孙宇航','男','2002-05-19','13390123456','sunyh@alumni.edu.cn','湖南省长沙市岳麓区',5,'2022-09-01','已毕业'),(11,'202200400011','朱雅婷','女','2002-10-08','13401234567','zhuyating@alumni.edu.cn','福建省厦门市思明区',5,'2022-09-01','已毕业'),(12,'202301200012','欧阳靖','男','2003-04-17','15611223344','ouyangj@university.edu.cn','云南省昆明市官渡区',6,'2023-09-01','在读'),(13,'202302300013','慕容雪','女','2004-07-11','15722334455','murongx@university.edu.cn','贵州省贵阳市云岩区',7,'2023-09-01','休学'),(14,'202401200014','公孙策','男','2005-12-25','15833445566','gongsunc@university.edu.cn','山东省青岛市市南区',8,'2024-09-01','在读'),(15,'202403300015','司马燕','女','2006-08-08','15944556677','simayan@university.edu.cn','河南省郑州市金水区',9,'2024-09-01','在读'),(16,'202304500016','尉迟琳','女','2003-03-03','15055667788','weichil@university.edu.cn','山西省太原市小店区',10,'2023-09-01','在读'),(17,'202300100017','林志强','男','2004-09-14','13166778899','linzq@university.edu.cn','吉林省长春市朝阳区',1,'2023-09-01','在读'),(18,'202300200018','黄诗涵','女','2005-01-23','13277889900','huangsh@university.edu.cn','黑龙江省哈尔滨市道里区',2,'2023-09-01','在读'),(19,'202400100019','徐天宇','男','2006-06-06','13388990011','xuty@university.edu.cn','安徽省合肥市蜀山区',3,'2024-09-01','在读'),(20,'202400300020','高晨曦','女','2005-04-04','13499001122','gaocx@university.edu.cn','江西省南昌市东湖区',4,'2024-09-01','在读'),(21,'202200400021','韩东旭','男','2002-11-11','13500112233','handx@alumni.edu.cn','广西省南宁市青秀区',5,'2022-09-01','已毕业'),(22,'202301200022','郭雨欣','女','2003-08-28','13611223344','guoyx@university.edu.cn','海南省海口市龙华区',6,'2023-09-01','在读'),(23,'202302300023','程浩然','男','2004-02-14','13722334455','chenghr@university.edu.cn','甘肃省兰州市城关区',7,'2023-09-01','休学'),(24,'202401200024','陆雨菲','女','2005-10-31','13833445566','luyf@university.edu.cn','宁夏银川市兴庆区',8,'2024-09-01','在读'),(25,'202403300025','石宇航','男','2006-07-07','13944556677','shiyh@university.edu.cn','新疆乌鲁木齐市天山区',9,'2024-09-01','在读'),(26,'202304500026','丁小萌','女','2003-05-20','14055667788','dingxm@university.edu.cn','内蒙古呼和浩特市新城区',10,'2023-09-01','在读'),(27,'202300100027','方文昊','男','2004-12-12','14166778899','fangwh@university.edu.cn','天津市和平区',1,'2023-09-01','在读'),(28,'202300200028','钟雨晴','女','2005-03-21','14277889900','zhongyq@university.edu.cn','河北省石家庄市长安区',2,'2023-09-01','在读'),(29,'202400100029','邱志鹏','男','2006-09-09','14388990011','qiuzp@university.edu.cn','湖南省株洲市天元区',3,'2024-09-01','在读'),(30,'202400300030','袁雅静','女','2005-04-16','14499001122','yuan@university.edu.cn','江苏省苏州市工业园区',4,'2024-09-01','在读'),(64,'202300100001','周一本','男','1988-06-10','13833996266','pnrjean@163.com','河北省石家庄市新华区中华北大街华林国际小区',1,'2008-09-01',NULL),(65,'202300100001','周一本','男','1988-06-10','13833996266','pnrjean@163.com','河北省石家庄市新华区中华北大街华林国际小区',1,'2008-09-01',NULL),(66,'202300100001','周一本','男','1988-06-10','13833996266','pnrjean@163.com','河北省石家庄市新华区中华北大街华林国际小区',1,'2008-09-01',NULL),(67,'202300100001','周一本','男','1988-06-10','13833996266','pnrjean@163.com','河北省石家庄市新华区中华北大街华林国际小区',1,'2008-09-01',NULL);
/*!40000 ALTER TABLE `students` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teachers`
--

DROP TABLE IF EXISTS `teachers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `teachers` (
  `teacher_id` int NOT NULL AUTO_INCREMENT,
  `teacher_number` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gender` enum('男','女') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `title` enum('讲师','副教授','教授') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `teach_course_id` int DEFAULT NULL,
  `department` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `hire_date` date DEFAULT NULL,
  `telephone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`teacher_id`) USING BTREE,
  KEY `teachers_courses_course_id_fk` (`teach_course_id`) USING BTREE,
  CONSTRAINT `teachers_courses_course_id_fk` FOREIGN KEY (`teach_course_id`) REFERENCES `courses` (`course_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='教师信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `teachers`
--

LOCK TABLES `teachers` WRITE;
/*!40000 ALTER TABLE `teachers` DISABLE KEYS */;
INSERT INTO `teachers` (`teacher_id`, `teacher_number`, `name`, `gender`, `title`, `teach_course_id`, `department`, `hire_date`, `telephone`, `email`) VALUES (1,'T20180207','王立伟','男','教授',13,'人工智能学院','2018-09-01','13811223344','wanglw@ai.univ.edu'),(2,'T20200415','陈晓婷','女','讲师',7,'软件学院','2020-04-15','15987654321','chenxt@ss.univ.edu'),(3,'T20210903','李国栋','男','副教授',20,'计算机学院','2021-09-03','13655443322','ligd@cs.univ.edu'),(4,'T20170522','张雪萌','女','教授',2,'网络空间安全学院','2017-05-22','13122334455','zhangxm@nsa.univ.edu'),(5,'T20221208','赵天宇','男','讲师',18,'数据科学学院','2022-12-08','15099887766','zhaoty@ds.univ.edu'),(6,'T20230519','周慧敏','女','讲师',9,'软件学院','2023-05-19','17722334455','zhouhm@ss.univ.edu'),(7,'T20191112','吴启航','男','副教授',22,'计算机学院','2019-11-12','13566778899','wuqh@cs.univ.edu'),(8,'T20210725','郑雨欣','女','讲师',4,'人工智能学院','2021-07-25','18911223344','zhengyx@ai.univ.edu'),(9,'T20180306','方志强','男','教授',17,'网络空间安全学院','2018-03-06','13244556677','fangzq@nsa.univ.edu'),(10,'T20200630','林雅琴','女','副教授',15,'数据科学学院','2020-06-30','18655443322','linyq@ds.univ.edu'),(11,'T20230801','徐浩然','男','讲师',6,'软件学院','2023-08-01','15011223344','xuhr@ss.univ.edu'),(12,'T20161205','黄美琳','女','教授',11,'计算机学院','2016-12-05','13966778899','huangml@cs.univ.edu'),(13,'T20220917','刘振宇','男','副教授',19,'人工智能学院','2022-09-17','17788990011','liuzy@ai.univ.edu'),(14,'T20210214','欧阳倩','女','讲师',3,'网络空间安全学院','2021-02-14','13522446688','ouyangq@nsa.univ.edu'),(15,'T20190410','孙博文','男','教授',8,'数据科学学院','2019-04-10','13877665544','sunbw@ds.univ.edu'),(16,'T20231123','唐雨晴','女','讲师',1,'软件学院','2023-11-23','15900112233','tangyq@ss.univ.edu'),(17,'T20200808','罗家伟','男','副教授',16,'计算机学院','2020-08-08','13611223344','luojw@cs.univ.edu'),(18,'T20170618','蔡晓雯','女','教授',10,'人工智能学院','2017-06-18','13133445566','caixw@ai.univ.edu'),(19,'T20211009','袁天翊','男','讲师',5,'网络空间安全学院','2021-10-09','15066778899','yuanty@nsa.univ.edu'),(20,'T20230405','邓诗涵','女','副教授',21,'数据科学学院','2023-04-05','18955443322','dengsh@ds.univ.edu');
/*!40000 ALTER TABLE `teachers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `update_log`
--

DROP TABLE IF EXISTS `update_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `update_log` (
  `update_id` int NOT NULL AUTO_INCREMENT,
  `update_date` date DEFAULT (curdate()) COMMENT '更新日期',
  `update_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `version_number` varchar(20) NOT NULL,
  PRIMARY KEY (`update_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='更新日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `update_log`
--

LOCK TABLES `update_log` WRITE;
/*!40000 ALTER TABLE `update_log` DISABLE KEYS */;
INSERT INTO `update_log` (`update_id`, `update_date`, `update_content`, `version_number`) VALUES (1,'2025-04-13','开始研究 Visio。','v0.0.1'),(2,'2025-04-13','学会了用Visio画ER图（包括实体关系图、数据表图）。','v0.0.2'),(3,'2025-04-13','把update_content字段的类型从varchar(500)改为了text。','v0.0.3'),(4,'2025-04-13','用Visio画出了学生管理系统的ER图，在数据库中创建了学生信息表、课程信息表、教师信息表、班级表、选课记录表共5个表，初步建成了学生管理系统数据库。','v0.0.4'),(5,'2025-04-13','在数据库中创建了“更新日志表”，学会了“SemVer软件版本控制法”，并开始在学生管理系统中使用这种软件版本控制法。','v0.0.5'),(6,'2025-04-14','发现ER图中缺少teachers表和classes表的联系，已经添加上。','v0.1.0'),(7,'2025-04-15','向6个数据表中都插入了数据，数据插入完毕，接下来就可以对数据进行各种操作了。','v0.1.1'),(8,'2025-04-23','1.修改“更新日志表”中的字段“更新日期”，设置为“默认为当前日期”。\n2.把选课表的名称从course改成了select_course。\n3.给各个表添加了备注。','v0.1.2');
/*!40000 ALTER TABLE `update_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'student_ms'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-09-17 22:26:11
