数据结构

12114

表总览

普通表

__bak_table_sync_config

CREATE TABLE `__bak_table_sync_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sourceDatabase` varchar(255)  DEFAULT NULL,
  `sourceTable` varchar(255)  DEFAULT NULL,
  `syncTimeSlot` varchar(255)  DEFAULT NULL,
  `syncDesc` varchar(255)  DEFAULT NULL COMMENT '同步状态,  正常, 源表不存在; 目标表不存在;,源表不存在; 目标表存在; ',
  `lastSyncTime` 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
) ENGINE = InnoDB AUTO_INCREMENT = 231 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

_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 COMMENT = '缓存表'

_page

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

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  `pageFile` varchar(255) DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `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 = 14 DEFAULT CHARSET = utf8mb4 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 COMMENT '数据JSON',
  `packageContent` text 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 = 9 DEFAULT CHARSET = utf8mb4 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 = 468 DEFAULT CHARSET = utf8mb4 COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource_request_log

• 文件表; 软删除未启用;

CREATE TABLE `_resource_request_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resourceId` varchar(255)  DEFAULT NULL COMMENT 'resource id;',
  `packageId` varchar(255)  DEFAULT NULL COMMENT 'resource package id',
  `userIp` varchar(255)  DEFAULT NULL COMMENT '用户ip;',
  `userAgent` varchar(255)  DEFAULT NULL COMMENT '设备信息',
  `userId` varchar(255)  DEFAULT NULL COMMENT '用户ID',
  `deviceId` varchar(255)  DEFAULT NULL COMMENT '设备id',
  `userIpRegion` varchar(255)  DEFAULT NULL COMMENT '用户Ip区域',
  `executeSql` varchar(255)  DEFAULT NULL COMMENT '执行的sql',
  `requestBody` text  COMMENT '请求body',
  `responseBody` text  COMMENT '响应body',
  `responseStatus` varchar(255)  DEFAULT NULL COMMENT '执行的结果;  success, fail',
  `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 `resourceId_index` (`resourceId`) USING BTREE,
  KEY `packageId_index` (`packageId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '文件表; 软删除未启用;'

_table_merge_config

CREATE TABLE `_table_merge_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sourceList` text,
  `targetDatabase` varchar(255) DEFAULT NULL,
  `targetTable` varchar(255) DEFAULT NULL,
  `mergeDesc` varchar(255) DEFAULT NULL COMMENT '同步状态,  正常, 源表不存在; 目标表不存在;,源表不存在; 目标表存在; ',
  `lastMergeTime` 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
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC

_table_sync_config

CREATE TABLE `_table_sync_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sourceDatabase` varchar(255) DEFAULT NULL,
  `sourceTable` varchar(255) DEFAULT NULL,
  `targetDatabase` varchar(255) DEFAULT NULL,
  `targetTable` varchar(255) DEFAULT NULL,
  `enableMysqlTrigger` varchar(255) DEFAULT NULL,
  `syncTimeSlot` varchar(255) DEFAULT NULL,
  `syncDesc` varchar(255) DEFAULT NULL COMMENT '同步状态,  正常, 源表不存在; 目标表不存在;,源表不存在; 目标表存在; ',
  `lastSyncTime` 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
) ENGINE = InnoDB AUTO_INCREMENT = 249 DEFAULT CHARSET = utf8mb4

_table_sync_log

CREATE TABLE `_table_sync_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sourceDatabase` varchar(255) DEFAULT NULL,
  `sourceTable` varchar(255) DEFAULT NULL,
  `syncAction` varchar(255) DEFAULT NULL COMMENT '同步动作',
  `syncDesc` varchar(255) DEFAULT NULL COMMENT '同步描述',
  `syncTime` 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
) ENGINE = InnoDB AUTO_INCREMENT = 41116 DEFAULT CHARSET = utf8mb4

_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 ROW_FORMAT = DYNAMIC 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 AUTO_INCREMENT = 41 DEFAULT CHARSET = utf8mb4 COMMENT = 'ui 施工方案'

_user

• 用户表

CREATE TABLE `_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255)  DEFAULT NULL COMMENT '自增id; 用于生成userId',
  `userId` varchar(255)  DEFAULT NULL COMMENT '主键id',
  `username` varchar(255)  DEFAULT NULL COMMENT '用户名(登陆)',
  `clearTextPassword` varchar(255)  DEFAULT NULL COMMENT '明文密码',
  `password` varchar(255)  DEFAULT NULL COMMENT '密码',
  `md5Salt` varchar(255)  DEFAULT NULL COMMENT 'md5Salt',
  `userStatus` varchar(255)  DEFAULT 'active' COMMENT '用户账号状态：活跃或关闭',
  `userType` varchar(255)  DEFAULT NULL COMMENT '用户类型; staff, student.',
  `userConfig` text  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 = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户表'

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

enterprise_app

CREATE TABLE `enterprise_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appId` varchar(255) DEFAULT NULL COMMENT 'appId',
  `appDatabase` varchar(255) DEFAULT NULL COMMENT 'database',
  `appJhId` varchar(255) DEFAULT NULL,
  `appPageList` text,
  `appPageDirectoryList` text COMMENT '展示在应用目录的页面列表, pageId数组',
  `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,
  UNIQUE KEY `appId` (`appId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 115 DEFAULT CHARSET = utf8mb4

enterprise_directory_user_session

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

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

enterprise_group

CREATE TABLE `enterprise_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` varchar(511) CHARACTER SET utf8mb4 DEFAULT NULL,
  `groupLastId` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'groupId',
  `groupPath` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `groupName` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '群组简称',
  `groupDeptName` varchar(255)  DEFAULT NULL COMMENT '群组全称',
  `groupAllName` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '路径全名',
  `principalId` varchar(255)  DEFAULT NULL COMMENT '组织负责人',
  `headId` varchar(255)  DEFAULT NULL COMMENT '部门主管',
  `leadId` varchar(255)  DEFAULT NULL COMMENT '分管领导',
  `groupDesc` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '群组描述',
  `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

enterprise_role

• 角色表; 软删除未启用;

CREATE TABLE `enterprise_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleId` varchar(255) DEFAULT NULL COMMENT 'roleId',
  `roleName` varchar(255) DEFAULT NULL COMMENT 'role name',
  `roleType` varchar(255) DEFAULT NULL COMMENT '职务类型; 正式职务, 临时职务',
  `roleDesc` varchar(255) DEFAULT NULL COMMENT 'role desc',
  `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 `uniq_roleId` (`roleId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 DEFAULT CHARSET = utf8mb4 COMMENT = '角色表; 软删除未启用;'

enterprise_user

CREATE TABLE `enterprise_user` (
  `id` int(11) NOT NULL,
  `idSequence` varchar(255) DEFAULT NULL COMMENT '自增id; 用于生成userId',
  `userId` varchar(255) DEFAULT NULL COMMENT '主键id',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名(登陆)',
  `userStatus` varchar(255) DEFAULT NULL COMMENT '用户账号状态：活跃或关闭',
  `memberId` varchar(255) DEFAULT NULL COMMENT '主键id',
  `groupId` varchar(511) DEFAULT NULL,
  `groupPath` varchar(255) DEFAULT NULL,
  `groupName` varchar(255) DEFAULT NULL COMMENT '群组简称',
  `groupAllName` varchar(255) DEFAULT NULL COMMENT '路径全名',
  `roleId` varchar(255) DEFAULT NULL COMMENT '角色Id',
  `roleName` varchar(255) DEFAULT NULL COMMENT 'role name',
  `qiweiId` varchar(255) DEFAULT NULL COMMENT '企微ID_mega\r',
  `phoneNumber` varchar(255) DEFAULT NULL COMMENT '电话',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4

enterprise_user_app

CREATE TABLE `enterprise_user_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` varchar(255) DEFAULT NULL COMMENT '组织ID\n',
  `roleId` varchar(255) DEFAULT NULL COMMENT '角色ID',
  `userId` varchar(255) DEFAULT NULL COMMENT '用户id',
  `appId` varchar(255) DEFAULT NULL COMMENT 'appId',
  `source` 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
) ENGINE = InnoDB AUTO_INCREMENT = 834 DEFAULT CHARSET = utf8mb4

enterprise_user_group_role

• 用户群组角色关联表; 软删除未启用;

CREATE TABLE `enterprise_user_group_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255) NOT NULL COMMENT '用户id',
  `groupId` varchar(255) NOT NULL COMMENT '群组Id',
  `roleId` varchar(255) DEFAULT NULL COMMENT '角色Id',
  `roleDeadline` 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,
  KEY `groupId_index` (`groupId`) USING BTREE,
  KEY `userId_index` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 661 DEFAULT CHARSET = utf8mb4 COMMENT = '用户群组角色关联表; 软删除未启用;'

enterprise_user_group_role_page

• 用户群组角色 - 页面 映射表; 软删除未启用;

CREATE TABLE `enterprise_user_group_role_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appId` varchar(255) DEFAULT NULL,
  `user` text COMMENT 'userId 或者 通配符; 通配符: *',
  `group` varchar(255) DEFAULT NULL COMMENT 'groupId 或者 通配符; 通配符: *',
  `role` varchar(255) DEFAULT NULL COMMENT 'roleId 或者 通配符; 通配符: *',
  `page` longtext COMMENT 'pageId id',
  `allowOrDeny` varchar(255) DEFAULT NULL COMMENT '用户群组角色 匹配后 执行动作; allow、deny',
  `desc` varchar(255) DEFAULT NULL COMMENT '映射描述',
  `source` 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
) ENGINE = InnoDB AUTO_INCREMENT = 321 DEFAULT CHARSET = utf8mb4 COMMENT = '用户群组角色 - 页面 映射表; 软删除未启用;'

enterprise_user_group_role_resource

• 用户群组角色 - 请求资源 映射表; 软删除未启用;

CREATE TABLE `enterprise_user_group_role_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appId` varchar(255) DEFAULT NULL,
  `user` text COMMENT 'userId 或者 通配符; 通配符: *',
  `group` varchar(255) DEFAULT NULL COMMENT 'groupId 或者 通配符; 通配符: *',
  `role` varchar(255) DEFAULT NULL COMMENT 'roleId 或者 通配符; 通配符: *',
  `resource` mediumtext COMMENT 'resourceId 或者 通配符; 通配符: *, !resourceId',
  `allowOrDeny` varchar(255) DEFAULT NULL COMMENT '用户群组角色 匹配后 执行动作; allow、deny',
  `desc` varchar(255) DEFAULT NULL COMMENT '映射描述',
  `source` 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
) ENGINE = InnoDB AUTO_INCREMENT = 218 DEFAULT CHARSET = utf8mb4 COMMENT = '用户群组角色 - 请求资源 映射表; 软删除未启用;'

enterprise_view01_user

• 用户表

CREATE TABLE `enterprise_view01_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) DEFAULT NULL COMMENT '自增id; 用于生成userId',
  `userId` varchar(255) DEFAULT NULL COMMENT '主键id',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名(登陆)',
  `phoneNumber` varchar(255) DEFAULT NULL COMMENT '电话',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `userStatus` varchar(255) DEFAULT 'active' COMMENT '用户账号状态：活跃或关闭',
  `qiweiId` varchar(255) DEFAULT NULL COMMENT '企微ID_mega\r\n',
  `userConfig` text COMMENT '配置信息',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `md5Salt` varchar(255) DEFAULT NULL COMMENT 'md5Salt',
  `clearTextPassword` 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 `userId_index` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 86 DEFAULT CHARSET = utf8mb4 COMMENT = '用户表'

enterprise_view02_user_app

CREATE TABLE `enterprise_view02_user_app` (
  `id` int(11) NOT NULL,
  `userId` varchar(255) DEFAULT NULL COMMENT '用户id',
  `appId` varchar(255) DEFAULT NULL COMMENT 'appId'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4

lms_exam___constant

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

CREATE TABLE `lms_exam___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 = '常量表; 软删除未启用;'

lms_exam__exam

CREATE TABLE `lms_exam__exam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `examId` varchar(255)  DEFAULT NULL COMMENT '考试ID',
  `examName` varchar(255)  DEFAULT NULL COMMENT '考试名',
  `semester` varchar(255)  DEFAULT NULL COMMENT '学期',
  `year` varchar(255)  DEFAULT NULL COMMENT '自然年',
  `academicYear` varchar(255)  DEFAULT NULL COMMENT '年份',
  `segment` varchar(255)  DEFAULT NULL COMMENT '学部',
  `level` varchar(255)  DEFAULT NULL COMMENT '年级',
  `examType` varchar(255)  DEFAULT NULL COMMENT '考试类型',
  `learningTrack` varchar(255)  DEFAULT NULL COMMENT '学科方向',
  `subjectCount` int(11) DEFAULT NULL COMMENT '科目总数',
  `subjectList` varchar(255)  DEFAULT NULL COMMENT '科目列表',
  `subjectFullScore` text  COMMENT '科目满分',
  `startDate` varchar(255)  DEFAULT NULL COMMENT '考试开始日期',
  `endDate` varchar(255)  DEFAULT NULL COMMENT '考试结束日期',
  `startMonth` varchar(255)  DEFAULT NULL COMMENT '考试开始月',
  `subjectFullScoreList` varchar(255)  DEFAULT NULL COMMENT '科目满分列表，和科目列表是对应关系',
  `description` text  COMMENT '简介',
  `isSendNotice` varchar(255)  DEFAULT NULL COMMENT '是否通知家长',
  `examStatus` varchar(255)  DEFAULT NULL COMMENT '考试状态',
  `examResultStatus` varchar(255)  DEFAULT NULL COMMENT '考试成绩状态',
  `noticeTemplate` varchar(255)  DEFAULT NULL COMMENT '成绩通知模板',
  `noticeContent` text  COMMENT '成绩通知卡片配置',
  `noticeDetailContent` text  COMMENT '成绩通知详情配置',
  `noticeBatchId` varchar(255)  DEFAULT NULL COMMENT '成绩通知生成批次编号',
  `noticeCount` int(11) DEFAULT '0' COMMENT '生成的成绩通知总数',
  `restulUploadBatchId` 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,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `examId` (`examId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 107 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

lms_exam__notice_task

• 通知任务表(学生维度)

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

lms_exam__student_exam_result_subject

CREATE TABLE `lms_exam__student_exam_result_subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(255)  DEFAULT NULL COMMENT '自然年',
  `examId` varchar(255)  DEFAULT NULL COMMENT '考试ID',
  `examName` varchar(255)  DEFAULT NULL COMMENT '考试名称',
  `studentId` varchar(255)  DEFAULT NULL COMMENT '学生Id',
  `name` varchar(255)  DEFAULT NULL COMMENT '学生姓名',
  `academicYear` varchar(255)  DEFAULT NULL COMMENT '学年',
  `semester` varchar(255)  DEFAULT NULL COMMENT '学期',
  `segment` varchar(255)  DEFAULT NULL COMMENT '学部',
  `level` varchar(255)  DEFAULT NULL COMMENT '年级',
  `number` varchar(255)  DEFAULT NULL COMMENT '考试编号',
  `classId` varchar(255)  DEFAULT NULL COMMENT '班级',
  `className` varchar(255)  DEFAULT NULL COMMENT '班级名称',
  `classTagList` varchar(255)  DEFAULT NULL COMMENT '班级标签',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT '科目ID',
  `subjectName` varchar(255)  DEFAULT NULL COMMENT '科目',
  `subjectSortOrder` varchar(255)  DEFAULT NULL COMMENT '科目排序',
  `score` varchar(255)  DEFAULT NULL COMMENT '分数',
  `subjectClassRank` varchar(255)  DEFAULT NULL COMMENT '班级排名',
  `subjectSchoolRank` varchar(255)  DEFAULT NULL COMMENT '学校排名',
  `scoreDetails` text  COMMENT '分数详情',
  `resultStatus` varchar(255)  DEFAULT NULL COMMENT '分数状态',
  `resultUploadBatchId` varchar(255)  DEFAULT NULL,
  `resultUploadByUserId` varchar(255)  DEFAULT NULL,
  `resultUploadByUser` varchar(255)  DEFAULT NULL,
  `resultUploadAt` varchar(255)  DEFAULT NULL,
  `resultConfirmedByUserId` varchar(255)  DEFAULT NULL,
  `resultConfirmedByUser` varchar(255)  DEFAULT NULL,
  `resultConfirmedAt` varchar(255)  DEFAULT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `examId_studentId_subjectId` (`examId`, `studentId`, `subjectId`) USING BTREE,
  KEY `examId` (`examId`) USING BTREE,
  KEY `studentId` (`studentId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 135309 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

lms_hr__employee

CREATE TABLE `lms_hr__employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` varchar(255)  DEFAULT NULL COMMENT '员工id',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT '员工姓名',
  `idSequence` int(11) DEFAULT NULL COMMENT '员工序号',
  `sex` varchar(255)  DEFAULT NULL COMMENT '员工性别',
  `age` int(11) DEFAULT NULL COMMENT '员工年龄',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT '联系电话',
  `emergencyContactNumber` varchar(255)  DEFAULT NULL COMMENT '紧急联系电话',
  `post` varchar(255)  DEFAULT NULL COMMENT '岗位1',
  `post2` varchar(255)  DEFAULT NULL COMMENT '岗位2',
  `post3` varchar(255)  DEFAULT NULL COMMENT '岗位3',
  `politicalBackground` varchar(255)  DEFAULT NULL COMMENT '政治面貌',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT '身份证号码',
  `dateOfBirth` varchar(255)  DEFAULT NULL COMMENT '出生日期',
  `institution` varchar(255)  DEFAULT NULL COMMENT '毕业学校',
  `major` varchar(255)  DEFAULT NULL COMMENT '专业',
  `highestEducation` varchar(255)  DEFAULT NULL COMMENT '学历层次',
  `teacherQualification` varchar(255)  DEFAULT NULL COMMENT '教师资格证类别',
  `teacherQualificationLeaver` varchar(255)  DEFAULT NULL COMMENT '教师资格证学段',
  `teacherQualificationSubject` varchar(255)  DEFAULT NULL COMMENT '教师资格证学科',
  `teacherCertificationNumber` varchar(255)  DEFAULT NULL COMMENT '教师资格证编号',
  `teachingLevel` varchar(255)  DEFAULT NULL COMMENT '任教学段',
  `teachingSubject` varchar(255)  DEFAULT NULL COMMENT '任教学科',
  `residentialAddress` varchar(255)  DEFAULT NULL COMMENT '家庭地址',
  `province` varchar(255)  DEFAULT NULL COMMENT '省',
  `city` varchar(255)  DEFAULT NULL COMMENT '市',
  `county` varchar(255)  DEFAULT NULL COMMENT '县',
  `operationAt` varchar(255)  DEFAULT NULL,
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT '入职',
  `dateOfContractExpiration` varchar(255)  DEFAULT NULL COMMENT '到期',
  `leaveRequestStatus` varchar(255)  DEFAULT NULL COMMENT '申请离职状态',
  `cardNumber` varchar(255)  DEFAULT NULL COMMENT '建设银行卡卡号',
  `licensePlateNumber` varchar(255)  DEFAULT NULL COMMENT '车牌号',
  `employmentForms` varchar(255)  DEFAULT NULL COMMENT '聘用形式',
  `probationPeriod` varchar(255)  DEFAULT NULL COMMENT '试用期',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT '在职状态',
  `status` varchar(255)  DEFAULT NULL COMMENT '员工状态',
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `contactPerson` varchar(255)  DEFAULT NULL COMMENT '联系人',
  `educationExperience` varchar(255)  DEFAULT NULL COMMENT '教育经历',
  `certificate` varchar(255)  DEFAULT NULL COMMENT '证书',
  `salaryCard` varchar(255)  DEFAULT NULL COMMENT '薪资卡信息',
  `socialSecurity` varchar(255)  DEFAULT NULL COMMENT '社保卡信息',
  `trainingExperience` varchar(255)  DEFAULT NULL COMMENT '培训经历',
  `workExperience` varchar(255)  DEFAULT NULL COMMENT '工作经历',
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `employeeId` (`employeeId`) USING BTREE,
  KEY `entryStatus` (`entryStatus`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 646 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

lms_hr__member_org_role

• 组织员工表

CREATE TABLE `lms_hr__member_org_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orgId` varchar(255)  DEFAULT NULL COMMENT '组织Id;',
  `memberId` varchar(255)  DEFAULT NULL COMMENT '职员Id;',
  `roleId` varchar(255)  DEFAULT NULL COMMENT '角色Id; 负责人、成员',
  `remark` 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 `orgId_memberId_roleId_index` (`orgId`, `memberId`, `roleId`) USING BTREE,
  KEY `memberId` (`memberId`) USING BTREE,
  KEY `orgId` (`orgId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 86 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '组织员工表'

lms_notice__notice_task

• 通知任务表(学生维度)

CREATE TABLE `lms_notice__notice_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` int(11) DEFAULT NULL COMMENT '自增id;',
  `taskId` varchar(255)  DEFAULT NULL COMMENT '任务Id',
  `studentId` varchar(255)  DEFAULT NULL COMMENT '学生ID',
  `studentName` varchar(255)  DEFAULT NULL COMMENT '学生名',
  `noticeTemplate` varchar(255)  DEFAULT '普通文字消息模版' COMMENT '模板文件名;',
  `noticeName` varchar(255)  DEFAULT NULL COMMENT '消息名称',
  `noticeContent` text  COMMENT '消息内容JSON; eg: {"content": "测试推送"}',
  `noticeDetailContent` text  COMMENT '消息详情页内容JSON',
  `isGeneratePush` varchar(255)  DEFAULT '否' COMMENT '是否生成推送数据;',
  `createAt` varchar(255)  DEFAULT NULL COMMENT '创建任务时间;',
  `schedulePushAt` varchar(255)  DEFAULT NULL COMMENT '计划推送时间; E.g: 2021-05-28T10:24:54+08:00',
  `isPushByWxTemplate` varchar(255)  DEFAULT NULL COMMENT '是否使用微信模板消息推送',
  `appId` varchar(255)  DEFAULT NULL COMMENT '消息来源业务ID',
  `noticeBatchId` varchar(255)  DEFAULT NULL COMMENT '消息生成批次编号',
  `noticeData` text  COMMENT '消息的业务数据',
  `recipientCount` int(11) DEFAULT NULL COMMENT '消息收件人数',
  `noticeStatus` varchar(255)  DEFAULT NULL COMMENT '消息状态：draft-草稿，publish-已发布；仅推送已发布的消息',
  `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 `uniq` (`taskId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '通知任务表(学生维度)'

lms_notice__notice_task_push

• 推送表(weichatOpenid-学生维度)

CREATE TABLE `lms_notice__notice_task_push` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `taskId` varchar(255)  DEFAULT NULL COMMENT '任务Id',
  `taskPushId` varchar(255)  DEFAULT NULL COMMENT '任务推送Id; taskId-001',
  `wechatOpenId` varchar(255)  DEFAULT NULL COMMENT '微信Id',
  `wechatOpenNickName` varchar(255)  DEFAULT NULL COMMENT '微信名',
  `studentId` varchar(255)  DEFAULT NULL COMMENT '学生ID',
  `studentName` varchar(255)  DEFAULT NULL COMMENT '学生名',
  `noticeTemplate` varchar(255)  DEFAULT '普通文字消息模版' COMMENT '模板文件名;',
  `noticeName` varchar(255)  DEFAULT NULL COMMENT '消息名称',
  `noticeContent` text  COMMENT '消息内容JSON; eg: {"content": "测试推送"}',
  `noticeDetailContent` text  COMMENT '消息详情页内容JSON',
  `pushStatus` varchar(255)  DEFAULT 'panding' COMMENT '推送状态; panding=未推送, success=推送成功, fail=推送失败',
  `pushAt` varchar(255)  DEFAULT NULL COMMENT '推送时间; E.g: 2021-05-28T10:24:54+08:00 ',
  `pushFailErrorReason` text  COMMENT '推送失败错误信息; [{ errorMessage }, { errorMessage }]',
  `pushFailTimes` int(11) NOT NULL DEFAULT '0' COMMENT '推送失败次数;',
  `schedulePushAt` varchar(255)  DEFAULT NULL COMMENT '计划推送时间; E.g: 2021-05-28T10:24:54+08:00',
  `isRead` varchar(255)  DEFAULT '否' 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 `taskPushId_unique` (`taskPushId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '推送表(weichatOpenid-学生维度)'

lms_notice__tuition_bill_order

• 微信Id-学生Id关联表

CREATE TABLE `lms_notice__tuition_bill_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255)  DEFAULT NULL COMMENT '自增id;',
  `studentId` varchar(255)  DEFAULT NULL COMMENT '学生id',
  `classId` varchar(255)  DEFAULT NULL COMMENT '班级id',
  `billId` varchar(255)  DEFAULT NULL COMMENT '微信Id',
  `billInfo` text  COMMENT '学生ID',
  `tuitionOrderId` varchar(255)  DEFAULT NULL COMMENT '订单流水号',
  `amount` decimal(10, 2) DEFAULT NULL COMMENT '总金额',
  `traceNo` int(6) unsigned zerofill DEFAULT NULL COMMENT '流水号',
  `bocPayLs` varchar(255)  DEFAULT NULL COMMENT '中银交易流水号',
  `bocQrCode` varchar(255)  DEFAULT NULL,
  `bocResponse` text  COMMENT '返回body',
  `bocNotify` text ,
  `bocNotifyAt` varchar(255)  DEFAULT NULL,
  `paymentStatus` varchar(255)  DEFAULT NULL COMMENT '订单状态',
  `retryCount` int(11) DEFAULT '0',
  `createAt` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  `createUser` 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 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = '微信Id-学生Id关联表'

lms_student_admin__class

CREATE TABLE `lms_student_admin__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

lms_student_admin__class_history

CREATE TABLE `lms_student_admin__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

lms_student_admin__student_basic

CREATE TABLE `lms_student_admin__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

lms_ua_arm__user

CREATE TABLE `lms_ua_arm__user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255)  DEFAULT NULL COMMENT '主键id',
  `username` varchar(255)  DEFAULT NULL COMMENT '用户名(登陆)',
  `displayName` varchar(255)  DEFAULT NULL COMMENT '用户名(展示)',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT '手机号码',
  `initialPassword` varchar(255)  DEFAULT NULL COMMENT '初始密码',
  `password` varchar(255)  DEFAULT NULL COMMENT '密码',
  `userStatus` varchar(255)  DEFAULT 'active' COMMENT '用户账号状态：活跃或关闭',
  `userType` varchar(255)  DEFAULT NULL COMMENT '用户类型; staff, student.',
  `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 `userId` (`userId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

lms_user_app_management___app

CREATE TABLE `lms_user_app_management___app` (
  `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 = 52 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

lms_user_app_management___user

• 用户表

CREATE TABLE `lms_user_app_management___user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255)  DEFAULT NULL COMMENT '自增id; 用于生成userId',
  `userId` varchar(255)  DEFAULT NULL COMMENT '主键id',
  `username` varchar(255)  DEFAULT NULL COMMENT '用户名(登陆)',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT '联系方式',
  `clearTextPassword` varchar(255)  DEFAULT NULL COMMENT '明文密码',
  `password` varchar(255)  DEFAULT NULL COMMENT '密码',
  `md5Salt` varchar(255)  DEFAULT NULL COMMENT 'md5Salt',
  `userStatus` varchar(255)  DEFAULT 'active' COMMENT '用户账号状态：活跃或关闭',
  `userType` varchar(255)  DEFAULT NULL COMMENT '用户类型; staff, student.',
  `userConfig` text  COMMENT '配置信息',
  `openid` varchar(255)  DEFAULT NULL COMMENT '微信openid',
  `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 `userId_index` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 391 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户表'

lms_user_app_management___user_app

CREATE TABLE `lms_user_app_management___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 = 792 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

视图

_directory_user_session

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

_group

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

_role

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

_user_group_role

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

_user_group_role_page

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_user_group_role_page` AS
select
  `enterprise_user_group_role_page`.`id` AS `id`,
  `enterprise_user_group_role_page`.`appId` AS `appId`,
  `enterprise_user_group_role_page`.`user` AS `user`,
  `enterprise_user_group_role_page`.`group` AS `group`,
  `enterprise_user_group_role_page`.`role` AS `role`,
  `enterprise_user_group_role_page`.`page` AS `page`,
  `enterprise_user_group_role_page`.`allowOrDeny` AS `allowOrDeny`,
  `enterprise_user_group_role_page`.`desc` AS `desc`,
  `enterprise_user_group_role_page`.`source` AS `source`,
  `enterprise_user_group_role_page`.`operation` AS `operation`,
  `enterprise_user_group_role_page`.`operationByUserId` AS `operationByUserId`,
  `enterprise_user_group_role_page`.`operationByUser` AS `operationByUser`,
  `enterprise_user_group_role_page`.`operationAt` AS `operationAt`
from
  `enterprise_user_group_role_page`
where
  (
    (
      `enterprise_user_group_role_page`.`appId` = 'lms-data-repository'
    )
    or (`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
  `enterprise_user_group_role_resource`.`id` AS `id`,
  `enterprise_user_group_role_resource`.`appId` AS `appId`,
  `enterprise_user_group_role_resource`.`user` AS `user`,
  `enterprise_user_group_role_resource`.`group` AS `group`,
  `enterprise_user_group_role_resource`.`role` AS `role`,
  `enterprise_user_group_role_resource`.`resource` AS `resource`,
  `enterprise_user_group_role_resource`.`allowOrDeny` AS `allowOrDeny`,
  `enterprise_user_group_role_resource`.`desc` AS `desc`,
  `enterprise_user_group_role_resource`.`source` AS `source`,
  `enterprise_user_group_role_resource`.`operation` AS `operation`,
  `enterprise_user_group_role_resource`.`operationByUserId` AS `operationByUserId`,
  `enterprise_user_group_role_resource`.`operationByUser` AS `operationByUser`,
  `enterprise_user_group_role_resource`.`operationAt` AS `operationAt`
from
  `enterprise_user_group_role_resource`
where
  (
    (
      `enterprise_user_group_role_resource`.`appId` = 'lms-data-repository'
    )
    or (
      `enterprise_user_group_role_resource`.`appId` = '*'
    )
  )

_view01_user

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

_view02_user_app

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