数据结构

12114

表总览

普通表

_cache

• 缓存表

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

_constant

• 常量表;

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

_file

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

CREATE TABLE `_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fileId` varchar(255)  DEFAULT NULL COMMENT 'fileId',
  `fileDirectory` varchar(255)  DEFAULT NULL COMMENT '文件保存路径;',
  `filename` varchar(255)  DEFAULT NULL COMMENT '文件名;',
  `filenameStorage` varchar(255)  DEFAULT NULL COMMENT '文件保存名',
  `downloadPath` varchar(255)  DEFAULT NULL COMMENT '文件下载路径',
  `fileType` varchar(255)  DEFAULT NULL COMMENT '文件类型;(预留字段)',
  `fileDesc` varchar(255)  DEFAULT NULL COMMENT '文件描述',
  `binarySize` 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 `fileId_index` (`fileId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '文件表; 软删除未启用;'

_group

• 群组表; 软删除未启用;

CREATE TABLE `_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` varchar(255)  NOT NULL COMMENT 'groupId',
  `groupName` varchar(255)  DEFAULT NULL COMMENT '群组名',
  `groupDesc` varchar(255)  DEFAULT NULL COMMENT '群组描述',
  `groupAvatar` varchar(255)  DEFAULT NULL COMMENT '群logo',
  `groupExtend` varchar(1024)  DEFAULT '{}' COMMENT '拓展字段; { groupNotice: ''xx'' }',
  `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
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '群组表; 软删除未启用;'

_page

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

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `sort` varchar(255)  DEFAULT NULL,
  `pageHook` text  COMMENT '{\n  "beforeHook":[\n  {"field": "doc", "service": "doc", "serviceFunc": "getDoc"}\n  ]\n}',
  `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 = 93 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

_record_history

• 数据历史表

CREATE TABLE `_record_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `table` varchar(255)  DEFAULT NULL COMMENT '表',
  `recordId` int(11) DEFAULT NULL COMMENT '数据在table中的主键id; recordContent.id',
  `recordContent` longtext  COMMENT '数据JSON',
  `packageContent` longtext  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 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '数据历史表'

_resource

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

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

_role

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

CREATE TABLE `_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleId` varchar(255)  DEFAULT NULL COMMENT 'roleId',
  `roleName` varchar(255)  DEFAULT NULL COMMENT 'role name',
  `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
) ENGINE = InnoDB AUTO_INCREMENT = 10 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '角色表; 软删除未启用;'

_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 '测试用例步骤;',
  `operation` varchar(255)  DEFAULT NULL COMMENT '操作; jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId; recordContent.operationByUserId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名; recordContent.operationByUser',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; recordContent.operationAt; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '测试用例表'

_ui

• ui 施工方案

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

_user

• 用户表;

CREATE TABLE `_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255)  DEFAULT NULL,
  `userId` varchar(255)  DEFAULT NULL COMMENT '用户id',
  `username` varchar(255)  DEFAULT NULL COMMENT '用户名',
  `userAvatar` varchar(255)  DEFAULT NULL COMMENT '用户头像',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT '联系方式',
  `gender` varchar(255)  DEFAULT 'male' COMMENT '性别; male, female',
  `birthday` varchar(255)  DEFAULT NULL COMMENT '生日E.g: 2021-05-28T10:24:54+08:00 ',
  `signature` varchar(255)  DEFAULT NULL COMMENT '签名',
  `email` varchar(255)  DEFAULT NULL COMMENT '邮箱',
  `clearTextPassword` varchar(255)  DEFAULT NULL COMMENT '初始明文密码',
  `password` varchar(255)  DEFAULT NULL COMMENT 'password',
  `md5Salt` varchar(255)  DEFAULT NULL COMMENT 'md5Salt',
  `userType` varchar(255)  DEFAULT 'common' COMMENT '用户类型; common, xiaochengxu',
  `userStatus` varchar(255)  DEFAULT 'active' COMMENT '用户类型; active, banned',
  `config` mediumtext  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_unique` (`userId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户表;'

_user_group_role

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

CREATE TABLE `_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',
  `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 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户群组角色关联表; 软删除未启用;'

_user_group_role_page

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

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

_user_group_role_resource

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

CREATE TABLE `_user_group_role_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255)  DEFAULT NULL COMMENT 'userId 或者 通配符; 通配符: *',
  `group` varchar(255)  DEFAULT NULL COMMENT 'groupId 或者 通配符; 通配符: *',
  `role` varchar(255)  DEFAULT NULL COMMENT 'roleId 或者 通配符; 通配符: *',
  `resource` varchar(255)  DEFAULT NULL COMMENT 'resourceId 或者 通配符; 通配符: *, !resourceId',
  `allowOrDeny` varchar(255)  DEFAULT NULL COMMENT '用户群组角色 匹配后 执行动作; allow、deny',
  `desc` 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 = 56 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',
  `userAgent` varchar(255)  DEFAULT NULL COMMENT '请求的 agent',
  `deviceId` varchar(255)  DEFAULT NULL COMMENT '设备id',
  `deviceType` varchar(255)  DEFAULT NULL COMMENT '设备类型',
  `userIpRegion` varchar(255)  DEFAULT NULL,
  `socketStatus` varchar(255)  NOT NULL DEFAULT 'offline' COMMENT 'socket状态',
  `authToken` varchar(2048)  DEFAULT NULL COMMENT 'auth token',
  `refreshToken` varchar(2048)  DEFAULT NULL COMMENT 'refresh 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_unique` (`userId`, `deviceId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户session表; deviceId 维度;软删除未启用;'

article_info

CREATE TABLE `article_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `articleId` bigint(20) DEFAULT NULL COMMENT '文章id, 10000 ++',
  `articleViewCount` int(11) DEFAULT NULL COMMENT '文章浏览量',
  `articleCommentCount` int(11) DEFAULT NULL COMMENT '文章评论数',
  `articleFavoriteCount` int(11) 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 `articleId_unique` (`articleId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

视图

_constant_ui

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_constant_ui` AS
select
  `lms_seo_admin`.`web_constant_ui`.`id` AS `id`,
  `lms_seo_admin`.`web_constant_ui`.`constantKey` AS `constantKey`,
  `lms_seo_admin`.`web_constant_ui`.`constantType` AS `constantType`,
  `lms_seo_admin`.`web_constant_ui`.`pageId` AS `pageId`,
  `lms_seo_admin`.`web_constant_ui`.`desc` AS `desc`,
  `lms_seo_admin`.`web_constant_ui`.`en` AS `en`,
  `lms_seo_admin`.`web_constant_ui`.`zh` AS `zh`,
  `lms_seo_admin`.`web_constant_ui`.`operation` AS `operation`,
  `lms_seo_admin`.`web_constant_ui`.`operationByUserId` AS `operationByUserId`,
  `lms_seo_admin`.`web_constant_ui`.`operationByUser` AS `operationByUser`,
  `lms_seo_admin`.`web_constant_ui`.`operationAt` AS `operationAt`
from
  `lms_seo_admin`.`web_constant_ui`

_view01_user

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

_view02_user_app

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
select
  `_user_app`.`id` AS `id`,
  `_app`.`appId` AS `appId`,
  `_app`.`appName` AS `appName`,
  `_user`.`userId` AS `userId`,
  `_user`.`username` AS `username`,
  `_user`.`userStatus` AS `userStatus`,
  `_user`.`userType` AS `userType`,
  `_user_app`.`operation` AS `operation`,
  `_user_app`.`operationByUserId` AS `operationByUserId`,
  `_user_app`.`operationByUser` AS `operationByUser`,
  `_user_app`.`operationAt` AS `operationAt`
from
  (
    (
      `lms_data_repository`.`lms_user_app_management___user_app` `_user_app`
      join `lms_data_repository`.`lms_user_app_management___user` `_user` on ((`_user_app`.`userId` = `_user`.`userId`))
    )
    join `lms_data_repository`.`lms_user_app_management___app` `_app` on ((`_user_app`.`appId` = `_app`.`appId`))
  )

view01_article

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_article` AS
select
  `lms_seo_admin`.`article`.`id` AS `id`,
  `lms_seo_admin`.`article`.`articleId` AS `articleId`,
  `lms_seo_admin`.`article`.`categoryId` AS `categoryId`,
  `lms_seo_admin`.`article`.`articleGroupName` AS `articleGroupName`,
  `lms_seo_admin`.`article`.`articleTagList` AS `articleTagList`,
  `lms_seo_admin`.`article`.`articleDescription` AS `articleDescription`,
  `lms_seo_admin`.`article`.`articlePublishStatus` AS `articlePublishStatus`,
  `lms_seo_admin`.`article`.`articlePublishTime` AS `articlePublishTime`,
  `lms_seo_admin`.`article`.`articleTitle` AS `articleTitle`,
  `lms_seo_admin`.`article`.`articleCoverImage` AS `articleCoverImage`,
  `lms_seo_admin`.`article`.`articleContent` AS `articleContent`,
  `lms_seo_admin`.`article`.`articleContentForSeo` AS `articleContentForSeo`,
  `lms_seo_admin`.`article`.`articleAssignmentList` AS `articleAssignmentList`,
  `lms_seo_admin`.`article`.`articleAssignmentListWithAnswer` AS `articleAssignmentListWithAnswer`,
  `lms_seo_admin`.`article`.`articleAudioUrl` AS `articleAudioUrl`,
  `lms_seo_admin`.`article`.`articleVideoUrl` AS `articleVideoUrl`,
  `lms_seo_admin`.`article`.`articleCreateTime` AS `articleCreateTime`,
  `lms_seo_admin`.`article`.`articleCreateUserId` AS `articleCreateUserId`,
  `lms_seo_admin`.`article`.`articleCreateUsername` AS `articleCreateUsername`,
  `lms_seo_admin`.`article`.`articleUpdateTime` AS `articleUpdateTime`,
  `lms_seo_admin`.`article`.`articleUpdateUserId` AS `articleUpdateUserId`,
  `lms_seo_admin`.`article`.`articleUpdateUsername` AS `articleUpdateUsername`,
  `lms_seo_admin`.`article`.`operation` AS `operation`,
  `lms_seo_admin`.`article`.`operationByUserId` AS `operationByUserId`,
  `lms_seo_admin`.`article`.`operationByUser` AS `operationByUser`,
  `lms_seo_admin`.`article`.`operationAt` AS `operationAt`
from
  `lms_seo_admin`.`article`

view01_category

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_category` AS
select
  `lms_seo_admin`.`category`.`id` AS `id`,
  `lms_seo_admin`.`category`.`categoryId` AS `categoryId`,
  `lms_seo_admin`.`category`.`categoryName` AS `categoryName`,
  `lms_seo_admin`.`category`.`categoryArticleIgnoreTiltle` AS `categoryArticleIgnoreTiltle`,
  `lms_seo_admin`.`category`.`categoryIntro` AS `categoryIntro`,
  `lms_seo_admin`.`category`.`categoryGroup` AS `categoryGroup`,
  `lms_seo_admin`.`category`.`categoryGroupSort` AS `categoryGroupSort`,
  `lms_seo_admin`.`category`.`categoryPublishStatus` AS `categoryPublishStatus`,
  `lms_seo_admin`.`category`.`categoryCreateTime` AS `categoryCreateTime`,
  `lms_seo_admin`.`category`.`categoryCreateUserId` AS `categoryCreateUserId`,
  `lms_seo_admin`.`category`.`categoryCreateUsername` AS `categoryCreateUsername`,
  `lms_seo_admin`.`category`.`categoryUpdateTime` AS `categoryUpdateTime`,
  `lms_seo_admin`.`category`.`categoryUpdateUserId` AS `categoryUpdateUserId`,
  `lms_seo_admin`.`category`.`categoryUpdateUsername` AS `categoryUpdateUsername`,
  `lms_seo_admin`.`category`.`operation` AS `operation`,
  `lms_seo_admin`.`category`.`operationByUserId` AS `operationByUserId`,
  `lms_seo_admin`.`category`.`operationByUser` AS `operationByUser`,
  `lms_seo_admin`.`category`.`operationAt` AS `operationAt`,
  `lms_seo_admin`.`category`.`categoryMark` AS `categoryMark`
from
  `lms_seo_admin`.`category`

xf_page

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `xf_page` AS
select
  `lms_seo_admin`.`xf_page`.`id` AS `id`,
  `lms_seo_admin`.`xf_page`.`xfPageId` AS `xfPageId`,
  `lms_seo_admin`.`xf_page`.`categoryId` AS `categoryId`,
  `lms_seo_admin`.`xf_page`.`routeAlias` AS `routeAlias`,
  `lms_seo_admin`.`xf_page`.`xfPageTagList` AS `xfPageTagList`,
  `lms_seo_admin`.`xf_page`.`xfPagePublishStatus` AS `xfPagePublishStatus`,
  `lms_seo_admin`.`xf_page`.`xfPagePublishTime` AS `xfPagePublishTime`,
  `lms_seo_admin`.`xf_page`.`xfPageTitle` AS `xfPageTitle`,
  `lms_seo_admin`.`xf_page`.`xfPageCoverImage` AS `xfPageCoverImage`,
  `lms_seo_admin`.`xf_page`.`xfPageContent` AS `xfPageContent`,
  `lms_seo_admin`.`xf_page`.`xfPageContentForSeo` AS `xfPageContentForSeo`,
  `lms_seo_admin`.`xf_page`.`xfPageAudioUrl` AS `xfPageAudioUrl`,
  `lms_seo_admin`.`xf_page`.`xfPageVideoUrl` AS `xfPageVideoUrl`,
  `lms_seo_admin`.`xf_page`.`xfPageDescription` AS `xfPageDescription`,
  `lms_seo_admin`.`xf_page`.`xfPageCreateTime` AS `xfPageCreateTime`,
  `lms_seo_admin`.`xf_page`.`xfPageCreateUserId` AS `xfPageCreateUserId`,
  `lms_seo_admin`.`xf_page`.`xfPageCreateUsername` AS `xfPageCreateUsername`,
  `lms_seo_admin`.`xf_page`.`xfPageUpdateTime` AS `xfPageUpdateTime`,
  `lms_seo_admin`.`xf_page`.`xfPageUpdateUserId` AS `xfPageUpdateUserId`,
  `lms_seo_admin`.`xf_page`.`xfPageUpdateUsername` AS `xfPageUpdateUsername`,
  `lms_seo_admin`.`xf_page`.`xfPageConfig` AS `xfPageConfig`,
  `lms_seo_admin`.`xf_page`.`template` AS `template`,
  `lms_seo_admin`.`xf_page`.`operation` AS `operation`,
  `lms_seo_admin`.`xf_page`.`operationByUserId` AS `operationByUserId`,
  `lms_seo_admin`.`xf_page`.`operationByUser` AS `operationByUser`,
  `lms_seo_admin`.`xf_page`.`operationAt` AS `operationAt`
from
  `lms_seo_admin`.`xf_page`