多应用+插件架构,代码干净,二开方便,首家独创一键云编译技术,文档视频完善,免费商用码云13.8K 广告
# SQL # ``` /* Navicat MySQL Data Transfer Source Server : weike Source Server Version : 50636 Source Host : 10.8.8.14:3306 Source Database : wkxuetang Target Server Type : MYSQL Target Server Version : 50636 File Encoding : 65001 Date: 2018-11-20 18:46:28 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for tbAnswerExamPush -- ---------------------------- DROP TABLE IF EXISTS `tbAnswerExamPush`; CREATE TABLE `tbAnswerExamPush` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdAeid` int(11) NOT NULL, `fdType` int(11) NOT NULL COMMENT '推荐类型 1:微课 2:考点 3:专题', `fdValue` int(11) NOT NULL COMMENT '类型对应的值', `fdStatus` tinyint(4) NOT NULL COMMENT '完成状态', `fdCreate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `fdAeid` (`fdAeid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='答卷推送内容'; -- ---------------------------- -- Records of tbAnswerExamPush -- ---------------------------- -- ---------------------------- -- Table structure for tbAnswerExamPushRecord -- ---------------------------- DROP TABLE IF EXISTS `tbAnswerExamPushRecord`; CREATE TABLE `tbAnswerExamPushRecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdAnswerExamPushID` int(11) NOT NULL, `fdAeid` int(11) DEFAULT '0', `fdStatus` int(11) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='答卷推送完成记录'; -- ---------------------------- -- Records of tbAnswerExamPushRecord -- ---------------------------- -- ---------------------------- -- Table structure for tbCourse -- ---------------------------- DROP TABLE IF EXISTS `tbCourse`; CREATE TABLE `tbCourse` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdUserID` int(11) NOT NULL COMMENT '课程创建者ID', `fdName` varchar(128) DEFAULT NULL, `fdCourseType` tinyint(4) DEFAULT '0' COMMENT '课程类型 \r\n 1:同步课\r\n 2:专题课', `fdSubjectID` tinyint(4) DEFAULT '0' COMMENT '科目id', `fdSchoolTypeID` tinyint(4) DEFAULT '0' COMMENT '学段ID ', `fdViewType` tinyint(4) DEFAULT '0' COMMENT '观看类型:\r\n 1:直播\r\n 2:录播', `fdDiff` tinyint(4) DEFAULT '0' COMMENT '课程难度系数', `fdFee` int(11) DEFAULT '0' COMMENT '付费金额,单位是分\r\n 0表示免费课程', `fdThumb` varchar(255) DEFAULT NULL COMMENT '课程缩略图', `fdVideo` varchar(255) DEFAULT NULL COMMENT '课程试学视频', `fdVideoThumb` varchar(255) DEFAULT NULL COMMENT '课程试学视频封面图', `fdInfo` text COMMENT '课程介绍', `fdStatus` tinyint(4) DEFAULT NULL COMMENT '课程状态 0:未发布 1:已发布 2:已下架', `fdCreate` datetime DEFAULT NULL, `fdUpdate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='学堂课程'; -- ---------------------------- -- Records of tbCourse -- ---------------------------- INSERT INTO `tbCourse` VALUES ('1', '235590', '我的第n个课程', '2', '2', '2', '2', '2', '2', 'http://xuetang.cm/content/coursecenter/0/0/0/1/-615639072.jpg', 'http://xuetang.cm/content/coursecenter/0/0/0/1/-615640928.mp4', null, '课程简介', '1', '2018-11-20 13:40:48', '2018-11-20 13:40:48'); INSERT INTO `tbCourse` VALUES ('2', '235590', 'TEST', '1', '2', '2', '2', '2', '2', 'http://xuetang.cm/content/coursecenter/0/0/0/1/-615639072.jpg', 'http://xuetang.cm/content/coursecenter/0/0/0/1/-615640928.mp4', null, '课程简介', '0', '2018-11-20 13:40:48', '2018-11-20 13:40:48'); -- ---------------------------- -- Table structure for tbCourseAttribute -- ---------------------------- DROP TABLE IF EXISTS `tbCourseAttribute`; CREATE TABLE `tbCourseAttribute` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) DEFAULT NULL COMMENT '课程ID', `fdAttributeID` int(11) DEFAULT NULL, `fdValue` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fdCourseID` (`fdCourseID`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='课程额外属性'; -- ---------------------------- -- Records of tbCourseAttribute -- ---------------------------- INSERT INTO `tbCourseAttribute` VALUES ('1', '1', '37', '1'); INSERT INTO `tbCourseAttribute` VALUES ('2', '1', '37', '2'); INSERT INTO `tbCourseAttribute` VALUES ('3', '1', '409', '1'); INSERT INTO `tbCourseAttribute` VALUES ('4', '1', '409', '2'); INSERT INTO `tbCourseAttribute` VALUES ('5', '1', '38', '1'); INSERT INTO `tbCourseAttribute` VALUES ('6', '1', '267', '41489'); -- ---------------------------- -- Table structure for tbCourseCatalog -- ---------------------------- DROP TABLE IF EXISTS `tbCourseCatalog`; CREATE TABLE `tbCourseCatalog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) DEFAULT NULL COMMENT '课程ID', `fdParentID` int(11) DEFAULT '0' COMMENT '课程目录上一级ID', `fdTagTypeID` tinyint(4) DEFAULT '0' COMMENT '对应目录类型\r\n 1:章节ID\r\n 2:知识点ID\r\n 3:辅材ID', `fdTagID` int(11) DEFAULT '0' COMMENT '对应的章节/知识点/辅材ID', `fdTagLevel` tinyint(4) DEFAULT '0' COMMENT '对应章节/知识点/辅材所在层级', `fdLevel` tinyint(4) DEFAULT '0' COMMENT '当前目录所在层级', `fdName` varchar(64) DEFAULT NULL, `fdOrder` int(11) DEFAULT '0' COMMENT '目录排序', `fdUserID` int(11) DEFAULT '0' COMMENT '添加目录用户ID', `fdSpeakerID` int(11) NOT NULL DEFAULT '0' COMMENT '主讲人ID', `fdTeacherID` int(11) DEFAULT '0' COMMENT '助教用户ID', `fdStarttime` datetime DEFAULT NULL COMMENT '直播课开课时间', `fdEndtime` datetime DEFAULT NULL COMMENT '直播课结束时间', `fdCreate` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `fdCourseID` (`fdCourseID`), KEY `fdParentID` (`fdParentID`), KEY `fdLevel` (`fdLevel`), KEY `fdSpeakerID` (`fdSpeakerID`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='课程目录'; -- ---------------------------- -- Records of tbCourseCatalog -- ---------------------------- INSERT INTO `tbCourseCatalog` VALUES ('1', '1', null, null, null, null, '1', '第一章 数学', '9', '235590', '0', '0', null, null, '2018-11-20 13:41:40'); INSERT INTO `tbCourseCatalog` VALUES ('2', '1', '1', '1', '54648', '3', '2', '第一节 数学代数', '11', '235590', '0', '0', null, null, '2018-11-20 13:41:40'); INSERT INTO `tbCourseCatalog` VALUES ('3', '1', null, null, null, null, '1', '第一章 数学', '9', '235590', '0', '0', null, null, '2018-11-20 13:42:11'); INSERT INTO `tbCourseCatalog` VALUES ('4', '1', '3', '1', '54648', '3', '2', '第一节 数学代数', '11', '235590', '0', '0', null, null, '2018-11-20 13:42:11'); -- ---------------------------- -- Table structure for tbCourseReview -- ---------------------------- DROP TABLE IF EXISTS `tbCourseReview`; CREATE TABLE `tbCourseReview` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) DEFAULT NULL COMMENT '课程ID', `fdCourseCatalogID` int(11) DEFAULT NULL COMMENT '课程章节id', `fdName` varchar(255) DEFAULT NULL COMMENT '视频名称', `fdUrl` varchar(255) DEFAULT NULL COMMENT '回放视频地址', `fdDuration` int(11) DEFAULT NULL COMMENT '回放视频时长,单位是秒', `fdThumb` varchar(255) DEFAULT NULL COMMENT '回放视频封面截图', `fdCreate` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `fdCourseID` (`fdCourseID`), KEY `fdCourseCatalogID` (`fdCourseCatalogID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='直播视频回放'; -- ---------------------------- -- Records of tbCourseReview -- ---------------------------- -- ---------------------------- -- Table structure for tbCourseStudent -- ---------------------------- DROP TABLE IF EXISTS `tbCourseStudent`; CREATE TABLE `tbCourseStudent` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) DEFAULT NULL COMMENT '课程ID', `fdUserID` int(11) DEFAULT NULL COMMENT '学生用户ID', `fdStatus` tinyint(4) DEFAULT '0' COMMENT '加入课程状态\r\n 0:正常加入\r\n 1:退出\r\n 2:过期', `fdCreate` datetime DEFAULT NULL, `fdUpdate` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `fdUserID` (`fdUserID`), KEY `fdCourseID` (`fdCourseID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='报名学生'; -- ---------------------------- -- Records of tbCourseStudent -- ---------------------------- -- ---------------------------- -- Table structure for tbCourseTask -- ---------------------------- DROP TABLE IF EXISTS `tbCourseTask`; CREATE TABLE `tbCourseTask` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) NOT NULL COMMENT '任务所属课程ID', `fdCourseCatalogID` int(11) NOT NULL COMMENT '任务所属课程章节ID', `fdName` varchar(255) NOT NULL COMMENT '任务名称', `fdIntro` text NOT NULL COMMENT '任务说明', `fdOrder` int(11) NOT NULL DEFAULT '0' COMMENT '任务排序', `fdUserID` int(11) NOT NULL COMMENT '任务添加者ID', `fdStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '任务状态', `fdCreate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `fdCourseID` (`fdCourseID`), KEY `fdCourseCatalogID` (`fdCourseCatalogID`), KEY `fdStatus` (`fdStatus`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='课程任务'; -- ---------------------------- -- Records of tbCourseTask -- ---------------------------- INSERT INTO `tbCourseTask` VALUES ('1', '1', '2', '第一个任务', '说明', '1', '235590', '0', '2018-11-20 13:46:12'); INSERT INTO `tbCourseTask` VALUES ('2', '1', '2', '第二个任务', '说明', '2', '235590', '0', '2018-11-20 14:58:36'); INSERT INTO `tbCourseTask` VALUES ('3', '1', '2', '第一个任务', '说明', '2', '235590', '0', '2018-11-20 14:59:18'); INSERT INTO `tbCourseTask` VALUES ('4', '1', '2', '第一个任务', '说明', '2', '235590', '0', '2018-11-20 14:59:57'); INSERT INTO `tbCourseTask` VALUES ('5', '1', '2', '第一个任务', '说明', '2', '235590', '0', '2018-11-20 15:00:30'); INSERT INTO `tbCourseTask` VALUES ('6', '1', '2', '第一个任务', '说明', '2', '235590', '0', '2018-11-20 15:01:44'); INSERT INTO `tbCourseTask` VALUES ('7', '1', '2', '第n个任务3', '说明132', '4', '235590', '1', '2018-11-20 15:02:28'); -- ---------------------------- -- Table structure for tbCourseTaskRecord -- ---------------------------- DROP TABLE IF EXISTS `tbCourseTaskRecord`; CREATE TABLE `tbCourseTaskRecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) DEFAULT NULL COMMENT '课程ID', `fdCourseCatalogID` int(11) DEFAULT NULL COMMENT '课程所属章节ID', `fdCourseTaskID` int(11) DEFAULT NULL COMMENT '课程任务ID', `fdType` int(11) DEFAULT NULL COMMENT '任务类型\r\n 以content.type参考', `fdValue` int(11) DEFAULT NULL COMMENT '对应类型的ID', `fdOrder` int(11) DEFAULT '0' COMMENT '任务排序', `fdUserID` int(11) DEFAULT '0' COMMENT '添加任务的用户ID', `fdCreate` datetime DEFAULT NULL, `fdStatus` tinyint(4) DEFAULT '0' COMMENT '任务状态\r\n 0:正常\r\n 1:删除', PRIMARY KEY (`id`), KEY `fdCourseID` (`fdCourseID`), KEY `fdCourseCatalogID` (`fdCourseCatalogID`), KEY `fdCourseTaskID` (`fdCourseTaskID`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='任务详情'; -- ---------------------------- -- Records of tbCourseTaskRecord -- ---------------------------- INSERT INTO `tbCourseTaskRecord` VALUES ('1', '1', '2', '7', '26', '62734', '1', '235590', '2018-11-20 15:02:28', '0'); INSERT INTO `tbCourseTaskRecord` VALUES ('2', '1', '2', '7', '26', '62734', '1', '235590', '2018-11-20 15:11:49', '0'); INSERT INTO `tbCourseTaskRecord` VALUES ('3', '1', '2', '7', '26', '62734', '2', '235590', '2018-11-20 15:12:18', '0'); INSERT INTO `tbCourseTaskRecord` VALUES ('4', '1', '2', '7', '26', '62734', null, '235590', '2018-11-20 15:34:28', '1'); -- ---------------------------- -- Table structure for tbCourseTeacher -- ---------------------------- DROP TABLE IF EXISTS `tbCourseTeacher`; CREATE TABLE `tbCourseTeacher` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) DEFAULT NULL COMMENT '课程ID', `fdUserID` int(11) DEFAULT NULL COMMENT '教师ID', `fdIsMaster` tinyint(4) DEFAULT NULL COMMENT '是否为课程作者 0:否 1:是', `fdStatus` tinyint(4) DEFAULT NULL COMMENT '教师参与状态\r\n 0:加入\r\n 1:退出\r\n 2:被退出', `fdCreate` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `fdCourseID` (`fdCourseID`), KEY `fdUserID` (`fdUserID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='课程参与教师'; -- ---------------------------- -- Records of tbCourseTeacher -- ---------------------------- INSERT INTO `tbCourseTeacher` VALUES ('1', '1', '235590', '1', '0', '2018-11-20 13:40:48'); -- ---------------------------- -- Table structure for tbFinishCourse -- ---------------------------- DROP TABLE IF EXISTS `tbFinishCourse`; CREATE TABLE `tbFinishCourse` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdUserID` int(11) DEFAULT NULL, `fdCourseID` int(11) DEFAULT NULL, `fdCreate` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `fdUserID` (`fdUserID`), KEY `fdCourseID` (`fdCourseID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='完成课程记录表'; -- ---------------------------- -- Records of tbFinishCourse -- ---------------------------- -- ---------------------------- -- Table structure for tbFinishTask -- ---------------------------- DROP TABLE IF EXISTS `tbFinishTask`; CREATE TABLE `tbFinishTask` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) DEFAULT NULL, `fdCourseTaskID` int(11) DEFAULT NULL, `fdUserID` int(11) DEFAULT NULL, `fdCreate` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `fdCourseID` (`fdCourseID`), KEY `fdCourseTaskID` (`fdCourseTaskID`), KEY `fdUserID` (`fdUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='完成任务记录表'; -- ---------------------------- -- Records of tbFinishTask -- ---------------------------- -- ---------------------------- -- Table structure for tbFinishTaskRecord -- ---------------------------- DROP TABLE IF EXISTS `tbFinishTaskRecord`; CREATE TABLE `tbFinishTaskRecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdCourseID` int(11) DEFAULT NULL COMMENT '课程ID', `fdCourseTaskID` int(11) DEFAULT NULL COMMENT '任务ID', `fdCourseTaskRecordID` int(11) DEFAULT NULL COMMENT '任务项ID', `fdUserID` int(11) DEFAULT NULL COMMENT '用户ID', `fdAeid` int(11) DEFAULT '0' COMMENT '答题类型的answerexamid', `fdCreate` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `fdCourseID` (`fdCourseID`), KEY `fdCourseTaskID` (`fdCourseTaskID`), KEY `fdCourseTaskRecordID` (`fdCourseTaskRecordID`), KEY `fdUserID` (`fdUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='完成任务项记录'; -- ---------------------------- -- Records of tbFinishTaskRecord -- ---------------------------- -- ---------------------------- -- Table structure for tbGroup -- ---------------------------- DROP TABLE IF EXISTS `tbGroup`; CREATE TABLE `tbGroup` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdUserID` int(11) NOT NULL COMMENT '教师ID', `fdName` varchar(255) NOT NULL COMMENT '小组名称', `fdText` text NOT NULL COMMENT '小组说明', `fdStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0:正常 1:删除', `fdCreate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `fdUserID` (`fdUserID`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='学堂分组'; -- ---------------------------- -- Records of tbGroup -- ---------------------------- INSERT INTO `tbGroup` VALUES ('1', '235590', 'test', '123456', '1', '2018-08-16 14:10:34'); INSERT INTO `tbGroup` VALUES ('2', '235590', 'test2', '123456', '0', '2018-08-16 14:28:01'); INSERT INTO `tbGroup` VALUES ('3', '151', '阿斯顿', '', '0', '0000-00-00 00:00:00'); INSERT INTO `tbGroup` VALUES ('4', '333', '555', '', '0', '2018-07-24 00:00:00'); INSERT INTO `tbGroup` VALUES ('5', '235590', '小组一', 'asss', '0', '2018-08-16 16:51:08'); INSERT INTO `tbGroup` VALUES ('6', '235590', '小组一', '', '1', '2018-08-16 16:53:09'); INSERT INTO `tbGroup` VALUES ('7', '235590', 'test1', '', '0', '2018-08-16 17:03:48'); -- ---------------------------- -- Table structure for tbGroupRecord -- ---------------------------- DROP TABLE IF EXISTS `tbGroupRecord`; CREATE TABLE `tbGroupRecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdGroupID` int(11) NOT NULL COMMENT '小组ID', `fdUserID` int(11) NOT NULL COMMENT '学生ID', `fdCreate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `fdGroupID` (`fdGroupID`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='学生小组记录'; -- ---------------------------- -- Records of tbGroupRecord -- ---------------------------- INSERT INTO `tbGroupRecord` VALUES ('7', '2', '692826', '2018-08-16 16:45:24'); INSERT INTO `tbGroupRecord` VALUES ('8', '2', '421906', '2018-08-16 16:45:24'); INSERT INTO `tbGroupRecord` VALUES ('9', '5', '692826', '2018-08-16 17:02:34'); INSERT INTO `tbGroupRecord` VALUES ('10', '6', '421906', '2018-08-16 17:02:46'); -- ---------------------------- -- Table structure for tbTestRecord -- ---------------------------- DROP TABLE IF EXISTS `tbTestRecord`; CREATE TABLE `tbTestRecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdUserID` int(11) NOT NULL, `fdTaskScheduleID` int(11) NOT NULL COMMENT '任务系统ID', `fdType` int(11) NOT NULL COMMENT '1:首测 2:终测', `fdAeid` int(11) NOT NULL COMMENT '答卷id', `fdCreate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `userid` (`fdUserID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='提分课程评估记录'; -- ---------------------------- -- Records of tbTestRecord -- ---------------------------- SET FOREIGN_KEY_CHECKS=1; ```