代码拉取完成，页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : python2512
Source Server Type : MySQL
Source Server Version : 80016
Source Host : localhost:3306
Source Schema : kgc2511
Target Server Type : MySQL
Target Server Version : 80016
File Encoding : 65001
Date: 20/06/2025 17:34:34
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for clazz
-- ----------------------------
DROP TABLE IF EXISTS `clazz`;
CREATE TABLE `clazz` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`class_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`class_room` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`class_state` int(11) NOT NULL,
`student_number` int(11) NOT NULL,
`headteacher` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`class_start` date NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `class_mame`(`class_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of clazz
-- ----------------------------
INSERT INTO `clazz` VALUES (1, 'python2511', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (2, 'python2512', '第七教室', 1, 10, '郭老师', '2025-06-09');
INSERT INTO `clazz` VALUES (4, 'python2521', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (5, 'python2531', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (6, 'python2541', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (7, 'python2551', '第六教室', 2, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (8, 'python2571', '第六教室', 2, 19, '刘老师', '2025-06-03');
INSERT INTO `clazz` VALUES (9, 'python2561', '第六教室', 2, 19, '刘老师', '2025-06-03');
INSERT INTO `clazz` VALUES (10, 'python2581', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (11, 'python2591', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (12, 'python2611', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (13, 'python2711', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (14, 'python2811', '第六教室', 1, 19, '郭老师', '2025-06-03');
INSERT INTO `clazz` VALUES (15, 'python2911', '第六教室', 1, 19, '郭老师', '2025-06-03');
-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`course_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`course_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`course_time` int(11) NOT NULL,
`create_time` date NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `course_no`(`course_no`) USING BTREE,
UNIQUE INDEX `course_name`(`course_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES (2, 'Java7.0', 'Java', 60, '2025-06-09');
INSERT INTO `course` VALUES (6, 'Python2.0', 'Python', 50, '2025-06-09');
INSERT INTO `course` VALUES (9, 'web1.0', 'Web', 25, '2025-06-12');
-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`dept_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`create_time` date NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `dept_name`(`dept_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of dept
-- ----------------------------
INSERT INTO `dept` VALUES (1, '市场部', '安徽合肥', '2025-06-05');
INSERT INTO `dept` VALUES (5, '教质部', '江苏南京', '2025-06-05');
INSERT INTO `dept` VALUES (6, '社招部', '安徽合肥', '2025-06-05');
INSERT INTO `dept` VALUES (8, '其它', '江苏南京', '2025-06-07');
INSERT INTO `dept` VALUES (9, '总经办', '安徽合肥', '2025-06-07');
-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`app` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`applied` datetime(6) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of django_migrations
-- ----------------------------
INSERT INTO `django_migrations` VALUES (1, 'role', '0001_initial', '2025-06-03 06:14:18.059852');
INSERT INTO `django_migrations` VALUES (3, 'dept', '0001_initial', '2025-06-05 05:36:50.948247');
INSERT INTO `django_migrations` VALUES (4, 'user', '0001_initial', '2025-06-05 07:03:53.920071');
INSERT INTO `django_migrations` VALUES (5, 'clazz', '0001_initial', '2025-06-07 05:43:50.303136');
INSERT INTO `django_migrations` VALUES (6, 'clazz', '0002_rename_class_mame_clazz_class_name', '2025-06-07 06:39:42.236711');
INSERT INTO `django_migrations` VALUES (7, 'course', '0001_initial', '2025-06-09 00:58:11.096248');
INSERT INTO `django_migrations` VALUES (10, 'student', '0001_initial', '2025-06-09 02:35:03.344391');
INSERT INTO `django_migrations` VALUES (11, 'source', '0001_initial', '2025-06-11 02:48:49.708072');
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`role_en` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`create_time` date NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `role_name`(`role_name`) USING BTREE,
UNIQUE INDEX `role_en`(`role_en`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, '管理员', 'admin', '这是一个管理员具有最高的权限', '2025-06-03');
INSERT INTO `role` VALUES (8, '普通用户', 'user', '普通用户角色', '2025-06-04');
INSERT INTO `role` VALUES (13, '教师', 'teacher', '教师身份拥有部分权限', '2025-06-06');
INSERT INTO `role` VALUES (14, '学生', 'student', '学生身份，权限较少', '2025-06-06');
-- ----------------------------
-- Table structure for source
-- ----------------------------
DROP TABLE IF EXISTS `source`;
CREATE TABLE `source` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`file_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`cover_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`size` int(11) NOT NULL,
`publisher` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`views` int(11) NOT NULL,
`create_time` date NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of source
-- ----------------------------
INSERT INTO `source` VALUES (9, '普通文本', 'text', '', '20250611114536.txt', 0, 'admin', 0, '2025-06-11');
INSERT INTO `source` VALUES (10, '小米超级工厂', 'video', '20250612074326.png', '20250612074330.mp4', 88068, 'admin', 3, '2025-06-12');
INSERT INTO `source` VALUES (11, '小米汽车测试', 'video', '20250612085340.png', '20250612085353.mp4', 44386, 'admin', 2, '2025-06-12');
-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`student_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`student_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`student_age` int(11) NOT NULL,
`student_gender` int(11) NOT NULL,
`student_tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`student_state` smallint(6) NOT NULL,
`school_time` date NOT NULL,
`create_time` date NOT NULL,
`clazz_id` bigint(20) NOT NULL,
`course_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `student_no`(`student_no`) USING BTREE,
UNIQUE INDEX `student_tel`(`student_tel`) USING BTREE,
INDEX `student_clazz_id_d3ce3f5b_fk_clazz_id`(`clazz_id`) USING BTREE,
INDEX `student_course_id_7a3c88a5_fk_course_id`(`course_id`) USING BTREE,
CONSTRAINT `student_clazz_id_d3ce3f5b_fk_clazz_id` FOREIGN KEY (`clazz_id`) REFERENCES `clazz` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `student_course_id_7a3c88a5_fk_course_id` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (2, '李四', '202506001', 25, 2, '15755361110', 1, '2025-06-09', '2025-06-09', 2, 2);
INSERT INTO `student` VALUES (4, '张三', '202506003', 21, 1, '15755361140', 1, '2025-06-10', '2025-06-09', 1, 2);
INSERT INTO `student` VALUES (5, '张三', '202507001', 20, 1, '15755371110', 1, '2025-06-03', '2025-06-10', 1, 6);
INSERT INTO `student` VALUES (6, '张三', '202507002', 21, 1, '15755371111', 1, '2025-06-04', '2025-06-10', 2, 6);
INSERT INTO `student` VALUES (9, '张三', '202607001', 20, 1, '18755371110', 1, '2025-06-03', '2025-06-10', 1, 6);
INSERT INTO `student` VALUES (10, '张三', '202607002', 21, 1, '18755371111', 1, '2025-06-04', '2025-06-10', 1, 6);
INSERT INTO `student` VALUES (11, '张三', '202607003', 22, 1, '18755371112', 2, '2025-06-05', '2025-06-10', 1, 6);
INSERT INTO `student` VALUES (12, '张三', '202607004', 23, 1, '18755371113', 2, '2025-06-06', '2025-06-10', 1, 6);
INSERT INTO `student` VALUES (13, '张三', '202607005', 24, 1, '18755371114', 1, '2025-06-07', '2025-06-10', 1, 6);
INSERT INTO `student` VALUES (14, '张三', '202607006', 25, 1, '18755371115', 1, '2025-06-08', '2025-06-10', 1, 6);
INSERT INTO `student` VALUES (21, '张三', '202608001', 20, 1, '19755371110', 1, '2025-06-03', '2025-06-10', 1, 6);
INSERT INTO `student` VALUES (22, '张三', '202608002', 21, 1, '19755371111', 1, '2025-06-04', '2025-06-10', 11, 9);
INSERT INTO `student` VALUES (31, '张三', '202709001', 20, 1, '14755371110', 1, '2025-06-03', '2025-06-10', 1, 9);
INSERT INTO `student` VALUES (32, '张三', '202709002', 21, 1, '14755371111', 1, '2025-06-04', '2025-06-10', 4, 6);
INSERT INTO `student` VALUES (33, '张三', '202707003', 22, 1, '14755371112', 1, '2025-06-05', '2025-06-10', 1, 6);
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`avatar` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`active` int(11) NOT NULL,
`age` int(11) NOT NULL,
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`create_time` date NOT NULL,
`dept_id` bigint(20) NOT NULL,
`role_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `username`(`username`) USING BTREE,
UNIQUE INDEX `email`(`email`) USING BTREE,
INDEX `user_dept_id_1c2c8cd1_fk_dept_id`(`dept_id`) USING BTREE,
INDEX `user_role_id_c3a87a3d_fk_role_id`(`role_id`) USING BTREE,
CONSTRAINT `user_dept_id_1c2c8cd1_fk_dept_id` FOREIGN KEY (`dept_id`) REFERENCES `dept` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `user_role_id_c3a87a3d_fk_role_id` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'admin', '96e79218965eb72c92a549dd5a330112', 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', 1, 21, '985732654@kgc.com', '2025-06-05', 9, 1);
INSERT INTO `user` VALUES (2, 'student', '96e79218965eb72c92a549dd5a330112', 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', 1, 21, '9857326654@kgc.com', '2025-06-06', 8, 14);
INSERT INTO `user` VALUES (3, 'teacher', '96e79218965eb72c92a549dd5a330112', 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', 1, 21, '985732444@kgc.com', '2025-06-06', 1, 13);
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手