# Host: 127.0.0.1  (Version 5.7.20-log)
# Date: 2017-10-26 15:42:10
# Generator: MySQL-Front 6.0  (Build 2.20)


#
# Structure for table "classestbl"
#

DROP TABLE IF EXISTS `classestbl`;
CREATE TABLE `classestbl` (
  `class_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '教学班ID',
  `course_id` int(11) NOT NULL DEFAULT '0' COMMENT '课程ID',
  `teacher_number` varchar(255) NOT NULL DEFAULT '' COMMENT '老师工号',
  `teacher_name` varchar(255) NOT NULL DEFAULT '' COMMENT '老师姓名',
  `teacher_password` char(13) DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='教学班';

#
# Data for table "classestbl"
#


#
# Structure for table "coursetbl"
#

DROP TABLE IF EXISTS `coursetbl`;
CREATE TABLE `coursetbl` (
  `course_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '课程ID',
  `course_number` varchar(255) NOT NULL DEFAULT '' COMMENT '课程编号',
  `course_name` varchar(255) NOT NULL DEFAULT '' COMMENT '课程名字',
  `semester` varchar(6) DEFAULT NULL COMMENT '学期',
  PRIMARY KEY (`course_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='课程';

#
# Data for table "coursetbl"
#

INSERT INTO `coursetbl` VALUES (1,'222','语文','一年级上'),(2,'333','数学','一年级上'),(3,'444','英语','一年级上'),(4,'555','思想与品德','一年级下'),(5,'444','体育','一年级下'),(6,'222','科学','二年级上'),(7,'666','历史','二年级下'),(8,'111','1','333');

#
# Structure for table "examtbl"
#

DROP TABLE IF EXISTS `examtbl`;
CREATE TABLE `examtbl` (
  `exam_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '测验ID',
  `course_id` int(11) NOT NULL DEFAULT '0' COMMENT '课程ID',
  `class_id` int(11) NOT NULL DEFAULT '0' COMMENT '教学班ID',
  `exam_name` varchar(255) NOT NULL DEFAULT '' COMMENT '测验名称',
  `exam_time` timestamp NULL DEFAULT NULL COMMENT '测验时间',
  `exam_place` varchar(255) DEFAULT NULL COMMENT '测验地点',
  `bank_id` int(11) NOT NULL DEFAULT '0' COMMENT '题库ID',
  PRIMARY KEY (`exam_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='测验';

#
# Data for table "examtbl"
#

INSERT INTO `examtbl` VALUES (1,0,0,'第一次测验',NULL,NULL,0);

#
# Structure for table "questionbanktbl"
#

DROP TABLE IF EXISTS `questionbanktbl`;
CREATE TABLE `questionbanktbl` (
  `bank_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '题库ID',
  `bank_instruction` varchar(255) DEFAULT NULL COMMENT '内容说明',
  PRIMARY KEY (`bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='题库';

#
# Data for table "questionbanktbl"
#


#
# Structure for table "questiontbl"
#

DROP TABLE IF EXISTS `questiontbl`;
CREATE TABLE `questiontbl` (
  `question_Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '题目编号',
  `bank_id` int(11) NOT NULL DEFAULT '0' COMMENT '题库ID',
  `content` blob COMMENT '题目内容',
  PRIMARY KEY (`question_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='题库里的题';

#
# Data for table "questiontbl"
#


#
# Structure for table "scoretbl"
#

DROP TABLE IF EXISTS `scoretbl`;
CREATE TABLE `scoretbl` (
  `score_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '成绩',
  `exam_id` int(11) NOT NULL DEFAULT '0' COMMENT '考试ID',
  `student_id` int(11) NOT NULL DEFAULT '0' COMMENT '学生ID',
  `student_score` float NOT NULL DEFAULT '0' COMMENT '学生成绩',
  PRIMARY KEY (`score_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='成绩';

#
# Data for table "scoretbl"
#


#
# Structure for table "studentstbl"
#

DROP TABLE IF EXISTS `studentstbl`;
CREATE TABLE `studentstbl` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生ID',
  `class_id` int(11) NOT NULL DEFAULT '0' COMMENT '班级ID',
  `student_number` varchar(255) NOT NULL DEFAULT '' COMMENT '学生学号',
  `student_name` varchar(255) NOT NULL DEFAULT '' COMMENT '学生姓名',
  `student_class` varchar(255) DEFAULT NULL COMMENT '所在班级',
  `student_grade` varchar(255) DEFAULT NULL COMMENT '所在年级',
  `student_password` char(13) DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='学生';

#
# Data for table "studentstbl"
#