江湖数字化平台
登录

数据结构

12114

表总览

普通表

_cache

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

_constant

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

_constant_ui

  • 常量表;
  1. CREATE TABLE `_constant_ui` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `constantKey` varchar(255)  DEFAULT NULL,
  4.   `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  5.   `pageId` varchar(255)  DEFAULT 'all' COMMENT '页面id',
  6.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  7.   `en` text  COMMENT '常量内容; object, array',
  8.   `zh` text  COMMENT '常量内容; object, array',
  9.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  10.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  11.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  12.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  13.   PRIMARY KEY (`id`) USING BTREE,
  14.   UNIQUE KEY `pageId_constantKey_unique` (`constantKey`, `pageId`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表;'

_page

  • 页面表; 软删除未启用;
  1. CREATE TABLE `_page` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  4.   `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  5.   `pageFile` varchar(255)  DEFAULT NULL,
  6.   `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  7.   `sort` varchar(255)  DEFAULT NULL,
  8.   `pageHook` text  COMMENT '{\n  "beforeHook":[\n  {"field": "doc", "service": "doc", "serviceFunc": "getDoc"}\n  ]\n}',
  9.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  10.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  11.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  12.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  13.   PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB AUTO_INCREMENT = 85 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

_record_history

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

_resource

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

_resource_request_log

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

_test_case

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

_ui

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

_user

  • 用户表;
  1. CREATE TABLE `_user` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `idSequence` varchar(255)  DEFAULT NULL,
  4.   `userId` varchar(255)  DEFAULT NULL COMMENT '用户id',
  5.   `username` varchar(255)  DEFAULT NULL COMMENT '用户名',
  6.   `userAvatar` varchar(255)  DEFAULT NULL COMMENT '用户头像',
  7.   `contactNumber` varchar(255)  DEFAULT NULL COMMENT '联系方式',
  8.   `gender` varchar(255)  DEFAULT 'male' COMMENT '性别; male, female',
  9.   `birthday` varchar(255)  DEFAULT NULL COMMENT '生日E.g: 2021-05-28T10:24:54+08:00 ',
  10.   `signature` varchar(255)  DEFAULT NULL COMMENT '签名',
  11.   `email` varchar(255)  DEFAULT NULL COMMENT '邮箱',
  12.   `clearTextPassword` varchar(255)  DEFAULT NULL COMMENT '初始明文密码',
  13.   `password` varchar(255)  DEFAULT NULL COMMENT 'password',
  14.   `md5Salt` varchar(255)  DEFAULT NULL COMMENT 'md5Salt',
  15.   `userType` varchar(255)  DEFAULT 'common' COMMENT '用户类型; common, xiaochengxu',
  16.   `userStatus` varchar(255)  DEFAULT 'active' COMMENT '用户类型; active, banned',
  17.   `config` mediumtext  COMMENT '置顶信息',
  18.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  19.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  20.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  21.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  22.   PRIMARY KEY (`id`) USING BTREE,
  23.   UNIQUE KEY `userId_unique` (`userId`) USING BTREE
  24. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户表;'

_user_session

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

article

  1. CREATE TABLE `article` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `articleId` bigint(20) DEFAULT NULL COMMENT '文章id, 10000 ++',
  4.   `categoryId` varchar(255)  DEFAULT NULL COMMENT '分类id',
  5.   `articleGroupName` varchar(255)  DEFAULT '' COMMENT '文章所属分组名',
  6.   `articleTagList` text CHARACTER SET utf8mb4  COMMENT '标签; 用, 拼接',
  7.   `articleDescription` varchar(255)  DEFAULT NULL COMMENT '文章描述',
  8.   `articlePublishStatus` varchar(255)  DEFAULT '' COMMENT '文章类型(状态)：public, login, draft, deleted',
  9.   `articlePublishTime` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '文章发布时间',
  10.   `articleTitle` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '标题',
  11.   `articleCoverImage` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '封面',
  12.   `articleContent` longtext CHARACTER SET utf8mb4  COMMENT '编辑的内容',
  13.   `articleContentForSeo` longtext CHARACTER SET utf8mb4  COMMENT 'HTML 用于渲染',
  14.   `articleAssignmentList` text  COMMENT '文章作业 [{ }]',
  15.   `articleAssignmentListWithAnswer` text  COMMENT '文章作业答案 [{ }]',
  16.   `articleAudioUrl` varchar(1023) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '默认音频URL唯一的',
  17.   `articleVideoUrl` varchar(1023)  DEFAULT '' COMMENT '默认视频URL',
  18.   `articleCreateTime` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '创建时间',
  19.   `articleCreateUserId` varchar(255)  DEFAULT '' COMMENT '创建者用户ID',
  20.   `articleCreateUsername` varchar(255)  DEFAULT '' COMMENT '创建者用户名',
  21.   `articleUpdateTime` varchar(255)  DEFAULT '' COMMENT '更新时间',
  22.   `articleUpdateUserId` varchar(255)  DEFAULT '' COMMENT '更新者用户ID',
  23.   `articleUpdateUsername` varchar(255)  DEFAULT '' COMMENT '更新者用户名',
  24.   `operation` varchar(255)  DEFAULT '' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  25.   `operationByUserId` varchar(255)  DEFAULT '' COMMENT '操作者userId',
  26.   `operationByUser` varchar(255)  DEFAULT '' COMMENT '操作者用户名',
  27.   `operationAt` varchar(255)  DEFAULT '' COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  28.   PRIMARY KEY (`id`) USING BTREE,
  29.   UNIQUE KEY `article_unique` (`articleId`) USING BTREE,
  30.   KEY `categoryId_index` (`categoryId`) USING BTREE,
  31.   KEY `articlePublishTime` (`articlePublishTime`) USING BTREE
  32. ) ENGINE = InnoDB AUTO_INCREMENT = 51270 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

article_bak

  1. CREATE TABLE `article_bak` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `articleId` bigint(20) DEFAULT NULL COMMENT '文章id, 10000 ++',
  4.   `categoryId` varchar(255)  DEFAULT NULL COMMENT '分类id',
  5.   `articleGroupName` varchar(255)  DEFAULT '' COMMENT '文章所属分组名',
  6.   `articleTagList` text CHARACTER SET utf8mb4  COMMENT '标签; 用, 拼接',
  7.   `articleDescription` varchar(255)  DEFAULT NULL COMMENT '文章描述',
  8.   `articlePublishStatus` varchar(255)  DEFAULT '' COMMENT '文章类型(状态)：public, login, draft, deleted',
  9.   `articlePublishTime` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '文章发布时间',
  10.   `articleTitle` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '标题',
  11.   `articleCoverImage` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '封面',
  12.   `articleContent` longtext CHARACTER SET utf8mb4  COMMENT '编辑的内容',
  13.   `articleContentForSeo` longtext CHARACTER SET utf8mb4  COMMENT 'HTML 用于渲染',
  14.   `articleAssignmentList` text  COMMENT '文章作业 [{ }]',
  15.   `articleAssignmentListWithAnswer` text  COMMENT '文章作业答案 [{ }]',
  16.   `articleAudioUrl` varchar(1023) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '默认音频URL唯一的',
  17.   `articleVideoUrl` varchar(1023)  DEFAULT '' COMMENT '默认视频URL',
  18.   `articleCreateTime` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '创建时间',
  19.   `articleCreateUserId` varchar(255)  DEFAULT '' COMMENT '创建者用户ID',
  20.   `articleCreateUsername` varchar(255)  DEFAULT '' COMMENT '创建者用户名',
  21.   `articleUpdateTime` varchar(255)  DEFAULT '' COMMENT '更新时间',
  22.   `articleUpdateUserId` varchar(255)  DEFAULT '' COMMENT '更新者用户ID',
  23.   `articleUpdateUsername` varchar(255)  DEFAULT '' COMMENT '更新者用户名',
  24.   `operation` varchar(255)  DEFAULT '' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  25.   `operationByUserId` varchar(255)  DEFAULT '' COMMENT '操作者userId',
  26.   `operationByUser` varchar(255)  DEFAULT '' COMMENT '操作者用户名',
  27.   `operationAt` varchar(255)  DEFAULT '' COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  28.   `articleConfig` varchar(500)  DEFAULT NULL COMMENT '命定页面配置',
  29.   PRIMARY KEY (`id`) USING BTREE,
  30.   UNIQUE KEY `article_unique` (`articleId`) USING BTREE,
  31.   KEY `categoryId_index` (`categoryId`) USING BTREE,
  32.   KEY `articlePublishTime` (`articlePublishTime`) USING BTREE
  33. ) ENGINE = InnoDB AUTO_INCREMENT = 4752 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

article_history

  1. CREATE TABLE `article_history` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `articleId` bigint(20) DEFAULT NULL COMMENT '文章id, 10000 ++',
  4.   `categoryId` varchar(255)  DEFAULT NULL COMMENT '分类id',
  5.   `articleGroupName` varchar(255)  DEFAULT NULL COMMENT '文章所属分组名',
  6.   `articleTagList` varchar(255)  DEFAULT NULL COMMENT '标签; 用, 拼接',
  7.   `articleDescription` varchar(1023)  DEFAULT NULL COMMENT '文章描述',
  8.   `articlePublishStatus` varchar(255)  DEFAULT 'login' COMMENT '文章类型(状态)：public, login, draft, deleted',
  9.   `articlePublishTime` varchar(255)  DEFAULT NULL COMMENT '文章发布时间',
  10.   `articleTitle` varchar(255)  DEFAULT NULL COMMENT '标题',
  11.   `articleCoverImage` varchar(255)  DEFAULT NULL COMMENT '封面',
  12.   `articleContent` longtext  COMMENT '编辑的内容',
  13.   `articleContentForSeo` longtext  COMMENT 'HTML 用于渲染',
  14.   `articleAssignmentList` text  COMMENT '文章作业 [{ }]',
  15.   `articleAssignmentListWithAnswer` text  COMMENT '文章作业答案 [{ }]',
  16.   `articleAudioUrl` varchar(255)  DEFAULT NULL COMMENT '默认音频URL唯一的',
  17.   `articleVideoUrl` varchar(255)  DEFAULT NULL COMMENT '默认视频URL',
  18.   `articleCreateTime` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  19.   `articleCreateUserId` varchar(255)  DEFAULT NULL COMMENT '创建者用户ID',
  20.   `articleCreateUsername` varchar(255)  DEFAULT NULL COMMENT '创建者用户名',
  21.   `articleUpdateTime` varchar(255)  DEFAULT NULL COMMENT '更新时间',
  22.   `articleUpdateUserId` varchar(255)  DEFAULT NULL COMMENT '更新者用户ID',
  23.   `articleUpdateUsername` varchar(255)  DEFAULT NULL COMMENT '更新者用户名',
  24.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  25.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  26.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  27.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  28.   PRIMARY KEY (`id`) USING BTREE
  29. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

calendar

  1. CREATE TABLE `calendar` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  3.   `calendarId` varchar(255)  DEFAULT NULL COMMENT '日历id',
  4.   `calendarName` varchar(255)  DEFAULT NULL COMMENT '日历name',
  5.   `calendarType` varchar(255)  DEFAULT NULL COMMENT '日历类型',
  6.   `startDay` varchar(255)  DEFAULT NULL COMMENT '开始日期',
  7.   `endDay` varchar(255)  DEFAULT NULL COMMENT '结束日期',
  8.   `events` text  COMMENT '事件',
  9.   `operation` varchar(255)  DEFAULT NULL COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  10.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  11.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  12.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  13.   PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

category

  1. CREATE TABLE `category` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `categoryId` bigint(255) DEFAULT NULL COMMENT '分类id',
  4.   `categoryName` varchar(255) CHARACTER SET utf8mb4  DEFAULT '',
  5.   `categoryArticleIgnoreTiltle` varchar(255)  DEFAULT NULL,
  6.   `categoryIntro` text CHARACTER SET utf8mb4 ,
  7.   `categoryGroup` varchar(255)  DEFAULT NULL,
  8.   `categoryGroupSort` varchar(255)  DEFAULT NULL,
  9.   `categoryPublishStatus` varchar(255)  DEFAULT '',
  10.   `categoryCreateTime` varchar(255)  DEFAULT '',
  11.   `categoryCreateUserId` varchar(255)  DEFAULT '',
  12.   `categoryCreateUsername` varchar(255)  DEFAULT '',
  13.   `categoryUpdateTime` varchar(255)  DEFAULT '',
  14.   `categoryUpdateUserId` varchar(255)  DEFAULT '',
  15.   `categoryUpdateUsername` varchar(255)  DEFAULT '',
  16.   `operation` varchar(255)  DEFAULT '',
  17.   `operationByUserId` varchar(255)  DEFAULT '',
  18.   `operationByUser` varchar(255)  DEFAULT '',
  19.   `operationAt` varchar(255)  DEFAULT '',
  20.   `categoryMark` varchar(255)  DEFAULT NULL COMMENT '备注',
  21.   PRIMARY KEY (`id`) USING BTREE,
  22.   KEY `categoryId_unique` (`categoryId`) USING BTREE,
  23.   KEY `categoryName_unique` (`categoryName`) USING BTREE
  24. ) ENGINE = InnoDB AUTO_INCREMENT = 195 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

web_constant_ui

  • 常量表;
  1. CREATE TABLE `web_constant_ui` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `constantKey` varchar(255)  DEFAULT NULL,
  4.   `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  5.   `pageId` varchar(255)  DEFAULT 'all' COMMENT '页面id',
  6.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  7.   `en` text  COMMENT '常量内容; object, array',
  8.   `zh` text  COMMENT '常量内容; object, array',
  9.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  10.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  11.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  12.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  13.   PRIMARY KEY (`id`) USING BTREE,
  14.   UNIQUE KEY `pageId_constantKey_unique` (`constantKey`, `pageId`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 25 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表;'

xf_page

  • 旋风定制页面表
  1. CREATE TABLE `xf_page` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `xfPageId` varchar(255)  DEFAULT NULL COMMENT 'xf pageId',
  4.   `categoryId` varchar(255)  DEFAULT NULL COMMENT '分类',
  5.   `routeAlias` varchar(255)  DEFAULT NULL,
  6.   `xfPageTagList` text  COMMENT '标签; 用, 拼接',
  7.   `xfPagePublishStatus` varchar(255)  DEFAULT '' COMMENT '文章类型(状态)：public, login, draft, deleted',
  8.   `xfPagePublishTime` varchar(255)  DEFAULT NULL COMMENT '文章发布时间',
  9.   `xfPageTitle` varchar(255)  DEFAULT NULL COMMENT '标题',
  10.   `xfPageCoverImage` varchar(255)  DEFAULT NULL COMMENT '封面',
  11.   `xfPageContent` longtext  COMMENT '编辑的内容',
  12.   `xfPageContentForSeo` longtext  COMMENT 'HTML 用于渲染',
  13.   `xfPageAudioUrl` varchar(1023)  DEFAULT NULL COMMENT '默认音频URL唯一的',
  14.   `xfPageVideoUrl` varchar(1023)  DEFAULT '' COMMENT '默认视频URL',
  15.   `xfPageDescription` varchar(255)  DEFAULT NULL COMMENT '描述',
  16.   `xfPageCreateTime` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  17.   `xfPageCreateUserId` varchar(255)  DEFAULT '' COMMENT '创建者用户ID',
  18.   `xfPageCreateUsername` varchar(255)  DEFAULT '' COMMENT '创建者用户名',
  19.   `xfPageUpdateTime` varchar(255)  DEFAULT '' COMMENT '更新时间',
  20.   `xfPageUpdateUserId` varchar(255)  DEFAULT '' COMMENT '更新者用户ID',
  21.   `xfPageUpdateUsername` varchar(255)  DEFAULT '' COMMENT '更新者用户名',
  22.   `xfPageConfig` mediumtext  COMMENT '配置',
  23.   `template` varchar(255)  DEFAULT NULL COMMENT '模板',
  24.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  25.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  26.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  27.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  28.   PRIMARY KEY (`id`) USING BTREE,
  29.   UNIQUE KEY `xf_page_xfPageId_uindex` (`xfPageId`) USING BTREE
  30. ) ENGINE = InnoDB AUTO_INCREMENT = 124 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '旋风定制页面表'

xf_page_history

  • 旋风定制页面历史表
  1. CREATE TABLE `xf_page_history` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `xfPageId` varchar(255)  DEFAULT NULL COMMENT 'xf pageId',
  4.   `categoryId` varchar(255)  DEFAULT NULL,
  5.   `routeAlias` varchar(255)  DEFAULT NULL,
  6.   `xfPageTagList` text  COMMENT '标签; 用, 拼接',
  7.   `xfPagePublishStatus` varchar(255)  DEFAULT '' COMMENT '文章类型(状态)：public, login, draft, deleted',
  8.   `xfPagePublishTime` varchar(255)  DEFAULT NULL COMMENT '文章发布时间',
  9.   `xfPageTitle` varchar(255)  DEFAULT NULL COMMENT '标题',
  10.   `xfPageDescription` varchar(255)  DEFAULT NULL COMMENT '描述',
  11.   `xfPageCoverImage` varchar(255)  DEFAULT NULL COMMENT '封面',
  12.   `xfPageContent` longtext  COMMENT '编辑的内容',
  13.   `xfPageContentForSeo` longtext  COMMENT 'HTML 用于渲染',
  14.   `xfPageAudioUrl` varchar(1023)  DEFAULT NULL COMMENT '默认音频URL唯一的',
  15.   `xfPageVideoUrl` varchar(1023)  DEFAULT '' COMMENT '默认视频URL',
  16.   `xfPageCreateTime` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  17.   `xfPageCreateUserId` varchar(255)  DEFAULT '' COMMENT '创建者用户ID',
  18.   `xfPageCreateUsername` varchar(255)  DEFAULT '' COMMENT '创建者用户名',
  19.   `xfPageUpdateTime` varchar(255)  DEFAULT '' COMMENT '更新时间',
  20.   `xfPageUpdateUserId` varchar(255)  DEFAULT '' COMMENT '更新者用户ID',
  21.   `xfPageUpdateUsername` varchar(255)  DEFAULT '' COMMENT '更新者用户名',
  22.   `xfPageConfig` text  COMMENT '配置',
  23.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  24.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  25.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  26.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  27.   `template` varchar(255) CHARACTER SET armscii8  DEFAULT NULL COMMENT '模板',
  28.   PRIMARY KEY (`id`) USING BTREE
  29. ) ENGINE = InnoDB AUTO_INCREMENT = 1050 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '旋风定制页面历史表'

xf_page_new

  • 旋风定制页面表
  1. CREATE TABLE `xf_page_new` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `xfPageId` varchar(255)  DEFAULT NULL COMMENT 'xf pageId',
  4.   `categoryId` varchar(255)  DEFAULT NULL COMMENT '分类',
  5.   `xfPageTagList` text  COMMENT '标签; 用, 拼接',
  6.   `xfPagePublishStatus` varchar(255)  DEFAULT '' COMMENT '文章类型(状态)：public, login, draft, deleted',
  7.   `xfPagePublishTime` varchar(255)  DEFAULT NULL COMMENT '文章发布时间',
  8.   `xfPageTitle` varchar(255)  DEFAULT NULL COMMENT '标题',
  9.   `xfPageCoverImage` varchar(255)  DEFAULT NULL COMMENT '封面',
  10.   `xfPageContent` longtext  COMMENT '编辑的内容',
  11.   `xfPageContentForSeo` longtext  COMMENT 'HTML 用于渲染',
  12.   `xfPageAudioUrl` varchar(1023)  DEFAULT NULL COMMENT '默认音频URL唯一的',
  13.   `xfPageVideoUrl` varchar(1023)  DEFAULT '' COMMENT '默认视频URL',
  14.   `xfPageCreateTime` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  15.   `xfPageCreateUserId` varchar(255)  DEFAULT '' COMMENT '创建者用户ID',
  16.   `xfPageCreateUsername` varchar(255)  DEFAULT '' COMMENT '创建者用户名',
  17.   `xfPageUpdateTime` varchar(255)  DEFAULT '' COMMENT '更新时间',
  18.   `xfPageUpdateUserId` varchar(255)  DEFAULT '' COMMENT '更新者用户ID',
  19.   `xfPageUpdateUsername` varchar(255)  DEFAULT '' COMMENT '更新者用户名',
  20.   `xfPageConfig` varchar(255)  DEFAULT NULL COMMENT '配置',
  21.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  22.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  23.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  24.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  25.   PRIMARY KEY (`id`) USING BTREE,
  26.   UNIQUE KEY `xf_page_xfPageId_uindex` (`xfPageId`) USING BTREE
  27. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '旋风定制页面表'

视图

_directory_user_session

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

_group

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

_role

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

_user_group_role

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

_user_group_role_page

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

_user_group_role_resource

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

_view01_user

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

_view02_user_app

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

view01_article

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_article` AS
  2. select
  3.   `article`.`id` AS `id`,
  4.   `article`.`articleId` AS `articleId`,
  5.   `article`.`categoryId` AS `categoryId`,
  6.   `article`.`articleGroupName` AS `articleGroupName`,
  7.   `article`.`articleTagList` AS `articleTagList`,
  8.   `article`.`articleDescription` AS `articleDescription`,
  9.   `article`.`articlePublishStatus` AS `articlePublishStatus`,
  10.   `article`.`articlePublishTime` AS `articlePublishTime`,
  11.   `article`.`articleTitle` AS `articleTitle`,
  12.   `article`.`articleCoverImage` AS `articleCoverImage`,
  13.   `article`.`articleAudioUrl` AS `articleAudioUrl`,
  14.   `article`.`articleVideoUrl` AS `articleVideoUrl`,
  15.   `article`.`articleCreateTime` AS `articleCreateTime`,
  16.   `article`.`articleCreateUserId` AS `articleCreateUserId`,
  17.   `article`.`articleCreateUsername` AS `articleCreateUsername`,
  18.   `article`.`articleUpdateTime` AS `articleUpdateTime`,
  19.   `article`.`articleUpdateUserId` AS `articleUpdateUserId`,
  20.   `article`.`articleUpdateUsername` AS `articleUpdateUsername`,
  21.   `article`.`operation` AS `operation`,
  22.   `article`.`operationByUserId` AS `operationByUserId`,
  23.   `article`.`operationByUser` AS `operationByUser`,
  24.   `article`.`operationAt` AS `operationAt`,
  25.   `category`.`categoryName` AS `categoryName`,
  26.   `category`.`categoryIntro` AS `categoryIntro`,
  27.   `category`.`categoryGroup` AS `categoryGroup`,
  28.   `category`.`categoryGroupSort` AS `categoryGroupSort`
  29. from
  30.   (
  31.     `article`
  32.     left join `category` on (
  33.       (`article`.`categoryId` = `category`.`categoryId`)
  34.     )
  35.   )

view01_category

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_category` AS
  2. select
  3.   count(
  4.     (
  5.       `article`.`articlePublishStatus` in ('public', 'login')
  6.     )
  7.   ) AS `count`,
  8.   `category`.`id` AS `id`,
  9.   `category`.`categoryId` AS `categoryId`,
  10.   `category`.`categoryName` AS `categoryName`,
  11.   `category`.`categoryArticleIgnoreTiltle` AS `categoryArticleIgnoreTiltle`,
  12.   `category`.`categoryGroup` AS `categoryGroup`,
  13.   `category`.`categoryGroupSort` AS `categoryGroupSort`,
  14.   concat(
  15.     '<',
  16.     `category`.`categoryGroup`,
  17.     `category`.`categoryGroupSort`,
  18.     '>'
  19.   ) AS `categoryGroupConcat`,
  20.   `category`.`categoryIntro` AS `categoryIntro`,
  21.   `category`.`categoryPublishStatus` AS `categoryPublishStatus`,
  22.   `category`.`categoryCreateTime` AS `categoryCreateTime`,
  23.   `category`.`categoryCreateUserId` AS `categoryCreateUserId`,
  24.   `category`.`categoryCreateUsername` AS `categoryCreateUsername`,
  25.   `category`.`categoryUpdateTime` AS `categoryUpdateTime`,
  26.   `category`.`categoryUpdateUserId` AS `categoryUpdateUserId`,
  27.   `category`.`categoryUpdateUsername` AS `categoryUpdateUsername`,
  28.   `category`.`operation` AS `operation`,
  29.   `category`.`operationByUserId` AS `operationByUserId`,
  30.   `category`.`operationByUser` AS `operationByUser`,
  31.   `category`.`operationAt` AS `operationAt`
  32. from
  33.   (
  34.     `category`
  35.     left join `article` on (
  36.       (`category`.`categoryId` = `article`.`categoryId`)
  37.     )
  38.   )
  39. group by
  40.   `category`.`categoryId`