grain_college
/
guli_edu.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : guli_edu

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2020-07-26 18:22:07
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for edu_chapter
-- ----------------------------
DROP TABLE IF EXISTS `edu_chapter`;
CREATE TABLE `edu_chapter` (
  `id` char(19) NOT NULL COMMENT '章节ID',
  `course_id` char(19) NOT NULL COMMENT '课程ID',
  `title` varchar(50) NOT NULL COMMENT '章节名称',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '显示排序',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_course_id` (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程';

-- ----------------------------
-- Records of edu_chapter
-- ----------------------------
INSERT INTO `edu_chapter` VALUES ('1287328980484890625', '1287328558642765825', '章节1', '1', '2020-07-26 18:08:41', '2020-07-26 18:08:41');

-- ----------------------------
-- Table structure for edu_comment
-- ----------------------------
DROP TABLE IF EXISTS `edu_comment`;
CREATE TABLE `edu_comment` (
  `id` char(19) NOT NULL COMMENT '讲师ID',
  `course_id` char(19) NOT NULL DEFAULT '' COMMENT '课程id',
  `teacher_id` char(19) NOT NULL DEFAULT '' COMMENT '讲师id',
  `member_id` char(19) NOT NULL DEFAULT '' COMMENT '会员id',
  `nickname` varchar(50) DEFAULT NULL COMMENT '会员昵称',
  `avatar` varchar(255) DEFAULT NULL COMMENT '会员头像',
  `content` varchar(500) DEFAULT NULL COMMENT '评论内容',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_course_id` (`course_id`),
  KEY `idx_teacher_id` (`teacher_id`),
  KEY `idx_member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论';

-- ----------------------------
-- Records of edu_comment
-- ----------------------------

-- ----------------------------
-- Table structure for edu_course
-- ----------------------------
DROP TABLE IF EXISTS `edu_course`;
CREATE TABLE `edu_course` (
  `id` char(19) NOT NULL COMMENT '课程ID',
  `teacher_id` char(19) NOT NULL COMMENT '课程讲师ID',
  `subject_id` char(19) NOT NULL COMMENT '课程专业ID',
  `subject_parent_id` char(19) NOT NULL COMMENT '课程专业父级ID',
  `title` varchar(50) NOT NULL COMMENT '课程标题',
  `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '课程销售价格，设置为0则可免费观看',
  `lesson_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '总课时',
  `cover` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '课程封面图片路径',
  `buy_count` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '销售数量',
  `view_count` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览数量',
  `version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `status` varchar(10) NOT NULL DEFAULT 'Draft' COMMENT '课程状态 Draft未发布  Normal已发布',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_title` (`title`),
  KEY `idx_subject_id` (`subject_id`),
  KEY `idx_teacher_id` (`teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程';

-- ----------------------------
-- Records of edu_course
-- ----------------------------
INSERT INTO `edu_course` VALUES ('1287328558642765825', '12', '1284682446039666689', '1284682446014500865', 'nuxt入门到入土', '888.00', '66', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-26/5f1d48ec-3e74-474b-9df3-5876afd61c31.jpg', '0', '0', '1', 'Normal', '2020-07-26 18:07:00', '2020-07-26 18:10:25');

-- ----------------------------
-- Table structure for edu_course_collect
-- ----------------------------
DROP TABLE IF EXISTS `edu_course_collect`;
CREATE TABLE `edu_course_collect` (
  `id` char(19) NOT NULL COMMENT '收藏ID',
  `course_id` char(19) NOT NULL COMMENT '课程讲师ID',
  `member_id` char(19) NOT NULL DEFAULT '' COMMENT '课程专业ID',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程收藏';

-- ----------------------------
-- Records of edu_course_collect
-- ----------------------------

-- ----------------------------
-- Table structure for edu_course_description
-- ----------------------------
DROP TABLE IF EXISTS `edu_course_description`;
CREATE TABLE `edu_course_description` (
  `id` char(19) NOT NULL COMMENT '课程ID',
  `description` text COMMENT '课程简介',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程简介';

-- ----------------------------
-- Records of edu_course_description
-- ----------------------------
INSERT INTO `edu_course_description` VALUES ('1287328558642765825', '<p>主讲林次月，讲了李惠利</p>', '2020-07-26 18:07:00', '2020-07-26 18:08:36');

-- ----------------------------
-- Table structure for edu_subject
-- ----------------------------
DROP TABLE IF EXISTS `edu_subject`;
CREATE TABLE `edu_subject` (
  `id` char(19) NOT NULL COMMENT '课程类别ID',
  `title` varchar(10) NOT NULL COMMENT '类别名称',
  `parent_id` char(19) NOT NULL DEFAULT '0' COMMENT '父ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程科目';

-- ----------------------------
-- Records of edu_subject
-- ----------------------------
INSERT INTO `edu_subject` VALUES ('1284679567933427713', '后端开发', '0', '0', '2020-07-19 10:40:52', '2020-07-19 10:40:52');
INSERT INTO `edu_subject` VALUES ('1284679567962787842', 'Java', '1284679567933427713', '0', '2020-07-19 10:40:52', '2020-07-19 10:40:52');
INSERT INTO `edu_subject` VALUES ('1284679568000536577', 'Python', '1284679567933427713', '0', '2020-07-19 10:40:52', '2020-07-19 10:40:52');
INSERT INTO `edu_subject` VALUES ('1284682446014500865', '前端开发', '0', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446039666689', 'HTML/CSS', '1284682446014500865', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446064832513', 'JavaScript', '1284682446014500865', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446081609730', '云计算', '0', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446098386946', 'Docker', '1284682446081609730', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446127747073', 'k8s', '1284682446081609730', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446144524290', '系统/运维', '0', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446157107201', 'Linux', '1284682446144524290', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446182273026', 'Windows', '1284682446144524290', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446199050241', '数据库', '0', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446211633154', 'MySQL', '1284682446199050241', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446236798977', 'MongoDB', '1284682446199050241', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446253576193', '大数据', '0', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446270353409', 'Hadoop', '1284682446253576193', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446295519233', 'Spark', '1284682446253576193', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446308102145', '人工智能', '0', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');
INSERT INTO `edu_subject` VALUES ('1284682446324879361', 'Python', '1284682446308102145', '0', '2020-07-19 10:52:18', '2020-07-19 10:52:18');

-- ----------------------------
-- Table structure for edu_teacher
-- ----------------------------
DROP TABLE IF EXISTS `edu_teacher`;
CREATE TABLE `edu_teacher` (
  `id` char(19) NOT NULL COMMENT '讲师ID',
  `name` varchar(20) NOT NULL COMMENT '讲师姓名',
  `intro` varchar(500) NOT NULL DEFAULT '' COMMENT '讲师简介',
  `career` varchar(500) DEFAULT NULL COMMENT '讲师资历,一句话说明讲师',
  `level` int(10) unsigned NOT NULL COMMENT '头衔 1高级讲师 2首席讲师',
  `avatar` varchar(255) DEFAULT NULL COMMENT '讲师头像',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `join_date` date DEFAULT NULL COMMENT '入驻时间',
  `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='讲师';

-- ----------------------------
-- Records of edu_teacher
-- ----------------------------
INSERT INTO `edu_teacher` VALUES ('1', '刘德华', '毕业于师范大学数学系，热爱教育事业，执教数学思维6年有余', '具备深厚的数学思维功底、丰富的小学教育经验，授课风格生动活泼，擅长用形象生动的比喻帮助理解、简单易懂的语言讲解难题，深受学生喜欢', '2', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '10', '2019-10-29', '0', '2018-03-30 17:15:57', '2019-04-28 05:02:18');
INSERT INTO `edu_teacher` VALUES ('10', '唐嫣', '北京师范大学法学院副教授', '北京师范大学法学院副教授、清华大学法学博士。自2004年至今已有9年的司法考试培训经验。长期从事司法考试辅导，深知命题规律，了解解题技巧。内容把握准确，授课重点明确，层次分明，调理清晰，将法条法理与案例有机融合，强调综合，深入浅出。', '1', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '20', '2019-10-29', '0', '2018-04-03 14:32:19', '2019-02-22 02:01:26');
INSERT INTO `edu_teacher` VALUES ('12', '林次月', '安阳工学院毕业', '本科', '2', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '1', '2020-07-09', '0', '2020-07-19 15:15:18', '2020-07-19 15:15:18');
INSERT INTO `edu_teacher` VALUES ('3', '钟汉良', '钟汉良钟汉良钟汉良钟汉良', '中教一级职称。讲课极具亲和力。', '1', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '2', '2019-10-29', '0', '2018-03-31 09:20:46', '2019-02-22 02:01:27');
INSERT INTO `edu_teacher` VALUES ('4', '周杰伦', '长期从事考研政治课讲授和考研命题趋势与应试对策研究。考研辅导新锐派的代表。', '政治学博士、管理学博士后，北京师范大学马克思主义学院副教授。多年来总结出了一套行之有效的应试技巧与答题方法，针对性和实用性极强，能帮助考生在轻松中应考，在激励的竞争中取得高分，脱颖而出。', '1', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '1', '2019-10-27', '0', '2018-04-03 14:13:51', '2020-07-16 14:44:24');
INSERT INTO `edu_teacher` VALUES ('5', '陈伟霆', '人大附中2009届毕业生', '北京大学数学科学学院2008级本科生，2012年第八届学生五四奖章获得者，在数学领域取得多项国际国内奖项，学术研究成绩突出。曾被两次评为北京大学三好学生、一次评为北京大学三好标兵，获得过北京大学国家奖学金、北京大学廖凯原奖学金、北京大学星光国际一等奖学金、北京大学明德新生奖学金等。', '1', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '1', '2019-10-29', '0', '2018-04-03 14:15:36', '2019-02-22 02:01:29');
INSERT INTO `edu_teacher` VALUES ('6', '姚晨', '华东师范大学数学系硕士生导师，中国数学奥林匹克高级教练', '曾参与北京市及全国多项数学活动的命题和组织工作，多次带领北京队参加高中、初中、小学的各项数学竞赛，均取得优异成绩。教学活而新，能够调动学生的学习兴趣并擅长对学生进行思维点拨，对学生学习习惯的养成和非智力因素培养有独到之处，是一位深受学生喜爱的老师。', '1', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '1', '2019-10-29', '0', '2018-04-01 14:19:28', '2019-02-22 02:01:29');
INSERT INTO `edu_teacher` VALUES ('7', '胡歌', '考研政治辅导实战派专家，全国考研政治命题研究组核心成员。', '法学博士，北京师范大学马克思主义学院副教授，专攻毛泽东思想概论、邓小平理论，长期从事考研辅导。出版著作两部，发表学术论文30余篇，主持国家社会科学基金项目和教育部重大课题子课题各一项，参与中央实施马克思主义理论研究和建设工程项目。', '2', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '8', '2019-09-04', '0', '2018-04-03 14:21:03', '2019-02-22 02:01:30');
INSERT INTO `edu_teacher` VALUES ('8', '谢娜', '资深课程设计专家，专注10年AACTP美国培训协会认证导师', '十年课程研发和培训咨询经验，曾任国企人力资源经理、大型外企培训经理，负责企业大学和培训体系搭建；曾任专业培训机构高级顾问、研发部总监，为包括广东移动、东莞移动、深圳移动、南方电网、工商银行、农业银行、民生银行、邮储银行、TCL集团、清华大学继续教育学院、中天路桥、广西扬翔股份等超过200家企业提供过培训与咨询服务，并担任近50个大型项目的总负责人。', '1', 'https://lcy-edu.oss-cn-beijing.aliyuncs.com/cover/2020-07-20/80afd9b9-8672-45d8-bb65-460d9429169b.jpg', '10', '2019-10-29', '0', '2018-04-03 14:23:33', '2019-11-23 08:38:09');

-- ----------------------------
-- Table structure for edu_video
-- ----------------------------
DROP TABLE IF EXISTS `edu_video`;
CREATE TABLE `edu_video` (
  `id` char(19) NOT NULL COMMENT '视频ID',
  `course_id` char(19) NOT NULL COMMENT '课程ID',
  `chapter_id` char(19) NOT NULL COMMENT '章节ID',
  `title` varchar(50) NOT NULL COMMENT '节点名称',
  `video_source_id` varchar(100) DEFAULT NULL COMMENT '云端视频资源',
  `video_original_name` varchar(100) DEFAULT NULL COMMENT '原始文件名称',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
  `play_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '播放次数',
  `is_free` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否可以试听：0收费 1免费',
  `duration` float NOT NULL DEFAULT '0' COMMENT '视频时长（秒）',
  `status` varchar(20) NOT NULL DEFAULT 'Empty' COMMENT '状态',
  `size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '视频源文件大小（字节）',
  `version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_course_id` (`course_id`),
  KEY `idx_chapter_id` (`chapter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程视频';

-- ----------------------------
-- Records of edu_video
-- ----------------------------
INSERT INTO `edu_video` VALUES ('1287329112085372930', '1287328558642765825', '1287328980484890625', '章节1的课时1', '7659098997f54a35add63e6483080a1c', '1.mp4', '1', '0', '0', '0', 'Empty', '0', '1', '2020-07-26 18:09:12', '2020-07-26 18:09:12');
INSERT INTO `edu_video` VALUES ('1287329264120504322', '1287328558642765825', '1287328980484890625', '章节1的课时2', 'bcecabf2cd4046ce840fce29d426fcb1', '2.mp4', '2', '0', '0', '0', 'Empty', '0', '1', '2020-07-26 18:09:49', '2020-07-26 18:09:49');