-- MySQL dump 10.13 Distrib 8.0.42, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: tlias
-- ------------------------------------------------------
-- Server version 8.0.42
/*!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 */;
--
-- Table structure for table `clazz`
--
DROP TABLE IF EXISTS `clazz`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clazz` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID,主键',
`name` varchar(30) NOT NULL COMMENT '班级名称',
`room` varchar(20) DEFAULT NULL COMMENT '班级教室',
`begin_date` date NOT NULL COMMENT '开课时间',
`end_date` date NOT NULL COMMENT '结课时间',
`master_id` int unsigned DEFAULT NULL COMMENT '班主任ID, 关联员工表ID',
`subject` tinyint unsigned NOT NULL COMMENT '学科, 1:java, 2:前端, 3:大数据, 4:Python, 5:Go, 6: 嵌入式',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='班级表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `clazz`
--
LOCK TABLES `clazz` WRITE;
/*!40000 ALTER TABLE `clazz` DISABLE KEYS */;
INSERT INTO `clazz` VALUES (1,'JavaEE就业163期','212','2025-04-30','2025-06-29',10,1,'2024-06-01 17:08:23','2024-06-01 17:39:58'),(2,'前端就业90期','210','2024-07-10','2024-01-20',3,2,'2024-06-01 17:45:12','2024-06-01 17:45:12'),(3,'JavaEE就业165期','108','2024-06-15','2024-12-25',6,1,'2024-06-01 17:45:40','2024-06-01 17:45:40'),(4,'JavaEE就业166期','105','2024-07-20','2024-02-20',20,1,'2024-06-01 17:46:10','2024-06-01 17:46:10'),(5,'大数据就业58期','209','2024-08-01','2024-02-15',7,3,'2024-06-01 17:51:21','2024-06-01 17:51:21'),(6,'JavaEE就业167期','325','2025-11-20','2026-05-10',36,1,'2024-11-15 11:35:46','2024-12-13 14:31:24');
/*!40000 ALTER TABLE `clazz` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dept`
--
DROP TABLE IF EXISTS `dept`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dept` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID, 主键',
`name` varchar(10) NOT NULL COMMENT '部门名称',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dept`
--
LOCK TABLES `dept` WRITE;
/*!40000 ALTER TABLE `dept` DISABLE KEYS */;
INSERT INTO `dept` VALUES (1,'学工部','2025-05-04 22:32:58','2025-05-13 19:48:47'),(2,'教研部','2025-03-25 09:47:40','2025-03-25 15:17:04'),(3,'咨询部','2025-03-25 09:47:40','2025-03-30 21:26:24'),(4,'就业部','2025-03-25 09:47:40','2025-03-30 09:47:40'),(5,'人事部','2025-03-25 09:47:40','2025-03-30 09:47:40'),(10,'财务部','2025-05-04 22:33:52','2025-05-06 21:34:02'),(11,'后勤部','2025-05-04 23:55:36','2025-05-04 23:58:49');
/*!40000 ALTER TABLE `dept` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `emp`
--
DROP TABLE IF EXISTS `emp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `emp` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID,主键',
`username` varchar(20) NOT NULL COMMENT '用户名',
`password` varchar(32) DEFAULT '123456' COMMENT '密码',
`name` varchar(10) NOT NULL COMMENT '姓名',
`gender` tinyint unsigned NOT NULL COMMENT '性别, 1:男, 2:女',
`phone` char(11) NOT NULL COMMENT '手机号',
`job` tinyint unsigned DEFAULT NULL COMMENT '职位, 1 班主任, 2 讲师 , 3 学工主管, 4 教研主管, 5 咨询师',
`salary` int unsigned DEFAULT NULL COMMENT '薪资',
`image` varchar(255) DEFAULT NULL COMMENT '头像',
`entry_date` date DEFAULT NULL COMMENT '入职日期',
`dept_id` int unsigned DEFAULT NULL COMMENT '部门ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='员工表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `emp`
--
LOCK TABLES `emp` WRITE;
/*!40000 ALTER TABLE `emp` DISABLE KEYS */;
INSERT INTO `emp` VALUES (1,'shinaian','123456','施耐庵',1,'13309090001',4,15000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2000-01-01',2,'2023-10-20 16:35:33','2023-11-16 16:11:26'),(2,'songjiang','123456','宋江',1,'13309090002',2,8600,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2015-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:35:37'),(3,'lujunyi','123456','卢俊义',1,'13309090003',2,8900,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2008-05-01',2,'2023-10-20 16:35:33','2023-10-20 16:35:39'),(4,'wuyong','123456','吴用',1,'13309090004',2,9200,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2007-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:35:41'),(5,'gongsunsheng','123456','公孙胜',1,'13309090005',2,9500,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2012-12-05',2,'2023-10-20 16:35:33','2023-10-20 16:35:43'),(6,'huosanniang','123456','扈三娘',2,'13309090006',3,6500,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2013-09-05',1,'2023-10-20 16:35:33','2023-10-20 16:35:45'),(7,'chaijin','123456','柴进',1,'13309090007',1,4700,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2005-08-01',1,'2023-10-20 16:35:33','2023-10-20 16:35:47'),(8,'likui','123456','李逵',1,'13309090008',1,4800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2014-11-09',1,'2023-10-20 16:35:33','2023-10-20 16:35:49'),(9,'wusong','123456','武松',1,'13309090009',1,4900,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2011-03-11',1,'2023-10-20 16:35:33','2023-10-20 16:35:51'),(10,'linchong','123456','林冲',1,'13309090010',1,5000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2013-09-05',1,'2023-10-20 16:35:33','2023-10-20 16:35:53'),(11,'huyanzhuo','123456','呼延灼',1,'13309090011',2,9700,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2007-02-01',2,'2023-10-20 16:35:33','2023-10-20 16:35:55'),(12,'xiaoliguang','123456','小李广',1,'13309090012',2,10000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2008-08-18',2,'2023-10-20 16:35:33','2023-10-20 16:35:57'),(13,'yangzhi','123456','杨志',1,'13309090013',1,5300,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2012-11-01',1,'2023-10-20 16:35:33','2023-10-20 16:35:59'),(14,'shijin','123456','史进',1,'13309090014',2,10600,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2002-08-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:01'),(15,'sunerniang','123456','孙二娘',2,'13309090015',2,10900,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2011-05-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:03'),(16,'luzhishen','123456','鲁智深',1,'13309090016',2,9600,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2010-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:05'),(17,'liying','55555','李应',1,'13309090017',1,5800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2015-03-21',1,'2023-10-20 16:35:33','2025-05-11 14:33:07'),(18,'shiqian','123456','时迁',1,'13309090018',2,10200,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2015-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:09'),(19,'gudasao','123456','顾大嫂',2,'13309090019',2,10500,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2008-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:11'),(20,'ruanxiaoer','123456','阮小二',1,'13309090020',2,10800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2018-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:13'),(21,'ruanxiaowu','123456','阮小五',1,'13309090021',5,5200,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2015-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:15'),(22,'ruanxiaoqi','123456','阮小七',1,'13309090022',5,5500,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2016-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:17'),(23,'ruanji','123456','阮籍',1,'13309090023',5,5800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2012-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:19'),(24,'tongwei','123456','童威',1,'13309090024',5,5000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2006-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:21'),(25,'tongmeng','123456','童猛',1,'13309090025',5,4800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2002-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:23'),(26,'yanshun','123456','燕顺',1,'13309090026',5,5400,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2011-01-01',3,'2023-10-20 16:35:33','2023-11-08 22:12:46'),(27,'lijun','123456','李俊',1,'13309090027',2,6600,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2004-01-01',2,'2023-10-20 16:35:33','2023-11-16 17:56:59'),(28,'lizhong','123456','李忠',1,'13309090028',5,5000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2007-01-01',3,'2023-10-20 16:35:33','2023-11-17 16:34:22'),(30,'liyun','123456','李云',1,'13309090030',NULL,NULL,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2020-03-01',NULL,'2023-10-20 16:35:33','2023-10-20 16:36:31'),(36,'guoyujia','123456','郭宇佳',1,'13309243078',2,8001,'https://java-ai-28.oss-cn-beijing.aliyuncs.com/2025/06/c57f4f9c-941f-4ff8-8125-ec63f67ff5c2.jpg','2025-05-01',1,'2025-05-12 11:38:23','2025-06-19 16:39:44'),(44,'maodie','123456','耄耋',1,'13022111045',4,50000,'https://java-ai-28.oss-cn-beijing.aliyuncs.com/2025/05/f41cebb4-082c-4f84-b1c4-d0050412ac09.png','2025-03-15',10,'2025-05-10 23:49:59','2025-05-10 23:49:59'),(45,'pengqian','123456','彭谦',1,'18729903553',5,10000000,'https://java-ai-28.oss-cn-beijing.aliyuncs.com/2025/06/be8baca2-732b-490f-a56a-1d18b9b7c614.jpg','2025-06-02',3,'2025-06-02 23:19:54','2025-06-02 23:19:54'),(48,'fengborui','123456','冯博睿',1,'15888888887',2,3000,'https://java-ai-28.oss-cn-beijing.aliyuncs.com/2025/06/08ddac82-9432-47fd-8f0a-0850e4623440.jpg','2025-06-18',11,'2025-06-19 16:42:12','2025-06-19 16:42:12');
/*!40000 ALTER TABLE `emp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `emp_expr`
--
DROP TABLE IF EXISTS `emp_expr`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `emp_expr` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID, 主键',
`emp_id` int unsigned DEFAULT NULL COMMENT '员工ID',
`begin` date DEFAULT NULL COMMENT '开始时间',
`end` date DEFAULT NULL COMMENT '结束时间',
`company` varchar(50) DEFAULT NULL COMMENT '公司名称',
`job` varchar(50) DEFAULT NULL COMMENT '职位',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='工作经历';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `emp_expr`
--
LOCK TABLES `emp_expr` WRITE;
/*!40000 ALTER TABLE `emp_expr` DISABLE KEYS */;
INSERT INTO `emp_expr` VALUES (6,44,'2022-05-05','2024-05-30','白手套','猫财神'),(7,45,'2025-03-12','2025-06-02','三角洲行动','摸金少校'),(8,48,'2025-03-13','2025-04-25','陕理工附中','校长');
/*!40000 ALTER TABLE `emp_expr` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `operate_log`
--
DROP TABLE IF EXISTS `operate_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `operate_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`operate_emp_id` int unsigned DEFAULT NULL COMMENT '操作人ID',
`operate_time` datetime DEFAULT NULL COMMENT '操作时间',
`class_name` varchar(100) DEFAULT NULL COMMENT '操作的类名',
`method_name` varchar(100) DEFAULT NULL COMMENT '操作的方法名',
`method_params` varchar(2000) DEFAULT NULL COMMENT '方法参数',
`return_value` varchar(2000) DEFAULT NULL COMMENT '返回值',
`cost_time` bigint unsigned DEFAULT NULL COMMENT '方法执行耗时, 单位:ms',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='操作日志表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `operate_log`
--
LOCK TABLES `operate_log` WRITE;
/*!40000 ALTER TABLE `operate_log` DISABLE KEYS */;
INSERT INTO `operate_log` VALUES (1,1,'2025-05-14 16:17:14','org.example.controller.DeptController','add','[Dept(id=null, name=678, createTime=2025-05-14T16:17:13.590562200, updateTime=2025-05-14T16:17:13.590562200)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',12),(2,1,'2025-05-14 16:17:20','org.example.controller.DeptController','update','[Dept(id=12, name=678666, createTime=2025-05-14T16:17:14, updateTime=2025-05-14T16:17:20.396796900)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',6),(3,1,'2025-05-14 16:17:23','org.example.controller.DeptController','delete','[12]','{\"code\":1,\"msg\":\"success\",\"data\":null}',6),(4,36,'2025-05-14 23:52:40','org.example.controller.DeptController','add','[Dept(id=null, name=666, createTime=2025-05-14T23:52:39.992155700, updateTime=2025-05-14T23:52:39.992155700)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',28),(5,36,'2025-05-14 23:52:44','org.example.controller.DeptController','update','[Dept(id=13, name=666888, createTime=2025-05-14T23:52:40, updateTime=2025-05-14T23:52:44.173557500)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',8),(6,36,'2025-05-14 23:52:46','org.example.controller.DeptController','delete','[13]','{\"code\":1,\"msg\":\"success\",\"data\":null}',7),(7,NULL,'2025-05-27 20:07:38','org.example.controller.DeptController','add','[Dept(id=null, name=, createTime=2025-05-27T20:07:38.466774100, updateTime=2025-05-27T20:07:38.466774100)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',29),(8,NULL,'2025-05-29 15:35:25','org.example.controller.DeptController','add','[Dept(id=null, name=搞笑部, createTime=2025-05-29T15:35:25.066868500, updateTime=2025-05-29T15:35:25.066868500)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',15),(9,NULL,'2025-05-29 15:35:45','org.example.controller.DeptController','add','[Dept(id=null, name=搞笑部, createTime=2025-05-29T15:35:44.727359400, updateTime=2025-05-29T15:35:44.727359400)]','null',399),(10,NULL,'2025-05-29 15:36:43','org.example.controller.DeptController','add','[Dept(id=null, name=搞笑部, createTime=2025-05-29T15:36:43.372420500, updateTime=2025-05-29T15:36:43.372420500)]','null',4),(11,NULL,'2025-05-29 16:47:32','org.example.controller.DeptController','add','[Dept(id=null, name=, createTime=2025-05-29T16:47:31.852988600, updateTime=2025-05-29T16:47:31.852988600)]','null',5),(12,NULL,'2025-05-29 16:52:17','org.example.controller.DeptController','add','[Dept(id=null, name=32, createTime=2025-05-29T16:52:16.564102800, updateTime=2025-05-29T16:52:16.564102800)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',5),(13,NULL,'2025-05-29 17:12:29','org.example.controller.DeptController','add','[Dept(id=null, name=搞笑部, createTime=2025-05-29T17:12:29.474613400, updateTime=2025-05-29T17:12:29.474613400)]','null',5),(14,NULL,'2025-05-29 18:03:31','org.example.controller.DeptController','update','[Dept(id=14, name=123, createTime=2025-05-27T20:07:38, updateTime=2025-05-29T18:03:30.662468)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',9),(15,NULL,'2025-05-29 18:04:06','org.example.controller.DeptController','update','[Dept(id=19, name=233333, createTime=2025-05-29T16:52:17, updateTime=2025-05-29T18:04:06.350611100)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',4),(16,NULL,'2025-05-29 18:32:13','org.example.controller.DeptController','delete','[19]','{\"code\":1,\"msg\":\"success\",\"data\":null}',15),(17,NULL,'2025-05-29 18:34:17','org.example.controller.DeptController','delete','[14]','{\"code\":1,\"msg\":\"success\",\"data\":null}',4),(18,NULL,'2025-05-29 18:37:32','org.example.controller.DeptController','delete','[15]','{\"code\":1,\"msg\":\"success\",\"data\":null}',5),(19,NULL,'2025-05-29 18:38:58','org.example.controller.DeptController','add','[Dept(id=null, name=沙增乐部, createTime=2025-05-29T18:38:57.904253900, updateTime=2025-05-29T18:38:57.904253900)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',4),(20,NULL,'2025-05-29 18:39:03','org.example.controller.DeptController','update','[Dept(id=21, name=沙增乐, createTime=2025-05-29T18:38:58, updateTime=2025-05-29T18:39:02.502901)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',3),(21,NULL,'2025-05-29 18:39:15','org.example.controller.DeptController','delete','[21]','{\"code\":1,\"msg\":\"success\",\"data\":null}',3),(22,NULL,'2025-05-29 22:27:39','org.example.controller.DeptController','add','[Dept(id=null, name=asdasdasd, createTime=2025-05-29T22:27:39.396613400, updateTime=2025-05-29T22:27:39.396613400)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',5),(23,NULL,'2025-05-29 22:27:57','org.example.controller.DeptController','delete','[22]','{\"code\":1,\"msg\":\"success\",\"data\":null}',3),(24,NULL,'2025-06-02 21:11:31','org.example.controller.DeptController','add','[Dept(id=null, name=沙增乐部, createTime=2025-06-02T21:11:31.464335100, updateTime=2025-06-02T21:11:31.464335100)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',24),(25,NULL,'2025-06-02 21:11:44','org.example.controller.DeptController','delete','[23]','{\"code\":1,\"msg\":\"success\",\"data\":null}',9),(26,NULL,'2025-06-02 21:12:13','org.example.controller.DeptController','add','[Dept(id=null, name=456, createTime=2025-06-02T21:12:12.517675600, updateTime=2025-06-02T21:12:12.517675600)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',4),(27,NULL,'2025-06-02 21:17:43','org.example.controller.DeptController','delete','[24]','{\"code\":1,\"msg\":\"success\",\"data\":null}',5);
/*!40000 ALTER TABLE `operate_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student`
--
DROP TABLE IF EXISTS `student`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `student` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID,主键',
`name` varchar(10) NOT NULL COMMENT '姓名',
`no` char(10) NOT NULL COMMENT '学号',
`gender` tinyint unsigned NOT NULL COMMENT '性别, 1: 男, 2: 女',
`phone` varchar(11) NOT NULL COMMENT '手机号',
`id_card` char(18) NOT NULL COMMENT '身份证号',
`is_college` tinyint unsigned NOT NULL COMMENT '是否来自于院校, 1:是, 0:否',
`address` varchar(100) DEFAULT NULL COMMENT '联系地址',
`degree` tinyint unsigned DEFAULT NULL COMMENT '最高学历, 1:初中, 2:高中, 3:大专, 4:本科, 5:硕士, 6:博士',
`graduation_date` date DEFAULT NULL COMMENT '毕业时间',
`clazz_id` int unsigned NOT NULL COMMENT '班级ID, 关联班级表ID',
`violation_count` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '违纪次数',
`violation_score` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '违纪扣分',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `no` (`no`),
UNIQUE KEY `phone` (`phone`),
UNIQUE KEY `id_card` (`id_card`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='学员表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student`
--
LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` VALUES (1,'段誉','2022000001',1,'18800000001','110120000300200001',1,'北京市昌平区建材城西路1号',1,'2021-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-15 16:20:59'),(2,'萧峰','2022000002',1,'18800210003','110120000300200002',1,'北京市昌平区建材城西路2号',2,'2022-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(3,'虚竹','2022000003',1,'18800013001','110120000300200003',1,'北京市昌平区建材城西路3号',2,'2024-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(4,'萧远山','2022000004',1,'18800003211','110120000300200004',1,'北京市昌平区建材城西路4号',3,'2024-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(5,'阿朱','2022000005',2,'18800160002','110120000300200005',1,'北京市昌平区建材城西路5号',4,'2020-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(6,'阿紫','2022000006',2,'18800000034','110120000300200006',1,'北京市昌平区建材城西路6号',4,'2021-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(7,'游坦之','2022000007',1,'18800000067','110120000300200007',1,'北京市昌平区建材城西路7号',4,'2022-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(8,'康敏','2022000008',2,'18800000077','110120000300200008',1,'北京市昌平区建材城西路8号',5,'2024-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(9,'徐长老','2022000009',1,'18800000341','110120000300200009',1,'北京市昌平区建材城西路9号',3,'2024-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(10,'云中鹤','2022000010',1,'18800006571','110120000300200010',1,'北京市昌平区建材城西路10号',2,'2020-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(11,'钟万仇','2022000011',1,'18800000391','110120000300200011',1,'北京市昌平区建材城西路11号',4,'2021-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-15 16:21:24'),(12,'崔百泉','2022000012',1,'18800000781','110120000300200018',1,'北京市昌平区建材城西路12号',4,'2022-07-05',3,6,17,'2024-11-14 21:22:19','2024-12-13 14:33:58'),(13,'耶律洪基','2022000013',1,'18800008901','110120000300200013',1,'北京市昌平区建材城西路13号',4,'2024-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-15 16:21:21'),(14,'天山童姥','2022000014',2,'18800009201','110120000300200014',1,'北京市昌平区建材城西路14号',4,'2024-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-15 16:21:17'),(15,'刘竹庄','2022000015',1,'18800009401','110120000300200015',1,'北京市昌平区建材城西路15号',3,'2020-07-01',4,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(16,'李春来','2022000016',1,'18800008501','110120000300200016',1,'北京市昌平区建材城西路16号',4,'2021-07-01',4,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(17,'王语嫣','2022000017',2,'18800007601','110120000300200017',1,'北京市昌平区建材城西路17号',2,'2022-07-01',4,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(18,'郑成功','2024001101',1,'13309092345','110110110110110110',0,'北京市昌平区回龙观街道88号',5,'2021-07-01',3,2,7,'2024-11-15 16:26:18','2024-11-15 16:40:10');
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-06-19 20:26:22
为什么在Navicat Premium 15中运行不了
原本计划轻松度过一段时间后回家，却突然接到新的工作任务，打乱了原有的安排。面对这突如其来的变化，只能调整心态，积极应对。
扫一扫
4125
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
