数据结构

12114

表总览

普通表

_cache

• 缓存表

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

_constant

• 常量表; 软删除未启用;

CREATE TABLE `_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `constantKey` varchar(255)  DEFAULT NULL,
  `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  `constantValue` text  COMMENT '常量内容; object, array',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表; 软删除未启用;'

_constant_copy1

• 常量表; 软删除未启用;

CREATE TABLE `_constant_copy1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `constantKey` varchar(255)  DEFAULT NULL,
  `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  `constantValue` text  COMMENT '常量内容; object, array',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表; 软删除未启用;'

_page

• 页面表; 软删除未启用;

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

_record_history

• 数据历史表

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

_resource

• 请求资源表; 软删除未启用; resourceId=${appId}.${pageId}.${actionId}

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

_test_case

• 测试用例表

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

_ui

• ui 施工方案

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

_user_app

CREATE TABLE `_user_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255)  DEFAULT NULL COMMENT '用户id',
  `appId` varchar(255)  DEFAULT NULL COMMENT 'appId',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 590 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

_user_session

• 用户session表; deviceId 维度;软删除未启用;

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

academic_year_constant

CREATE TABLE `academic_year_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `academicYear` varchar(255) DEFAULT NULL,
  `semester` varchar(255) DEFAULT NULL,
  `calendarYear` varchar(255) DEFAULT NULL,
  `semesterName` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT '状态：active-当前学期, archive-过期',
  `operationAt` varchar(255) DEFAULT NULL,
  `operationByUserId` varchar(255) DEFAULT NULL,
  `operationByUser` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC

access_control_student

• 学生表的 accessControl 表

CREATE TABLE `access_control_student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255)  DEFAULT NULL COMMENT '主键id',
  `username` varchar(255)  DEFAULT NULL COMMENT '用户名(登陆)',
  `resourceData` varchar(255)  DEFAULT NULL COMMENT '明文密码',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username_index` (`username`) USING BTREE,
  UNIQUE KEY `userId_index` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 52 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '学生表的 accessControl 表'

class

CREATE TABLE `class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(255)  DEFAULT NULL COMMENT '自然年',
  `academicYear` varchar(255)  DEFAULT NULL,
  `semester` varchar(255)  DEFAULT NULL,
  `segment` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学部',
  `level` varchar(255)  DEFAULT NULL COMMENT '年级',
  `number` varchar(255)  DEFAULT NULL COMMENT '班级编号',
  `classId` varchar(255)  DEFAULT NULL COMMENT '班级Id',
  `className` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级名',
  `classNum` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级',
  `formTeacherId` varchar(255)  DEFAULT NULL COMMENT '班主任ID',
  `formTeacherName` varchar(255)  DEFAULT NULL COMMENT '班主任姓名',
  `formTeacherGender` varchar(255)  DEFAULT NULL COMMENT '班主任性别',
  `formTeacherContact` varchar(255)  DEFAULT NULL COMMENT '班主任联系方式',
  `learningTrack` varchar(255)  DEFAULT NULL,
  `classType` varchar(255)  DEFAULT NULL COMMENT '班级类型',
  `classTagList` text  COMMENT '班级标注',
  `classCreatedBy` varchar(255)  DEFAULT NULL COMMENT '创建班级人员',
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `classStatus` varchar(255)  DEFAULT NULL COMMENT '班级状态',
  `operation` varchar(255)  DEFAULT NULL COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 196 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

class_history

CREATE TABLE `class_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(255)  DEFAULT NULL COMMENT '自然年',
  `academicYear` varchar(255)  DEFAULT NULL,
  `semester` varchar(255)  DEFAULT NULL,
  `segment` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学部',
  `level` varchar(255)  DEFAULT NULL COMMENT '年级',
  `number` varchar(255)  DEFAULT NULL COMMENT '班级编号',
  `classId` varchar(255)  DEFAULT NULL COMMENT '班级Id',
  `className` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级名',
  `classNum` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级',
  `formTeacherId` varchar(255)  DEFAULT NULL COMMENT '班主任ID',
  `formTeacherName` varchar(255)  DEFAULT NULL COMMENT '班主任姓名',
  `formTeacherGender` varchar(255)  DEFAULT NULL COMMENT '班主任性别',
  `formTeacherContact` varchar(255)  DEFAULT NULL COMMENT '班主任联系方式',
  `learningTrack` varchar(255)  DEFAULT NULL,
  `classType` varchar(255)  DEFAULT NULL COMMENT '班级类型',
  `classTagList` text  COMMENT '班级标注',
  `classCreatedBy` varchar(255)  DEFAULT NULL COMMENT '创建班级人员',
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `classStatus` varchar(255)  DEFAULT NULL COMMENT '班级状态',
  `operation` varchar(255)  DEFAULT NULL COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniq` (`classId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 472 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

restaurant_student

CREATE TABLE `restaurant_student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appId` varchar(255)  DEFAULT NULL COMMENT 'appId',
  `appGroup` varchar(255)  DEFAULT NULL COMMENT 'app组',
  `appName` varchar(255)  DEFAULT NULL COMMENT 'app名',
  `appDesc` varchar(255)  DEFAULT NULL COMMENT 'app描述',
  `appUrl` varchar(255)  DEFAULT NULL COMMENT 'app链接',
  `appMenu` text  COMMENT 'app菜单',
  `appType` varchar(255)  DEFAULT 'internal' COMMENT '应用类型：internal，external',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `appId` (`appId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

student_attachment

• 员工附件表

CREATE TABLE `student_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `studentFileId` varchar(100)  DEFAULT NULL,
  `studentId` varchar(100)  NOT NULL COMMENT '学生id',
  `filename` varchar(255)  DEFAULT NULL COMMENT '文件名',
  `type` varchar(255)  DEFAULT NULL COMMENT '1 学生基本资料 2 员工档案资料 3 员工离职资料',
  `subType` varchar(255)  NOT NULL COMMENT '11、身份证原件 12、学历证明 13、个人证件照 14、身份证复印件 15、工资银行卡 16、社保卡 17、公积金卡 18、获奖证书 19、其他 21、劳动合同 22、入职简历 23、入职登记表 24、入职体检单 25、离职证明 26、转正申请表 27、其他\n31、离职审批 32、离职证明 33 、其他\n',
  `rowStatus` varchar(255)  DEFAULT NULL COMMENT '附件状态',
  `downloadPath` varchar(255)  DEFAULT NULL,
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `createUserId` bigint(20) DEFAULT NULL,
  `createTime` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = '员工附件表'

student_basic

CREATE TABLE `student_basic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `enrollmentYear` varchar(255)  DEFAULT NULL COMMENT '入学学年',
  `enrollmentSemester` varchar(255)  DEFAULT NULL COMMENT '入学学期',
  `enrollmentDate` varchar(255)  DEFAULT NULL COMMENT '入学日期',
  `studentId` varchar(255)  DEFAULT NULL COMMENT '学生编号',
  `classId` varchar(255)  DEFAULT NULL COMMENT '班级id',
  `idSequence` int(11) DEFAULT NULL COMMENT '学生序号',
  `enrollmentSegment` varchar(255)  DEFAULT NULL COMMENT '入学学部',
  `enrollmentLevel` varchar(255)  DEFAULT NULL COMMENT '入学年级',
  `enrollmentClassId` varchar(255)  DEFAULT NULL COMMENT '入学班级号',
  `name` varchar(255)  DEFAULT NULL COMMENT '学生名',
  `avatar` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '照片头像',
  `gender` varchar(255)  DEFAULT NULL COMMENT '性别',
  `studentFeeStatus` varchar(255)  DEFAULT '新生' COMMENT '新老生状态',
  `studentStatus` varchar(255)  DEFAULT NULL COMMENT '学生状态',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT '身份证件号',
  `scholarshipLevel` varchar(255)  DEFAULT NULL COMMENT '奖学金等级',
  `requestType` varchar(255)  DEFAULT NULL COMMENT '申请类型：退学/入学/保籍',
  `afterSchoolCareType` varchar(255)  DEFAULT NULL COMMENT '就读方式',
  `residentialAddress` varchar(255)  DEFAULT NULL COMMENT '家庭住址',
  `guardian1Name` varchar(255)  DEFAULT NULL COMMENT '监护人1姓名',
  `guardian1Relationship` varchar(255)  DEFAULT NULL COMMENT '监护人1关系',
  `guardian1Contact` varchar(255)  DEFAULT NULL COMMENT '监护人1联系方式',
  `guardian1ResidentialAddress` varchar(255)  DEFAULT NULL COMMENT '监护人1现住址',
  `guardian2Name` varchar(255)  DEFAULT NULL COMMENT '监护人2姓名',
  `guardian2Relationship` varchar(255)  DEFAULT NULL COMMENT '监护人2关系',
  `guardian2Contact` varchar(255)  DEFAULT NULL COMMENT '监护人2联系方式',
  `guardian2ResidentialAddress` varchar(255)  DEFAULT NULL COMMENT '监护人2现住址',
  `remarks` longtext CHARACTER SET utf8mb4 COMMENT '历史备注',
  `newRemarks` varchar(255)  DEFAULT NULL COMMENT '追加备注',
  `hostelName` varchar(255)  DEFAULT NULL COMMENT '宿舍楼号',
  `hostelUnitNumber` varchar(255)  DEFAULT NULL COMMENT '房间号',
  `hostelBedId` varchar(255)  DEFAULT NULL COMMENT '床号',
  `dining_canteen_table` varchar(255)  DEFAULT NULL COMMENT '桌号',
  `completedEnrollmentRecordYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成入学信息录入',
  `completedClassAssignedYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成分班',
  `completedLogisticsAssignedYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成餐桌和宿舍分配',
  `completedPaymentYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成学费付款',
  `completedEnrollmentYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成入学程序',
  `completedQuitYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成退学程序',
  `compeletedUpgradeYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成升学程序',
  `enrolledBy` varchar(255) CHARACTER SET utf16 DEFAULT NULL COMMENT '入学信息录入人员',
  `classAssignedBy` varchar(255)  DEFAULT NULL COMMENT '分班经办人员',
  `paymentReceivedBy` varchar(255)  DEFAULT NULL COMMENT '收款人员',
  `checkPaymentStatusBy` varchar(255)  DEFAULT NULL COMMENT '检查缴费状态人员',
  `hostelAssignedBy` varchar(255)  DEFAULT NULL COMMENT '宿舍分配人员',
  `enrollmentApprovedBy` varchar(255)  DEFAULT NULL COMMENT '批准入学人员',
  `quitApprovedBy` varchar(255)  DEFAULT NULL COMMENT '批准退学人员',
  `operation` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `completedQuitAssignedYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成退宿',
  `quitHostelAssignedBy` varchar(255)  DEFAULT NULL COMMENT '退宿人员',
  `completedQuitPaymentYesOrNo` varchar(255)  DEFAULT NULL COMMENT '是否完成退费',
  `quitPaymentBy` varchar(255)  DEFAULT NULL COMMENT '退费人员',
  `middleSchoolExamScore` varchar(255)  DEFAULT NULL COMMENT '中考分数',
  `middleSchoolExamSequence` varchar(255)  DEFAULT NULL COMMENT '中考学生序号',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniq` (`studentId`) USING BTREE,
  KEY `classId` (`classId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9319 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

student_class_history

CREATE TABLE `student_class_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '自然年',
  `studentId` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学生Id',
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学生姓名',
  `gender` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '性别',
  `academicYear` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学年',
  `semester` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学期',
  `segment` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学部',
  `level` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '年级',
  `number` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级编号',
  `classNum` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级号',
  `classId` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级ID',
  `className` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级名',
  `recordStatus` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '记录状态：active/archive',
  `formTeacherId` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班主任ID',
  `formTeacherName` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班主任',
  `formTeacherGender` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班主任性别',
  `formTeacherContact` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '班主任联系方式',
  `learningTrack` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `remarks` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  `studentOperation` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学生动态',
  `operation` varchar(255) CHARACTER SET utf8 DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9378 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

student_request

CREATE TABLE `student_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `studentId` varchar(255)  NOT NULL,
  `name` varchar(255)  DEFAULT NULL,
  `gender` varchar(255)  DEFAULT NULL,
  `year` varchar(255)  DEFAULT NULL,
  `semester` varchar(255)  DEFAULT NULL,
  `segment` varchar(255)  DEFAULT NULL,
  `level` varchar(255)  DEFAULT NULL,
  `number` varchar(255)  DEFAULT NULL,
  `academicYear` varchar(255)  DEFAULT NULL,
  `requestType` varchar(255)  DEFAULT NULL,
  `studentStatus` varchar(255)  DEFAULT NULL,
  `completedApprovedYesOrNo` varchar(255)  DEFAULT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  `quitApprovedBy` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 59 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

student_status_history

CREATE TABLE `student_status_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '自然年',
  `semester` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学期',
  `studentId` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '学生Id',
  `status` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '记录状态：active/archive',
  `remarks` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  `createAt` varchar(255) DEFAULT NULL,
  `createByUser` varchar(255) DEFAULT NULL COMMENT '记录人',
  `operation` varchar(255) CHARACTER SET utf8 DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14146 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC

视图

_directory_user_session

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_directory_user_session` AS
select
  `lms_data_repository`.`enterprise_directory_user_session`.`id` AS `id`,
  `lms_data_repository`.`enterprise_directory_user_session`.`userId` AS `userId`,
  `lms_data_repository`.`enterprise_directory_user_session`.`userIp` AS `userIp`,
  `lms_data_repository`.`enterprise_directory_user_session`.`userIpRegion` AS `userIpRegion`,
  `lms_data_repository`.`enterprise_directory_user_session`.`userAgent` AS `userAgent`,
  `lms_data_repository`.`enterprise_directory_user_session`.`deviceId` AS `deviceId`,
  `lms_data_repository`.`enterprise_directory_user_session`.`deviceType` AS `deviceType`,
  `lms_data_repository`.`enterprise_directory_user_session`.`socketStatus` AS `socketStatus`,
  `lms_data_repository`.`enterprise_directory_user_session`.`authToken` AS `authToken`,
  `lms_data_repository`.`enterprise_directory_user_session`.`operation` AS `operation`,
  `lms_data_repository`.`enterprise_directory_user_session`.`operationByUserId` AS `operationByUserId`,
  `lms_data_repository`.`enterprise_directory_user_session`.`operationByUser` AS `operationByUser`,
  `lms_data_repository`.`enterprise_directory_user_session`.`operationAt` AS `operationAt`
from
  `lms_data_repository`.`enterprise_directory_user_session`

_group

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_group` AS
select
  `lms_data_repository`.`enterprise_group`.`id` AS `id`,
  `lms_data_repository`.`enterprise_group`.`groupId` AS `groupId`,
  `lms_data_repository`.`enterprise_group`.`groupLastId` AS `groupLastId`,
  `lms_data_repository`.`enterprise_group`.`groupPath` AS `groupPath`,
  `lms_data_repository`.`enterprise_group`.`groupName` AS `groupName`,
  `lms_data_repository`.`enterprise_group`.`groupDeptName` AS `groupDeptName`,
  `lms_data_repository`.`enterprise_group`.`groupAllName` AS `groupAllName`,
  `lms_data_repository`.`enterprise_group`.`principalId` AS `principalId`,
  `lms_data_repository`.`enterprise_group`.`headId` AS `headId`,
  `lms_data_repository`.`enterprise_group`.`leadId` AS `leadId`,
  `lms_data_repository`.`enterprise_group`.`groupDesc` AS `groupDesc`,
  `lms_data_repository`.`enterprise_group`.`operation` AS `operation`,
  `lms_data_repository`.`enterprise_group`.`operationByUserId` AS `operationByUserId`,
  `lms_data_repository`.`enterprise_group`.`operationByUser` AS `operationByUser`,
  `lms_data_repository`.`enterprise_group`.`operationAt` AS `operationAt`
from
  `lms_data_repository`.`enterprise_group`

_role

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_role` AS
select
  `lms_data_repository`.`enterprise_role`.`id` AS `id`,
  `lms_data_repository`.`enterprise_role`.`roleId` AS `roleId`,
  `lms_data_repository`.`enterprise_role`.`roleName` AS `roleName`,
  `lms_data_repository`.`enterprise_role`.`roleType` AS `roleType`,
  `lms_data_repository`.`enterprise_role`.`roleDesc` AS `roleDesc`,
  `lms_data_repository`.`enterprise_role`.`operation` AS `operation`,
  `lms_data_repository`.`enterprise_role`.`operationByUserId` AS `operationByUserId`,
  `lms_data_repository`.`enterprise_role`.`operationByUser` AS `operationByUser`,
  `lms_data_repository`.`enterprise_role`.`operationAt` AS `operationAt`
from
  `lms_data_repository`.`enterprise_role`

_user_group_role

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_user_group_role` AS
select
  `lms_data_repository`.`enterprise_user_group_role`.`id` AS `id`,
  `lms_data_repository`.`enterprise_user_group_role`.`userId` AS `userId`,
  `lms_data_repository`.`enterprise_user_group_role`.`groupId` AS `groupId`,
  `lms_data_repository`.`enterprise_user_group_role`.`roleId` AS `roleId`,
  `lms_data_repository`.`enterprise_user_group_role`.`roleDeadline` AS `roleDeadline`,
  `lms_data_repository`.`enterprise_user_group_role`.`operation` AS `operation`,
  `lms_data_repository`.`enterprise_user_group_role`.`operationByUserId` AS `operationByUserId`,
  `lms_data_repository`.`enterprise_user_group_role`.`operationByUser` AS `operationByUser`,
  `lms_data_repository`.`enterprise_user_group_role`.`operationAt` AS `operationAt`
from
  `lms_data_repository`.`enterprise_user_group_role`

_user_group_role_page

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_user_group_role_page` AS
select
  `lms_data_repository`.`enterprise_user_group_role_page`.`id` AS `id`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`appId` AS `appId`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`user` AS `user`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`group` AS `group`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`role` AS `role`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`page` AS `page`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`allowOrDeny` AS `allowOrDeny`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`desc` AS `desc`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`source` AS `source`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`operation` AS `operation`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`operationByUserId` AS `operationByUserId`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`operationByUser` AS `operationByUser`,
  `lms_data_repository`.`enterprise_user_group_role_page`.`operationAt` AS `operationAt`
from
  `lms_data_repository`.`enterprise_user_group_role_page`
where
  (
    (
      `lms_data_repository`.`enterprise_user_group_role_page`.`appId` = 'lms-student-admin'
    )
    or (
      `lms_data_repository`.`enterprise_user_group_role_page`.`appId` = '*'
    )
  )

_user_group_role_resource

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_user_group_role_resource` AS
select
  `lms_data_repository`.`enterprise_user_group_role_resource`.`id` AS `id`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`appId` AS `appId`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`user` AS `user`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`group` AS `group`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`role` AS `role`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`resource` AS `resource`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`allowOrDeny` AS `allowOrDeny`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`desc` AS `desc`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`source` AS `source`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`operation` AS `operation`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`operationByUserId` AS `operationByUserId`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`operationByUser` AS `operationByUser`,
  `lms_data_repository`.`enterprise_user_group_role_resource`.`operationAt` AS `operationAt`
from
  `lms_data_repository`.`enterprise_user_group_role_resource`
where
  (
    (
      `lms_data_repository`.`enterprise_user_group_role_resource`.`appId` = 'lms-student-admin'
    )
    or (
      `lms_data_repository`.`enterprise_user_group_role_resource`.`appId` = '*'
    )
  )

_view01_user

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_view01_user` AS
select
  `lms_data_repository`.`enterprise_view01_user`.`id` AS `id`,
  `lms_data_repository`.`enterprise_view01_user`.`idSequence` AS `idSequence`,
  `lms_data_repository`.`enterprise_view01_user`.`userId` AS `userId`,
  `lms_data_repository`.`enterprise_view01_user`.`username` AS `username`,
  `lms_data_repository`.`enterprise_view01_user`.`phoneNumber` AS `phoneNumber`,
  `lms_data_repository`.`enterprise_view01_user`.`email` AS `email`,
  `lms_data_repository`.`enterprise_view01_user`.`userStatus` AS `userStatus`,
  `lms_data_repository`.`enterprise_view01_user`.`qiweiId` AS `qiweiId`,
  `lms_data_repository`.`enterprise_view01_user`.`userConfig` AS `userConfig`,
  `lms_data_repository`.`enterprise_view01_user`.`password` AS `password`,
  `lms_data_repository`.`enterprise_view01_user`.`md5Salt` AS `md5Salt`,
  `lms_data_repository`.`enterprise_view01_user`.`clearTextPassword` AS `clearTextPassword`,
  `lms_data_repository`.`enterprise_view01_user`.`operation` AS `operation`,
  `lms_data_repository`.`enterprise_view01_user`.`operationByUserId` AS `operationByUserId`,
  `lms_data_repository`.`enterprise_view01_user`.`operationByUser` AS `operationByUser`,
  `lms_data_repository`.`enterprise_view01_user`.`operationAt` AS `operationAt`
from
  `lms_data_repository`.`enterprise_view01_user`

_view02_user_app

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
select
  `lms_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  `lms_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  `lms_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
from
  `lms_data_repository`.`enterprise_view02_user_app`
where
  (
    `lms_data_repository`.`enterprise_view02_user_app`.`appId` = 'lms-student-admin'
  )

view01_class

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_class` AS
select
  count(
    if(
      (`student_basic`.`studentStatus` = '在校'),
      `student_basic`.`classId`,
      NULL
    )
  ) AS `count`,
  `class`.`id` AS `id`,
  `class`.`classId` AS `classId`,
  `class`.`classNum` AS `classNum`,
  `class`.`classTagList` AS `classTagList`,
  `class`.`level` AS `level`,
  `class`.`formTeacherId` AS `formTeacherId`,
  `class`.`formTeacherName` AS `formTeacherName`,
  `class`.`formTeacherGender` AS `formTeacherGender`,
  `class`.`formTeacherContact` AS `formTeacherContact`,
  `class`.`segment` AS `segment`,
  `class`.`learningTrack` AS `learningTrack`,
  `class`.`remarks` AS `remarks`,
  `class`.`classStatus` AS `classStatus`,
  `class`.`classType` AS `classType`,
  `class`.`classCreatedBy` AS `classCreatedBy`,
  `class`.`operation` AS `operation`,
  `class`.`operationByUserId` AS `operationByUserId`,
  `class`.`operationByUser` AS `operationByUser`,
  `class`.`operationAt` AS `operationAt`,
  `class`.`className` AS `className`,
  `class`.`year` AS `year`,
  `class`.`academicYear` AS `academicYear`,
  `class`.`semester` AS `semester`,
  `class`.`number` AS `number`
from
  (
    `class`
    left join `student_basic` on (
      (
        `class`.`classId` = convert(`student_basic`.`classId` using utf8mb4)
      )
    )
  )
group by
  `class`.`classId`

view01_class_all

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_class_all` AS
select
  `class`.`id` AS `id`,
  `class`.`year` AS `year`,
  `class`.`academicYear` AS `academicYear`,
  `class`.`semester` AS `semester`,
  `class`.`segment` AS `segment`,
  `class`.`level` AS `level`,
  `class`.`number` AS `number`,
  `class`.`classId` AS `classId`,
  `class`.`className` AS `className`,
  `class`.`classNum` AS `classNum`,
  `class`.`formTeacherId` AS `formTeacherId`,
  `class`.`formTeacherName` AS `formTeacherName`,
  `class`.`formTeacherGender` AS `formTeacherGender`,
  `class`.`formTeacherContact` AS `formTeacherContact`,
  `class`.`learningTrack` AS `learningTrack`,
  `class`.`classType` AS `classType`,
  `class`.`classTagList` AS `classTagList`,
  `class`.`classCreatedBy` AS `classCreatedBy`,
  `class`.`remarks` AS `remarks`,
  `class`.`classStatus` AS `classStatus`,
  `class`.`operation` AS `operation`,
  `class`.`operationByUserId` AS `operationByUserId`,
  `class`.`operationByUser` AS `operationByUser`,
  `class`.`operationAt` AS `operationAt`
from
  `class`
union all
select
  `class_history`.`id` AS `id`,
  `class_history`.`year` AS `year`,
  `class_history`.`academicYear` AS `academicYear`,
  `class_history`.`semester` AS `semester`,
  `class_history`.`segment` AS `segment`,
  `class_history`.`level` AS `level`,
  `class_history`.`number` AS `number`,
  `class_history`.`classId` AS `classId`,
  `class_history`.`className` AS `className`,
  `class_history`.`classNum` AS `classNum`,
  `class_history`.`formTeacherId` AS `formTeacherId`,
  `class_history`.`formTeacherName` AS `formTeacherName`,
  `class_history`.`formTeacherGender` AS `formTeacherGender`,
  `class_history`.`formTeacherContact` AS `formTeacherContact`,
  `class_history`.`learningTrack` AS `learningTrack`,
  `class_history`.`classType` AS `classType`,
  `class_history`.`classTagList` AS `classTagList`,
  `class_history`.`classCreatedBy` AS `classCreatedBy`,
  `class_history`.`remarks` AS `remarks`,
  `class_history`.`classStatus` AS `classStatus`,
  `class_history`.`operation` AS `operation`,
  `class_history`.`operationByUserId` AS `operationByUserId`,
  `class_history`.`operationByUser` AS `operationByUser`,
  `class_history`.`operationAt` AS `operationAt`
from
  `class_history`

view01_student_basic_class

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_student_basic_class` AS
select
  `student_basic`.`studentId` AS `studentId`,
  `student_basic`.`name` AS `name`,
  `class`.`year` AS `year`,
  `class`.`academicYear` AS `academicYear`,
  `class`.`semester` AS `semester`,
  `class`.`classNum` AS `classNum`,
  `student_basic`.`studentStatus` AS `studentStatus`,
  `class`.`segment` AS `segment`,
  `class`.`level` AS `level`,
  `student_basic`.`remarks` AS `remarks`,
  `student_basic`.`newRemarks` AS `newRemarks`,
  `student_basic`.`gender` AS `gender`,
  `student_basic`.`guardian2Contact` AS `guardian2Contact`,
  `student_basic`.`guardian2Relationship` AS `guardian2Relationship`,
  `student_basic`.`guardian2Name` AS `guardian2Name`,
  `student_basic`.`guardian1Contact` AS `guardian1Contact`,
  `student_basic`.`guardian1Relationship` AS `guardian1Relationship`,
  `student_basic`.`guardian1Name` AS `guardian1Name`,
  `class`.`classId` AS `classId`,
  `class`.`className` AS `className`,
  `student_basic`.`requestType` AS `requestType`,
  `student_basic`.`completedClassAssignedYesOrNo` AS `completedClassAssignedYesOrNo`,
  `student_basic`.`completedEnrollmentRecordYesOrNo` AS `completedEnrollmentRecordYesOrNo`,
  `student_basic`.`completedLogisticsAssignedYesOrNo` AS `completedLogisticsAssignedYesOrNo`,
  `student_basic`.`completedPaymentYesOrNo` AS `completedPaymentYesOrNo`,
  `student_basic`.`completedEnrollmentYesOrNo` AS `completedEnrollmentYesOrNo`,
  `student_basic`.`completedQuitYesOrNo` AS `completedQuitYesOrNo`,
  `student_basic`.`id` AS `id`,
  `student_basic`.`compeletedUpgradeYesOrNo` AS `compeletedUpgradeYesOrNo`,
  `student_basic`.`enrollmentYear` AS `enrollmentYear`,
  `student_basic`.`enrollmentSemester` AS `enrollmentSemester`,
  `student_basic`.`enrollmentSegment` AS `enrollmentSegment`,
  `student_basic`.`enrollmentLevel` AS `enrollmentLevel`,
  `student_basic`.`middleSchoolExamScore` AS `middleSchoolExamScore`,
  `student_basic`.`operationAt` AS `operationAt`,
  `class`.`number` AS `number`,
  `student_basic`.`icNumber` AS `icNumber`,
  `student_basic`.`afterSchoolCareType` AS `afterSchoolCareType`,
  `student_basic`.`studentFeeStatus` AS `freshmanOrReturning`,
  `class`.`formTeacherId` AS `formTeacherId`,
  `class`.`formTeacherName` AS `formTeacherName`,
  `student_basic`.`avatar` AS `avatar`
from
  (
    `student_basic`
    left join `class` on ((`class`.`classId` = `student_basic`.`classId`))
  )

view01_student_basic_max_id

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_student_basic_max_id` AS
select
  max(`student_basic`.`idSequence`) AS `maxId`
from
  `student_basic`

view01_student_basic_request

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_student_basic_request` AS
select
  `student_basic`.`remarks` AS `remarks`,
  `student_request`.`studentId` AS `studentId`,
  `student_request`.`name` AS `name`,
  `student_request`.`gender` AS `gender`,
  `student_request`.`segment` AS `segment`,
  `student_request`.`level` AS `level`,
  `student_request`.`number` AS `number`,
  `student_request`.`academicYear` AS `academicYear`,
  `student_request`.`requestType` AS `requestType`,
  `student_request`.`studentStatus` AS `studentStatus`,
  `student_request`.`completedApprovedYesOrNo` AS `completedApprovedYesOrNo`,
  `student_request`.`operation` AS `operation`,
  `student_request`.`operationByUserId` AS `operationByUserId`,
  `student_request`.`operationByUser` AS `operationByUser`,
  `student_request`.`operationAt` AS `operationAt`,
  `student_request`.`quitApprovedBy` AS `quitApprovedBy`,
  `student_basic`.`hostelName` AS `hostelName`,
  `student_basic`.`hostelUnitNumber` AS `hostelUnitNumber`,
  `student_basic`.`hostelBedId` AS `hostelBedId`,
  `student_basic`.`dining_canteen_table` AS `dining_canteen_table`,
  `student_basic`.`completedQuitAssignedYesOrNo` AS `completedQuitAssignedYesOrNo`,
  `student_basic`.`quitHostelAssignedBy` AS `quitHostelAssignedBy`,
  `student_basic`.`completedQuitPaymentYesOrNo` AS `completedQuitPaymentYesOrNo`,
  `student_basic`.`quitPaymentBy` AS `quitPaymentBy`,
  `student_basic`.`completedQuitYesOrNo` AS `completedQuitYesOrNo`,
  `student_request`.`year` AS `year`,
  `student_request`.`semester` AS `semester`,
  `student_basic`.`classId` AS `classId`,
  `student_request`.`id` AS `id`
from
  (
    `student_basic`
    join `student_request` on (
      (
        `student_basic`.`studentId` = `student_request`.`studentId`
      )
    )
  )

view01_student_bill

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_student_bill` AS
select
  `lms_student_admin`.`student_basic`.`id` AS `id`,
  `lms_student_admin`.`student_basic`.`enrollmentYear` AS `enrollmentYear`,
  `lms_student_admin`.`student_basic`.`enrollmentSemester` AS `enrollmentSemester`,
  `lms_student_admin`.`student_basic`.`enrollmentDate` AS `enrollmentDate`,
  `lms_student_admin`.`student_basic`.`studentId` AS `studentId`,
  `lms_student_admin`.`student_basic`.`classId` AS `classId`,
  `lms_student_admin`.`student_basic`.`idSequence` AS `idSequence`,
  `lms_student_admin`.`student_basic`.`enrollmentSegment` AS `enrollmentSegment`,
  `lms_student_admin`.`student_basic`.`enrollmentLevel` AS `enrollmentLevel`,
  `lms_student_admin`.`student_basic`.`enrollmentClassId` AS `enrollmentClassId`,
  `lms_student_admin`.`student_basic`.`name` AS `name`,
  `lms_student_admin`.`student_basic`.`gender` AS `gender`,
  `lms_student_admin`.`student_basic`.`studentFeeStatus` AS `studentFeeStatus`,
  `lms_student_admin`.`student_basic`.`studentStatus` AS `studentStatus`,
  `lms_student_admin`.`student_basic`.`icNumber` AS `icNumber`,
  `lms_student_admin`.`student_basic`.`scholarshipLevel` AS `scholarshipLevel`,
  `lms_student_admin`.`student_basic`.`requestType` AS `requestType`,
  `lms_student_admin`.`student_basic`.`afterSchoolCareType` AS `afterSchoolCareType`,
  `lms_student_admin`.`student_basic`.`residentialAddress` AS `residentialAddress`,
  `lms_student_admin`.`student_basic`.`guardian1Name` AS `guardian1Name`,
  `lms_student_admin`.`student_basic`.`guardian1Relationship` AS `guardian1Relationship`,
  `lms_student_admin`.`student_basic`.`guardian1Contact` AS `guardian1Contact`,
  `lms_student_admin`.`student_basic`.`guardian1ResidentialAddress` AS `guardian1ResidentialAddress`,
  `lms_student_admin`.`student_basic`.`guardian2Name` AS `guardian2Name`,
  `lms_student_admin`.`student_basic`.`guardian2Relationship` AS `guardian2Relationship`,
  `lms_student_admin`.`student_basic`.`guardian2Contact` AS `guardian2Contact`,
  `lms_student_admin`.`student_basic`.`guardian2ResidentialAddress` AS `guardian2ResidentialAddress`,
  `lms_student_admin`.`student_basic`.`remarks` AS `remarks`,
  `lms_student_admin`.`student_basic`.`newRemarks` AS `newRemarks`,
  `lms_student_admin`.`student_basic`.`hostelName` AS `hostelName`,
  `lms_student_admin`.`student_basic`.`hostelUnitNumber` AS `hostelUnitNumber`,
  `lms_student_admin`.`student_basic`.`hostelBedId` AS `hostelBedId`,
  `lms_student_admin`.`student_basic`.`dining_canteen_table` AS `dining_canteen_table`,
  `lms_student_admin`.`student_basic`.`completedEnrollmentRecordYesOrNo` AS `completedEnrollmentRecordYesOrNo`,
  `lms_student_admin`.`student_basic`.`completedClassAssignedYesOrNo` AS `completedClassAssignedYesOrNo`,
  `lms_student_admin`.`student_basic`.`completedLogisticsAssignedYesOrNo` AS `completedLogisticsAssignedYesOrNo`,
  `lms_student_admin`.`student_basic`.`completedPaymentYesOrNo` AS `completedPaymentYesOrNo`,
  `lms_student_admin`.`student_basic`.`completedEnrollmentYesOrNo` AS `completedEnrollmentYesOrNo`,
  `lms_student_admin`.`student_basic`.`completedQuitYesOrNo` AS `completedQuitYesOrNo`,
  `lms_student_admin`.`student_basic`.`compeletedUpgradeYesOrNo` AS `compeletedUpgradeYesOrNo`,
  `lms_student_admin`.`student_basic`.`enrolledBy` AS `enrolledBy`,
  `lms_student_admin`.`student_basic`.`classAssignedBy` AS `classAssignedBy`,
  `lms_student_admin`.`student_basic`.`paymentReceivedBy` AS `paymentReceivedBy`,
  `lms_student_admin`.`student_basic`.`checkPaymentStatusBy` AS `checkPaymentStatusBy`,
  `lms_student_admin`.`student_basic`.`hostelAssignedBy` AS `hostelAssignedBy`,
  `lms_student_admin`.`student_basic`.`enrollmentApprovedBy` AS `enrollmentApprovedBy`,
  `lms_student_admin`.`student_basic`.`quitApprovedBy` AS `quitApprovedBy`,
  `lms_student_admin`.`student_basic`.`operation` AS `operation`,
  `lms_student_admin`.`student_basic`.`operationAt` AS `operationAt`,
  `lms_student_admin`.`student_basic`.`operationByUserId` AS `operationByUserId`,
  `lms_student_admin`.`student_basic`.`operationByUser` AS `operationByUser`,
  `lms_student_admin`.`student_basic`.`completedQuitAssignedYesOrNo` AS `completedQuitAssignedYesOrNo`,
  `lms_student_admin`.`student_basic`.`quitHostelAssignedBy` AS `quitHostelAssignedBy`,
  `lms_student_admin`.`student_basic`.`completedQuitPaymentYesOrNo` AS `completedQuitPaymentYesOrNo`,
  `lms_student_admin`.`student_basic`.`quitPaymentBy` AS `quitPaymentBy`,
  `lms_student_admin`.`student_basic`.`middleSchoolExamScore` AS `middleSchoolExamScore`,
  `lms_student_admin`.`student_basic`.`middleSchoolExamSequence` AS `middleSchoolExamSequence`,
  `lms_finance`.`bill`.`billCompletedStatus` AS `billCompletedStatus`
from
  (
    `lms_student_admin`.`student_basic`
    left join `lms_finance`.`bill` on (
      (
        `lms_student_admin`.`student_basic`.`studentId` = `lms_finance`.`bill`.`studentId`
      )
    )
  )