all-project/学校历史数据迁移/xg_class_teacher_counselor_rel.sql

/*
 Navicat Premium Dump SQL

 Source Server         : 47.99.164.66  hn02le.34lkdLKD
 Source Server Type    : MySQL
 Source Server Version : 50736 (5.7.36)
 Source Host           : 47.99.164.66:3306
 Source Schema         : hzdyjs_xg

 Target Server Type    : MySQL
 Target Server Version : 50736 (5.7.36)
 File Encoding         : 65001

 Date: 22/12/2025 15:46:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for xg_class_teacher_counselor_rel
-- ----------------------------
DROP TABLE IF EXISTS `xg_class_teacher_counselor_rel`;
CREATE TABLE `xg_class_teacher_counselor_rel` (
  `id` bigint(20) NOT NULL COMMENT '主键ID（雪花ID）',
  `tenant_id` varchar(20) NOT NULL DEFAULT '000000' COMMENT '租户编号',
  `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `class_id` bigint(20) NOT NULL COMMENT '班级ID，关联xg_class_msg.id',
  `class_name` varchar(100) DEFAULT NULL COMMENT '班级名称',
  `teacher_id` bigint(20) NOT NULL COMMENT '教师ID，关联sys_user.user_id',
  `teacher_name` varchar(50) DEFAULT NULL COMMENT '教师姓名',
  `teacher_type` varchar(20) NOT NULL COMMENT '教师类型：class_teacher-班主任，counselor-辅导员，advisor-导师',
  `start_date` datetime NOT NULL COMMENT '开始日期',
  `end_date` datetime DEFAULT NULL COMMENT '结束日期',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_tenant_id` (`tenant_id`),
  KEY `idx_deleted` (`deleted`),
  KEY `idx_class_id` (`class_id`),
  KEY `idx_teacher_id` (`teacher_id`),
  KEY `idx_teacher_type` (`teacher_type`),
  KEY `idx_start_date` (`start_date`),
  KEY `idx_end_date` (`end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='班级班主任辅导员关联表';

SET FOREIGN_KEY_CHECKS = 1;