ssm java mysql 在线考试系统
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `et_comment`
-- ----------------------------
DROP TABLE IF EXISTS `et_comment`;
CREATE TABLE `et_comment` (
`comment_id` int(10) NOT NULL AUTO_INCREMENT,
`question_id` int(10) NOT NULL,
`index_id` int(10) NOT NULL,
`user_id` int(10) NOT NULL,
`content_msg` mediumtext NOT NULL,
`quoto_id` int(10) NOT NULL DEFAULT '0',
`re_id` int(10) NOT NULL DEFAULT '0',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`comment_id`),
KEY `fk_q_id` (`question_id`),
KEY `fk_u_id` (`user_id`),
CONSTRAINT `fk_q_id` FOREIGN KEY (`question_id`) REFERENCES `et_question` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_u_id` FOREIGN KEY (`user_id`) REFERENCES `et_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of et_comment
-- ----------------------------
-- ----------------------------
-- Table structure for `et_exam_paper`
-- ----------------------------
DROP TABLE IF EXISTS `et_exam_paper`;
CREATE TABLE `et_exam_paper` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(40) NOT NULL,
`content` mediumtext,
`duration` int(11) NOT NULL COMMENT '试卷考试时间',
`total_point` int(11) DEFAULT '0',
`pass_point` int(11) DEFAULT '0',
`group_id` int(11) NOT NULL COMMENT '班组ID',
`is_visible` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否所有用户可见,默认为0',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '试卷状态, 0未完成 -> 1已完成 -> 2已发布 -> 3通过审核 (已发布和通过审核的无法再修改)',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`summary` varchar(100) DEFAULT NULL COMMENT '试卷介绍',
`is_subjective` tinyint(1) DEFAULT NULL COMMENT '为1表示为包含主观题的试卷,需阅卷',
`answer_sheet` mediumtext COMMENT '试卷答案,用答题卡的结构保存',
`creator` varchar(40) DEFAULT NULL COMMENT '创建人的账号',
`paper_type` varchar(40) NOT NULL DEFAULT '1' COMMENT '0 真题 1 模拟 2 专家',
`field_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `group_id` (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='试卷';