zf_txwx_dataExchange/resources/sql/memdb.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 微校推送成员数据
 Source Server Type    : MySQL
 Source Server Version : 80024
 Source Host           : 172.16.20.77:3306
 Source Schema         : memdb

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

 Date: 08/01/2024 08:47:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for class_schedule
-- ----------------------------
DROP TABLE IF EXISTS `class_schedule`;
CREATE TABLE `class_schedule`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `jc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '节次',
  `zj` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '周几',
  `djz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第几周',
  `xq` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学期',
  `xn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学年',
  `jsxm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教师姓名',
  `jsgh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教师工号',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_user` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人员',
  `update_user` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人员',
  `deleted` int NULL DEFAULT NULL COMMENT '未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7377 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for face_similar_data
-- ----------------------------
DROP TABLE IF EXISTS `face_similar_data`;
CREATE TABLE `face_similar_data`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `m_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学工号',
  `face_similar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '人脸对比度',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `cardNumber`(`m_card_number` ASC) USING BTREE COMMENT '加个索引'
) ENGINE = InnoDB AUTO_INCREMENT = 50682 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member`  (
  `m_id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键自增字段',
  `m_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学工号，如：weixiao2164257621',
  `m_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名，如：张三',
  `m_gender` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别，如：男',
  `m_grade` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '年级，如：2016',
  `m_college` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学院名称，如：信息科学与技术学院',
  `m_profession` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系的名称，如：计算机系',
  `m_major` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专业名称，如：软件工程',
  `m_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '班级，如：软件工程1班',
  `m_identity_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份类型，如：1学生，2老师',
  `m_identity_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份名称，如：本科生',
  `m_card_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '身份证' COMMENT '证件类型（默认是：身份证），如：身份证，能支持[身份证]、[回乡证]、[台胞证] 、[外国护照]和[其它]',
  `m_id_card` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证件号码，如：4XXX***7',
  `m_country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家，如：CHN',
  `m_telephone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号，如：137***8',
  `m_organization` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组织架构（我自己来拼），如：老师:南昌交通学院/教职工/所在部门，学生:南昌交通学院/学生/学院/年级/专业/班级',
  `m_campus` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '校区，如：墨轩湖校区',
  `m_employer` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作单位，如：XX研究所',
  `m_building` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '楼栋，如：mxh或m开头是墨轩湖，否则是黄家湖',
  `m_building_remark` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '楼栋，位置说明',
  `m_building_explain` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '楼栋，中文解释',
  `m_dorm_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '宿舍号，如：206',
  `m_dorm_move` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否搬迁宿舍',
  `m_remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注，如：00000000',
  `m_email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱，如：weixiao@tencent.com',
  `m_expire_at` datetime NULL DEFAULT NULL COMMENT '有效时间，如：2019-01-01 00:00:00',
  `m_qq` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'QQ号， 如：12345678',
  `m_nation` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '民族， 如：汉族',
  `m_origin_place` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '户籍，如：陕西省',
  `m_source_place` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生源地',
  `m_graduated_school` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '毕业学校，如：XX中学',
  `m_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '家庭住址，如：仙桃市郑场镇潘阳村八组',
  `m_school_period` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学段，如：大学',
  `m_educational` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学制',
  `m_register_year` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '入学年份，如：2022',
  `m_position` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职务',
  `m_department` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门',
  `m_birthday` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生日',
  `m_id_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编号',
  `m_valid_start_time` datetime NULL DEFAULT NULL COMMENT '有效开始时间',
  `m_validity_period` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '有效期',
  `m_in_out_school` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '在校（离线）',
  `m_role` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色',
  `m_label` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标签',
  `m_physical_card_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物理卡号',
  `m_physical_chip_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物理芯片号',
  `m_push_Scope` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '推送范围',
  `m_create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '信息添加时间（自动生成）',
  `m_update_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '信息组合字段更新时间（用脚本生成）',
  `m_status` tinyint(1) NULL DEFAULT 0 COMMENT '0未确认，1已存在，2已推送，3字段有异常，4离职，5已推送编号，6管理员admin',
  `m_status_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录状态的时间',
  `OPERATION_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型：new、changed、deleted',
  `OPERATION_TIME` date NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`m_id`, `m_card_number`) USING BTREE,
  UNIQUE INDEX `idx_card_number`(`m_card_number`) USING BTREE,
  INDEX `idx_college`(`m_college`) USING BTREE,
  INDEX `idx_status`(`m_status`) USING BTREE,
  INDEX `idx_id_card`(`m_id_card`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 74318 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '成员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for member_head_image
-- ----------------------------
DROP TABLE IF EXISTS `member_head_image`;
CREATE TABLE `member_head_image`  (
  `m_id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '头像id',
  `m_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学工号，如：weixiao2164257621',
  `m_head_image` mediumblob NULL COMMENT '头像',
  `m_head_image_status` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '头像图片转存：0默认，1成功，2身份证为null',
  `m_head_image_status_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '头像转存时间',
  `m_push_yushi` tinyint(1) NULL DEFAULT 0 COMMENT '推送到宇视：0默认，1推送成功，2推送失败，3图片超过6M',
  `OPERATION_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型：new、changed、deleted',
  `OPERATION_TIME` date NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`m_id`, `m_card_number`) USING BTREE,
  INDEX `idx_card_number`(`m_card_number`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 50688 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '成员头像' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tb_config
-- ----------------------------
DROP TABLE IF EXISTS `tb_config`;
CREATE TABLE `tb_config`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  `cfg_key` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `cfg_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开学时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for tb_course
-- ----------------------------
DROP TABLE IF EXISTS `tb_course`;
CREATE TABLE `tb_course`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id，优化查询用，无需推送',
  `push_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '序号',
  `push_kcbm` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程编号',
  `push_kczwmc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程名称',
  `push_zxs` int NULL DEFAULT NULL COMMENT '总学时',
  `push_xf` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学分',
  `push_xymc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '院系名称',
  `push_kclb` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程性质：必修，限选课，公选课等',
  `push_ksfs` int NULL DEFAULT NULL COMMENT '考试方式：1考试，2考查',
  `push_kclbmc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程性质名称',
  `push_kclx` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程类型',
  `push_kclxmc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程类型名称',
  `OPERATION_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型：new、changed、deleted',
  `OPERATION_TIME` date NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_course_id`(`push_id`) USING BTREE,
  INDEX `idx_course_kcbm`(`push_kcbm`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 9025 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tb_course_scheduling
-- ----------------------------
DROP TABLE IF EXISTS `tb_course_scheduling`;
CREATE TABLE `tb_course_scheduling`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id，优化查询用，无需推送',
  `push_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '序号',
  `push_kcbh` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程编号',
  `push_kcmc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程名称',
  `push_jxbid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学班id',
  `push_jxbmc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学班名称',
  `push_jsgh` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教师工号',
  `push_jsxm` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教师姓名',
  `push_xn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学年',
  `push_xq` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学期',
  `push_djz` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第几周',
  `push_zj` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '周几',
  `push_jc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '节次',
  `push_skdd` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上课地点',
  `push_jxbzc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学班组成',
  `push_course_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程类型（课设、实验、临时课程相关）',
  `push_start_time` timestamp NULL DEFAULT NULL COMMENT '上课开始时间（课设、实验、临时课程相关）',
  `push_end_time` timestamp NULL DEFAULT NULL COMMENT '上课结束时间（课设、实验、临时课程相关）',
  `push_campus` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '校区（课设、实验、临时课程相关）',
  `push_building` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '楼栋（课设、实验、临时课程相关）',
  `push_student_num` int NULL DEFAULT NULL COMMENT '教学班人数（课设、实验、临时课程相关）',
  `OPERATION_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型：new、changed、deleted',
  `OPERATION_TIME` date NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_course_scheduling_kcbh`(`push_kcbh`) USING BTREE,
  INDEX `idx_course_scheduling_jsgh`(`push_jsgh`) USING BTREE,
  INDEX `idx_course_scheduling_id`(`push_id`) USING BTREE,
  INDEX `idx_course_scheduling_xn`(`push_xn`) USING BTREE,
  INDEX `idx_course_scheduling_xq`(`push_xq`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 105449 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程安排' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tb_course_selection
-- ----------------------------
DROP TABLE IF EXISTS `tb_course_selection`;
CREATE TABLE `tb_course_selection`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id，优化查询用的，无需推送',
  `push_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '序号',
  `push_xh` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学号',
  `push_xm` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `push_kcbh` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程编号',
  `push_kcmc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程名称',
  `push_jxbid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学班id（选课课号）',
  `push_jxbmc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学班名称',
  `push_xn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学年',
  `push_xq` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学期',
  `push_jsgh` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '老师工号',
  `push_jsxm` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '老师姓名',
  `OPERATION_TYPE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型：new、changed、deleted',
  `OPERATION_TIME` date NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_course_selection_xh`(`push_xh`) USING BTREE,
  INDEX `idx_course_selection_kcbh`(`push_kcbh`) USING BTREE,
  INDEX `idx_course_selection_id`(`push_id`) USING BTREE,
  INDEX `idx_course_selection_jxbid`(`push_jxbid`) USING BTREE,
  INDEX `idx_course_selection_xn`(`push_xn`) USING BTREE,
  INDEX `idx_course_selection_xq`(`push_xq`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 528359 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '选课表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for temp_info_send_to_yushi_2023
-- ----------------------------
DROP TABLE IF EXISTS `temp_info_send_to_yushi_2023`;
CREATE TABLE `temp_info_send_to_yushi_2023`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学工号，如：weixiao2164257621',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名，如：张三',
  `college` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学院名称，如：信息科学与技术学院',
  `profession` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专业名称，如：软件工程',
  `classname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '班级，如：软件工程1班',
  `image` mediumblob NULL COMMENT '头像',
  `sendToYushi` int NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8192 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `logintime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;