数据结构

12114

表总览

普通表

_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 = 5 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,
  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 = 18 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 = 4 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 = 47 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource_request_log

  • 文件表; 软删除未启用;
  1. CREATE TABLE `_resource_request_log` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `resourceId` varchar(255) DEFAULT NULL COMMENT 'resource id;',
  4. `packageId` varchar(255) DEFAULT NULL COMMENT 'resource package id',
  5. `userIp` varchar(255) DEFAULT NULL COMMENT '用户ip;',
  6. `userAgent` varchar(255) DEFAULT NULL COMMENT '设备信息',
  7. `userId` varchar(255) DEFAULT NULL COMMENT '用户ID',
  8. `deviceId` varchar(255) DEFAULT NULL COMMENT '设备id',
  9. `userIpRegion` varchar(255) DEFAULT NULL COMMENT '用户Ip区域',
  10. `executeSql` varchar(255) DEFAULT NULL COMMENT '执行的sql',
  11. `requestBody` longtext COMMENT '请求body',
  12. `responseBody` longtext COMMENT '响应body',
  13. `responseStatus` varchar(255) DEFAULT NULL COMMENT '执行的结果; success, fail',
  14. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  15. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  16. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  17. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  18. PRIMARY KEY (`id`) USING BTREE,
  19. KEY `resourceId_index` (`resourceId`) USING BTREE,
  20. KEY `packageId_index` (`packageId`) USING BTREE
  21. ) 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 AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'ui 施工方案'

_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 = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户session表; deviceId 维度;软删除未启用;'

appraisal

  • 周期测评
  1. CREATE TABLE `appraisal` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `idSequence` varchar(255) DEFAULT NULL COMMENT '顺序号',
  4. `appraisalId` varchar(255) DEFAULT NULL COMMENT '评价ID',
  5. `appraisalName` varchar(255) DEFAULT NULL COMMENT '名称',
  6. `appraisalCategory` varchar(255) DEFAULT NULL COMMENT '评语类别',
  7. `year` varchar(255) DEFAULT NULL COMMENT '自然年',
  8. `semester` varchar(255) DEFAULT NULL COMMENT '学期',
  9. `segment` varchar(255) DEFAULT NULL COMMENT '学部',
  10. `level` varchar(255) DEFAULT NULL COMMENT '年级',
  11. `number` varchar(255) DEFAULT NULL COMMENT '班级号',
  12. `classId` varchar(255) DEFAULT NULL COMMENT '班级ID',
  13. `className` varchar(255) DEFAULT NULL,
  14. `appraisalDate` varchar(255) DEFAULT NULL COMMENT '评语日期',
  15. `description` text COMMENT '简介',
  16. `isSendNotice` varchar(255) DEFAULT NULL COMMENT '发送状态',
  17. `sendCount` varchar(255) DEFAULT NULL COMMENT '发送计数',
  18. `operation` varchar(255) DEFAULT NULL,
  19. `operationAt` varchar(255) DEFAULT NULL,
  20. `operationByUserId` varchar(255) DEFAULT NULL,
  21. `operationByUser` varchar(255) DEFAULT NULL,
  22. PRIMARY KEY (`id`) USING BTREE,
  23. UNIQUE KEY `appraisalId` (`appraisalId`) USING BTREE
  24. ) ENGINE = InnoDB AUTO_INCREMENT = 29 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '周期测评'

appraisal_student

  1. CREATE TABLE `appraisal_student` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `appraisalStudentId` int(11) DEFAULT NULL,
  4. `studentId` varchar(255) DEFAULT NULL COMMENT '学生ID',
  5. `studentName` varchar(255) DEFAULT NULL COMMENT '学生姓名',
  6. `level` varchar(255) DEFAULT NULL COMMENT '年级ID',
  7. `classId` varchar(255) DEFAULT NULL COMMENT '班级ID',
  8. `className` varchar(255) DEFAULT NULL COMMENT '班级名称',
  9. `teacherId` varchar(255) DEFAULT NULL COMMENT '班主任',
  10. `teacherName` varchar(255) DEFAULT NULL COMMENT '班主任姓名',
  11. `appraisalId` varchar(255) DEFAULT NULL,
  12. `comment` text COMMENT '评语',
  13. `commentMap` text COMMENT '评语结构配置',
  14. `matter` varchar(255) DEFAULT NULL,
  15. `commentDate` varchar(255) DEFAULT NULL,
  16. `commentById` varchar(255) DEFAULT NULL,
  17. `commentByName` varchar(255) DEFAULT NULL,
  18. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  19. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  20. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  21. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  22. PRIMARY KEY (`id`) USING BTREE
  23. ) ENGINE = InnoDB AUTO_INCREMENT = 5280 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

comment_for_student_copy1

  1. CREATE TABLE `comment_for_student_copy1` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `studentId` varchar(255) DEFAULT NULL,
  4. `studentName` varchar(255) DEFAULT NULL,
  5. `classId` varchar(255) DEFAULT NULL,
  6. `comment` text ,
  7. `matter` varchar(255) DEFAULT NULL,
  8. `commentDate` varchar(255) DEFAULT NULL,
  9. `commentById` varchar(255) DEFAULT NULL,
  10. `commentByName` varchar(255) DEFAULT NULL,
  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. ) 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. `appraisalId` varchar(255) DEFAULT NULL,
  6. `studentId` varchar(255) DEFAULT NULL COMMENT '学生ID',
  7. `studentName` varchar(255) DEFAULT NULL COMMENT '学生名',
  8. `noticeTemplate` varchar(255) DEFAULT '普通文字消息模版' COMMENT '模板文件名;',
  9. `noticeName` varchar(255) DEFAULT NULL COMMENT '消息名称',
  10. `noticeContent` text COMMENT '消息内容JSON; eg: {"content": "测试推送"}',
  11. `noticeDetailContent` text COMMENT '消息详情页内容JSON',
  12. `isGeneratePush` varchar(255) DEFAULT '否' COMMENT '是否生成推送数据;',
  13. `createAt` varchar(255) DEFAULT NULL COMMENT '创建任务时间;',
  14. `schedulePushAt` varchar(255) DEFAULT NULL COMMENT '计划推送时间; E.g: 2021-05-28T10:24:54+08:00',
  15. `isPushByWxTemplate` varchar(255) DEFAULT NULL COMMENT '是否使用微信模板消息推送',
  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 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 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`

_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-mentor'
  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-mentor'
  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-mentor'
  11. )

view01_class

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

view01_class_all

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_class_all` AS
  2. select
  3. `lms_student_admin`.`class`.`id` AS `id`,
  4. `lms_student_admin`.`class`.`year` AS `year`,
  5. `lms_student_admin`.`class`.`academicYear` AS `academicYear`,
  6. `lms_student_admin`.`class`.`semester` AS `semester`,
  7. `lms_student_admin`.`class`.`segment` AS `segment`,
  8. `lms_student_admin`.`class`.`level` AS `level`,
  9. `lms_student_admin`.`class`.`number` AS `number`,
  10. `lms_student_admin`.`class`.`classId` AS `classId`,
  11. `lms_student_admin`.`class`.`className` AS `className`,
  12. `lms_student_admin`.`class`.`classNum` AS `classNum`,
  13. `lms_student_admin`.`class`.`formTeacherId` AS `formTeacherId`,
  14. `lms_student_admin`.`class`.`formTeacherName` AS `formTeacherName`,
  15. `lms_student_admin`.`class`.`formTeacherGender` AS `formTeacherGender`,
  16. `lms_student_admin`.`class`.`formTeacherContact` AS `formTeacherContact`,
  17. `lms_student_admin`.`class`.`learningTrack` AS `learningTrack`,
  18. `lms_student_admin`.`class`.`classType` AS `classType`,
  19. `lms_student_admin`.`class`.`classTagList` AS `classTagList`,
  20. `lms_student_admin`.`class`.`classCreatedBy` AS `classCreatedBy`,
  21. `lms_student_admin`.`class`.`remarks` AS `remarks`,
  22. `lms_student_admin`.`class`.`classStatus` AS `classStatus`,
  23. `lms_student_admin`.`class`.`operation` AS `operation`,
  24. `lms_student_admin`.`class`.`operationByUserId` AS `operationByUserId`,
  25. `lms_student_admin`.`class`.`operationByUser` AS `operationByUser`,
  26. `lms_student_admin`.`class`.`operationAt` AS `operationAt`
  27. from
  28. `lms_student_admin`.`class`
  29. union
  30. select
  31. `lms_student_admin`.`class_history`.`id` AS `id`,
  32. `lms_student_admin`.`class_history`.`year` AS `year`,
  33. `lms_student_admin`.`class_history`.`academicYear` AS `academicYear`,
  34. `lms_student_admin`.`class_history`.`semester` AS `semester`,
  35. `lms_student_admin`.`class_history`.`segment` AS `segment`,
  36. `lms_student_admin`.`class_history`.`level` AS `level`,
  37. `lms_student_admin`.`class_history`.`number` AS `number`,
  38. `lms_student_admin`.`class_history`.`classId` AS `classId`,
  39. `lms_student_admin`.`class_history`.`className` AS `className`,
  40. `lms_student_admin`.`class_history`.`classNum` AS `classNum`,
  41. `lms_student_admin`.`class_history`.`formTeacherId` AS `formTeacherId`,
  42. `lms_student_admin`.`class_history`.`formTeacherName` AS `formTeacherName`,
  43. `lms_student_admin`.`class_history`.`formTeacherGender` AS `formTeacherGender`,
  44. `lms_student_admin`.`class_history`.`formTeacherContact` AS `formTeacherContact`,
  45. `lms_student_admin`.`class_history`.`learningTrack` AS `learningTrack`,
  46. `lms_student_admin`.`class_history`.`classType` AS `classType`,
  47. `lms_student_admin`.`class_history`.`classTagList` AS `classTagList`,
  48. `lms_student_admin`.`class_history`.`classCreatedBy` AS `classCreatedBy`,
  49. `lms_student_admin`.`class_history`.`remarks` AS `remarks`,
  50. `lms_student_admin`.`class_history`.`classStatus` AS `classStatus`,
  51. `lms_student_admin`.`class_history`.`operation` AS `operation`,
  52. `lms_student_admin`.`class_history`.`operationByUserId` AS `operationByUserId`,
  53. `lms_student_admin`.`class_history`.`operationByUser` AS `operationByUser`,
  54. `lms_student_admin`.`class_history`.`operationAt` AS `operationAt`
  55. from
  56. `lms_student_admin`.`class_history`

view02_appraisal

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view02_appraisal` AS
  2. select
  3. `lms_mentor`.`appraisal`.`id` AS `id`,
  4. `lms_mentor`.`appraisal`.`idSequence` AS `idSequence`,
  5. `lms_mentor`.`appraisal`.`appraisalId` AS `appraisalId`,
  6. `lms_mentor`.`appraisal`.`appraisalName` AS `appraisalName`,
  7. `lms_mentor`.`appraisal`.`year` AS `year`,
  8. `lms_mentor`.`appraisal`.`semester` AS `semester`,
  9. `lms_mentor`.`appraisal`.`segment` AS `segment`,
  10. `lms_mentor`.`appraisal`.`level` AS `level`,
  11. `lms_mentor`.`appraisal`.`number` AS `number`,
  12. `lms_mentor`.`appraisal`.`className` AS `className`,
  13. `lms_mentor`.`appraisal`.`appraisalDate` AS `appraisalDate`,
  14. `lms_mentor`.`appraisal`.`description` AS `description`,
  15. `lms_mentor`.`appraisal`.`isSendNotice` AS `isSendNotice`,
  16. `lms_mentor`.`appraisal`.`sendCount` AS `sendCount`,
  17. `lms_mentor`.`appraisal`.`operation` AS `operation`,
  18. `lms_mentor`.`appraisal`.`operationAt` AS `operationAt`,
  19. `lms_mentor`.`appraisal`.`operationByUserId` AS `operationByUserId`,
  20. `lms_mentor`.`appraisal`.`operationByUser` AS `operationByUser`,
  21. `lms_mentor`.`appraisal`.`classId` AS `classId`,
  22. group_concat(
  23. distinct `view01_class`.`formTeacherId` separator ','
  24. ) AS `teacherId`,
  25. `lms_mentor`.`appraisal`.`appraisalCategory` AS `appraisalCategory`
  26. from
  27. (
  28. (
  29. `lms_mentor`.`appraisal`
  30. left join `lms_mentor`.`appraisal_student` on (
  31. (
  32. `lms_mentor`.`appraisal`.`appraisalId` = `lms_mentor`.`appraisal_student`.`appraisalId`
  33. )
  34. )
  35. )
  36. left join `lms_mentor`.`view01_class` on (
  37. (
  38. `lms_mentor`.`appraisal_student`.`classId` = `view01_class`.`classId`
  39. )
  40. )
  41. )
  42. group by
  43. `lms_mentor`.`appraisal`.`appraisalId`

view02_appraisal_student

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view02_appraisal_student` AS
  2. select
  3. `lms_mentor`.`appraisal_student`.`id` AS `id`,
  4. `lms_mentor`.`appraisal_student`.`appraisalStudentId` AS `appraisalStudentId`,
  5. `lms_mentor`.`appraisal_student`.`studentId` AS `studentId`,
  6. `lms_mentor`.`appraisal_student`.`studentName` AS `studentName`,
  7. `lms_mentor`.`appraisal_student`.`level` AS `level`,
  8. `lms_mentor`.`appraisal_student`.`classId` AS `classId`,
  9. `lms_mentor`.`appraisal_student`.`appraisalId` AS `appraisalId`,
  10. `lms_mentor`.`appraisal_student`.`comment` AS `comment`,
  11. `lms_mentor`.`appraisal_student`.`commentMap` AS `commentMap`,
  12. `lms_mentor`.`appraisal_student`.`matter` AS `matter`,
  13. `lms_mentor`.`appraisal_student`.`commentDate` AS `commentDate`,
  14. `lms_mentor`.`appraisal_student`.`commentById` AS `commentById`,
  15. `lms_mentor`.`appraisal_student`.`commentByName` AS `commentByName`,
  16. `lms_mentor`.`appraisal_student`.`operation` AS `operation`,
  17. `lms_mentor`.`appraisal_student`.`operationByUserId` AS `operationByUserId`,
  18. `lms_mentor`.`appraisal_student`.`operationByUser` AS `operationByUser`,
  19. `lms_mentor`.`appraisal_student`.`operationAt` AS `operationAt`,
  20. `lms_mentor`.`appraisal`.`year` AS `year`,
  21. `lms_mentor`.`appraisal`.`semester` AS `semester`,
  22. `lms_mentor`.`appraisal_student`.`className` AS `className`,
  23. `view01_class`.`number` AS `number`,
  24. `view01_class`.`formTeacherId` AS `teacherId`,
  25. `view01_class`.`formTeacherName` AS `teacherName`,
  26. `lms_mentor`.`appraisal`.`segment` AS `segment`,
  27. `lms_mentor`.`appraisal`.`appraisalCategory` AS `appraisalCategory`
  28. from
  29. (
  30. (
  31. `lms_mentor`.`appraisal_student`
  32. left join `lms_mentor`.`appraisal` on (
  33. (
  34. `lms_mentor`.`appraisal_student`.`appraisalId` = `lms_mentor`.`appraisal`.`appraisalId`
  35. )
  36. )
  37. )
  38. left join `lms_mentor`.`view01_class` on (
  39. (
  40. `lms_mentor`.`appraisal_student`.`classId` = `view01_class`.`classId`
  41. )
  42. )
  43. )

view_student_basic

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