/*
Navicat Premium Data Transfer
Source Server : 本地
Source Server Type : MySQL
Source Server Version : 50723
Source Host : localhost:3306
Source Schema : onlineanswer
Target Server Type : MySQL
Target Server Version : 50723
File Encoding : 65001
Date: 23/01/2019 17:52:54
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for answerresult
-- ----------------------------
DROP TABLE IF EXISTS `answerresult`;
CREATE TABLE `answerresult` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '业务主键',
`studentid` int(11) NOT NULL,
`ssid` int(11) NULL DEFAULT NULL COMMENT '学员答题主表ID',
`examid` int(11) NULL DEFAULT NULL COMMENT '名称',
`a` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '答案A 0 默认未选中 1 选中',
`b` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '答案B 0 默认未选中 1 选中',
`c` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '答案C 0 默认未选中 1 选中',
`d` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '答案D 0 默认未选中 1 选中',
`studentanswer` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生答案',
`correctanswer` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正确答案',
`istrue` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '答题是否正确0错误,1正确',
`createtime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 362 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of answerresult
-- ----------------------------
INSERT INTO `answerresult` VALUES (1, 1, 1, 1, '0', '1', '1', '0', 'BC', 'BC', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (2, 1, 1, 2, '0', '1', '1', '0', 'BC', 'A', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (3, 1, 1, 3, '1', '0', '1', '0', 'AC', 'D', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (4, 1, 1, 4, '0', '1', '0', '1', 'BD', 'BD', '1', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (5, 1, 1, 5, '1', '1', '1', '0', 'ABC', 'BCD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (6, 1, 1, 6, '1', '1', '1', '0', 'ABC', 'C', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (7, 1, 1, 7, '1', '1', '1', '0', 'ABC', 'AD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (8, 1, 1, 8, '1', '1', '1', '0', 'ABC', 'CD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (9, 1, 1, 9, '1', '1', '1', '0', 'ABC', 'A', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (10, 1, 1, 10, '1', '1', '1', '0', 'ABC', 'AD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (11, 1, 1, 11, '1', '1', '1', '0', 'ABC', 'BD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (12, 1, 1, 12, '1', '1', '1', '0', 'ABC', 'AD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (13, 1, 1, 13, '1', '1', '0', '1', 'ABD', 'ABD', '1', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (14, 1, 1, 14, '1', '1', '1', '0', 'ABC', 'D', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (15, 1, 1, 15, '1', '1', '1', '0', 'ABC', 'BD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (16, 1, 1, 16, '1', '1', '1', '0', 'ABC', 'D', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (17, 1, 1, 17, '1', '1', '1', '0', 'ABC', 'BD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (18, 1, 1, 18, '1', '1', '1', '0', 'ABC', 'C', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (19, 1, 1, 19, '1', '1', '1', '0', 'ABC', 'ACD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (20, 1, 1, 20, '0', '1', '1', '0', 'BC', 'BD', '0', '2019-01-21 09:26:19');
INSERT INTO `answerresult` VALUES (21, 1, 12, 4, '0', '0', '0', '0', '0000', 'BD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (22, 1, 12, 9, '0', '0', '0', '0', '0000', 'A', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (23, 1, 12, 12, '0', '0', '0', '0', '0000', 'AD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (24, 1, 12, 17, '0', '0', '0', '0', '0000', 'BD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (25, 1, 12, 1, '0', '0', '0', '0', '0000', 'BC', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (26, 1, 12, 18, '0', '0', '0', '0', '0000', 'C', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (27, 1, 12, 16, '0', '0', '0', '0', '0000', 'D', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (28, 1, 12, 20, '0', '0', '0', '0', '0000', 'BD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (29, 1, 12, 21, '0', '0', '0', '0', '0000', 'BC', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (30, 1, 12, 22, '0', '0', '0', '0', '0000', 'AC', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (31, 1, 12, 8, '0', '0', '0', '0', '0000', 'CD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (32, 1, 12, 10, '0', '0', '0', '0', '0000', 'AD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (33, 1, 12, 3, '0', '0', '0', '0', '0000', 'D', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (34, 1, 12, 11, '0', '0', '0', '0', '0000', 'BD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (35, 1, 12, 15, '0', '0', '0', '0', '0000', 'BD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (36, 1, 12, 6, '0', '0', '0', '0', '0000', 'C', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (37, 1, 12, 5, '0', '0', '0', '0', '0000', 'BCD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (38, 1, 12, 19, '0', '0', '0', '0', '0000', 'ACD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (39, 1, 12, 23, '0', '0', '0', '0', '0000', 'ABD', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (40, 1, 12, 14, '0', '0', '0', '0', '0000', 'D', '0', '2019-01-23 11:10:25');
INSERT INTO `answerresult` VALUES (41, 1, 13, 21, '1', '1', '0', '0', 'AB00', 'BC', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (42, 1, 13, 9, '0', '1', '1', '0', '0BC0', 'A', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (43, 1, 13, 8, '0', '0', '0', '0', '0000', 'CD', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (44, 1, 13, 22, '0', '1', '1', '0', '0BC0', 'AC', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (45, 1, 13, 13, '0', '0', '1', '0', '00C0', 'ABD', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (46, 1, 13, 15, '0', '0', '0', '0', '0000', 'BD', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (47, 1, 13, 12, '0', '0', '0', '0', '0000', 'AD', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (48, 1, 13, 19, '0', '0', '0', '0', '0000', 'ACD', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (49, 1, 13, 23, '0', '0', '0', '0', '0000', 'ABD', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (50, 1, 13, 24, '0', '0', '0', '0', '0000', 'ABD', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (51, 1, 13, 16, '0', '0', '0', '0', '0000', 'D', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (52, 1, 13, 1, '0', '0', '0', '0', '0000', 'BC', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (53, 1, 13, 14, '0', '0', '0', '0', '0000', 'D', '0', '2019-01-23 11:11:14');
INSERT INTO `answerresult` VALUES (54, 1, 13, 3, '0', '0', '0', '0', '0000', 'D
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
在线答题系统.zip (3个子文件)
OnLineAnswer20190125后端ExcelIO流导入.zip 213KB
onlineAnswer20190125前端V1.1.zip 1.39MB
onlineanswer.sql 60KB
共 3 条
- 1
资源评论
- weixin_440494422019-07-01感谢楼主分享
- 乘虚圆2019-03-25感谢楼主分享
- jamesdong11202019-06-03感谢楼主分享
laoshu527
- 粉丝: 5
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功