江湖数字化平台
登录

数据结构

12120

表总览

通用表

业务表

_ui

  • ui 施工方案
  1. CREATE TABLE `_ui` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  4.   `uiActionType` varchar(255) DEFAULT NULL COMMENT 'ui 动作类型，如：fetchData, postData, changeUi',
  5.   `uiActionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  6.   `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  7.   `uiActionConfig` text COMMENT 'ui 动作数据',
  8.   `appDataSchema` text COMMENT 'ui 校验数据',
  9.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  10.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  11.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  12.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  13.   PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = 'ui 施工方案'

article

  1. CREATE TABLE `article` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `articleId` bigint(20) DEFAULT NULL COMMENT '文章id, 10000 ++',
  4.   `categoryId` varchar(255) DEFAULT NULL,
  5.   `categoryName` varchar(255) DEFAULT NULL,
  6.   `articleCategoryId` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '分类id',
  7.   `courseId` varchar(255) DEFAULT NULL COMMENT '课程id',
  8.   `courseBatchId` varchar(255) DEFAULT NULL,
  9.   `articleGroupName` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '文章所属分组名',
  10.   `articleTagList` text CHARACTER SET utf8mb4 COMMENT '标签; 用, 拼接',
  11.   `articlePublishStatus` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '文章类型(状态)：public, login, draft, deleted',
  12.   `articlePublishTime` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '文章发布时间',
  13.   `articleTitle` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '标题',
  14.   `articleShortName` varchar(255) DEFAULT NULL COMMENT '标题简称',
  15.   `articleConfig` text COMMENT '课件配置：是否考试、时长等',
  16.   `articleCoverImage` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '封面',
  17.   `articleContent` longtext CHARACTER SET utf8mb4 COMMENT '内容; 文章内容、考试题目/答案、作业题目/答案、新闻内容',
  18.   `articleContentForSeo` longtext CHARACTER SET utf8mb4 COMMENT 'HTML 用于渲染',
  19.   `articleType` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '文章分类：article=文章/exam=考试/assignment=作业/material=资料/news=新闻',
  20.   `articleAudioUrl` varchar(1023) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '默认音频URL唯一的',
  21.   `articleVideoUrl` varchar(1023) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '默认视频URL',
  22.   `articleCreateTime` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '创建时间',
  23.   `articleCreateUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '创建者用户ID',
  24.   `articleCreateUsername` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '创建者用户名',
  25.   `articleUpdateTime` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '更新时间',
  26.   `articleUpdateUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '更新者用户ID',
  27.   `articleUpdateUsername` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '更新者用户名',
  28.   `articlePrice` int(11) DEFAULT '0' COMMENT '价格;',
  29.   `visitCount` int(11) DEFAULT '0' COMMENT '访问量',
  30.   `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  31.   `operationByUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '操作者userId',
  32.   `operationByUser` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '操作者用户名',
  33.   `operationAt` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  34.   `auditStatus` varchar(255) DEFAULT 'pending' COMMENT '审核状态; pending=未审核,approve=审核通过,reject=审核不通过',
  35.   `auditByUserId` varchar(255) DEFAULT '' COMMENT '审核人userId;',
  36.   `auditComment` varchar(255) DEFAULT '' COMMENT '审核意见;',
  37.   `auditAt` varchar(255) DEFAULT '' COMMENT '审核时间;',
  38.   `ownerUserId` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '所有者userId',
  39.   `ownerUserName` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '所有者',
  40.   PRIMARY KEY (`id`) USING BTREE,
  41.   UNIQUE KEY `article_unique` (`articleId`) USING BTREE,
  42.   KEY `categoryId_index` (`articleCategoryId`) USING BTREE,
  43.   KEY `articlePublishTime` (`articlePublishTime`) USING BTREE
  44. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8

article_history

  1. CREATE TABLE `article_history` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `articleId` bigint(20) DEFAULT NULL COMMENT '文章id, 10000 ++',
  4.   `categoryId` varchar(255) DEFAULT NULL COMMENT '分类ID',
  5.   `categoryName` varchar(255) DEFAULT NULL COMMENT '分类名称',
  6.   `articleCategoryId` varchar(255) DEFAULT NULL,
  7.   `courseId` varchar(255) DEFAULT NULL COMMENT '课程id',
  8.   `courseBatchId` varchar(255) DEFAULT NULL COMMENT '课程id',
  9.   `articleGroupName` varchar(255) DEFAULT NULL COMMENT '文章所属分组名',
  10.   `articleTagList` varchar(255) DEFAULT NULL COMMENT '标签; 用, 拼接',
  11.   `articlePublishStatus` varchar(255) DEFAULT 'login' COMMENT '文章类型(状态)：public, login, draft, deleted',
  12.   `articlePublishTime` varchar(255) DEFAULT NULL COMMENT '文章发布时间',
  13.   `articleApproveStatus` varchar(255) DEFAULT NULL,
  14.   `articleTitle` varchar(255) DEFAULT NULL COMMENT '标题',
  15.   `articleShortName` varchar(255) DEFAULT NULL COMMENT '标题简称',
  16.   `articleConfig` text,
  17.   `articleCoverImage` varchar(255) DEFAULT NULL COMMENT '封面',
  18.   `articleContent` longtext COMMENT '编辑的内容',
  19.   `articleContentForSeo` longtext COMMENT 'HTML 用于渲染',
  20.   `articleAssignment` text COMMENT '文章作业 [{ }]',
  21.   `articleAssignmentWithAnswer` text COMMENT '文章作业答案 [{ }]',
  22.   `articleAudioUrl` varchar(255) DEFAULT NULL COMMENT '默认音频URL唯一的',
  23.   `articleVideoUrl` varchar(255) DEFAULT NULL COMMENT '默认视频URL',
  24.   `articleCreateTime` varchar(255) DEFAULT NULL COMMENT '创建时间',
  25.   `articleCreateUserId` varchar(255) DEFAULT NULL COMMENT '创建者用户ID',
  26.   `articleCreateUsername` varchar(255) DEFAULT NULL COMMENT '创建者用户名',
  27.   `articleUpdateTime` varchar(255) DEFAULT NULL COMMENT '更新时间',
  28.   `articleUpdateUserId` varchar(255) DEFAULT NULL COMMENT '更新者用户ID',
  29.   `articlePrice` int(11) DEFAULT NULL COMMENT '文章价格',
  30.   `articleType` varchar(255) DEFAULT NULL COMMENT '文章类型',
  31.   `articleUpdateUsername` varchar(255) DEFAULT NULL COMMENT '更新者用户名',
  32.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  33.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  34.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  35.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  36.   `articleAssignmentPublishStatus` varchar(255) DEFAULT NULL COMMENT '文章作业发布状态; publish;',
  37.   `ownerUserId` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '所有者userId',
  38.   `ownerUserName` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '所有者',
  39.   PRIMARY KEY (`id`) USING BTREE
  40. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4

article_student_response

  • 学生文章回复表
  1. CREATE TABLE `article_student_response` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `responseId` varchar(30) DEFAULT NULL COMMENT '回答ID',
  4.   `courseId` varchar(30) DEFAULT NULL COMMENT '课程ID',
  5.   `classId` varchar(50) DEFAULT NULL COMMENT '班级ID',
  6.   `articleTitle` varchar(255) DEFAULT NULL COMMENT '标题',
  7.   `articleId` varchar(30) DEFAULT NULL COMMENT '文章ID',
  8.   `articleType` varchar(255) DEFAULT NULL COMMENT '文章分类：article=文章/exam=考试/assignment=作业/news=新闻',
  9.   `userId` varchar(50) DEFAULT NULL COMMENT '用户ID',
  10.   `fullMark` int(11) DEFAULT NULL COMMENT '满分数',
  11.   `totalMark` int(11) DEFAULT NULL COMMENT '实际分数',
  12.   `responseNote` varchar(255) DEFAULT NULL COMMENT '备注',
  13.   `responseSubmitStatus` varchar(255) DEFAULT NULL COMMENT '提交状态; publish',
  14.   `responseSubmitAt` varchar(255) DEFAULT NULL COMMENT '提交时间',
  15.   `responseContent` text COMMENT '用户提交内容+标准答案',
  16.   `responseRetryNumber` int(11) DEFAULT NULL COMMENT '重新回复的次数',
  17.   `teacherId` varchar(255) DEFAULT NULL COMMENT '批改老师ID',
  18.   `teacherReview` text COMMENT '批改老师评语',
  19.   `teacherReviewStatus` varchar(255) DEFAULT '' COMMENT '批改状态; publish',
  20.   `teacherReviewAt` varchar(255) DEFAULT NULL COMMENT '批改时间',
  21.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  22.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者用户ID; userId',
  23.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者;',
  24.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  25.   `responsePercent` int(3) DEFAULT '0' COMMENT '回答进度百分比;',
  26.   PRIMARY KEY (`id`) USING BTREE
  27. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '学生文章回复表'

attendance

  1. CREATE TABLE `attendance` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `classId` varchar(255)  DEFAULT NULL,
  4.   `courseId` varchar(255)  DEFAULT NULL,
  5.   `userId` varchar(255)  DEFAULT NULL COMMENT '学生用户id;',
  6.   `lessonNumber` int(11) DEFAULT NULL COMMENT '第几课;',
  7.   `attendanceDate` varchar(255)  DEFAULT NULL COMMENT '出勤时间;',
  8.   `attendance` varchar(255)  DEFAULT NULL COMMENT '出勤类型;出勤,缺勤,迟到,早退',
  9.   `articleId` varchar(255)  DEFAULT NULL COMMENT '文章ID',
  10.   `articleTitle` varchar(255)  DEFAULT NULL COMMENT '文章题目',
  11.   `markedAt` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  12.   `markedByUser` varchar(255)  DEFAULT NULL COMMENT '创建人',
  13.   `markedByUserId` varchar(255)  DEFAULT NULL COMMENT '创建人Id;',
  14.   `remarks` varchar(255)  DEFAULT NULL COMMENT '备注；缺勤情况说明',
  15.   `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT '',
  16.   `operationAt` varchar(255) CHARACTER SET utf8mb4 DEFAULT '',
  17.   `operationByUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '',
  18.   `operationByUser` varchar(255) CHARACTER SET utf8mb4 DEFAULT '',
  19.   `courseBatchId` varchar(255)  DEFAULT NULL,
  20.   PRIMARY KEY (`id`) USING BTREE,
  21.   KEY `id` (`id`) USING BTREE,
  22.   KEY `classId` (`classId`) USING BTREE,
  23.   KEY `studentId` (`userId`) USING BTREE
  24. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

course

  • 课程
  1. CREATE TABLE `course` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `courseId` varchar(255) DEFAULT NULL COMMENT '课程id;',
  4.   `categoryId` varchar(255) DEFAULT NULL COMMENT '课程分类id;',
  5.   `courseTitle` varchar(255) DEFAULT '' COMMENT '标题;',
  6.   `courseType` varchar(255) DEFAULT '6' COMMENT '课程类型;article=图文专题；audio=音频专题；video=视频专题；live=直播专题；column=专栏；other=其他专题',
  7.   `courseContent` longtext COMMENT '内容;',
  8.   `courseImage` varchar(255) DEFAULT '' COMMENT '封面图;',
  9.   `courseTag` varchar(1000) DEFAULT '' COMMENT '标签;',
  10.   `coursePrice` decimal(8, 2) DEFAULT NULL COMMENT '金额;',
  11.   `banner` varchar(2000) DEFAULT '' COMMENT 'banner图;',
  12.   `posterImage` varchar(255) DEFAULT '' COMMENT '海报;',
  13.   `serviceCode` varchar(255) DEFAULT '' COMMENT '客服二维码;',
  14.   `freeAritleIdList` varchar(255) DEFAULT NULL COMMENT '免费文章id列表;',
  15.   `isDel` varchar(255) DEFAULT 'false' COMMENT '是否删除;',
  16.   `isFree` varchar(255) DEFAULT 'true' COMMENT '是否免费;',
  17.   `freeMemberPrivilegeLevel` varchar(255) DEFAULT NULL COMMENT '免费最低会员等级;',
  18.   `sort` int(11) DEFAULT '0' COMMENT '排序;',
  19.   `sales` varchar(255) DEFAULT '0' COMMENT '实际销量;',
  20.   `userCount` int(11) DEFAULT '0' COMMENT '用户人数;',
  21.   `operation` varchar(255) DEFAULT '' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  22.   `operationByUserId` varchar(255) DEFAULT '' COMMENT '操作者userId',
  23.   `operationByUser` varchar(255) DEFAULT '' COMMENT '操作者用户名',
  24.   `operationAt` varchar(255) DEFAULT '' COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  25.   `auditStatus` varchar(255) DEFAULT 'pending' COMMENT '审核状态',
  26.   `auditByUserId` varchar(255) DEFAULT '' COMMENT '审核人userId;',
  27.   `auditComment` varchar(255) DEFAULT '' COMMENT '审核意见;',
  28.   `auditAt` varchar(255) DEFAULT '' COMMENT '审核时间;',
  29.   `ownerUserId` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '所有者userId',
  30.   `ownerUserName` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '所有者',
  31.   `helperUserIdList` varchar(255) DEFAULT NULL COMMENT '助手用户ID列表;',
  32.   `helperUserNameList` varchar(255) DEFAULT NULL COMMENT '助手用户名列表;',
  33.   PRIMARY KEY (`id`) USING BTREE
  34. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COMMENT = '课程'

course_article

  • 课程文章表
  1. CREATE TABLE `course_article` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `courseId` varchar(255) DEFAULT NULL COMMENT '课程id;',
  4.   `articleId` varchar(255) DEFAULT NULL COMMENT '文章id;',
  5.   `albumId` varchar(255) DEFAULT NULL COMMENT '教材id;',
  6.   `lessonNumber` int(11) DEFAULT NULL COMMENT '课时编号;',
  7.   `albumTitle` varchar(255) DEFAULT NULL COMMENT '教材标题;',
  8.   `articleType` varchar(255) DEFAULT NULL COMMENT '文章分类：article=文章/exam=考试/assignment=作业/news=新闻',
  9.   `articleTagList` text COMMENT '标签; 用, 拼接',
  10.   `articlePublishStatus` varchar(255) DEFAULT '' COMMENT '文章类型(状态);public, login, draft, deleted',
  11.   `articlePublishTime` varchar(255) DEFAULT NULL COMMENT '文章发布时间;',
  12.   `articleTitle` varchar(255) DEFAULT NULL COMMENT '标题;',
  13.   `articleDesignStatus` varchar(255) DEFAULT 'firstDraft' COMMENT '稿件状态;firstDraft | secondDraft | thirdDraft',
  14.   `articleCoverImage` varchar(255) DEFAULT NULL COMMENT '封面;',
  15.   `isFree` varchar(255) DEFAULT 'true' COMMENT '是否免费; true=是,false=否',
  16.   `price` int(11) DEFAULT NULL COMMENT '价格;',
  17.   `visitCount` int(11) DEFAULT '0' COMMENT '访问量; 资料的下载量',
  18.   `questionCount` int(11) DEFAULT '0' COMMENT '题目数量;',
  19.   `responseCount` int(11) DEFAULT '0' COMMENT '回复量;',
  20.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  21.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者用户ID; userId',
  22.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者;',
  23.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  24.   PRIMARY KEY (`id`) USING BTREE
  25. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '课程文章表'

course_category

  • 课程分类列表
  1. CREATE TABLE `course_category` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `categoryId` varchar(255) NOT NULL COMMENT '分类id;',
  4.   `categoryName` varchar(255) NOT NULL DEFAULT '' COMMENT '分类名称;',
  5.   `icon` varchar(255) DEFAULT '' COMMENT '分类图标;',
  6.   `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序;',
  7.   `isShown` varchar(255) DEFAULT 'true' COMMENT '是否显示;true=显示, false=隐藏',
  8.   `isDel` varchar(255) DEFAULT 'false' COMMENT '是否删除;false未删除, true已删除',
  9.   `operation` varchar(255) DEFAULT '' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  10.   `operationByUserId` varchar(255) DEFAULT '' COMMENT '操作者userId',
  11.   `operationByUser` varchar(255) DEFAULT '' COMMENT '操作者用户名',
  12.   `operationAt` varchar(255) DEFAULT '' COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  13.   PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB AUTO_INCREMENT = 129 DEFAULT CHARSET = utf8mb4 COMMENT = '课程分类列表'

course_gift

  • 课程赠送表
  1. CREATE TABLE `course_gift` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `giftId` varchar(255) NOT NULL DEFAULT '0' COMMENT '赠送ID，git_随机数',
  4.   `courseId` varchar(255) NOT NULL DEFAULT '' COMMENT '课程ID',
  5.   `courseName` varchar(255) DEFAULT NULL COMMENT '课程名称',
  6.   `courseImage` varchar(255) DEFAULT NULL COMMENT '封面图;',
  7.   `coursePrice` decimal(8, 2) DEFAULT NULL COMMENT '金额;',
  8.   `userId` varchar(255) NOT NULL DEFAULT '' COMMENT '用户ID',
  9.   `userName` varchar(255) DEFAULT '0' COMMENT '用户名',
  10.   `userAvatar` varchar(255) DEFAULT NULL COMMENT '用户头像',
  11.   `receiveUserId` varchar(255) DEFAULT '' COMMENT '领取人ID',
  12.   `receiveUserName` varchar(255) DEFAULT '' COMMENT '领取人',
  13.   `receiveTime` varchar(255) DEFAULT '' COMMENT '领取时间',
  14.   `receiveStatus` varchar(255) NOT NULL DEFAULT 'waitReceive' COMMENT '领取状态; waitReceive=未领取; received=已领取;',
  15.   `operation` varchar(255) CHARACTER SET utf8mb4  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  16.   `operationByUserId` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作者userId',
  17.   `operationByUser` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作者用户名',
  18.   `operationAt` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  19.   PRIMARY KEY (`id`) USING BTREE
  20. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '课程赠送表'

course_user

  • 课程用户表
  1. CREATE TABLE `course_user` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `courseId` varchar(255) NOT NULL DEFAULT '' COMMENT '课程id; ',
  4.   `courseTitle` varchar(255) DEFAULT '' COMMENT '标题;',
  5.   `courseType` varchar(255) DEFAULT 'article' COMMENT '课程类型; article=图文,audio=音频,video=视频课程,live=直播课程,column=专栏,other=其他课程',
  6.   `courseTag` varchar(1000) DEFAULT '' COMMENT '标签;',
  7.   `courseImage` varchar(255) DEFAULT '' COMMENT '封面图;',
  8.   `userId` varchar(255) NOT NULL DEFAULT '' COMMENT '用户id; ',
  9.   `userName` varchar(255) DEFAULT '' COMMENT '用户名; ',
  10.   `userAvatar` varchar(255) DEFAULT '' COMMENT '用户头像; ',
  11.   `classId` varchar(255) DEFAULT NULL COMMENT '分配班级id; ',
  12.   `orderId` varchar(255) DEFAULT NULL COMMENT '订单ID',
  13.   `isDel` varchar(255) NOT NULL DEFAULT 'false' COMMENT '是否删除; true=已删除,false=未删除',
  14.   `isPay` varchar(255) DEFAULT NULL COMMENT '是否付费',
  15.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  16.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  17.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  18.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  19.   PRIMARY KEY (`id`) USING BTREE
  20. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '课程用户表'

home_recommend

  • 首页推荐
  1. CREATE TABLE `home_recommend` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `title` varchar(255) DEFAULT '' COMMENT '标题;',
  4.   `type` varchar(255) DEFAULT '' COMMENT '类型; banner=轮播图,navIcon=跳转图标,news=新闻,activity=活动,ad=广告,live=直播,course=课程,link=自定义跳转,goods=商品,hotLive=热门直播,teacher=讲师,groupBooking=拼团,menu=菜单,material=素材',
  5.   `link` varchar(255) DEFAULT '' COMMENT '自定义跳转路径;',
  6.   `icon` varchar(255) DEFAULT '' COMMENT '图标;',
  7.   `image` varchar(255) DEFAULT '' COMMENT '封面图;',
  8.   `contentList` text COMMENT '内容列表JSON;',
  9.   `contentListOfDemo` text COMMENT '内容列表JSON（示例）;',
  10.   `contentDisplay` varchar(255) DEFAULT '' COMMENT '内容显示类型; big=大图,grid=宫图,small=小图,img=纯图,fixed=固定',
  11.   `sort` int(11) DEFAULT '0' COMMENT '排序;',
  12.   `isShown` varchar(255) DEFAULT 'true' COMMENT '是否显示; true=是,false=否',
  13.   `isBuildin` varchar(255) DEFAULT 'false' COMMENT '是否内置; true=是,false=否',
  14.   `operation` varchar(255) NOT NULL DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  15.   `rowStatus` varchar(255) DEFAULT 'true' COMMENT '数据状态：true==正常，false==回收站',
  16.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  17.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  18.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  19.   PRIMARY KEY (`id`, `operation`) USING BTREE
  20. ) ENGINE = InnoDB AUTO_INCREMENT = 19 DEFAULT CHARSET = utf8mb4 COMMENT = '首页推荐'

order

  • 订单表
  1. CREATE TABLE `order` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `orderId` varchar(255) NOT NULL DEFAULT '' COMMENT '订单号;',
  4.   `orderType` varchar(255) NOT NULL DEFAULT 'course' COMMENT '订单类别; course=课程订单,product=商品订单,exam=考试订单,material=资料,member=会员订单',
  5.   `orderStatus` varchar(255) NOT NULL DEFAULT 'waitpay' COMMENT '订单状态; waitpay=待支付,paid=已支付,waitSend=待发货,waitReceive=待收货,waitComment=待评价,commented=已评价,refunded=已退款,cancel=已取消',
  6.   `userName` varchar(255) NOT NULL DEFAULT '' COMMENT '用户姓名',
  7.   `userId` varchar(255) NOT NULL DEFAULT '' COMMENT '用户id',
  8.   `userPhone` varchar(255) NOT NULL DEFAULT '' COMMENT '用户电话',
  9.   `userAddress` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  10.   `courseId` varchar(255) DEFAULT NULL COMMENT '购买课程ID',
  11.   `memberId` varchar(255) DEFAULT NULL COMMENT '购买会员类型ID',
  12.   `articleId` varchar(255) DEFAULT NULL COMMENT '购买的文章id;考试和资料',
  13.   `productId` varchar(255) DEFAULT NULL COMMENT '商品id;',
  14.   `totalNum` int(11) NOT NULL DEFAULT '1' COMMENT '订单商品总数;',
  15.   `totalPrice` decimal(14, 2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单总价;',
  16.   `totalPostage` decimal(14, 2) unsigned NOT NULL DEFAULT '0.00' COMMENT '邮费;',
  17.   `payPrice` decimal(14, 2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际支付金额;',
  18.   `payPostage` decimal(14, 2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付邮费',
  19.   `payType` varchar(255) NOT NULL DEFAULT 'wechat' COMMENT '支付方式; wechat=微信支付; alipay=支付宝; offline=线下支付',
  20.   `payTradeNo` varchar(255) NOT NULL DEFAULT '' COMMENT '微信/支付宝交易订单号',
  21.   `payTime` varchar(255) DEFAULT NULL COMMENT '支付时间;',
  22.   `merchantId` varchar(255) DEFAULT NULL COMMENT '支付商户ID',
  23.   `payStatus` varchar(255) NOT NULL DEFAULT 'unpaid' COMMENT '支付状态; unpaid=未支付; paid=已支付; refunding=退款中; refunded=已退款;cancel=取消;received=已收货',
  24.   `deductionPrice` decimal(14, 2) unsigned NOT NULL DEFAULT '0.00' COMMENT '抵扣金额',
  25.   `couponId` varchar(255) DEFAULT NULL COMMENT '优惠券id',
  26.   `couponPrice` decimal(14, 2) unsigned DEFAULT '0.00' COMMENT '优惠券金额',
  27.   `deliveryName` varchar(255) DEFAULT NULL COMMENT '快递公司',
  28.   `deliveryType` varchar(255) DEFAULT NULL COMMENT '物流类型',
  29.   `deliveryNumber` varchar(64) DEFAULT NULL COMMENT '快递单号',
  30.   `refundStatus` varchar(255) NOT NULL DEFAULT 'unrefund' COMMENT '退款状态： unrefund=未退款,applying=申请中,refunded=已退款',
  31.   `refundReason` varchar(255) DEFAULT NULL COMMENT '退款原因',
  32.   `refundReasonPicList` text COMMENT '退款原因图片列表',
  33.   `refundRejectReason` varchar(255) DEFAULT NULL COMMENT '退款拒绝原因;',
  34.   `refundApplyTime` varchar(255) DEFAULT NULL COMMENT '退款申请时间',
  35.   `refundTime` varchar(255) DEFAULT NULL COMMENT '退款时间',
  36.   `refundPrice` decimal(14, 2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退款金额',
  37.   `mark` varchar(512) DEFAULT NULL COMMENT '备注',
  38.   `isDel` varchar(255) NOT NULL DEFAULT 'false' COMMENT '是否删除; true=已删除; false=未删除;',
  39.   `isGift` varchar(255) NOT NULL DEFAULT 'false' COMMENT '是否赠送订单;',
  40.   `remark` varchar(512) DEFAULT NULL COMMENT '管理员备注',
  41.   `spreadUserId` varchar(255) DEFAULT NULL COMMENT '推广人id',
  42.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  43.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  44.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  45.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  46.   PRIMARY KEY (`id`) USING BTREE,
  47.   UNIQUE KEY `orderId` (`orderId`) USING BTREE,
  48.   KEY `userId` (`userId`) USING BTREE,
  49.   KEY `orderType` (`orderType`) USING BTREE,
  50.   KEY `orderStatus` (`orderStatus`) USING BTREE
  51. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COMMENT = '订单表'

store_category

  • 商品分类表
  1. CREATE TABLE `store_category` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  3.   `categoryId` varchar(255) NOT NULL DEFAULT '' COMMENT '分类ID;',
  4.   `categoryName` varchar(255) NOT NULL DEFAULT '' COMMENT '分类名称;',
  5.   `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序;',
  6.   `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '图标;',
  7.   `isDel` varchar(255) NOT NULL DEFAULT 'false' COMMENT '是否删除; false=未删除，true=已删除',
  8.   `isShown` varchar(255) NOT NULL DEFAULT 'false' COMMENT '是否推荐; false=未推荐，true=已推荐',
  9.   `operation` varchar(255) DEFAULT NULL,
  10.   `operationByUserId` varchar(255) DEFAULT NULL,
  11.   `operationByUser` varchar(255) DEFAULT NULL,
  12.   `operationAt` varchar(255) DEFAULT NULL,
  13.   PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COMMENT = '商品分类表'

store_product

  • 商品表
  1. CREATE TABLE `store_product` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  3.   `productId` varchar(255) NOT NULL DEFAULT '' COMMENT '商品ID;',
  4.   `productName` varchar(255) NOT NULL DEFAULT '' COMMENT '商品名称;',
  5.   `productDesc` varchar(255) DEFAULT '' COMMENT '商品简介;',
  6.   `productImage` varchar(255) DEFAULT '' COMMENT '商品图片;',
  7.   `banner` varchar(255) DEFAULT '' COMMENT '轮播图;',
  8.   `keyword` varchar(255) DEFAULT '' COMMENT '关键字;',
  9.   `categoryId` varchar(255) DEFAULT '' COMMENT '分类id;',
  10.   `price` decimal(14, 2) unsigned DEFAULT NULL COMMENT '商品价格;',
  11.   `marketPrice` decimal(14, 2) unsigned DEFAULT NULL COMMENT '市场价（划线价格）;',
  12.   `unitName` varchar(255) DEFAULT '' COMMENT '单位名;',
  13.   `sort` int(11) DEFAULT '0' COMMENT '排序;',
  14.   `sales` int(11) unsigned DEFAULT '0' COMMENT '销量;',
  15.   `salesVitual` int(11) DEFAULT '0' COMMENT '虚拟销量;',
  16.   `stock` int(11) unsigned DEFAULT '0' COMMENT '库存;',
  17.   `isRecommend` varchar(255) DEFAULT 'false' COMMENT '是否推荐; false=未推荐，true=已推荐',
  18.   `isShown` varchar(255) DEFAULT 'false' COMMENT '状态; false=未上架，true=已上架;',
  19.   `isDel` varchar(255) DEFAULT 'false' COMMENT '是否删除; false=未删除，true=已删除',
  20.   `cost` decimal(14, 2) unsigned DEFAULT NULL COMMENT '成本价',
  21.   `browse` int(11) DEFAULT '0' COMMENT '浏览量;',
  22.   `productContent` text COMMENT '商品详情;',
  23.   `operation` varchar(255) DEFAULT NULL,
  24.   `operationByUserId` varchar(255) DEFAULT NULL,
  25.   `operationByUser` varchar(255) DEFAULT NULL,
  26.   `operationAt` varchar(255) DEFAULT NULL,
  27.   PRIMARY KEY (`id`) USING BTREE
  28. ) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8 COMMENT = '商品表'

student_learning_record

  1. CREATE TABLE `student_learning_record` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  3.   `courseMemberId` varchar(255)  DEFAULT NULL COMMENT '学习记录编号',
  4.   `courseBatchId` varchar(255)  DEFAULT NULL COMMENT '课程本期ID',
  5.   `courseName` varchar(255)  DEFAULT NULL COMMENT '课程名称',
  6.   `courseId` varchar(255)  DEFAULT NULL COMMENT '所属课程系列',
  7.   `classId` varchar(255)  DEFAULT NULL COMMENT '班级编号',
  8.   `memberId` varchar(255)  DEFAULT NULL COMMENT '员工编号',
  9.   `netName` varchar(255)  DEFAULT NULL COMMENT '名字',
  10.   `loginId` varchar(255)  DEFAULT NULL COMMENT '用户ID',
  11.   `district` varchar(255)  DEFAULT NULL COMMENT '分公司ID',
  12.   `orgId` varchar(255)  DEFAULT NULL COMMENT '行政组织ID',
  13.   `orgName` varchar(255)  DEFAULT NULL COMMENT '行政组织名称',
  14.   `orgFullName` varchar(255)  DEFAULT NULL COMMENT '行政组织全称',
  15.   `roleId` varchar(255)  DEFAULT NULL COMMENT '组织角色ID',
  16.   `stage` varchar(50)  DEFAULT NULL COMMENT '职务阶段',
  17.   `title` varchar(50)  DEFAULT NULL COMMENT '职务',
  18.   `position` varchar(50)  DEFAULT NULL COMMENT '职务',
  19.   `memberRole` varchar(50)  DEFAULT NULL COMMENT '学员在课程的职分',
  20.   `result` varchar(50)  DEFAULT NULL COMMENT '毕业成绩',
  21.   `note` text  COMMENT '备注',
  22.   `comment` text  COMMENT '阶段评语',
  23.   `teacherRecommendation` varchar(255)  DEFAULT NULL COMMENT '建议：毕业、不及格',
  24.   `courseCreditEarned` varchar(50)  DEFAULT NULL COMMENT '所得学分',
  25.   `examScoreStat` varchar(255)  DEFAULT NULL COMMENT '平时成绩统计',
  26.   `examScoreDetail` text  COMMENT '每课成绩详情',
  27.   `overallComment` varchar(1023)  DEFAULT NULL COMMENT '整体评语',
  28.   `commentDetail` text  COMMENT '评语详情',
  29.   `attendanceStat` varchar(1023)  DEFAULT NULL COMMENT '出勤统计',
  30.   `attendanceDetail` text  COMMENT '出勤详情',
  31.   `assignmentStat` varchar(1023)  DEFAULT NULL COMMENT '作业统计',
  32.   `assignmentDetail` text  COMMENT '作业详情汇报',
  33.   `noteStat` varchar(1023)  DEFAULT NULL COMMENT '笔记统计',
  34.   `noteDetail` text  COMMENT '笔记详情汇报',
  35.   `totalLearningHour` varchar(255)  DEFAULT NULL COMMENT '总学习时长',
  36.   `memberCourseStatus` varchar(255)  DEFAULT NULL COMMENT '课程学习状态',
  37.   `nominatedByMemberId` varchar(255)  DEFAULT NULL COMMENT '推荐人员工编号',
  38.   `nominatedByUserId` varchar(255)  DEFAULT NULL COMMENT '推荐人用户名',
  39.   `nominatedByUser` varchar(255)  DEFAULT NULL COMMENT '推荐人',
  40.   `dateStarted` varchar(255)  DEFAULT NULL COMMENT '学习开始时间',
  41.   `dateEnded` varchar(255)  DEFAULT NULL COMMENT '学习结束时间',
  42.   `operation` varchar(255)  DEFAULT NULL COMMENT '操作',
  43.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  44.   `operationByUserId` varchar(50)  DEFAULT NULL COMMENT '操作者userId',
  45.   `operationByUser` varchar(50)  DEFAULT NULL COMMENT '操作者用户名(展示)',
  46.   PRIMARY KEY (`id`) USING BTREE
  47. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

user_address

  • 用户地址表
  1. CREATE TABLE `user_address` (
  2.   `id` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  3.   `addressId` varchar(255) NOT NULL DEFAULT '' COMMENT '用户地址ID;',
  4.   `userId` varchar(255) NOT NULL DEFAULT '0' COMMENT '用户ID;',
  5.   `realName` varchar(255) NOT NULL DEFAULT '' COMMENT '收货人姓名;',
  6.   `phone` varchar(255) NOT NULL DEFAULT '' COMMENT '收货人电话;',
  7.   `province` varchar(255) NOT NULL DEFAULT '' COMMENT '收货人所在省;',
  8.   `city` varchar(255) NOT NULL DEFAULT '' COMMENT '收货人所在市;',
  9.   `district` varchar(255) NOT NULL DEFAULT '' COMMENT '收货人所在区;',
  10.   `detail` varchar(255) NOT NULL DEFAULT '' COMMENT '收货人详细地址;',
  11.   `postCode` varchar(255) DEFAULT '0' COMMENT '邮编;',
  12.   `longitude` varchar(255) DEFAULT '0' COMMENT '经度;',
  13.   `latitude` varchar(255) DEFAULT '0' COMMENT '纬度;',
  14.   `isDefault` varchar(255) NOT NULL DEFAULT 'false' COMMENT '是否默认; false=不是，true=是',
  15.   `operation` varchar(255) CHARACTER SET utf8mb4  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  16.   `operationByUserId` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作者userId',
  17.   `operationByUser` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作者用户名',
  18.   `operationAt` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  19.   `districtCode` varchar(255) DEFAULT NULL COMMENT '地区编码;',
  20.   `cityCode` varchar(255) DEFAULT NULL COMMENT '城市编码;',
  21.   `provinceCode` varchar(255) DEFAULT NULL COMMENT '省份编码;',
  22.   PRIMARY KEY (`id`) USING BTREE
  23. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8 COMMENT = '用户地址表'

user_comment

  • 商品评论表
  1. CREATE TABLE `user_comment` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  3.   `commentId` varchar(255) NOT NULL DEFAULT '' COMMENT '评论ID;',
  4.   `commentType` varchar(255) NOT NULL DEFAULT 'course' COMMENT '评论类型; course=课程, product=商品',
  5.   `courseId` varchar(255) DEFAULT '' COMMENT '课程ID;',
  6.   `courseName` varchar(255) DEFAULT NULL COMMENT '课程名称;',
  7.   `productId` varchar(255) DEFAULT '' COMMENT '商品ID;',
  8.   `productName` varchar(255) DEFAULT NULL COMMENT '商品名称;',
  9.   `userId` varchar(255) NOT NULL DEFAULT '' COMMENT '用户ID;',
  10.   `orderId` varchar(255) NOT NULL DEFAULT '' COMMENT '订单ID;',
  11.   `nickname` varchar(255) DEFAULT NULL COMMENT '用户昵称;',
  12.   `avatar` varchar(255) DEFAULT NULL COMMENT '用户头像;',
  13.   `comment` varchar(255) DEFAULT NULL COMMENT '评论内容;',
  14.   `star` int(11) DEFAULT NULL COMMENT '评分;',
  15.   `pics` varchar(255) DEFAULT NULL COMMENT '评论图片;',
  16.   `replyContent` varchar(255) DEFAULT NULL COMMENT '回复内容;',
  17.   `replyTime` varchar(255) DEFAULT NULL COMMENT '回复时间;',
  18.   `replyUserId` varchar(255) DEFAULT NULL COMMENT '回复人员Id;',
  19.   `replyUserName` varchar(255) DEFAULT NULL COMMENT '回复人员名称;',
  20.   `isReply` varchar(255) DEFAULT NULL COMMENT '是否回复; true=是,false=否',
  21.   `isDel` varchar(255) DEFAULT NULL COMMENT '是否删除; true=是,false=否',
  22.   `isShown` varchar(255) DEFAULT NULL COMMENT '是否显示; true=是,false=否',
  23.   `isVirtual` varchar(255) DEFAULT 'false' COMMENT '是否虚拟评论;',
  24.   `operation` varchar(255) CHARACTER SET utf8mb4  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  25.   `operationByUserId` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作者userId',
  26.   `operationByUser` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作者用户名',
  27.   `operationAt` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  28.   PRIMARY KEY (`id`) USING BTREE
  29. ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = '商品评论表'

user_learing_record

  • 用户学习记录
  1. CREATE TABLE `user_learing_record` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `courseId` varchar(11) DEFAULT NULL COMMENT '课程id',
  4.   `articleId` varchar(11) DEFAULT NULL COMMENT '文章id',
  5.   `learingType` varchar(255) DEFAULT NULL COMMENT '学习记录类型;course,article,exam,assignment',
  6.   `operation` varchar(255) CHARACTER SET utf8mb4  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  7.   `operationByUserId` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作者userId',
  8.   `operationByUser` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作者用户名',
  9.   `operationAt` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  10.   `userId` varchar(255) DEFAULT NULL COMMENT '用户id',
  11.   PRIMARY KEY (`id`) USING BTREE
  12. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COMMENT = '用户学习记录'

user_like

  • 用户点赞收藏
  1. CREATE TABLE `user_like` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `likeType` varchar(255) NOT NULL DEFAULT 'collect' COMMENT '类型; like=点赞, collect=收藏',
  4.   `userId` varchar(255) NOT NULL DEFAULT '0' COMMENT '用户id',
  5.   `articleId` varchar(255) DEFAULT '' COMMENT '文章id',
  6.   `courseId` varchar(255) DEFAULT '0' COMMENT '课程id',
  7.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  8.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  9.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  10.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  11.   PRIMARY KEY (`id`) USING BTREE
  12. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '用户点赞收藏'

业务视图

_view02_user_app

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
  2. select
  3.   (
  4.     case `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId`
  5.       when 'jufeng-mgmt' then 'mgmt'
  6.       when 'jufeng-student' then 'student'
  7.       when 'jufeng-teacher' then 'teacher'
  8.       else NULL
  9.     end
  10.   ) AS `jhId`,
  11.   `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  12.   `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  13.   `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
  14. from
  15.   `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`
  16. where
  17.   (
  18.     `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` in ('jufeng-mgmt', 'jufeng-student', 'jufeng-teacher')
  19.   )

view01_article

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_article` AS
  2. select
  3.   `article`.`id` AS `id`,
  4.   `article`.`articleId` AS `articleId`,
  5.   `article`.`categoryId` AS `categoryId`,
  6.   `article`.`categoryName` AS `categoryName`,
  7.   `article`.`articleCategoryId` AS `articleCategoryId`,
  8.   `article`.`courseId` AS `courseId`,
  9.   `article`.`courseBatchId` AS `courseBatchId`,
  10.   `article`.`articleGroupName` AS `articleGroupName`,
  11.   `article`.`articleTagList` AS `articleTagList`,
  12.   `article`.`articlePublishStatus` AS `articlePublishStatus`,
  13.   `article`.`articlePublishTime` AS `articlePublishTime`,
  14.   `article`.`articleTitle` AS `articleTitle`,
  15.   `article`.`articleShortName` AS `articleShortName`,
  16.   `article`.`articleConfig` AS `articleConfig`,
  17.   `article`.`articleCoverImage` AS `articleCoverImage`,
  18.   `article`.`articleContent` AS `articleContent`,
  19.   `article`.`articleContentForSeo` AS `articleContentForSeo`,
  20.   `article`.`articleType` AS `articleType`,
  21.   `article`.`articleAudioUrl` AS `articleAudioUrl`,
  22.   `article`.`articleVideoUrl` AS `articleVideoUrl`,
  23.   `article`.`articleCreateTime` AS `articleCreateTime`,
  24.   `article`.`articleCreateUserId` AS `articleCreateUserId`,
  25.   `article`.`articleCreateUsername` AS `articleCreateUsername`,
  26.   `article`.`articleUpdateTime` AS `articleUpdateTime`,
  27.   `article`.`articleUpdateUserId` AS `articleUpdateUserId`,
  28.   `article`.`articleUpdateUsername` AS `articleUpdateUsername`,
  29.   `article`.`visitCount` AS `visitCount`,
  30.   `article`.`operation` AS `operation`,
  31.   `article`.`operationByUserId` AS `operationByUserId`,
  32.   `article`.`operationByUser` AS `operationByUser`,
  33.   `article`.`operationAt` AS `operationAt`,
  34.   `article`.`auditStatus` AS `auditStatus`,
  35.   `article`.`auditByUserId` AS `auditByUserId`,
  36.   `article`.`auditComment` AS `auditComment`,
  37.   `article`.`auditAt` AS `auditAt`,
  38.   `article`.`ownerUserId` AS `ownerUserId`,
  39.   `article`.`ownerUserName` AS `ownerUserName`
  40. from
  41.   `article`

view01_article_detail

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_article_detail` AS
  2. select
  3.   `article`.`id` AS `id`,
  4.   `article`.`articleId` AS `articleId`,
  5.   `article`.`categoryId` AS `categoryId`,
  6.   `article`.`categoryName` AS `categoryName`,
  7.   `article`.`articleCategoryId` AS `articleCategoryId`,
  8.   `article`.`courseBatchId` AS `courseBatchId`,
  9.   `article`.`articleGroupName` AS `articleGroupName`,
  10.   `article`.`articleTagList` AS `articleTagList`,
  11.   `article`.`articlePublishStatus` AS `articlePublishStatus`,
  12.   `article`.`articlePublishTime` AS `articlePublishTime`,
  13.   `article`.`articleTitle` AS `articleTitle`,
  14.   `article`.`articleShortName` AS `articleShortName`,
  15.   `article`.`articleConfig` AS `articleConfig`,
  16.   `article`.`articleCoverImage` AS `articleCoverImage`,
  17.   `article`.`articleContent` AS `articleContent`,
  18.   `article`.`articleContentForSeo` AS `articleContentForSeo`,
  19.   `article`.`articleType` AS `articleType`,
  20.   `article`.`articleAudioUrl` AS `articleAudioUrl`,
  21.   `article`.`articleVideoUrl` AS `articleVideoUrl`,
  22.   `article`.`articleCreateTime` AS `articleCreateTime`,
  23.   `article`.`articleCreateUserId` AS `articleCreateUserId`,
  24.   `article`.`articleCreateUsername` AS `articleCreateUsername`,
  25.   `article`.`articleUpdateTime` AS `articleUpdateTime`,
  26.   `article`.`articleUpdateUserId` AS `articleUpdateUserId`,
  27.   `article`.`articleUpdateUsername` AS `articleUpdateUsername`,
  28.   `article`.`articlePrice` AS `articlePrice`,
  29.   `article`.`visitCount` AS `visitCount`,
  30.   `article`.`operation` AS `operation`,
  31.   `article`.`operationByUserId` AS `operationByUserId`,
  32.   `article`.`operationByUser` AS `operationByUser`,
  33.   `article`.`operationAt` AS `operationAt`,
  34.   `article`.`auditStatus` AS `auditStatus`,
  35.   `course_article`.`responseCount` AS `responseCount`,
  36.   `course_article`.`courseId` AS `courseId`
  37. from
  38.   (
  39.     `article`
  40.     join `course_article` on (
  41.       (
  42.         `article`.`articleId` = `course_article`.`articleId`
  43.       )
  44.     )
  45.   )

view01_article_student_response

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_article_student_response` AS
  2. select
  3.   `article_student_response`.`id` AS `id`,
  4.   `article_student_response`.`responseId` AS `responseId`,
  5.   `article_student_response`.`courseId` AS `courseId`,
  6.   `article_student_response`.`classId` AS `classId`,
  7.   `article_student_response`.`articleTitle` AS `articleTitle`,
  8.   `article_student_response`.`articleId` AS `articleId`,
  9.   `article_student_response`.`articleType` AS `articleType`,
  10.   `article_student_response`.`userId` AS `userId`,
  11.   `article_student_response`.`fullMark` AS `fullMark`,
  12.   `article_student_response`.`totalMark` AS `totalMark`,
  13.   `article_student_response`.`responseNote` AS `responseNote`,
  14.   `article_student_response`.`responseSubmitStatus` AS `responseSubmitStatus`,
  15.   `article_student_response`.`responseSubmitAt` AS `responseSubmitAt`,
  16.   `article_student_response`.`responseContent` AS `responseContent`,
  17.   `article_student_response`.`responseRetryNumber` AS `responseRetryNumber`,
  18.   `article_student_response`.`teacherId` AS `teacherId`,
  19.   `article_student_response`.`teacherReview` AS `teacherReview`,
  20.   `article_student_response`.`teacherReviewStatus` AS `teacherReviewStatus`,
  21.   `article_student_response`.`teacherReviewAt` AS `teacherReviewAt`,
  22.   `article_student_response`.`operation` AS `operation`,
  23.   `article_student_response`.`operationByUserId` AS `operationByUserId`,
  24.   `article_student_response`.`operationByUser` AS `operationByUser`,
  25.   `article_student_response`.`operationAt` AS `operationAt`,
  26.   `article_student_response`.`responsePercent` AS `responsePercent`,
  27.   `_user`.`username` AS `netName`,
  28.   `article`.`ownerUserId` AS `ownerUserId`,
  29.   `article`.`ownerUserName` AS `ownerUserName`
  30. from
  31.   (
  32.     (
  33.       `article_student_response`
  34.       join `_user` on (
  35.         (
  36.           `article_student_response`.`userId` = `_user`.`userId`
  37.         )
  38.       )
  39.     )
  40.     join `article` on (
  41.       (
  42.         `article_student_response`.`articleId` = `article`.`articleId`
  43.       )
  44.     )
  45.   )

view01_attendance

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_attendance` AS
  2. select
  3.   `attendance`.`id` AS `id`,
  4.   `attendance`.`classId` AS `classId`,
  5.   `attendance`.`courseId` AS `courseId`,
  6.   `attendance`.`userId` AS `userId`,
  7.   `attendance`.`lessonNumber` AS `lessonNumber`,
  8.   `attendance`.`attendanceDate` AS `attendanceDate`,
  9.   `attendance`.`attendance` AS `attendance`,
  10.   `attendance`.`articleId` AS `articleId`,
  11.   `attendance`.`articleTitle` AS `articleTitle`,
  12.   `attendance`.`markedAt` AS `markedAt`,
  13.   `attendance`.`markedByUser` AS `markedByUser`,
  14.   `attendance`.`markedByUserId` AS `markedByUserId`,
  15.   `attendance`.`remarks` AS `remarks`,
  16.   `attendance`.`operation` AS `operation`,
  17.   `attendance`.`operationAt` AS `operationAt`,
  18.   `attendance`.`operationByUserId` AS `operationByUserId`,
  19.   `attendance`.`operationByUser` AS `operationByUser`,
  20.   `attendance`.`courseBatchId` AS `courseBatchId`,
  21.   `course`.`ownerUserId` AS `ownerUserId`,
  22.   `course`.`ownerUserName` AS `ownerUserName`
  23. from
  24.   (
  25.     `attendance`
  26.     join `course` on ((`attendance`.`courseId` = `course`.`courseId`))
  27.   )

view01_course_article

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_course_article` AS
  2. select
  3.   `course_article`.`id` AS `id`,
  4.   `course_article`.`courseId` AS `courseId`,
  5.   `course_article`.`articleId` AS `articleId`,
  6.   `course_article`.`albumId` AS `albumId`,
  7.   `course_article`.`lessonNumber` AS `lessonNumber`,
  8.   `course_article`.`articleDesignStatus` AS `articleDesignStatus`,
  9.   `course_article`.`isFree` AS `isFree`,
  10.   `course_article`.`price` AS `price`,
  11.   `course_article`.`visitCount` AS `visitCount`,
  12.   `course_article`.`questionCount` AS `questionCount`,
  13.   `course_article`.`responseCount` AS `responseCount`,
  14.   `course_article`.`operation` AS `operation`,
  15.   `course_article`.`operationByUserId` AS `operationByUserId`,
  16.   `course_article`.`operationByUser` AS `operationByUser`,
  17.   `course_article`.`operationAt` AS `operationAt`,
  18.   `article`.`articleTitle` AS `articleTitle`,
  19.   `article`.`articleType` AS `articleType`,
  20.   `article`.`articleTagList` AS `articleTagList`,
  21.   `article`.`articlePublishStatus` AS `articlePublishStatus`,
  22.   `article`.`articleCoverImage` AS `articleCoverImage`,
  23.   `article`.`articlePublishTime` AS `articlePublishTime`,
  24.   `article`.`articlePrice` AS `articlePrice`,
  25.   `article`.`ownerUserId` AS `ownerUserId`,
  26.   `article`.`ownerUserName` AS `ownerUserName`,
  27.   `article`.`auditStatus` AS `auditStatus`
  28. from
  29.   (
  30.     `course_article`
  31.     left join `article` on (
  32.       (
  33.         `course_article`.`articleId` = `article`.`articleId`
  34.       )
  35.     )
  36.   )

view01_course_list

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_course_list` AS
  2. select
  3.   `course`.`id` AS `id`,
  4.   `course`.`courseId` AS `courseId`,
  5.   `course`.`categoryId` AS `categoryId`,
  6.   `course`.`courseTitle` AS `courseTitle`,
  7.   `course`.`courseType` AS `courseType`,
  8.   `course`.`courseContent` AS `courseContent`,
  9.   `course`.`courseImage` AS `courseImage`,
  10.   `course`.`courseTag` AS `courseTag`,
  11.   `course`.`coursePrice` AS `coursePrice`,
  12.   `course`.`banner` AS `banner`,
  13.   `course`.`posterImage` AS `posterImage`,
  14.   `course`.`serviceCode` AS `serviceCode`,
  15.   `course`.`freeAritleIdList` AS `freeAritleIdList`,
  16.   `course`.`isDel` AS `isDel`,
  17.   `course`.`isFree` AS `isFree`,
  18.   `course`.`sort` AS `sort`,
  19.   `course`.`sales` AS `sales`,
  20.   `course`.`operation` AS `operation`,
  21.   `course`.`operationByUserId` AS `operationByUserId`,
  22.   `course`.`operationByUser` AS `operationByUser`,
  23.   `course`.`operationAt` AS `operationAt`,
  24.   `course`.`userCount` AS `userCount`,
  25.   count(
  26.     distinct (
  27.       case
  28.         when (
  29.           (`course_article`.`articleType` = 'article')
  30.           and (`course_article`.`articlePublishStatus` = 'login')
  31.         ) then `course_article`.`id`
  32.       end
  33.     )
  34.   ) AS `articleCount`
  35. from
  36.   (
  37.     `course`
  38.     left join `course_article` on (
  39.       (`course`.`courseId` = `course_article`.`courseId`)
  40.     )
  41.   )
  42. group by
  43.   `course`.`id`
  44. having
  45.   (`articleCount` > 0)

view01_course_user

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_course_user` AS
  2. select
  3.   `course_user`.`id` AS `id`,
  4.   `course_user`.`courseId` AS `courseId`,
  5.   `course_user`.`courseTitle` AS `courseTitle`,
  6.   `course_user`.`courseType` AS `courseType`,
  7.   `course_user`.`courseTag` AS `courseTag`,
  8.   `course_user`.`courseImage` AS `courseImage`,
  9.   `course_user`.`userId` AS `userId`,
  10.   `course_user`.`userName` AS `userName`,
  11.   `course_user`.`userAvatar` AS `userAvatar`,
  12.   `course_user`.`classId` AS `classId`,
  13.   `course_user`.`orderId` AS `orderId`,
  14.   `course_user`.`isDel` AS `isDel`,
  15.   `course_user`.`isPay` AS `isPay`,
  16.   `course_user`.`operation` AS `operation`,
  17.   `course_user`.`operationByUserId` AS `operationByUserId`,
  18.   `course_user`.`operationByUser` AS `operationByUser`,
  19.   `course_user`.`operationAt` AS `operationAt`,
  20.   `course`.`ownerUserId` AS `ownerUserId`,
  21.   `course`.`ownerUserName` AS `ownerUserName`,
  22.   `course`.`helperUserIdList` AS `helperUserIdList`
  23. from
  24.   (
  25.     `course_user`
  26.     join `course` on ((`course_user`.`courseId` = `course`.`courseId`))
  27.   )

view01_course_with_article_count

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_course_with_article_count` AS
  2. select
  3.   `c`.`id` AS `id`,
  4.   `c`.`courseId` AS `courseId`,
  5.   `c`.`categoryId` AS `categoryId`,
  6.   `c`.`courseTitle` AS `courseTitle`,
  7.   `c`.`courseType` AS `courseType`,
  8.   `c`.`courseContent` AS `courseContent`,
  9.   `c`.`courseImage` AS `courseImage`,
  10.   `c`.`courseTag` AS `courseTag`,
  11.   `c`.`coursePrice` AS `coursePrice`,
  12.   `c`.`banner` AS `banner`,
  13.   `c`.`posterImage` AS `posterImage`,
  14.   `c`.`serviceCode` AS `serviceCode`,
  15.   `c`.`freeAritleIdList` AS `freeAritleIdList`,
  16.   `c`.`isDel` AS `isDel`,
  17.   `c`.`isFree` AS `isFree`,
  18.   `c`.`sort` AS `sort`,
  19.   `c`.`sales` AS `sales`,
  20.   `c`.`operation` AS `operation`,
  21.   `c`.`operationByUserId` AS `operationByUserId`,
  22.   `c`.`operationByUser` AS `operationByUser`,
  23.   `c`.`operationAt` AS `operationAt`,
  24.   `c`.`helperUserIdList` AS `helperUserIdList`,
  25.   sum(
  26.     if((`c_art`.`articlePublishStatus` = 'login'), 1, 0)
  27.   ) AS `articleCount`,
  28.   `course_category`.`categoryName` AS `categoryName`,
  29.   `c`.`ownerUserId` AS `ownerUserId`,
  30.   `c`.`auditStatus` AS `auditStatus`
  31. from
  32.   (
  33.     (
  34.       `course` `c`
  35.       left join `view01_course_article` `c_art` on ((`c`.`courseId` = `c_art`.`courseId`))
  36.     )
  37.     join `course_category` on (
  38.       (`c`.`categoryId` = `course_category`.`categoryId`)
  39.     )
  40.   )
  41. group by
  42.   `c`.`id`

view01_order

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_order` AS
  2. select
  3.   `order`.`id` AS `id`,
  4.   `order`.`orderId` AS `orderId`,
  5.   `order`.`orderType` AS `orderType`,
  6.   `order`.`orderStatus` AS `orderStatus`,
  7.   `order`.`userName` AS `userName`,
  8.   `order`.`userId` AS `userId`,
  9.   `order`.`userPhone` AS `userPhone`,
  10.   `order`.`userAddress` AS `userAddress`,
  11.   `order`.`courseId` AS `courseId`,
  12.   `order`.`memberId` AS `memberId`,
  13.   `order`.`articleId` AS `articleId`,
  14.   `order`.`productId` AS `productId`,
  15.   `order`.`totalNum` AS `totalNum`,
  16.   `order`.`totalPrice` AS `totalPrice`,
  17.   `order`.`totalPostage` AS `totalPostage`,
  18.   `order`.`payPrice` AS `payPrice`,
  19.   `order`.`payPostage` AS `payPostage`,
  20.   `order`.`payType` AS `payType`,
  21.   `order`.`payTradeNo` AS `payTradeNo`,
  22.   `order`.`payTime` AS `payTime`,
  23.   `order`.`merchantId` AS `merchantId`,
  24.   `order`.`payStatus` AS `payStatus`,
  25.   `order`.`deductionPrice` AS `deductionPrice`,
  26.   `order`.`couponId` AS `couponId`,
  27.   `order`.`couponPrice` AS `couponPrice`,
  28.   `order`.`deliveryName` AS `deliveryName`,
  29.   `order`.`deliveryType` AS `deliveryType`,
  30.   `order`.`deliveryNumber` AS `deliveryNumber`,
  31.   `order`.`refundStatus` AS `refundStatus`,
  32.   `order`.`refundReason` AS `refundReason`,
  33.   `order`.`refundReasonPicList` AS `refundReasonPicList`,
  34.   `order`.`refundApplyTime` AS `refundApplyTime`,
  35.   `order`.`refundTime` AS `refundTime`,
  36.   `order`.`refundPrice` AS `refundPrice`,
  37.   `order`.`mark` AS `mark`,
  38.   `order`.`isDel` AS `isDel`,
  39.   `order`.`remark` AS `remark`,
  40.   `order`.`spreadUserId` AS `spreadUserId`,
  41.   `order`.`operation` AS `operation`,
  42.   `order`.`operationByUserId` AS `operationByUserId`,
  43.   `order`.`operationByUser` AS `operationByUser`,
  44.   `order`.`operationAt` AS `operationAt`,
  45.   `article`.`categoryName` AS `categoryName`,
  46.   `article`.`articleCoverImage` AS `articleCoverImage`,
  47.   `course`.`courseImage` AS `courseImage`,
  48.   `course`.`courseTitle` AS `courseTitle`,
  49.   `store_product`.`productName` AS `productName`,
  50.   `store_product`.`productImage` AS `productImage`,
  51.   `order`.`refundRejectReason` AS `refundRejectReason`
  52. from
  53.   (
  54.     (
  55.       (
  56.         `order`
  57.         left join `article` on ((`order`.`articleId` = `article`.`articleId`))
  58.       )
  59.       left join `course` on ((`order`.`courseId` = `course`.`courseId`))
  60.     )
  61.     left join `store_product` on (
  62.       (
  63.         `order`.`productId` = convert(`store_product`.`productId` using utf8mb4)
  64.       )
  65.     )
  66.   )

view01_order_detail

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_order_detail` AS
  2. select
  3.   `order`.`id` AS `id`,
  4.   `order`.`orderId` AS `orderId`,
  5.   `order`.`orderType` AS `orderType`,
  6.   `order`.`orderStatus` AS `orderStatus`,
  7.   `order`.`userName` AS `userName`,
  8.   `order`.`userId` AS `userId`,
  9.   `order`.`userPhone` AS `userPhone`,
  10.   `order`.`userAddress` AS `userAddress`,
  11.   `order`.`courseId` AS `courseId`,
  12.   `order`.`memberId` AS `memberId`,
  13.   `order`.`articleId` AS `articleId`,
  14.   `order`.`productId` AS `productId`,
  15.   `order`.`totalNum` AS `totalNum`,
  16.   `order`.`totalPrice` AS `totalPrice`,
  17.   `order`.`totalPostage` AS `totalPostage`,
  18.   `order`.`payPrice` AS `payPrice`,
  19.   `order`.`payPostage` AS `payPostage`,
  20.   `order`.`payType` AS `payType`,
  21.   `order`.`payTradeNo` AS `payTradeNo`,
  22.   `order`.`payTime` AS `payTime`,
  23.   `order`.`merchantId` AS `merchantId`,
  24.   `order`.`payStatus` AS `payStatus`,
  25.   `order`.`deductionPrice` AS `deductionPrice`,
  26.   `order`.`couponId` AS `couponId`,
  27.   `order`.`couponPrice` AS `couponPrice`,
  28.   `order`.`deliveryName` AS `deliveryName`,
  29.   `order`.`deliveryType` AS `deliveryType`,
  30.   `order`.`deliveryNumber` AS `deliveryNumber`,
  31.   `order`.`refundStatus` AS `refundStatus`,
  32.   `order`.`refundReason` AS `refundReason`,
  33.   `order`.`refundReasonPicList` AS `refundReasonPicList`,
  34.   `order`.`refundApplyTime` AS `refundApplyTime`,
  35.   `order`.`refundTime` AS `refundTime`,
  36.   `order`.`refundPrice` AS `refundPrice`,
  37.   `order`.`mark` AS `mark`,
  38.   `order`.`isDel` AS `isDel`,
  39.   `order`.`remark` AS `remark`,
  40.   `order`.`spreadUserId` AS `spreadUserId`,
  41.   `order`.`operation` AS `operation`,
  42.   `order`.`operationByUserId` AS `operationByUserId`,
  43.   `order`.`operationByUser` AS `operationByUser`,
  44.   `order`.`operationAt` AS `operationAt`,
  45.   `course`.`courseTitle` AS `courseTitle`,
  46.   `article`.`articleTitle` AS `articleTitle`,
  47.   `store_product`.`productName` AS `productName`
  48. from
  49.   (
  50.     (
  51.       (
  52.         `order`
  53.         left join `course` on ((`order`.`courseId` = `course`.`courseId`))
  54.       )
  55.       left join `article` on ((`order`.`articleId` = `article`.`articleId`))
  56.     )
  57.     left join `store_product` on (
  58.       (
  59.         `order`.`productId` = convert(`store_product`.`productId` using utf8mb4)
  60.       )
  61.     )
  62.   )

view01_student_learning_record

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_student_learning_record` AS
  2. select
  3.   `student_learning_record`.`id` AS `id`,
  4.   `student_learning_record`.`courseMemberId` AS `courseMemberId`,
  5.   `student_learning_record`.`courseBatchId` AS `courseBatchId`,
  6.   `student_learning_record`.`courseId` AS `courseId`,
  7.   `student_learning_record`.`classId` AS `classId`,
  8.   `student_learning_record`.`memberId` AS `memberId`,
  9.   `student_learning_record`.`loginId` AS `loginId`,
  10.   `student_learning_record`.`district` AS `district`,
  11.   `student_learning_record`.`orgId` AS `orgId`,
  12.   `student_learning_record`.`orgName` AS `orgName`,
  13.   `student_learning_record`.`orgFullName` AS `orgFullName`,
  14.   `student_learning_record`.`roleId` AS `roleId`,
  15.   `student_learning_record`.`stage` AS `stage`,
  16.   `student_learning_record`.`title` AS `title`,
  17.   `student_learning_record`.`position` AS `position`,
  18.   `student_learning_record`.`memberRole` AS `memberRole`,
  19.   `student_learning_record`.`result` AS `result`,
  20.   `student_learning_record`.`note` AS `note`,
  21.   `student_learning_record`.`comment` AS `comment`,
  22.   `student_learning_record`.`teacherRecommendation` AS `teacherRecommendation`,
  23.   `student_learning_record`.`courseCreditEarned` AS `courseCreditEarned`,
  24.   `student_learning_record`.`examScoreStat` AS `examScoreStat`,
  25.   `student_learning_record`.`examScoreDetail` AS `examScoreDetail`,
  26.   `student_learning_record`.`overallComment` AS `overallComment`,
  27.   `student_learning_record`.`commentDetail` AS `commentDetail`,
  28.   `student_learning_record`.`attendanceStat` AS `attendanceStat`,
  29.   `student_learning_record`.`attendanceDetail` AS `attendanceDetail`,
  30.   `student_learning_record`.`assignmentStat` AS `assignmentStat`,
  31.   `student_learning_record`.`assignmentDetail` AS `assignmentDetail`,
  32.   `student_learning_record`.`noteStat` AS `noteStat`,
  33.   `student_learning_record`.`noteDetail` AS `noteDetail`,
  34.   `student_learning_record`.`totalLearningHour` AS `totalLearningHour`,
  35.   `student_learning_record`.`memberCourseStatus` AS `memberCourseStatus`,
  36.   `student_learning_record`.`nominatedByMemberId` AS `nominatedByMemberId`,
  37.   `student_learning_record`.`nominatedByUserId` AS `nominatedByUserId`,
  38.   `student_learning_record`.`nominatedByUser` AS `nominatedByUser`,
  39.   `student_learning_record`.`dateStarted` AS `dateStarted`,
  40.   `student_learning_record`.`dateEnded` AS `dateEnded`,
  41.   `student_learning_record`.`operation` AS `operation`,
  42.   `student_learning_record`.`operationAt` AS `operationAt`,
  43.   `student_learning_record`.`operationByUserId` AS `operationByUserId`,
  44.   `student_learning_record`.`operationByUser` AS `operationByUser`,
  45.   `course`.`courseTitle` AS `courseName`,
  46.   `_user`.`username` AS `netName`,
  47.   `course`.`ownerUserId` AS `ownerUserId`,
  48.   `course`.`ownerUserName` AS `ownerUserName`
  49. from
  50.   (
  51.     (
  52.       `student_learning_record`
  53.       join `course` on (
  54.         (
  55.           `student_learning_record`.`courseId` = `course`.`courseId`
  56.         )
  57.       )
  58.     )
  59.     join `_user` on (
  60.       (
  61.         `student_learning_record`.`loginId` = `_user`.`userId`
  62.       )
  63.     )
  64.   )

view01_user_learing_record

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_user_learing_record` AS
  2. select distinct
  3.   `user_learing_record`.`id` AS `id`,
  4.   `user_learing_record`.`courseId` AS `courseId`,
  5.   `user_learing_record`.`articleId` AS `articleId`,
  6.   `user_learing_record`.`learingType` AS `learingType`,
  7.   `user_learing_record`.`operation` AS `operation`,
  8.   `user_learing_record`.`operationByUserId` AS `operationByUserId`,
  9.   `user_learing_record`.`operationByUser` AS `operationByUser`,
  10.   `user_learing_record`.`operationAt` AS `operationAt`,
  11.   `user_learing_record`.`userId` AS `userId`,
  12.   `course`.`courseImage` AS `courseImage`,
  13.   `course`.`courseTitle` AS `courseTitle`,
  14.   `course`.`coursePrice` AS `coursePrice`,
  15.   `course`.`userCount` AS `userCount`,
  16.   `course_article`.`articleTitle` AS `articleTitle`,
  17.   `course_article`.`articleCoverImage` AS `articleCoverImage`,
  18.   `course_article`.`articlePrice` AS `articlePrice`,
  19.   `course_article`.`responseCount` AS `responseCount`
  20. from
  21.   (
  22.     (
  23.       `user_learing_record`
  24.       left join `course` on (
  25.         (
  26.           `user_learing_record`.`courseId` = `course`.`courseId`
  27.         )
  28.       )
  29.     )
  30.     join `view01_course_article` `course_article` on (
  31.       (
  32.         `user_learing_record`.`articleId` = `course_article`.`articleId`
  33.       )
  34.     )
  35.   )

view01_user_learing_record_article

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_user_learing_record_article` AS
  2. select
  3.   `user_learing_record`.`id` AS `id`,
  4.   `user_learing_record`.`courseId` AS `courseId`,
  5.   `user_learing_record`.`articleId` AS `articleId`,
  6.   `user_learing_record`.`learingType` AS `learingType`,
  7.   `user_learing_record`.`operation` AS `operation`,
  8.   `user_learing_record`.`operationByUserId` AS `operationByUserId`,
  9.   `user_learing_record`.`operationByUser` AS `operationByUser`,
  10.   `user_learing_record`.`operationAt` AS `operationAt`,
  11.   `user_learing_record`.`userId` AS `userId`,
  12.   `course`.`courseImage` AS `courseImage`,
  13.   `course_article`.`articleTitle` AS `articleTitle`,
  14.   `course_article`.`articleCoverImage` AS `articleCoverImage`,
  15.   `course_article`.`articlePrice` AS `articlePrice`,
  16.   `course_article`.`responseCount` AS `responseCount`
  17. from
  18.   (
  19.     (
  20.       `user_learing_record`
  21.       join `course` on (
  22.         (
  23.           `user_learing_record`.`courseId` = `course`.`courseId`
  24.         )
  25.       )
  26.     )
  27.     join `view01_course_article` `course_article` on (
  28.       (
  29.         `user_learing_record`.`articleId` = `course_article`.`articleId`
  30.       )
  31.     )
  32.   )
  33. where
  34.   (
  35.     not(
  36.       (
  37.         `user_learing_record`.`learingType` like '%course%'
  38.       )
  39.     )
  40.   )
  41. group by
  42.   `user_learing_record`.`articleId`

view01_user_learing_record_course

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_user_learing_record_course` AS
  2. select distinct
  3.   `user_learing_record`.`id` AS `id`,
  4.   `user_learing_record`.`courseId` AS `courseId`,
  5.   `user_learing_record`.`articleId` AS `articleId`,
  6.   `user_learing_record`.`learingType` AS `learingType`,
  7.   `user_learing_record`.`operation` AS `operation`,
  8.   `user_learing_record`.`operationByUserId` AS `operationByUserId`,
  9.   `user_learing_record`.`operationByUser` AS `operationByUser`,
  10.   `user_learing_record`.`operationAt` AS `operationAt`,
  11.   `user_learing_record`.`userId` AS `userId`,
  12.   `course`.`courseImage` AS `courseImage`,
  13.   `course`.`courseTitle` AS `courseTitle`,
  14.   `course`.`coursePrice` AS `coursePrice`,
  15.   `course`.`userCount` AS `userCount`
  16. from
  17.   (
  18.     `user_learing_record`
  19.     left join `course` on (
  20.       (
  21.         `user_learing_record`.`courseId` = `course`.`courseId`
  22.       )
  23.     )
  24.   )
  25. where
  26.   (`user_learing_record`.`learingType` = 'course')

view01_user_like

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_user_like` AS
  2. select
  3.   `user_like`.`userId` AS `userId`,
  4.   `user_like`.`articleId` AS `articleId`,
  5.   `user_like`.`courseId` AS `courseId`,
  6.   `user_like`.`operationAt` AS `operationAt`,
  7.   `user_like`.`operationByUser` AS `operationByUser`,
  8.   `user_like`.`operationByUserId` AS `operationByUserId`,
  9.   `user_like`.`operation` AS `operation`,
  10.   `course`.`courseTitle` AS `courseTitle`,
  11.   `course`.`courseType` AS `courseType`,
  12.   `course`.`coursePrice` AS `coursePrice`,
  13.   `course`.`courseContent` AS `courseContent`,
  14.   `course`.`courseImage` AS `courseImage`,
  15.   `course`.`auditStatus` AS `auditStatus`,
  16.   `article`.`categoryId` AS `categoryId`,
  17.   `article`.`articleTitle` AS `articleTitle`,
  18.   `article`.`articleType` AS `articleType`,
  19.   `article`.`articleCoverImage` AS `articleCoverImage`,
  20.   `article`.`articlePrice` AS `articlePrice`,
  21.   `article`.`articleContent` AS `articleContent`,
  22.   `article`.`articleContentForSeo` AS `articleContentForSeo`,
  23.   `article`.`articleAudioUrl` AS `articleAudioUrl`,
  24.   `article`.`articleCreateTime` AS `articleCreateTime`,
  25.   `article`.`articleVideoUrl` AS `articleVideoUrl`,
  26.   `article`.`visitCount` AS `visitCount`,
  27.   `article`.`auditStatus` AS `articleAuditStatus`,
  28.   `course`.`userCount` AS `userCount`
  29. from
  30.   (
  31.     (
  32.       `user_like`
  33.       left join `course` on ((`user_like`.`courseId` = `course`.`courseId`))
  34.     )
  35.     left join `article` on ((`user_like`.`articleId` = `article`.`articleId`))
  36.   )