SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `SV_INSTANTPAPER1`
-- ----------------------------
DROP TABLE IF EXISTS `SV_INSTANTPAPER1`;
CREATE TABLE `SV_INSTANTPAPER1` (
 		`INSTANTPAPER1_ID` varchar(100) NOT NULL,
		`PAPER_NAME` varchar(100) DEFAULT NULL COMMENT '试卷名称',
		`TAG` varchar(300) DEFAULT NULL COMMENT '标签',
		`PERMISSION` varchar(100) DEFAULT NULL COMMENT '权限',
		`SUBJECT_ID` varchar(50) DEFAULT NULL COMMENT '科目',
		`GRADE_ID` varchar(50) DEFAULT NULL COMMENT '年级',
		`CLASS_ID` varchar(50) DEFAULT NULL COMMENT '班级',
		`SCHOOL_ID` varchar(50) DEFAULT NULL COMMENT '学校',
		`COMBINATION` int(1) NOT NULL COMMENT '是否组合试卷',
		`PAPER_SCORE` varchar(10) DEFAULT NULL COMMENT '试卷总分',
		`USER_ID` varchar(50) DEFAULT NULL COMMENT '用户',
		`CREATE_TIME` varchar(32) DEFAULT NULL COMMENT '创建时间',
		`COUNT` varchar(10) DEFAULT NULL COMMENT '考试次数',
  		PRIMARY KEY (`INSTANTPAPER1_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `SV_INSTANTPAPER1CONTENT`
-- ----------------------------
DROP TABLE IF EXISTS `SV_INSTANTPAPER1CONTENT`;
CREATE TABLE `SV_INSTANTPAPER1CONTENT` (
 		`INSTANTPAPER1CONTENT_ID` varchar(100) NOT NULL,
		`PAPER_ID` varchar(50) DEFAULT NULL COMMENT '试卷',
		`QUESTION_ID` varchar(50) DEFAULT NULL COMMENT '试题',
		`RANK` varchar(10) DEFAULT NULL COMMENT '排序',
		`TITLE` varchar(20) DEFAULT NULL COMMENT '题号',
		`SCORE` varchar(255) DEFAULT NULL COMMENT '分数',
		`REMARK` varchar(255) DEFAULT NULL COMMENT '说明',
  		PRIMARY KEY (`INSTANTPAPER1CONTENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `SV_INSTANTQUESTIONDATASOURCE1`
-- ----------------------------
DROP TABLE IF EXISTS `SV_INSTANTQUESTIONDATASOURCE1`;
CREATE TABLE `SV_INSTANTQUESTIONDATASOURCE1` (
 		`INSTANTQUESTIONDATASOURCE1_ID` varchar(100) NOT NULL,
		`IMAGE_URL` varchar(100) DEFAULT NULL COMMENT '图片路径',
		`SCORE` double(11,2) DEFAULT NULL COMMENT '分数',
		`ANSWER_CONTENT` varchar(100) DEFAULT NULL COMMENT '答案内容',
		`RIGHT_ANSWER` varchar(100) DEFAULT NULL COMMENT '标准答案',
		`TAG` varchar(300) DEFAULT NULL COMMENT '标签',
		`PERMISSION` varchar(100) DEFAULT NULL COMMENT '权限',
		`SUBJECT_ID` varchar(50) DEFAULT NULL COMMENT '科目',
		`GRADE_ID` varchar(50) DEFAULT NULL COMMENT '年级',
		`SCHOOL_ID` varchar(50) DEFAULT NULL COMMENT '学校',
		`USER_ID` varchar(50) DEFAULT NULL COMMENT '用户ID',
		`创建时间` varchar(32) DEFAULT NULL COMMENT 'create_time',
		`CLASS_ID` varchar(50) DEFAULT NULL COMMENT '班级',
  		PRIMARY KEY (`INSTANTQUESTIONDATASOURCE1_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `SV_PAPERANSWER1`
-- ----------------------------
DROP TABLE IF EXISTS `SV_PAPERANSWER1`;
CREATE TABLE `SV_PAPERANSWER1` (
 		`PAPERANSWER1_ID` varchar(100) NOT NULL,
		`PAPER_ID` varchar(35) DEFAULT NULL COMMENT '试卷',
		`PAPER_NAME` varchar(30) DEFAULT NULL COMMENT '试卷名称',
		`SUBJECT_ID` varchar(35) DEFAULT NULL COMMENT '科目',
		`CLASS_ID` varchar(35) DEFAULT NULL COMMENT '班级ID',
		`GRADE_ID` varchar(35) DEFAULT NULL COMMENT '年级',
		`SCHOOL_ID` varchar(35) DEFAULT NULL COMMENT '学校',
		`USER_ID` varchar(35) DEFAULT NULL COMMENT '创建者',
		`CREATE_DATE` varchar(32) DEFAULT NULL COMMENT '考试时间',
		`AVG_SCORE` varchar(35) DEFAULT NULL COMMENT '平均分',
		`HIGHT_SCORE` varchar(35) DEFAULT NULL COMMENT '最高分',
		`REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  		PRIMARY KEY (`PAPERANSWER1_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `SV_STUDENTANSWER1`
-- ----------------------------
DROP TABLE IF EXISTS `SV_STUDENTANSWER1`;
CREATE TABLE `SV_STUDENTANSWER1` (
 		`STUDENTANSWER1_ID` varchar(100) NOT NULL,
		`STUDENT_ID` varchar(35) DEFAULT NULL COMMENT '学生',
		`STUDENT_NAME` varchar(30) DEFAULT NULL COMMENT '学生姓名',
		`STUDENT_NO` varchar(35) DEFAULT NULL COMMENT '学生学号',
		`CONTENT` varchar(1000) DEFAULT NULL COMMENT '答案内容（正确与否）',
		`GET_SCORE` varchar(32) DEFAULT NULL COMMENT '学生得分',
		`PAPER_ID` varchar(35) DEFAULT NULL COMMENT '试卷',
		`ANSWER_ID` varchar(35) DEFAULT NULL COMMENT '答卷ID',
		`CLASS_ID` varchar(35) DEFAULT NULL COMMENT '班级ID',
		`GRADE_ID` varchar(35) DEFAULT NULL COMMENT '年级ID',
		`SCHOOL_ID` varchar(35) DEFAULT NULL COMMENT '学校ID',
  		PRIMARY KEY (`STUDENTANSWER1_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;