period.zip

/* Navicat Premium Data Transfer Source Server : keshi Source Server Type : MySQL Source Server Version : 50733 (5.7.33-log) Source Host : localhost:6033 Source Schema : period Target Server Type : MySQL Target Server Version : 50733 (5.7.33-log) File Encoding : 65001 Date: 24/03/2023 11:17:31 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for action_log -- ---------------------------- DROP TABLE IF EXISTS `action_log`; CREATE TABLE `action_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_log` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作的详细记录', `action_time` datetime NOT NULL COMMENT '操作的时间', `import_id` int(11) NOT NULL COMMENT '对应生效时间和导入时间', PRIMARY KEY (`id`) USING BTREE, INDEX `import_id`(`import_id`) USING BTREE, CONSTRAINT `action_log_ibfk_2` FOREIGN KEY (`import_id`) REFERENCES `import_file_id` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 915 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志记录' ROW_FORMAT = COMPACT; -- ---------------------------- -- Table structure for afterward_checkin_apply -- ---------------------------- DROP TABLE IF EXISTS `afterward_checkin_apply`; CREATE TABLE `afterward_checkin_apply` ( `id` int(11) NOT NULL AUTO_INCREMENT, `afterward_checkin_teacher_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '事后签到申请教师的职工号', `afterward_checkin_date` date NOT NULL COMMENT '申请事后签到的课程所在的日期', `afterward_checkin_sn` int(11) NOT NULL COMMENT '申请事后签到的课程开始于第几节课', `afterward_checkin_apply_time` datetime NOT NULL COMMENT '什么时候填写的事后签到申请', `afterward_checkin_apply_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '在什么地方填写的事后签到申请', `verified_status` int(11) NULL DEFAULT NULL COMMENT '0为待审批，1为审批通过，2为审批未通过', `verifier_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批教师的职工号', `apply_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '申请事后调课原因\r\n', `import_id` int(11) NOT NULL COMMENT '对应生效时间和导入时间', PRIMARY KEY (`id`) USING BTREE, INDEX `afterward_checkin_teacher_id`(`afterward_checkin_teacher_id`) USING BTREE, INDEX `verifier_id`(`verifier_id`) USING BTREE, INDEX `import_id`(`import_id`) USING BTREE, INDEX `afterward_checkin_apply_ibfk_1`(`afterward_checkin_teacher_id`, `import_id`) USING BTREE, INDEX `afterward_checkin_apply_ibfk_2`(`verifier_id`, `import_id`) USING BTREE, CONSTRAINT `afterward_checkin_apply_ibfk_1` FOREIGN KEY (`afterward_checkin_teacher_id`, `import_id`) REFERENCES `teacher` (`teacher_sn`, `import_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `afterward_checkin_apply_ibfk_2` FOREIGN KEY (`verifier_id`, `import_id`) REFERENCES `teacher` (`teacher_sn`, `import_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `afterward_checkin_apply_ibfk_3` FOREIGN KEY (`import_id`) REFERENCES `import_file_id` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 69 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '事后签到表' ROW_FORMAT = COMPACT; -- ---------------------------- -- Table structure for change_apply -- ---------------------------- DROP TABLE IF EXISTS `change_apply`; CREATE TABLE `change_apply` ( `id` int(11) NOT NULL AUTO_INCREMENT, `change_date` date NOT NULL COMMENT '调课的课程所在的日期', `change_lesson_schedule_id` int(11) NOT NULL COMMENT '调课课程在课程表中的id', `replace_date` date NULL DEFAULT NULL COMMENT '代课课程所在的日期（加课则此处为Null）', `replace_lesson_schedule_id` int(11) NULL DEFAULT NULL COMMENT '代课课程在课程表中的id（加课则此处为Null）', `apply_type` int(11) NOT NULL COMMENT '0因公，1因私', `apply_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请时所在的地理位置', `apply_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请调课理由', `apply_time` datetime NOT NULL COMMENT '调课申请时间', `agree_time` datetime NULL DEFAULT NULL COMMENT '代课老师同意时间', `verify_time` datetime NULL DEFAULT NULL COMMENT '系主任审核时间', `verify_status_teacher` int(11) NOT NULL DEFAULT 0 COMMENT '0是代课教师未处理，1代课教师已同意，2代课教师已拒绝', `verify_status_manager` int(11) NULL DEFAULT 0 COMMENT '0系主任未处理，1系主任已同意，2系主任已拒绝 ，（系主任为调课教师的系主任）', `apply_teacher_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发起申请的老师的职工号', `proxy_teacher_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代课老师职工号', `import_id` int(11) NOT NULL COMMENT '对应生效时间和导入时间', PRIMARY KEY (`id`) USING BTREE, INDEX `change_lesson_schedule_id`(`change_lesson_schedule_id`) USING BTREE, INDEX `replace_lesson_schedule_id`(`replace_lesson_schedule_id`) USING BTREE, INDEX `apply_teacher_id`(`apply_teacher_id`) USING BTREE, INDEX `proxy_teacher_id`(`proxy_teacher_id`) USING BTREE, INDEX `import_id`(`import_id`) USING BTREE, INDEX `change_apply_ibfk_3`(`apply_teacher_id`, `import_id`) USING BTREE, INDEX `change_apply_ibfk_4`(`proxy_teacher_id`, `import_id`) USING BTREE, CONSTRAINT `change_apply_ibfk_1` FOREIGN KEY (`change_lesson_schedule_id`) REFERENCES `schedular` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `change_apply_ibfk_2` FOREIGN KEY (`replace_lesson_schedule_id`) REFERENCES `schedular` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `change_apply_ibfk_3` FOREIGN KEY (`apply_teacher_id`, `import_id`) REFERENCES `teacher` (`teacher_sn`, `import_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `change_apply_ibfk_4` FOREIGN KEY (`proxy_teacher_id`, `import_id`) REFERENCES `teacher` (`teacher_sn`, `import_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `change_apply_ibfk_5` FOREIGN KEY (`import_id`) REFERENCES `import_file_id` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 141 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '调课申请表' ROW_FORMAT = COMPACT; -- ---------------------------- -- Table structure for change_apply_file -- ---------------------------- DROP TABLE IF EXISTS `change_apply_file`; CREATE TABLE `change_apply_file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `file_path` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件路径(包含文件名)', `change_apply_id` int(11) NULL DEFAULT NULL COMMENT '所属的调课申请id', PRIMARY KEY (`id`) USING BTREE, INDEX `change_apply_id_fk`(`change_apply_id`) USING BTREE, CONSTRAINT `change_apply_id_fk` FOREIGN KEY (`change_apply_id`) REFERENCES `change_apply` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '因公调课上传文件表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for checkin -- ---------------------------- DROP TABLE IF EXISTS `checkin`; CREATE TABLE `checkin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `checkin_date` date NOT NULL COMMENT '二维码签到的日期', `checkin_time` time NOT NULL COMMENT '二维码签到时间', `checkin_cla