基于python的在线教育课程作业批改考试系统(mysql)-Django.VUE【数据库设计、论文、源码、开题报告】

最新推荐文章于 2024-03-30 16:19:43 发布
云码资源
最新推荐文章于 2024-03-30 16:19:43 发布
阅读量284
点赞数
分类专栏： python实战项目文章标签： django 数据库 mysql
本文链接：https://blog.csdn.net/itrjxxs_2/article/details/129333628
版权
python实战项目专栏收录该内容
43 篇文章 6 订阅
订阅专栏
功能介绍

用户端功能有：首页、课程信息、我的课程、课程作业、我的作业、课程考试、我的考试、在线留言、班级信息、我的班级、个人中心等
管理端功能有：教师管理、学生管理、课程信息查看、我的课程管理、作业管理、考试管理、作业批改、考试批改、班级信息管理、我的班级管理、系统管理
教师后台功能有：课程信息查看、我的课程管理、作业管理、考试管理、作业批改、考试批改、班级信息管理、我的班级管理
更多功能请看运行截图！
使用技术

开发语言：python
使用框架：Django2.0
前端技术：JavaScript、VUE.js（2.X）、css3
数据库：MySQL 5.7
数据库管理工具：Navicat或sqlyog
开发工具：pycharm
python版本：python3.7及以上
项目截图

在这里插入图片描述
数据库脚本


DROP DATABASE IF EXISTS django22858;

CREATE DATABASE django22858 default character set utf8mb4 collate utf8mb4_general_ci;

USE django22858;

DROP TABLE IF EXISTS `xuesheng`;

CREATE TABLE `xuesheng` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`xuehao` varchar(200) NOT NULL UNIQUE   COMMENT '学号',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`xueshengxingming` varchar(200) NOT NULL   COMMENT '学生姓名',
	`xingbie` varchar(200)    COMMENT '性别',
	`xueyuan` varchar(200)    COMMENT '学院',
	`zhuanye` varchar(200)    COMMENT '专业',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`youxiang` varchar(200)    COMMENT '邮箱',
	`zhaopian` varchar(200)    COMMENT '照片',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学生';

INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(11,'学生1','123456','学生姓名1','男','学院1','专业1','13823888881','773890001@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian1.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(12,'学生2','123456','学生姓名2','男','学院2','专业2','13823888882','773890002@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian2.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(13,'学生3','123456','学生姓名3','男','学院3','专业3','13823888883','773890003@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian3.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(14,'学生4','123456','学生姓名4','男','学院4','专业4','13823888884','773890004@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian4.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(15,'学生5','123456','学生姓名5','男','学院5','专业5','13823888885','773890005@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian5.jpg');
INSERT INTO xuesheng(id,xuehao,mima,xueshengxingming,xingbie,xueyuan,zhuanye,lianxidianhua,youxiang,zhaopian) VALUES(16,'学生6','123456','学生姓名6','男','学院6','专业6','13823888886','773890006@qq.com','http://localhost:8080/django22858/upload/xuesheng_zhaopian6.jpg');

DROP TABLE IF EXISTS `jiaoshi`;

CREATE TABLE `jiaoshi` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonghao` varchar(200) NOT NULL UNIQUE   COMMENT '工号',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`xingbie` varchar(200)    COMMENT '性别',
	`touxiang` varchar(200)    COMMENT '头像',
	`zhicheng` varchar(200)    COMMENT '职称',
	`dianhua` varchar(200)    COMMENT '电话',
	`youxiang` varchar(200)    COMMENT '邮箱',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='教师';

INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(21,'教师1','123456','教师姓名1','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang1.jpg','职称1','13823888881','773890001@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(22,'教师2','123456','教师姓名2','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang2.jpg','职称2','13823888882','773890002@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(23,'教师3','123456','教师姓名3','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang3.jpg','职称3','13823888883','773890003@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(24,'教师4','123456','教师姓名4','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang4.jpg','职称4','13823888884','773890004@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(25,'教师5','123456','教师姓名5','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang5.jpg','职称5','13823888885','773890005@qq.com');
INSERT INTO jiaoshi(id,gonghao,mima,jiaoshixingming,xingbie,touxiang,zhicheng,dianhua,youxiang) VALUES(26,'教师6','123456','教师姓名6','男','http://localhost:8080/django22858/upload/jiaoshi_touxiang6.jpg','职称6','13823888886','773890006@qq.com');

DROP TABLE IF EXISTS `kechengxinxi`;

CREATE TABLE `kechengxinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`kechengbianhao` varchar(200) NOT NULL UNIQUE   COMMENT '课程编号',
	`kechengmingcheng` varchar(200) NOT NULL   COMMENT '课程名称',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`tupian` varchar(200)    COMMENT '图片',
	`kechengziliao` varchar(200)    COMMENT '课程资料',
	`kechengneirong` longtext    COMMENT '课程内容',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`thumbsupnum` int   default '0' COMMENT '赞',
	`crazilynum` int   default '0' COMMENT '踩',
	`clicktime` datetime    COMMENT '最近点击时间',
	`clicknum` int   default '0' COMMENT '点击次数',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程信息';

INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(31,'课程编号1','课程名称1','课程类型1','http://localhost:8080/django22858/upload/kechengxinxi_tupian1.jpg','','课程内容1','工号1','教师姓名1',1,1,CURRENT_TIMESTAMP,1);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(32,'课程编号2','课程名称2','课程类型2','http://localhost:8080/django22858/upload/kechengxinxi_tupian2.jpg','','课程内容2','工号2','教师姓名2',2,2,CURRENT_TIMESTAMP,2);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(33,'课程编号3','课程名称3','课程类型3','http://localhost:8080/django22858/upload/kechengxinxi_tupian3.jpg','','课程内容3','工号3','教师姓名3',3,3,CURRENT_TIMESTAMP,3);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(34,'课程编号4','课程名称4','课程类型4','http://localhost:8080/django22858/upload/kechengxinxi_tupian4.jpg','','课程内容4','工号4','教师姓名4',4,4,CURRENT_TIMESTAMP,4);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(35,'课程编号5','课程名称5','课程类型5','http://localhost:8080/django22858/upload/kechengxinxi_tupian5.jpg','','课程内容5','工号5','教师姓名5',5,5,CURRENT_TIMESTAMP,5);
INSERT INTO kechengxinxi(id,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,gonghao,jiaoshixingming,thumbsupnum,crazilynum,clicktime,clicknum) VALUES(36,'课程编号6','课程名称6','课程类型6','http://localhost:8080/django22858/upload/kechengxinxi_tupian6.jpg','','课程内容6','工号6','教师姓名6',6,6,CURRENT_TIMESTAMP,6);

DROP TABLE IF EXISTS `kechengfenlei`;

CREATE TABLE `kechengfenlei` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程分类';

INSERT INTO kechengfenlei(id,kechengleixing) VALUES(41,'课程类型1');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(42,'课程类型2');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(43,'课程类型3');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(44,'课程类型4');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(45,'课程类型5');
INSERT INTO kechengfenlei(id,kechengleixing) VALUES(46,'课程类型6');

DROP TABLE IF EXISTS `wodekecheng`;

CREATE TABLE `wodekecheng` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`kechengbianhao` varchar(200)    COMMENT '课程编号',
	`kechengmingcheng` varchar(200)    COMMENT '课程名称',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`tupian` varchar(200)    COMMENT '图片',
	`kechengziliao` varchar(200)    COMMENT '课程资料',
	`kechengneirong` longtext    COMMENT '课程内容',
	`kechengjieshao` longtext    COMMENT '课程介绍',
	`userid` bigint    COMMENT '用户id',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的课程';

INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(51,'学号1','学生姓名1','工号1','教师姓名1','课程编号1','课程名称1','课程类型1','http://localhost:8080/django22858/upload/wodekecheng_tupian1.jpg','','课程内容1','课程介绍1',1);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(52,'学号2','学生姓名2','工号2','教师姓名2','课程编号2','课程名称2','课程类型2','http://localhost:8080/django22858/upload/wodekecheng_tupian2.jpg','','课程内容2','课程介绍2',2);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(53,'学号3','学生姓名3','工号3','教师姓名3','课程编号3','课程名称3','课程类型3','http://localhost:8080/django22858/upload/wodekecheng_tupian3.jpg','','课程内容3','课程介绍3',3);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(54,'学号4','学生姓名4','工号4','教师姓名4','课程编号4','课程名称4','课程类型4','http://localhost:8080/django22858/upload/wodekecheng_tupian4.jpg','','课程内容4','课程介绍4',4);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(55,'学号5','学生姓名5','工号5','教师姓名5','课程编号5','课程名称5','课程类型5','http://localhost:8080/django22858/upload/wodekecheng_tupian5.jpg','','课程内容5','课程介绍5',5);
INSERT INTO wodekecheng(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,tupian,kechengziliao,kechengneirong,kechengjieshao,userid) VALUES(56,'学号6','学生姓名6','工号6','教师姓名6','课程编号6','课程名称6','课程类型6','http://localhost:8080/django22858/upload/wodekecheng_tupian6.jpg','','课程内容6','课程介绍6',6);

DROP TABLE IF EXISTS `kechengzuoye`;

CREATE TABLE `kechengzuoye` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	`kechengbianhao` varchar(200)    COMMENT '课程编号',
	`kechengmingcheng` varchar(200)    COMMENT '课程名称',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`zuoyemingcheng` varchar(200)    COMMENT '作业名称',
	`xiangguanfujian` varchar(200)    COMMENT '相关附件',
	`buzhishijian` datetime    COMMENT '布置时间',
	`jiezhishijian` datetime    COMMENT '截止时间',
	`zuoyeneirong` longtext    COMMENT '作业内容',
	`xiangguantupian` varchar(200)    COMMENT '相关图片',
	`userid` bigint    COMMENT '用户id',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程作业';

INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(61,'工号1','教师姓名1','学号1','学生姓名1','课程编号1','课程名称1','课程类型1','作业名称1','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容1','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian1.jpg',1);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(62,'工号2','教师姓名2','学号2','学生姓名2','课程编号2','课程名称2','课程类型2','作业名称2','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容2','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian2.jpg',2);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(63,'工号3','教师姓名3','学号3','学生姓名3','课程编号3','课程名称3','课程类型3','作业名称3','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容3','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian3.jpg',3);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(64,'工号4','教师姓名4','学号4','学生姓名4','课程编号4','课程名称4','课程类型4','作业名称4','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容4','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian4.jpg',4);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(65,'工号5','教师姓名5','学号5','学生姓名5','课程编号5','课程名称5','课程类型5','作业名称5','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容5','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian5.jpg',5);
INSERT INTO kechengzuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,buzhishijian,jiezhishijian,zuoyeneirong,xiangguantupian,userid) VALUES(66,'工号6','教师姓名6','学号6','学生姓名6','课程编号6','课程名称6','课程类型6','作业名称6','',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'作业内容6','http://localhost:8080/django22858/upload/kechengzuoye_xiangguantupian6.jpg',6);

DROP TABLE IF EXISTS `wodezuoye`;

CREATE TABLE `wodezuoye` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	`kechengbianhao` varchar(200)    COMMENT '课程编号',
	`kechengmingcheng` varchar(200)    COMMENT '课程名称',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`zuoyemingcheng` varchar(200)    COMMENT '作业名称',
	`xiangguanfujian` varchar(200)    COMMENT '相关附件',
	`tijiaoshijian` datetime    COMMENT '提交时间',
	`pigaineirong` longtext    COMMENT '批改内容',
	`zuoyechengji` varchar(200)    COMMENT '作业成绩',
	`xiangguantupian` varchar(200)    COMMENT '相关图片',
	`beizhu` varchar(200)    COMMENT '备注',
	`userid` bigint    COMMENT '用户id',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的作业';

INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(71,'工号1','教师姓名1','学号1','学生姓名1','课程编号1','课程名称1','课程类型1','作业名称1','',CURRENT_TIMESTAMP,'批改内容1','作业成绩1','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian1.jpg','备注1',1);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(72,'工号2','教师姓名2','学号2','学生姓名2','课程编号2','课程名称2','课程类型2','作业名称2','',CURRENT_TIMESTAMP,'批改内容2','作业成绩2','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian2.jpg','备注2',2);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(73,'工号3','教师姓名3','学号3','学生姓名3','课程编号3','课程名称3','课程类型3','作业名称3','',CURRENT_TIMESTAMP,'批改内容3','作业成绩3','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian3.jpg','备注3',3);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(74,'工号4','教师姓名4','学号4','学生姓名4','课程编号4','课程名称4','课程类型4','作业名称4','',CURRENT_TIMESTAMP,'批改内容4','作业成绩4','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian4.jpg','备注4',4);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(75,'工号5','教师姓名5','学号5','学生姓名5','课程编号5','课程名称5','课程类型5','作业名称5','',CURRENT_TIMESTAMP,'批改内容5','作业成绩5','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian5.jpg','备注5',5);
INSERT INTO wodezuoye(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguanfujian,tijiaoshijian,pigaineirong,zuoyechengji,xiangguantupian,beizhu,userid) VALUES(76,'工号6','教师姓名6','学号6','学生姓名6','课程编号6','课程名称6','课程类型6','作业名称6','',CURRENT_TIMESTAMP,'批改内容6','作业成绩6','http://localhost:8080/django22858/upload/wodezuoye_xiangguantupian6.jpg','备注6',6);

DROP TABLE IF EXISTS `kechengkaoshi`;

CREATE TABLE `kechengkaoshi` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	`kechengbianhao` varchar(200)    COMMENT '课程编号',
	`kechengmingcheng` varchar(200)    COMMENT '课程名称',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`shijuanmingcheng` varchar(200)    COMMENT '试卷名称',
	`xiangguanfujian` varchar(200)    COMMENT '相关附件',
	`xiangguantupian` varchar(200)    COMMENT '相关图片',
	`shijuanneirong` longtext    COMMENT '试卷内容',
	`kaishishijian` datetime    COMMENT '开始时间',
	`jieshushijian` datetime    COMMENT '结束时间',
	`userid` bigint    COMMENT '用户id',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程考试';

INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(81,'工号1','教师姓名1','学号1','学生姓名1','课程编号1','课程名称1','课程类型1','试卷名称1','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian1.jpg','试卷内容1',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,1);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(82,'工号2','教师姓名2','学号2','学生姓名2','课程编号2','课程名称2','课程类型2','试卷名称2','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian2.jpg','试卷内容2',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,2);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(83,'工号3','教师姓名3','学号3','学生姓名3','课程编号3','课程名称3','课程类型3','试卷名称3','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian3.jpg','试卷内容3',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,3);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(84,'工号4','教师姓名4','学号4','学生姓名4','课程编号4','课程名称4','课程类型4','试卷名称4','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian4.jpg','试卷内容4',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,4);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(85,'工号5','教师姓名5','学号5','学生姓名5','课程编号5','课程名称5','课程类型5','试卷名称5','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian5.jpg','试卷内容5',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,5);
INSERT INTO kechengkaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,kaishishijian,jieshushijian,userid) VALUES(86,'工号6','教师姓名6','学号6','学生姓名6','课程编号6','课程名称6','课程类型6','试卷名称6','','http://localhost:8080/django22858/upload/kechengkaoshi_xiangguantupian6.jpg','试卷内容6',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,6);

DROP TABLE IF EXISTS `wodekaoshi`;

CREATE TABLE `wodekaoshi` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	`kechengbianhao` varchar(200)    COMMENT '课程编号',
	`kechengmingcheng` varchar(200)    COMMENT '课程名称',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`shijuanmingcheng` varchar(200)    COMMENT '试卷名称',
	`xiangguanfujian` varchar(200)    COMMENT '相关附件',
	`xiangguantupian` varchar(200)    COMMENT '相关图片',
	`shijuanneirong` longtext    COMMENT '试卷内容',
	`shijuanchengji` varchar(200)    COMMENT '试卷成绩',
	`beizhu` varchar(200)    COMMENT '备注',
	`userid` bigint    COMMENT '用户id',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的考试';

INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(91,'工号1','教师姓名1','学号1','学生姓名1','课程编号1','课程名称1','课程类型1','试卷名称1','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian1.jpg','试卷内容1','试卷成绩1','备注1',1);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(92,'工号2','教师姓名2','学号2','学生姓名2','课程编号2','课程名称2','课程类型2','试卷名称2','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian2.jpg','试卷内容2','试卷成绩2','备注2',2);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(93,'工号3','教师姓名3','学号3','学生姓名3','课程编号3','课程名称3','课程类型3','试卷名称3','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian3.jpg','试卷内容3','试卷成绩3','备注3',3);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(94,'工号4','教师姓名4','学号4','学生姓名4','课程编号4','课程名称4','课程类型4','试卷名称4','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian4.jpg','试卷内容4','试卷成绩4','备注4',4);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(95,'工号5','教师姓名5','学号5','学生姓名5','课程编号5','课程名称5','课程类型5','试卷名称5','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian5.jpg','试卷内容5','试卷成绩5','备注5',5);
INSERT INTO wodekaoshi(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,shijuanchengji,beizhu,userid) VALUES(96,'工号6','教师姓名6','学号6','学生姓名6','课程编号6','课程名称6','课程类型6','试卷名称6','','http://localhost:8080/django22858/upload/wodekaoshi_xiangguantupian6.jpg','试卷内容6','试卷成绩6','备注6',6);

DROP TABLE IF EXISTS `zuoyepigai`;

CREATE TABLE `zuoyepigai` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`kechengbianhao` varchar(200)    COMMENT '课程编号',
	`kechengmingcheng` varchar(200)    COMMENT '课程名称',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`zuoyemingcheng` varchar(200)    COMMENT '作业名称',
	`xiangguantupian` varchar(200)    COMMENT '相关图片',
	`xiangguanfujian` varchar(200)    COMMENT '相关附件',
	`zuoyeneirong` longtext    COMMENT '作业内容',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='作业批改';

INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(101,'工号1','教师姓名1','课程编号1','课程名称1','课程类型1','作业名称1','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian1.jpg','','作业内容1','学号1','学生姓名1');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(102,'工号2','教师姓名2','课程编号2','课程名称2','课程类型2','作业名称2','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian2.jpg','','作业内容2','学号2','学生姓名2');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(103,'工号3','教师姓名3','课程编号3','课程名称3','课程类型3','作业名称3','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian3.jpg','','作业内容3','学号3','学生姓名3');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(104,'工号4','教师姓名4','课程编号4','课程名称4','课程类型4','作业名称4','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian4.jpg','','作业内容4','学号4','学生姓名4');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(105,'工号5','教师姓名5','课程编号5','课程名称5','课程类型5','作业名称5','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian5.jpg','','作业内容5','学号5','学生姓名5');
INSERT INTO zuoyepigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,zuoyemingcheng,xiangguantupian,xiangguanfujian,zuoyeneirong,xuehao,xueshengxingming) VALUES(106,'工号6','教师姓名6','课程编号6','课程名称6','课程类型6','作业名称6','http://localhost:8080/django22858/upload/zuoyepigai_xiangguantupian6.jpg','','作业内容6','学号6','学生姓名6');

DROP TABLE IF EXISTS `kaoshipigai`;

CREATE TABLE `kaoshipigai` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`kechengbianhao` varchar(200)    COMMENT '课程编号',
	`kechengmingcheng` varchar(200)    COMMENT '课程名称',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`shijuanmingcheng` varchar(200)    COMMENT '试卷名称',
	`xiangguanfujian` varchar(200)    COMMENT '相关附件',
	`xiangguantupian` varchar(200)    COMMENT '相关图片',
	`shijuanneirong` varchar(200)    COMMENT '试卷内容',
	`jiaojuanshijian` datetime    COMMENT '交卷时间',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='考试批改';

INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(111,'工号1','教师姓名1','课程编号1','课程名称1','课程类型1','试卷名称1','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian1.jpg','',CURRENT_TIMESTAMP,'学号1','学生姓名1');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(112,'工号2','教师姓名2','课程编号2','课程名称2','课程类型2','试卷名称2','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian2.jpg','',CURRENT_TIMESTAMP,'学号2','学生姓名2');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(113,'工号3','教师姓名3','课程编号3','课程名称3','课程类型3','试卷名称3','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian3.jpg','',CURRENT_TIMESTAMP,'学号3','学生姓名3');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(114,'工号4','教师姓名4','课程编号4','课程名称4','课程类型4','试卷名称4','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian4.jpg','',CURRENT_TIMESTAMP,'学号4','学生姓名4');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(115,'工号5','教师姓名5','课程编号5','课程名称5','课程类型5','试卷名称5','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian5.jpg','',CURRENT_TIMESTAMP,'学号5','学生姓名5');
INSERT INTO kaoshipigai(id,gonghao,jiaoshixingming,kechengbianhao,kechengmingcheng,kechengleixing,shijuanmingcheng,xiangguanfujian,xiangguantupian,shijuanneirong,jiaojuanshijian,xuehao,xueshengxingming) VALUES(116,'工号6','教师姓名6','课程编号6','课程名称6','课程类型6','试卷名称6','','http://localhost:8080/django22858/upload/kaoshipigai_xiangguantupian6.jpg','',CURRENT_TIMESTAMP,'学号6','学生姓名6');

DROP TABLE IF EXISTS `kechenggonggao`;

CREATE TABLE `kechenggonggao` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonggaobiaoti` varchar(200)    COMMENT '公告标题',
	`gonggaoneirong` longtext    COMMENT '公告内容',
	`kechengmingcheng` varchar(200)    COMMENT '课程名称',
	`kechengbianhao` varchar(200)    COMMENT '课程编号',
	`kechengleixing` varchar(200)    COMMENT '课程类型',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`faburiqi` date    COMMENT '发布日期',
	`gonggaotupian` varchar(200)    COMMENT '公告图片',
	`thumbsupnum` int   default '0' COMMENT '赞',
	`crazilynum` int   default '0' COMMENT '踩',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程公告';

INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(121,'公告标题1','公告内容1','课程名称1','课程编号1','课程类型1','工号1','教师姓名1',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian1.jpg',1,1);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(122,'公告标题2','公告内容2','课程名称2','课程编号2','课程类型2','工号2','教师姓名2',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian2.jpg',2,2);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(123,'公告标题3','公告内容3','课程名称3','课程编号3','课程类型3','工号3','教师姓名3',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian3.jpg',3,3);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(124,'公告标题4','公告内容4','课程名称4','课程编号4','课程类型4','工号4','教师姓名4',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian4.jpg',4,4);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(125,'公告标题5','公告内容5','课程名称5','课程编号5','课程类型5','工号5','教师姓名5',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian5.jpg',5,5);
INSERT INTO kechenggonggao(id,gonggaobiaoti,gonggaoneirong,kechengmingcheng,kechengbianhao,kechengleixing,gonghao,jiaoshixingming,faburiqi,gonggaotupian,thumbsupnum,crazilynum) VALUES(126,'公告标题6','公告内容6','课程名称6','课程编号6','课程类型6','工号6','教师姓名6',CURRENT_TIMESTAMP,'http://localhost:8080/django22858/upload/kechenggonggao_gonggaotupian6.jpg',6,6);

DROP TABLE IF EXISTS `banjixinxi`;

CREATE TABLE `banjixinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`banji` varchar(200) NOT NULL UNIQUE   COMMENT '班级',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`dianhua` varchar(200)    COMMENT '电话',
	`tupian` varchar(200)    COMMENT '图片',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='班级信息';

INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(131,'班级1','工号1','教师姓名1','电话1','http://localhost:8080/django22858/upload/banjixinxi_tupian1.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(132,'班级2','工号2','教师姓名2','电话2','http://localhost:8080/django22858/upload/banjixinxi_tupian2.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(133,'班级3','工号3','教师姓名3','电话3','http://localhost:8080/django22858/upload/banjixinxi_tupian3.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(134,'班级4','工号4','教师姓名4','电话4','http://localhost:8080/django22858/upload/banjixinxi_tupian4.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(135,'班级5','工号5','教师姓名5','电话5','http://localhost:8080/django22858/upload/banjixinxi_tupian5.jpg');
INSERT INTO banjixinxi(id,banji,gonghao,jiaoshixingming,dianhua,tupian) VALUES(136,'班级6','工号6','教师姓名6','电话6','http://localhost:8080/django22858/upload/banjixinxi_tupian6.jpg');

DROP TABLE IF EXISTS `wodebanji`;

CREATE TABLE `wodebanji` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	`banji` varchar(200) NOT NULL   COMMENT '班级',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`dianhua` varchar(200)    COMMENT '电话',
	`tupian` varchar(200)    COMMENT '图片',
	`sfsh` varchar(200)   default '否' COMMENT '是否审核',
	`shhf` longtext    COMMENT '审核回复',
	`userid` bigint    COMMENT '用户id',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的班级';

INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(141,'学号1','学生姓名1','班级1','工号1','教师姓名1','电话1','http://localhost:8080/django22858/upload/wodebanji_tupian1.jpg','是','',1);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(142,'学号2','学生姓名2','班级2','工号2','教师姓名2','电话2','http://localhost:8080/django22858/upload/wodebanji_tupian2.jpg','是','',2);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(143,'学号3','学生姓名3','班级3','工号3','教师姓名3','电话3','http://localhost:8080/django22858/upload/wodebanji_tupian3.jpg','是','',3);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(144,'学号4','学生姓名4','班级4','工号4','教师姓名4','电话4','http://localhost:8080/django22858/upload/wodebanji_tupian4.jpg','是','',4);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(145,'学号5','学生姓名5','班级5','工号5','教师姓名5','电话5','http://localhost:8080/django22858/upload/wodebanji_tupian5.jpg','是','',5);
INSERT INTO wodebanji(id,xuehao,xueshengxingming,banji,gonghao,jiaoshixingming,dianhua,tupian,sfsh,shhf,userid) VALUES(146,'学号6','学生姓名6','班级6','工号6','教师姓名6','电话6','http://localhost:8080/django22858/upload/wodebanji_tupian6.jpg','是','',6);

DROP TABLE IF EXISTS `zaixianliuyan`;

CREATE TABLE `zaixianliuyan` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`liuyanbianhao` varchar(200) NOT NULL UNIQUE   COMMENT '留言编号',
	`tupian` varchar(200)    COMMENT '图片',
	`liuyanneirong` longtext    COMMENT '留言内容',
	`liuyanshijian` datetime    COMMENT '留言时间',
	`userid` bigint    COMMENT '用户id',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='在线留言';

INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(151,'学号1','学生姓名1','工号1','教师姓名1','留言编号1','http://localhost:8080/django22858/upload/zaixianliuyan_tupian1.jpg','留言内容1',CURRENT_TIMESTAMP,1);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(152,'学号2','学生姓名2','工号2','教师姓名2','留言编号2','http://localhost:8080/django22858/upload/zaixianliuyan_tupian2.jpg','留言内容2',CURRENT_TIMESTAMP,2);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(153,'学号3','学生姓名3','工号3','教师姓名3','留言编号3','http://localhost:8080/django22858/upload/zaixianliuyan_tupian3.jpg','留言内容3',CURRENT_TIMESTAMP,3);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(154,'学号4','学生姓名4','工号4','教师姓名4','留言编号4','http://localhost:8080/django22858/upload/zaixianliuyan_tupian4.jpg','留言内容4',CURRENT_TIMESTAMP,4);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(155,'学号5','学生姓名5','工号5','教师姓名5','留言编号5','http://localhost:8080/django22858/upload/zaixianliuyan_tupian5.jpg','留言内容5',CURRENT_TIMESTAMP,5);
INSERT INTO zaixianliuyan(id,xuehao,xueshengxingming,gonghao,jiaoshixingming,liuyanbianhao,tupian,liuyanneirong,liuyanshijian,userid) VALUES(156,'学号6','学生姓名6','工号6','教师姓名6','留言编号6','http://localhost:8080/django22858/upload/zaixianliuyan_tupian6.jpg','留言内容6',CURRENT_TIMESTAMP,6);

DROP TABLE IF EXISTS `liuyanhuifu`;

CREATE TABLE `liuyanhuifu` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`gonghao` varchar(200)    COMMENT '工号',
	`jiaoshixingming` varchar(200)    COMMENT '教师姓名',
	`xuehao` varchar(200)    COMMENT '学号',
	`xueshengxingming` varchar(200)    COMMENT '学生姓名',
	`liuyanbianhao` varchar(200)    COMMENT '留言编号',
	`tupian` varchar(200)    COMMENT '图片',
	`liuyanneirong` varchar(200)    COMMENT '留言内容',
	`huifuneirong` longtext    COMMENT '回复内容',
	`huifushijian` datetime    COMMENT '回复时间',
	`userid` bigint    COMMENT '用户id',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='留言回复';

INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(161,'工号1','教师姓名1','学号1','学生姓名1','留言编号1','http://localhost:8080/django22858/upload/liuyanhuifu_tupian1.jpg','留言内容1','回复内容1',CURRENT_TIMESTAMP,1);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(162,'工号2','教师姓名2','学号2','学生姓名2','留言编号2','http://localhost:8080/django22858/upload/liuyanhuifu_tupian2.jpg','留言内容2','回复内容2',CURRENT_TIMESTAMP,2);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(163,'工号3','教师姓名3','学号3','学生姓名3','留言编号3','http://localhost:8080/django22858/upload/liuyanhuifu_tupian3.jpg','留言内容3','回复内容3',CURRENT_TIMESTAMP,3);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(164,'工号4','教师姓名4','学号4','学生姓名4','留言编号4','http://localhost:8080/django22858/upload/liuyanhuifu_tupian4.jpg','留言内容4','回复内容4',CURRENT_TIMESTAMP,4);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(165,'工号5','教师姓名5','学号5','学生姓名5','留言编号5','http://localhost:8080/django22858/upload/liuyanhuifu_tupian5.jpg','留言内容5','回复内容5',CURRENT_TIMESTAMP,5);
INSERT INTO liuyanhuifu(id,gonghao,jiaoshixingming,xuehao,xueshengxingming,liuyanbianhao,tupian,liuyanneirong,huifuneirong,huifushijian,userid) VALUES(166,'工号6','教师姓名6','学号6','学生姓名6','留言编号6','http://localhost:8080/django22858/upload/liuyanhuifu_tupian6.jpg','留言内容6','回复内容6',CURRENT_TIMESTAMP,6);

DROP TABLE IF EXISTS `storeup`;

CREATE TABLE `storeup` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`userid` bigint NOT NULL   COMMENT '用户id',
	`refid` bigint    COMMENT '收藏id',
	`tablename` varchar(200)    COMMENT '表名',
	`name` varchar(200) NOT NULL   COMMENT '收藏名称',
	`picture` varchar(200) NOT NULL   COMMENT '收藏图片',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';


DROP TABLE IF EXISTS `discusskechengxinxi`;

CREATE TABLE `discusskechengxinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`refid` bigint NOT NULL   COMMENT '关联表id',
	`userid` bigint NOT NULL   COMMENT '用户id',
	`nickname` varchar(200)    COMMENT '用户名',
	`content` longtext NOT NULL   COMMENT '评论内容',
	`reply` longtext    COMMENT '回复内容',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程信息评论表';

INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(181,1,1,'用户名1','评论内容1','回复内容1');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(182,2,2,'用户名2','评论内容2','回复内容2');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(183,3,3,'用户名3','评论内容3','回复内容3');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(184,4,4,'用户名4','评论内容4','回复内容4');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(185,5,5,'用户名5','评论内容5','回复内容5');
INSERT INTO discusskechengxinxi(id,refid,userid,nickname,content,reply) VALUES(186,6,6,'用户名6','评论内容6','回复内容6');

DROP TABLE IF EXISTS `discusswodekecheng`;

CREATE TABLE `discusswodekecheng` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`refid` bigint NOT NULL   COMMENT '关联表id',
	`userid` bigint NOT NULL   COMMENT '用户id',
	`nickname` varchar(200)    COMMENT '用户名',
	`content` longtext NOT NULL   COMMENT '评论内容',
	`reply` longtext    COMMENT '回复内容',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='我的课程评论表';

INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(191,1,1,'用户名1','评论内容1','回复内容1');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(192,2,2,'用户名2','评论内容2','回复内容2');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(193,3,3,'用户名3','评论内容3','回复内容3');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(194,4,4,'用户名4','评论内容4','回复内容4');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(195,5,5,'用户名5','评论内容5','回复内容5');
INSERT INTO discusswodekecheng(id,refid,userid,nickname,content,reply) VALUES(196,6,6,'用户名6','评论内容6','回复内容6');


DROP TABLE IF EXISTS `config`;

CREATE TABLE `config`(
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`name` varchar(100) NOT NULL COMMENT '配置参数名称',
	`value` varchar(100) COMMENT '配置参数值',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配置文件';

insert into config(id,name,value) values(1,'picture1','http://localhost:8080/django22858/upload/picture1.jpg');
insert into config(id,name,value) values(2,'picture2','http://localhost:8080/django22858/upload/picture2.jpg');
insert into config(id,name,value) values(3,'picture3','http://localhost:8080/django22858/upload/picture3.jpg');
insert into config(id,name) values(6,'homepage');


DROP TABLE IF EXISTS `users`;

CREATE TABLE `users`(
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`username` varchar(100) NOT NULL COMMENT '用户名',
	`password` varchar(100) NOT NULL COMMENT '密码',
	`role` varchar(100) default '管理员' COMMENT '角色',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '新增时间',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

insert into users(id,username, password) values(1,'abo','abo');
云码资源
关注
0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
基于python的在线教育课程作业批改考试系统(mysql)-Django.VUE【数据库设计、论文、源码、开题报告】

用户端功能有：首页、课程信息、我的课程、课程作业、我的作业、课程考试、我的考试、在线留言、班级信息、我的班级、个人中心等管理端功能有：教师管理、学生管理、课程信息查看、我的课程管理、作业管理、考试管理、作业批改、考试批改、班级信息管理、我的班级管理、系统管理教师后台功能有：课程信息查看、我的课程管理、作业管理、考试管理、作业批改、考试批改、班级信息管理、我的班级管理更多功能请看运行截图！
复制链接

扫一扫