江湖数字化平台
登录

数据结构

12114

表总览

普通表

__bkp_data__notice_task_20230515

  • 通知任务表(学生维度)
  1. CREATE TABLE `__bkp_data__notice_task_20230515` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `idSequence` int(11) DEFAULT NULL COMMENT '自增id;',
  4.   `taskId` varchar(255)  DEFAULT NULL COMMENT '任务Id',
  5.   `studentId` varchar(255)  DEFAULT NULL COMMENT '学生ID',
  6.   `studentName` varchar(255)  DEFAULT NULL COMMENT '学生名',
  7.   `noticeTemplate` varchar(255)  DEFAULT '普通文字消息模版' COMMENT '模板文件名;',
  8.   `noticeName` varchar(255)  DEFAULT NULL COMMENT '消息名称',
  9.   `noticeContent` text  COMMENT '消息内容JSON; eg: {"content": "测试推送"}',
  10.   `noticeDetailContent` text  COMMENT '消息详情页内容JSON',
  11.   `isGeneratePush` varchar(255)  DEFAULT '否' COMMENT '是否生成推送数据;',
  12.   `createAt` varchar(255)  DEFAULT NULL COMMENT '创建任务时间;',
  13.   `schedulePushAt` varchar(255)  DEFAULT NULL COMMENT '计划推送时间; E.g: 2021-05-28T10:24:54+08:00',
  14.   `examId` varchar(255)  DEFAULT NULL COMMENT '成绩对应的考试ID',
  15.   `appId` varchar(255)  DEFAULT NULL COMMENT '消息来源业务ID',
  16.   `noticeBatchId` varchar(255)  DEFAULT NULL COMMENT '成绩通知生成批次编号',
  17.   `noticeData` varchar(255)  DEFAULT NULL COMMENT '消息业务数据',
  18.   `noticeStatus` varchar(255)  DEFAULT NULL COMMENT '消息状态：new-新建, draft-草稿, publish-发布',
  19.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  20.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  21.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  22.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  23.   PRIMARY KEY (`id`) USING BTREE,
  24.   UNIQUE KEY `task_unique` (`taskId`) USING BTREE
  25. ) ENGINE = InnoDB AUTO_INCREMENT = 2681 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '通知任务表(学生维度)'

_cache

  • 缓存表
  1. CREATE TABLE `_cache` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `userId` varchar(255)  NOT NULL COMMENT '用户Id',
  4.   `content` longtext  COMMENT '缓存数据',
  5.   `recordStatus` varchar(255)  DEFAULT 'active',
  6.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  7.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  8.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  9.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  10.   PRIMARY KEY (`id`) USING BTREE
  11. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '缓存表'

_constant

  • 常量表; 软删除未启用;
  1. CREATE TABLE `_constant` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `constantKey` varchar(255)  DEFAULT NULL,
  4.   `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  5.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  6.   `constantValue` text  COMMENT '常量内容; object, array',
  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 AUTO_INCREMENT = 30 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表; 软删除未启用;'

_page

  • 页面表; 软删除未启用;
  1. CREATE TABLE `_page` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  4.   `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  5.   `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  6.   `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  7.   `sort` varchar(255)  DEFAULT NULL,
  8.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  9.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  10.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  11.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  12.   PRIMARY KEY (`id`) USING BTREE
  13. ) ENGINE = InnoDB AUTO_INCREMENT = 41 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

_record_history

  • 数据历史表
  1. CREATE TABLE `_record_history` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `table` varchar(255)  DEFAULT NULL COMMENT '表',
  4.   `recordId` int(11) DEFAULT NULL COMMENT '数据在table中的主键id; recordContent.id',
  5.   `recordContent` text  NOT NULL COMMENT '数据',
  6.   `packageContent` text  NOT NULL COMMENT '当时请求的 package JSON',
  7.   `operation` varchar(255)  DEFAULT NULL COMMENT '操作; jhInsert, jhUpdate, jhDelete jhRestore',
  8.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId; recordContent.operationByUserId',
  9.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名; recordContent.operationByUser',
  10.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; recordContent.operationAt; E.g: 2021-05-28T10:24:54+08:00 ',
  11.   PRIMARY KEY (`id`) USING BTREE,
  12.   KEY `index_record_id` (`recordId`) USING BTREE,
  13.   KEY `index_table_action` (`table`, `operation`) USING BTREE
  14. ) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '数据历史表'

_resource

  • 请求资源表; 软删除未启用; resourceId=${appId}.${pageId}.${actionId}
  1. CREATE TABLE `_resource` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `accessControlTable` varchar(255)  DEFAULT NULL COMMENT '数据规则控制表',
  4.   `resourceHook` text  COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  5.   `pageId` varchar(255)  DEFAULT NULL COMMENT 'page id; E.g: index',
  6.   `actionId` varchar(255)  DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  7.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  8.   `resourceType` varchar(255)  DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  9.   `appDataSchema` text  COMMENT 'appData 参数校验',
  10.   `resourceData` text  COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  11.   `requestDemo` text  COMMENT '请求Demo',
  12.   `responseDemo` text  COMMENT '响应Demo',
  13.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  14.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  15.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  16.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  17.   PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE = InnoDB AUTO_INCREMENT = 397 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_test_case

  • 测试用例表
  1. CREATE TABLE `_test_case` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `pageId` varchar(255)  DEFAULT NULL COMMENT '页面Id',
  4.   `testId` varchar(255)  DEFAULT NULL COMMENT '测试用例Id; 10000 ++',
  5.   `testName` varchar(255)  DEFAULT NULL COMMENT '测试用例名',
  6.   `uiActionIdList` varchar(255)  DEFAULT NULL COMMENT 'uiAction列表; 一个测试用例对应多个uiActionId',
  7.   `testOpeartion` text  COMMENT '测试用例步骤;',
  8.   `expectedResult` text  COMMENT '期望结果',
  9.   `operation` varchar(255)  DEFAULT NULL COMMENT '操作; jhInsert, jhUpdate, jhDelete jhRestore',
  10.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId; recordContent.operationByUserId',
  11.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名; recordContent.operationByUser',
  12.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; recordContent.operationAt; E.g: 2021-05-28T10:24:54+08:00 ',
  13.   PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '测试用例表'

_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 COLLATE = utf8mb4_bin COMMENT = 'ui 施工方案'

_user

  • 用户表
  1. CREATE TABLE `_user` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `idSequence` varchar(255)  DEFAULT NULL COMMENT '自增id; 用于生成userId',
  4.   `userId` varchar(255)  DEFAULT NULL COMMENT '主键id',
  5.   `username` varchar(255)  DEFAULT NULL COMMENT '用户名(登陆)',
  6.   `clearTextPassword` varchar(255)  DEFAULT NULL COMMENT '明文密码',
  7.   `password` varchar(255)  DEFAULT NULL COMMENT '密码',
  8.   `md5Salt` varchar(255)  DEFAULT NULL COMMENT 'md5Salt',
  9.   `userStatus` varchar(255)  DEFAULT 'active' COMMENT '用户账号状态：活跃或关闭',
  10.   `userType` varchar(255)  DEFAULT NULL COMMENT '用户类型; staff, student.',
  11.   `config` mediumtext  COMMENT '配置信息',
  12.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  13.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  14.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  15.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  16.   PRIMARY KEY (`id`) USING BTREE,
  17.   UNIQUE KEY `username_index` (`username`) USING BTREE,
  18.   UNIQUE KEY `userId_index` (`userId`) USING BTREE
  19. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户表'

_user_session

  • 用户session表; deviceId 维度;软删除未启用;
  1. CREATE TABLE `_user_session` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `userId` varchar(255)  DEFAULT NULL COMMENT '用户id',
  4.   `userIp` varchar(255)  DEFAULT NULL COMMENT '用户ip',
  5.   `userIpRegion` varchar(255)  DEFAULT NULL COMMENT '用户Ip区域',
  6.   `userAgent` text  COMMENT '请求的 agent',
  7.   `deviceId` varchar(255)  DEFAULT NULL COMMENT '设备id',
  8.   `deviceType` varchar(255)  DEFAULT 'web' COMMENT '设备类型; flutter, web, bot_databot, bot_chatbot, bot_xiaochengxu',
  9.   `socketStatus` varchar(255)  DEFAULT 'offline' COMMENT 'socket状态',
  10.   `authToken` varchar(255)  DEFAULT NULL COMMENT 'auth token',
  11.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  12.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  13.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  14.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  15.   PRIMARY KEY (`id`) USING BTREE,
  16.   KEY `userId_index` (`userId`) USING BTREE,
  17.   KEY `userId_deviceId_index` (`userId`, `deviceId`) USING BTREE,
  18.   KEY `authToken_index` (`authToken`) USING BTREE
  19. ) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户session表; deviceId 维度;软删除未启用;'

exam

  1. CREATE TABLE `exam` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `examId` varchar(255)  DEFAULT NULL COMMENT '考试ID',
  4.   `examName` varchar(255)  DEFAULT NULL COMMENT '考试名',
  5.   `semester` varchar(255)  DEFAULT NULL COMMENT '学期',
  6.   `year` varchar(255)  DEFAULT NULL COMMENT '自然年',
  7.   `academicYear` varchar(255)  DEFAULT NULL COMMENT '年份',
  8.   `segment` varchar(255)  DEFAULT NULL COMMENT '学部',
  9.   `level` varchar(255)  DEFAULT NULL COMMENT '年级',
  10.   `examType` varchar(255)  DEFAULT NULL COMMENT '考试类型',
  11.   `learningTrack` varchar(255)  DEFAULT NULL COMMENT '学科方向',
  12.   `subjectCount` int(11) DEFAULT NULL COMMENT '科目总数',
  13.   `subjectList` varchar(255)  DEFAULT NULL COMMENT '科目列表',
  14.   `subjectFullScore` text  COMMENT '科目满分',
  15.   `startDate` varchar(255)  DEFAULT NULL COMMENT '考试开始日期',
  16.   `endDate` varchar(255)  DEFAULT NULL COMMENT '考试结束日期',
  17.   `startMonth` varchar(255)  DEFAULT NULL COMMENT '考试开始月',
  18.   `subjectFullScoreList` varchar(255)  DEFAULT NULL COMMENT '科目满分列表，和科目列表是对应关系',
  19.   `description` text  COMMENT '简介',
  20.   `isSendNotice` varchar(255)  DEFAULT NULL COMMENT '是否通知家长',
  21.   `examStatus` varchar(255)  DEFAULT NULL COMMENT '考试状态',
  22.   `examResultStatus` varchar(255)  DEFAULT NULL COMMENT '考试成绩状态',
  23.   `noticeTemplate` varchar(255)  DEFAULT NULL COMMENT '成绩通知模板',
  24.   `noticeContent` text  COMMENT '成绩通知卡片配置',
  25.   `noticeDetailContent` text  COMMENT '成绩通知详情配置',
  26.   `noticeBatchId` varchar(255)  DEFAULT NULL COMMENT '成绩通知生成批次编号',
  27.   `noticeCount` int(11) DEFAULT '0' COMMENT '生成的成绩通知总数',
  28.   `restulUploadBatchId` varchar(255)  DEFAULT NULL COMMENT '考试成绩上传批次编号',
  29.   `operation` varchar(255)  DEFAULT NULL,
  30.   `operationAt` varchar(255)  DEFAULT NULL,
  31.   `operationByUserId` varchar(255)  DEFAULT NULL,
  32.   `operationByUser` varchar(255)  DEFAULT NULL,
  33.   PRIMARY KEY (`id`) USING BTREE,
  34.   UNIQUE KEY `examId` (`examId`) USING BTREE
  35. ) ENGINE = InnoDB AUTO_INCREMENT = 107 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

notice_batch

  1. CREATE TABLE `notice_batch` (
  2.   `id` int(11) NOT NULL,
  3.   `noticeBatchId` varchar(255)  DEFAULT NULL COMMENT '消息通知批次编号',
  4.   `appId` varchar(255)  DEFAULT NULL COMMENT '消息来源业务Id',
  5.   `examId` varchar(255)  DEFAULT NULL COMMENT '考试ID',
  6.   `noticeTemplateId` varchar(255)  DEFAULT NULL COMMENT '消息模板ID',
  7.   `noticeTemplate` varchar(255)  DEFAULT NULL COMMENT '消息模板名',
  8.   `studentCount` int(11) DEFAULT NULL COMMENT '学生人数',
  9.   `generatedNoticeCount` int(11) DEFAULT NULL COMMENT '生成的消息数',
  10.   `sentNoticeCount` int(11) DEFAULT NULL COMMENT '实际发送的消息数',
  11.   `noticeBatchStatus` varchar(255)  DEFAULT NULL COMMENT 'new-新建, draft-草稿, publish-已发布',
  12.   `operation` varchar(255)  DEFAULT NULL,
  13.   `operationAt` varchar(255)  DEFAULT NULL,
  14.   `operationByUserId` varchar(255)  DEFAULT NULL,
  15.   `operationByUser` varchar(255)  DEFAULT NULL,
  16.   PRIMARY KEY (`id`) USING BTREE
  17. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

notice_task

  • 通知任务表(学生维度)
  1. CREATE TABLE `notice_task` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `idSequence` int(11) DEFAULT NULL COMMENT '自增id;',
  4.   `taskId` varchar(255)  DEFAULT NULL COMMENT '任务Id',
  5.   `studentId` varchar(255)  DEFAULT NULL COMMENT '学生ID',
  6.   `studentName` varchar(255)  DEFAULT NULL COMMENT '学生名',
  7.   `noticeTemplate` varchar(255)  DEFAULT '普通文字消息模版' COMMENT '模板文件名;',
  8.   `noticeName` varchar(255)  DEFAULT NULL COMMENT '消息名称',
  9.   `noticeContent` text  COMMENT '消息内容JSON; eg: {"content": "测试推送"}',
  10.   `noticeDetailContent` text  COMMENT '消息详情页内容JSON',
  11.   `isGeneratePush` varchar(255)  DEFAULT '否' COMMENT '是否生成推送数据;',
  12.   `createAt` varchar(255)  DEFAULT NULL COMMENT '创建任务时间;',
  13.   `schedulePushAt` varchar(255)  DEFAULT NULL COMMENT '计划推送时间; E.g: 2021-05-28T10:24:54+08:00',
  14.   `isPushByWxTemplate` varchar(255)  DEFAULT NULL COMMENT '是否使用微信模板消息推送',
  15.   `examId` varchar(255)  DEFAULT NULL COMMENT '成绩对应的考试ID',
  16.   `appId` varchar(255)  DEFAULT NULL COMMENT '消息来源业务ID',
  17.   `noticeBatchId` varchar(255)  DEFAULT NULL COMMENT '成绩通知生成批次编号',
  18.   `noticeData` varchar(255)  DEFAULT NULL COMMENT '消息业务数据',
  19.   `noticeStatus` varchar(255)  DEFAULT NULL COMMENT '消息状态：new-新建, draft-草稿, publish-发布',
  20.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  21.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者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.   UNIQUE KEY `task_unique` (`taskId`) USING BTREE
  26. ) ENGINE = InnoDB AUTO_INCREMENT = 45 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '通知任务表(学生维度)'

notice_template

  1. CREATE TABLE `notice_template` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `noticeTemplateId` varchar(255)  DEFAULT NULL,
  4.   `noticeTemplate` varchar(255)  DEFAULT NULL,
  5.   `noticeContent` text ,
  6.   `noticeDetailContent` text ,
  7.   `noticeTemplateStatus` varchar(255)  DEFAULT NULL,
  8.   `operation` varchar(255)  DEFAULT 'insert',
  9.   `operationByUserId` varchar(255)  DEFAULT NULL,
  10.   `operationByUser` varchar(255)  DEFAULT NULL,
  11.   `operationAt` varchar(255)  DEFAULT NULL,
  12.   PRIMARY KEY (`id`) USING BTREE
  13. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

student_exam_result_overall

  1. CREATE TABLE `student_exam_result_overall` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `year` varchar(255)  DEFAULT NULL,
  4.   `examId` varchar(255)  DEFAULT NULL COMMENT '考试ID',
  5.   `examName` varchar(255)  DEFAULT NULL COMMENT '考试名称',
  6.   `studentId` varchar(255)  DEFAULT NULL COMMENT '学生Id',
  7.   `name` varchar(255)  DEFAULT NULL COMMENT '学生姓名',
  8.   `academicYear` varchar(255)  DEFAULT NULL COMMENT '学年',
  9.   `semester` varchar(255)  DEFAULT NULL COMMENT '学期',
  10.   `segment` varchar(255)  DEFAULT NULL COMMENT '学部',
  11.   `level` varchar(255)  DEFAULT NULL COMMENT '年级',
  12.   `classId` varchar(255)  DEFAULT NULL COMMENT '班级',
  13.   `className` varchar(255)  DEFAULT NULL COMMENT '班级名称',
  14.   `classTagList` text  COMMENT '班级标签',
  15.   `totalScore` varchar(255)  DEFAULT NULL COMMENT '总分',
  16.   `overallClassRank` int(11) DEFAULT NULL COMMENT '班级排名',
  17.   `overallSchoolRank` int(11) DEFAULT NULL COMMENT '学校排名',
  18.   `overallClassPercentile` varchar(255)  DEFAULT NULL,
  19.   `overallSchoolPercentile` varchar(255)  DEFAULT NULL,
  20.   `attendance` varchar(255)  DEFAULT NULL COMMENT '出勤',
  21.   `remarks` text  COMMENT '备注',
  22.   `resultStatus` varchar(255)  DEFAULT NULL COMMENT '分数状态',
  23.   `resultUploadBatchId` varchar(255)  DEFAULT NULL COMMENT '成绩上传批次编号',
  24.   `resultUploadByUserId` varchar(255)  DEFAULT NULL COMMENT '成绩上传人',
  25.   `resultUploadByUser` varchar(255)  DEFAULT NULL COMMENT '成绩上传',
  26.   `resultUploadAt` varchar(255)  DEFAULT NULL,
  27.   `resultConfirmedByUserId` varchar(255)  DEFAULT NULL,
  28.   `resultConfirmedByUser` varchar(255)  DEFAULT NULL,
  29.   `resultConfirmedAt` varchar(255)  DEFAULT NULL,
  30.   `operation` varchar(255)  DEFAULT NULL,
  31.   `operationAt` varchar(255)  DEFAULT NULL,
  32.   `operationByUserId` varchar(255)  DEFAULT NULL,
  33.   `operationByUser` varchar(255)  DEFAULT NULL,
  34.   PRIMARY KEY (`id`) USING BTREE,
  35.   UNIQUE KEY `examId_studentId` (`examId`, `studentId`) USING BTREE,
  36.   KEY `examId` (`examId`) USING BTREE,
  37.   KEY `studentId` (`studentId`) USING BTREE
  38. ) ENGINE = InnoDB AUTO_INCREMENT = 19726 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

student_exam_result_subject

  1. CREATE TABLE `student_exam_result_subject` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `year` varchar(255)  DEFAULT NULL COMMENT '自然年',
  4.   `examId` varchar(255)  DEFAULT NULL COMMENT '考试ID',
  5.   `examName` varchar(255)  DEFAULT NULL COMMENT '考试名称',
  6.   `studentId` varchar(255)  DEFAULT NULL COMMENT '学生Id',
  7.   `name` varchar(255)  DEFAULT NULL COMMENT '学生姓名',
  8.   `academicYear` varchar(255)  DEFAULT NULL COMMENT '学年',
  9.   `semester` varchar(255)  DEFAULT NULL COMMENT '学期',
  10.   `segment` varchar(255)  DEFAULT NULL COMMENT '学部',
  11.   `level` varchar(255)  DEFAULT NULL COMMENT '年级',
  12.   `number` varchar(255)  DEFAULT NULL COMMENT '考试编号',
  13.   `classId` varchar(255)  DEFAULT NULL COMMENT '班级',
  14.   `className` varchar(255)  DEFAULT NULL COMMENT '班级名称',
  15.   `classTagList` varchar(255)  DEFAULT NULL COMMENT '班级标签',
  16.   `subjectId` varchar(255)  DEFAULT NULL COMMENT '科目ID',
  17.   `subjectName` varchar(255)  DEFAULT NULL COMMENT '科目',
  18.   `subjectSortOrder` varchar(255)  DEFAULT NULL COMMENT '科目排序',
  19.   `score` varchar(255)  DEFAULT NULL COMMENT '分数',
  20.   `subjectClassRank` varchar(255)  DEFAULT NULL COMMENT '班级排名',
  21.   `subjectSchoolRank` varchar(255)  DEFAULT NULL COMMENT '学校排名',
  22.   `scoreDetails` text  COMMENT '分数详情',
  23.   `resultStatus` varchar(255)  DEFAULT NULL COMMENT '分数状态',
  24.   `resultUploadBatchId` varchar(255)  DEFAULT NULL,
  25.   `resultUploadByUserId` varchar(255)  DEFAULT NULL,
  26.   `resultUploadByUser` varchar(255)  DEFAULT NULL,
  27.   `resultUploadAt` varchar(255)  DEFAULT NULL,
  28.   `resultConfirmedByUserId` varchar(255)  DEFAULT NULL,
  29.   `resultConfirmedByUser` varchar(255)  DEFAULT NULL,
  30.   `resultConfirmedAt` varchar(255)  DEFAULT NULL,
  31.   `operation` varchar(255)  DEFAULT NULL,
  32.   `operationAt` varchar(255)  DEFAULT NULL,
  33.   `operationByUserId` varchar(255)  DEFAULT NULL,
  34.   `operationByUser` varchar(255)  DEFAULT NULL,
  35.   PRIMARY KEY (`id`) USING BTREE,
  36.   UNIQUE KEY `examId_studentId_subjectId` (`examId`, `studentId`, `subjectId`) USING BTREE,
  37.   KEY `examId` (`examId`) USING BTREE,
  38.   KEY `studentId` (`studentId`) USING BTREE
  39. ) ENGINE = InnoDB AUTO_INCREMENT = 135309 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

视图

_directory_user_session

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_directory_user_session` AS
  2. select
  3.   `lms_data_repository`.`enterprise_directory_user_session`.`id` AS `id`,
  4.   `lms_data_repository`.`enterprise_directory_user_session`.`userId` AS `userId`,
  5.   `lms_data_repository`.`enterprise_directory_user_session`.`userIp` AS `userIp`,
  6.   `lms_data_repository`.`enterprise_directory_user_session`.`userIpRegion` AS `userIpRegion`,
  7.   `lms_data_repository`.`enterprise_directory_user_session`.`userAgent` AS `userAgent`,
  8.   `lms_data_repository`.`enterprise_directory_user_session`.`deviceId` AS `deviceId`,
  9.   `lms_data_repository`.`enterprise_directory_user_session`.`deviceType` AS `deviceType`,
  10.   `lms_data_repository`.`enterprise_directory_user_session`.`socketStatus` AS `socketStatus`,
  11.   `lms_data_repository`.`enterprise_directory_user_session`.`authToken` AS `authToken`,
  12.   `lms_data_repository`.`enterprise_directory_user_session`.`operation` AS `operation`,
  13.   `lms_data_repository`.`enterprise_directory_user_session`.`operationByUserId` AS `operationByUserId`,
  14.   `lms_data_repository`.`enterprise_directory_user_session`.`operationByUser` AS `operationByUser`,
  15.   `lms_data_repository`.`enterprise_directory_user_session`.`operationAt` AS `operationAt`
  16. from
  17.   `lms_data_repository`.`enterprise_directory_user_session`

_dr__class

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_dr__class` AS
  2. select
  3.   `c`.`id` AS `id`,
  4.   `c`.`year` AS `year`,
  5.   `c`.`academicYear` AS `academicYear`,
  6.   `c`.`semester` AS `semester`,
  7.   `c`.`segment` AS `segment`,
  8.   `c`.`level` AS `level`,
  9.   `c`.`number` AS `number`,
  10.   `c`.`classId` AS `classId`,
  11.   `c`.`className` AS `className`,
  12.   `c`.`classNum` AS `classNum`,
  13.   `c`.`formTeacherId` AS `formTeacherId`,
  14.   `c`.`formTeacherName` AS `formTeacherName`,
  15.   `c`.`formTeacherGender` AS `formTeacherGender`,
  16.   `c`.`formTeacherContact` AS `formTeacherContact`,
  17.   `c`.`learningTrack` AS `learningTrack`,
  18.   `c`.`classType` AS `classType`,
  19.   `c`.`classTagList` AS `classTagList`,
  20.   `c`.`classCreatedBy` AS `classCreatedBy`,
  21.   `c`.`remarks` AS `remarks`,
  22.   `c`.`classStatus` AS `classStatus`,
  23.   `c`.`operation` AS `operation`,
  24.   `c`.`operationByUserId` AS `operationByUserId`,
  25.   `c`.`operationByUser` AS `operationByUser`,
  26.   `c`.`operationAt` AS `operationAt`
  27. from
  28.   `lms_data_repository`.`lms_student_admin__class` `c`

_dr__notice_task

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_dr__notice_task` AS
  2. select
  3.   `n`.`id` AS `id`,
  4.   `n`.`idSequence` AS `idSequence`,
  5.   `n`.`taskId` AS `taskId`,
  6.   `n`.`studentId` AS `studentId`,
  7.   `n`.`studentName` AS `studentName`,
  8.   `n`.`noticeTemplate` AS `noticeTemplate`,
  9.   `n`.`noticeName` AS `noticeName`,
  10.   `n`.`noticeContent` AS `noticeContent`,
  11.   `n`.`noticeDetailContent` AS `noticeDetailContent`,
  12.   `n`.`isGeneratePush` AS `isGeneratePush`,
  13.   `n`.`createAt` AS `createAt`,
  14.   `n`.`schedulePushAt` AS `schedulePushAt`,
  15.   `n`.`isPushByWxTemplate` AS `isPushByWxTemplate`,
  16.   `n`.`appId` AS `appId`,
  17.   `n`.`noticeBatchId` AS `noticeBatchId`,
  18.   `n`.`noticeData` AS `noticeData`,
  19.   `n`.`recipientCount` AS `recipientCount`,
  20.   `n`.`noticeStatus` AS `noticeStatus`,
  21.   `n`.`operation` AS `operation`,
  22.   `n`.`operationByUserId` AS `operationByUserId`,
  23.   `n`.`operationByUser` AS `operationByUser`,
  24.   `n`.`operationAt` AS `operationAt`
  25. from
  26.   `lms_data_repository`.`lms_notice__notice_task` `n`

_dr__notice_task_push

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_dr__notice_task_push` AS
  2. select
  3.   `n`.`id` AS `id`,
  4.   `n`.`taskId` AS `taskId`,
  5.   `n`.`taskPushId` AS `taskPushId`,
  6.   `n`.`wechatOpenId` AS `wechatOpenId`,
  7.   `n`.`wechatOpenNickName` AS `wechatOpenNickName`,
  8.   `n`.`studentId` AS `studentId`,
  9.   `n`.`studentName` AS `studentName`,
  10.   `n`.`noticeTemplate` AS `noticeTemplate`,
  11.   `n`.`noticeName` AS `noticeName`,
  12.   `n`.`noticeContent` AS `noticeContent`,
  13.   `n`.`noticeDetailContent` AS `noticeDetailContent`,
  14.   `n`.`pushStatus` AS `pushStatus`,
  15.   `n`.`pushAt` AS `pushAt`,
  16.   `n`.`pushFailErrorReason` AS `pushFailErrorReason`,
  17.   `n`.`pushFailTimes` AS `pushFailTimes`,
  18.   `n`.`schedulePushAt` AS `schedulePushAt`,
  19.   `n`.`operation` AS `operation`,
  20.   `n`.`operationByUserId` AS `operationByUserId`,
  21.   `n`.`operationByUser` AS `operationByUser`,
  22.   `n`.`operationAt` AS `operationAt`
  23. from
  24.   `lms_data_repository`.`lms_notice__notice_task_push` `n`

_dr__student_basic

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_dr__student_basic` AS
  2. select
  3.   `s`.`id` AS `id`,
  4.   `s`.`enrollmentYear` AS `enrollmentYear`,
  5.   `s`.`enrollmentSemester` AS `enrollmentSemester`,
  6.   `s`.`enrollmentDate` AS `enrollmentDate`,
  7.   `s`.`studentId` AS `studentId`,
  8.   `s`.`classId` AS `classId`,
  9.   `s`.`idSequence` AS `idSequence`,
  10.   `s`.`enrollmentSegment` AS `enrollmentSegment`,
  11.   `s`.`enrollmentLevel` AS `enrollmentLevel`,
  12.   `s`.`enrollmentClassId` AS `enrollmentClassId`,
  13.   `s`.`name` AS `name`,
  14.   `s`.`gender` AS `gender`,
  15.   `s`.`studentStatus` AS `studentStatus`,
  16.   `s`.`icNumber` AS `icNumber`,
  17.   `s`.`scholarshipLevel` AS `scholarshipLevel`,
  18.   `s`.`requestType` AS `requestType`,
  19.   `s`.`afterSchoolCareType` AS `afterSchoolCareType`,
  20.   `s`.`residentialAddress` AS `residentialAddress`,
  21.   `s`.`guardian1Name` AS `guardian1Name`,
  22.   `s`.`guardian1Relationship` AS `guardian1Relationship`,
  23.   `s`.`guardian1Contact` AS `guardian1Contact`,
  24.   `s`.`guardian1ResidentialAddress` AS `guardian1ResidentialAddress`,
  25.   `s`.`guardian2Name` AS `guardian2Name`,
  26.   `s`.`guardian2Relationship` AS `guardian2Relationship`,
  27.   `s`.`guardian2Contact` AS `guardian2Contact`,
  28.   `s`.`guardian2ResidentialAddress` AS `guardian2ResidentialAddress`,
  29.   `s`.`remarks` AS `remarks`,
  30.   `s`.`newRemarks` AS `newRemarks`,
  31.   `s`.`hostelName` AS `hostelName`,
  32.   `s`.`hostelUnitNumber` AS `hostelUnitNumber`,
  33.   `s`.`hostelBedId` AS `hostelBedId`,
  34.   `s`.`dining_canteen_table` AS `dining_canteen_table`,
  35.   `s`.`completedEnrollmentRecordYesOrNo` AS `completedEnrollmentRecordYesOrNo`,
  36.   `s`.`completedClassAssignedYesOrNo` AS `completedClassAssignedYesOrNo`,
  37.   `s`.`completedLogisticsAssignedYesOrNo` AS `completedLogisticsAssignedYesOrNo`,
  38.   `s`.`completedPaymentYesOrNo` AS `completedPaymentYesOrNo`,
  39.   `s`.`completedEnrollmentYesOrNo` AS `completedEnrollmentYesOrNo`,
  40.   `s`.`completedQuitYesOrNo` AS `completedQuitYesOrNo`,
  41.   `s`.`compeletedUpgradeYesOrNo` AS `compeletedUpgradeYesOrNo`,
  42.   `s`.`enrolledBy` AS `enrolledBy`,
  43.   `s`.`classAssignedBy` AS `classAssignedBy`,
  44.   `s`.`paymentReceivedBy` AS `paymentReceivedBy`,
  45.   `s`.`checkPaymentStatusBy` AS `checkPaymentStatusBy`,
  46.   `s`.`hostelAssignedBy` AS `hostelAssignedBy`,
  47.   `s`.`enrollmentApprovedBy` AS `enrollmentApprovedBy`,
  48.   `s`.`quitApprovedBy` AS `quitApprovedBy`,
  49.   `s`.`operation` AS `operation`,
  50.   `s`.`operationAt` AS `operationAt`,
  51.   `s`.`operationByUserId` AS `operationByUserId`,
  52.   `s`.`operationByUser` AS `operationByUser`,
  53.   `s`.`completedQuitAssignedYesOrNo` AS `completedQuitAssignedYesOrNo`,
  54.   `s`.`quitHostelAssignedBy` AS `quitHostelAssignedBy`,
  55.   `s`.`completedQuitPaymentYesOrNo` AS `completedQuitPaymentYesOrNo`,
  56.   `s`.`middleSchoolExamScore` AS `middleSchoolExamScore`,
  57.   `s`.`middleSchoolExamSequence` AS `middleSchoolExamSequence`,
  58.   `s`.`quitPaymentBy` AS `quitPaymentBy`
  59. from
  60.   `lms_data_repository`.`lms_student_admin__student_basic` `s`

_group

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_group` AS
  2. select
  3.   `lms_data_repository`.`enterprise_group`.`id` AS `id`,
  4.   `lms_data_repository`.`enterprise_group`.`groupId` AS `groupId`,
  5.   `lms_data_repository`.`enterprise_group`.`groupLastId` AS `groupLastId`,
  6.   `lms_data_repository`.`enterprise_group`.`groupPath` AS `groupPath`,
  7.   `lms_data_repository`.`enterprise_group`.`groupName` AS `groupName`,
  8.   `lms_data_repository`.`enterprise_group`.`groupDeptName` AS `groupDeptName`,
  9.   `lms_data_repository`.`enterprise_group`.`groupAllName` AS `groupAllName`,
  10.   `lms_data_repository`.`enterprise_group`.`principalId` AS `principalId`,
  11.   `lms_data_repository`.`enterprise_group`.`headId` AS `headId`,
  12.   `lms_data_repository`.`enterprise_group`.`leadId` AS `leadId`,
  13.   `lms_data_repository`.`enterprise_group`.`groupDesc` AS `groupDesc`,
  14.   `lms_data_repository`.`enterprise_group`.`operation` AS `operation`,
  15.   `lms_data_repository`.`enterprise_group`.`operationByUserId` AS `operationByUserId`,
  16.   `lms_data_repository`.`enterprise_group`.`operationByUser` AS `operationByUser`,
  17.   `lms_data_repository`.`enterprise_group`.`operationAt` AS `operationAt`
  18. from
  19.   `lms_data_repository`.`enterprise_group`

_role

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_role` AS
  2. select
  3.   `lms_data_repository`.`enterprise_role`.`id` AS `id`,
  4.   `lms_data_repository`.`enterprise_role`.`roleId` AS `roleId`,
  5.   `lms_data_repository`.`enterprise_role`.`roleName` AS `roleName`,
  6.   `lms_data_repository`.`enterprise_role`.`roleType` AS `roleType`,
  7.   `lms_data_repository`.`enterprise_role`.`roleDesc` AS `roleDesc`,
  8.   `lms_data_repository`.`enterprise_role`.`operation` AS `operation`,
  9.   `lms_data_repository`.`enterprise_role`.`operationByUserId` AS `operationByUserId`,
  10.   `lms_data_repository`.`enterprise_role`.`operationByUser` AS `operationByUser`,
  11.   `lms_data_repository`.`enterprise_role`.`operationAt` AS `operationAt`
  12. from
  13.   `lms_data_repository`.`enterprise_role`

_user_group_role

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_user_group_role` AS
  2. select
  3.   `lms_data_repository`.`enterprise_user_group_role`.`id` AS `id`,
  4.   `lms_data_repository`.`enterprise_user_group_role`.`userId` AS `userId`,
  5.   `lms_data_repository`.`enterprise_user_group_role`.`groupId` AS `groupId`,
  6.   `lms_data_repository`.`enterprise_user_group_role`.`roleId` AS `roleId`,
  7.   `lms_data_repository`.`enterprise_user_group_role`.`roleDeadline` AS `roleDeadline`,
  8.   `lms_data_repository`.`enterprise_user_group_role`.`operation` AS `operation`,
  9.   `lms_data_repository`.`enterprise_user_group_role`.`operationByUserId` AS `operationByUserId`,
  10.   `lms_data_repository`.`enterprise_user_group_role`.`operationByUser` AS `operationByUser`,
  11.   `lms_data_repository`.`enterprise_user_group_role`.`operationAt` AS `operationAt`
  12. from
  13.   `lms_data_repository`.`enterprise_user_group_role`

_user_group_role_page

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_user_group_role_page` AS
  2. select
  3.   `lms_data_repository`.`enterprise_user_group_role_page`.`id` AS `id`,
  4.   `lms_data_repository`.`enterprise_user_group_role_page`.`appId` AS `appId`,
  5.   `lms_data_repository`.`enterprise_user_group_role_page`.`user` AS `user`,
  6.   `lms_data_repository`.`enterprise_user_group_role_page`.`group` AS `group`,
  7.   `lms_data_repository`.`enterprise_user_group_role_page`.`role` AS `role`,
  8.   `lms_data_repository`.`enterprise_user_group_role_page`.`page` AS `page`,
  9.   `lms_data_repository`.`enterprise_user_group_role_page`.`allowOrDeny` AS `allowOrDeny`,
  10.   `lms_data_repository`.`enterprise_user_group_role_page`.`desc` AS `desc`,
  11.   `lms_data_repository`.`enterprise_user_group_role_page`.`source` AS `source`,
  12.   `lms_data_repository`.`enterprise_user_group_role_page`.`operation` AS `operation`,
  13.   `lms_data_repository`.`enterprise_user_group_role_page`.`operationByUserId` AS `operationByUserId`,
  14.   `lms_data_repository`.`enterprise_user_group_role_page`.`operationByUser` AS `operationByUser`,
  15.   `lms_data_repository`.`enterprise_user_group_role_page`.`operationAt` AS `operationAt`
  16. from
  17.   `lms_data_repository`.`enterprise_user_group_role_page`
  18. where
  19.   (
  20.     (
  21.       `lms_data_repository`.`enterprise_user_group_role_page`.`appId` = 'lms-exam'
  22.     )
  23.     or (
  24.       `lms_data_repository`.`enterprise_user_group_role_page`.`appId` = '*'
  25.     )
  26.   )

_user_group_role_resource

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_user_group_role_resource` AS
  2. select
  3.   `lms_data_repository`.`enterprise_user_group_role_resource`.`id` AS `id`,
  4.   `lms_data_repository`.`enterprise_user_group_role_resource`.`appId` AS `appId`,
  5.   `lms_data_repository`.`enterprise_user_group_role_resource`.`user` AS `user`,
  6.   `lms_data_repository`.`enterprise_user_group_role_resource`.`group` AS `group`,
  7.   `lms_data_repository`.`enterprise_user_group_role_resource`.`role` AS `role`,
  8.   `lms_data_repository`.`enterprise_user_group_role_resource`.`resource` AS `resource`,
  9.   `lms_data_repository`.`enterprise_user_group_role_resource`.`allowOrDeny` AS `allowOrDeny`,
  10.   `lms_data_repository`.`enterprise_user_group_role_resource`.`desc` AS `desc`,
  11.   `lms_data_repository`.`enterprise_user_group_role_resource`.`source` AS `source`,
  12.   `lms_data_repository`.`enterprise_user_group_role_resource`.`operation` AS `operation`,
  13.   `lms_data_repository`.`enterprise_user_group_role_resource`.`operationByUserId` AS `operationByUserId`,
  14.   `lms_data_repository`.`enterprise_user_group_role_resource`.`operationByUser` AS `operationByUser`,
  15.   `lms_data_repository`.`enterprise_user_group_role_resource`.`operationAt` AS `operationAt`
  16. from
  17.   `lms_data_repository`.`enterprise_user_group_role_resource`
  18. where
  19.   (
  20.     (
  21.       `lms_data_repository`.`enterprise_user_group_role_resource`.`appId` = 'lms-exam'
  22.     )
  23.     or (
  24.       `lms_data_repository`.`enterprise_user_group_role_resource`.`appId` = '*'
  25.     )
  26.   )

_view01_user

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_view01_user` AS
  2. select
  3.   `lms_data_repository`.`enterprise_view01_user`.`id` AS `id`,
  4.   `lms_data_repository`.`enterprise_view01_user`.`idSequence` AS `idSequence`,
  5.   `lms_data_repository`.`enterprise_view01_user`.`userId` AS `userId`,
  6.   `lms_data_repository`.`enterprise_view01_user`.`username` AS `username`,
  7.   `lms_data_repository`.`enterprise_view01_user`.`phoneNumber` AS `phoneNumber`,
  8.   `lms_data_repository`.`enterprise_view01_user`.`email` AS `email`,
  9.   `lms_data_repository`.`enterprise_view01_user`.`userStatus` AS `userStatus`,
  10.   `lms_data_repository`.`enterprise_view01_user`.`qiweiId` AS `qiweiId`,
  11.   `lms_data_repository`.`enterprise_view01_user`.`userConfig` AS `userConfig`,
  12.   `lms_data_repository`.`enterprise_view01_user`.`password` AS `password`,
  13.   `lms_data_repository`.`enterprise_view01_user`.`md5Salt` AS `md5Salt`,
  14.   `lms_data_repository`.`enterprise_view01_user`.`clearTextPassword` AS `clearTextPassword`,
  15.   `lms_data_repository`.`enterprise_view01_user`.`operation` AS `operation`,
  16.   `lms_data_repository`.`enterprise_view01_user`.`operationByUserId` AS `operationByUserId`,
  17.   `lms_data_repository`.`enterprise_view01_user`.`operationByUser` AS `operationByUser`,
  18.   `lms_data_repository`.`enterprise_view01_user`.`operationAt` AS `operationAt`
  19. from
  20.   `lms_data_repository`.`enterprise_view01_user`

_view02_user_app

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
  2. select
  3.   `lms_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  4.   `lms_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  5.   `lms_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
  6. from
  7.   `lms_data_repository`.`enterprise_view02_user_app`
  8. where
  9.   (
  10.     `lms_data_repository`.`enterprise_view02_user_app`.`appId` = 'lms-exam'
  11.   )

view01_exam

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_exam` AS
  2. select
  3.   `e`.`id` AS `id`,
  4.   `e`.`examId` AS `examId`,
  5.   `e`.`examName` AS `examName`,
  6.   `e`.`semester` AS `semester`,
  7.   `e`.`year` AS `year`,
  8.   `e`.`academicYear` AS `academicYear`,
  9.   `e`.`segment` AS `segment`,
  10.   `e`.`level` AS `level`,
  11.   `e`.`examType` AS `examType`,
  12.   `e`.`learningTrack` AS `learningTrack`,
  13.   `e`.`subjectCount` AS `subjectCount`,
  14.   `e`.`subjectList` AS `subjectList`,
  15.   `e`.`subjectFullScore` AS `subjectFullScore`,
  16.   `e`.`startDate` AS `startDate`,
  17.   `e`.`endDate` AS `endDate`,
  18.   `e`.`startMonth` AS `startMonth`,
  19.   `e`.`subjectFullScoreList` AS `subjectFullScoreList`,
  20.   `e`.`description` AS `description`,
  21.   `e`.`isSendNotice` AS `isSendNotice`,
  22.   `e`.`examStatus` AS `examStatus`,
  23.   `e`.`examResultStatus` AS `examResultStatus`,
  24.   `e`.`noticeTemplate` AS `noticeTemplate`,
  25.   `e`.`noticeContent` AS `noticeContent`,
  26.   `e`.`noticeDetailContent` AS `noticeDetailContent`,
  27.   `e`.`noticeBatchId` AS `noticeBatchId`,
  28.   `e`.`noticeCount` AS `noticeCount`,
  29.   `e`.`restulUploadBatchId` AS `restulUploadBatchId`,
  30.   `e`.`operation` AS `operation`,
  31.   `e`.`operationAt` AS `operationAt`,
  32.   `e`.`operationByUserId` AS `operationByUserId`,
  33.   `e`.`operationByUser` AS `operationByUser`,
  34.   count(`ro`.`studentId`) AS `studentCount`
  35. from
  36.   (
  37.     `exam` `e`
  38.     left join `student_exam_result_overall` `ro` on ((`e`.`examId` = `ro`.`examId`))
  39.   )
  40. where
  41.   (`e`.`examStatus` <> '已作废')
  42. group by
  43.   `e`.`examId`

view01_notice_task

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_notice_task` AS
  2. select
  3.   `nexam`.`id` AS `id`,
  4.   `nexam`.`idSequence` AS `idSequence`,
  5.   `nexam`.`taskId` AS `taskId`,
  6.   `nexam`.`studentId` AS `studentId`,
  7.   `nexam`.`studentName` AS `studentName`,
  8.   `nexam`.`noticeTemplate` AS `noticeTemplate`,
  9.   `nexam`.`noticeName` AS `noticeName`,
  10.   `nexam`.`noticeContent` AS `noticeContent`,
  11.   `nexam`.`noticeDetailContent` AS `noticeDetailContent`,
  12.   `nexam`.`isGeneratePush` AS `isGeneratePush`,
  13.   `nexam`.`createAt` AS `createAt`,
  14.   `nexam`.`schedulePushAt` AS `schedulePushAt`,
  15.   `nexam`.`isPushByWxTemplate` AS `isPushByWxTemplate`,
  16.   `nexam`.`examId` AS `examId`,
  17.   `nexam`.`appId` AS `appId`,
  18.   `nexam`.`noticeBatchId` AS `noticeBatchId`,
  19.   `nexam`.`noticeData` AS `noticeData`,
  20.   `nexam`.`noticeStatus` AS `noticeStatus`,
  21.   `nexam`.`operation` AS `operation`,
  22.   `nexam`.`operationByUserId` AS `operationByUserId`,
  23.   `nexam`.`operationByUser` AS `operationByUser`,
  24.   `nexam`.`operationAt` AS `operationAt`,
  25.   if(isnull(`n`.`id`), '否', '是') AS `isCollected`
  26. from
  27.   (
  28.     `lms_exam`.`notice_task` `nexam`
  29.     left join `lms_exam`.`_dr__notice_task` `n` on ((`nexam`.`taskId` = `n`.`taskId`))
  30.   )

view01_student

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_student` AS
  2. select
  3.   `s`.`id` AS `id`,
  4.   `s`.`studentId` AS `studentId`,
  5.   `s`.`idSequence` AS `idSequence`,
  6.   `s`.`name` AS `name`,
  7.   `s`.`classId` AS `classId`,
  8.   `c`.`className` AS `className`,
  9.   `c`.`classTagList` AS `classTagList`,
  10.   `c`.`segment` AS `segment`,
  11.   `c`.`level` AS `level`,
  12.   `s`.`studentStatus` AS `studentStatus`,
  13.   `s`.`remarks` AS `remarks`,
  14.   `s`.`operation` AS `operation`,
  15.   `s`.`operationByUserId` AS `operationByUserId`,
  16.   `s`.`operationByUser` AS `operationByUser`,
  17.   `s`.`operationAt` AS `operationAt`
  18. from
  19.   (
  20.     `lms_exam`.`_dr__student_basic` `s`
  21.     left join `lms_exam`.`_dr__class` `c` on (
  22.       (
  23.         convert(`s`.`classId` using utf8mb4) = `c`.`classId`
  24.       )
  25.     )
  26.   )

view01_student_exam_result_overall

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_student_exam_result_overall` AS
  2. select
  3.   `student_exam_result_overall`.`id` AS `id`,
  4.   `student_exam_result_overall`.`year` AS `year`,
  5.   `student_exam_result_overall`.`examId` AS `examId`,
  6.   `student_exam_result_overall`.`examName` AS `examName`,
  7.   `student_exam_result_overall`.`studentId` AS `studentId`,
  8.   `student_exam_result_overall`.`name` AS `name`,
  9.   `student_exam_result_overall`.`academicYear` AS `academicYear`,
  10.   `student_exam_result_overall`.`semester` AS `semester`,
  11.   `student_exam_result_overall`.`segment` AS `segment`,
  12.   `student_exam_result_overall`.`level` AS `level`,
  13.   `student_exam_result_overall`.`classId` AS `classId`,
  14.   `student_exam_result_overall`.`className` AS `className`,
  15.   `student_exam_result_overall`.`classTagList` AS `classTagList`,
  16.   `student_exam_result_overall`.`totalScore` AS `totalScore`,
  17.   `student_exam_result_overall`.`overallClassRank` AS `overallClassRank`,
  18.   `student_exam_result_overall`.`overallSchoolRank` AS `overallSchoolRank`,
  19.   `student_exam_result_overall`.`overallClassPercentile` AS `overallClassPercentile`,
  20.   `student_exam_result_overall`.`overallSchoolPercentile` AS `overallSchoolPercentile`,
  21.   `student_exam_result_overall`.`attendance` AS `attendance`,
  22.   `student_exam_result_overall`.`remarks` AS `remarks`,
  23.   `student_exam_result_overall`.`resultStatus` AS `resultStatus`,
  24.   `student_exam_result_overall`.`resultUploadBatchId` AS `resultUploadBatchId`,
  25.   `student_exam_result_overall`.`resultUploadByUserId` AS `resultUploadByUserId`,
  26.   `student_exam_result_overall`.`resultUploadByUser` AS `resultUploadByUser`,
  27.   `student_exam_result_overall`.`resultUploadAt` AS `resultUploadAt`,
  28.   `student_exam_result_overall`.`resultConfirmedByUserId` AS `resultConfirmedByUserId`,
  29.   `student_exam_result_overall`.`resultConfirmedByUser` AS `resultConfirmedByUser`,
  30.   `student_exam_result_overall`.`resultConfirmedAt` AS `resultConfirmedAt`,
  31.   `student_exam_result_overall`.`operation` AS `operation`,
  32.   `student_exam_result_overall`.`operationAt` AS `operationAt`,
  33.   `student_exam_result_overall`.`operationByUserId` AS `operationByUserId`,
  34.   `student_exam_result_overall`.`operationByUser` AS `operationByUser`,
  35.   `exam`.`startDate` AS `examStartDate`
  36. from
  37.   (
  38.     `student_exam_result_overall`
  39.     left join `exam` on (
  40.       (
  41.         `student_exam_result_overall`.`examId` = `exam`.`examId`
  42.       )
  43.     )
  44.   )

view01_student_exam_result_subject

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_student_exam_result_subject` AS
  2. select
  3.   `student_exam_result_subject`.`id` AS `id`,
  4.   `student_exam_result_subject`.`year` AS `year`,
  5.   `student_exam_result_subject`.`examId` AS `examId`,
  6.   `student_exam_result_subject`.`examName` AS `examName`,
  7.   `student_exam_result_subject`.`studentId` AS `studentId`,
  8.   `student_exam_result_subject`.`name` AS `name`,
  9.   `student_exam_result_subject`.`academicYear` AS `academicYear`,
  10.   `student_exam_result_subject`.`semester` AS `semester`,
  11.   `student_exam_result_subject`.`segment` AS `segment`,
  12.   `student_exam_result_subject`.`level` AS `level`,
  13.   `student_exam_result_subject`.`number` AS `number`,
  14.   `student_exam_result_subject`.`classId` AS `classId`,
  15.   `student_exam_result_subject`.`className` AS `className`,
  16.   `student_exam_result_subject`.`classTagList` AS `classTagList`,
  17.   `student_exam_result_subject`.`subjectId` AS `subjectId`,
  18.   `student_exam_result_subject`.`subjectName` AS `subjectName`,
  19.   `student_exam_result_subject`.`subjectSortOrder` AS `subjectSortOrder`,
  20.   `student_exam_result_subject`.`score` AS `score`,
  21.   `student_exam_result_subject`.`subjectClassRank` AS `subjectClassRank`,
  22.   `student_exam_result_subject`.`subjectSchoolRank` AS `subjectSchoolRank`,
  23.   `student_exam_result_subject`.`scoreDetails` AS `scoreDetails`,
  24.   `student_exam_result_subject`.`resultStatus` AS `resultStatus`,
  25.   `student_exam_result_subject`.`resultUploadBatchId` AS `resultUploadBatchId`,
  26.   `student_exam_result_subject`.`resultUploadByUserId` AS `resultUploadByUserId`,
  27.   `student_exam_result_subject`.`resultUploadByUser` AS `resultUploadByUser`,
  28.   `student_exam_result_subject`.`resultUploadAt` AS `resultUploadAt`,
  29.   `student_exam_result_subject`.`resultConfirmedByUserId` AS `resultConfirmedByUserId`,
  30.   `student_exam_result_subject`.`resultConfirmedByUser` AS `resultConfirmedByUser`,
  31.   `student_exam_result_subject`.`resultConfirmedAt` AS `resultConfirmedAt`,
  32.   `student_exam_result_subject`.`operation` AS `operation`,
  33.   `student_exam_result_subject`.`operationAt` AS `operationAt`,
  34.   `student_exam_result_subject`.`operationByUserId` AS `operationByUserId`,
  35.   `student_exam_result_subject`.`operationByUser` AS `operationByUser`,
  36.   `exam`.`startDate` AS `examStartDate`
  37. from
  38.   (
  39.     `student_exam_result_subject`
  40.     left join `exam` on (
  41.       (
  42.         `student_exam_result_subject`.`examId` = `exam`.`examId`
  43.       )
  44.     )
  45.   )

view02_exam_with_notice_count

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view02_exam_with_notice_count` AS
  2. select
  3.   `e`.`id` AS `id`,
  4.   `e`.`examId` AS `examId`,
  5.   `e`.`examName` AS `examName`,
  6.   `e`.`semester` AS `semester`,
  7.   `e`.`academicYear` AS `academicYear`,
  8.   `e`.`segment` AS `segment`,
  9.   `e`.`level` AS `level`,
  10.   `e`.`examType` AS `examType`,
  11.   `e`.`subjectCount` AS `subjectCount`,
  12.   `e`.`subjectList` AS `subjectList`,
  13.   `e`.`description` AS `description`,
  14.   `e`.`isSendNotice` AS `isSendNotice`,
  15.   `e`.`examStatus` AS `examStatus`,
  16.   `e`.`examResultStatus` AS `examResultStatus`,
  17.   `e`.`noticeTemplate` AS `noticeTemplate`,
  18.   `e`.`noticeContent` AS `noticeContent`,
  19.   `e`.`noticeDetailContent` AS `noticeDetailContent`,
  20.   `e`.`noticeBatchId` AS `noticeBatchId`,
  21.   `e`.`operation` AS `operation`,
  22.   `e`.`operationAt` AS `operationAt`,
  23.   `e`.`operationByUserId` AS `operationByUserId`,
  24.   `e`.`operationByUser` AS `operationByUser`,
  25.   `e`.`studentCount` AS `studentCount`,
  26.   count(`n`.`taskId`) AS `noticeCount`
  27. from
  28.   (
  29.     (
  30.       `view01_exam` `e`
  31.       left join `student_exam_result_overall` `ro` on ((`e`.`examId` = `ro`.`examId`))
  32.     )
  33.     left join `notice_task` `n` on ((`e`.`examId` = `n`.`examId`))
  34.   )
  35. group by
  36.   `e`.`examId`