江湖数字化平台
登录

数据结构

12086

表总览

通用表

业务表

_ui

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

album

  1. CREATE TABLE `album` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `albumId` bigint(20) DEFAULT NULL,
  4.   `albumTitle` varchar(255) DEFAULT NULL,
  5.   `albumSort` varchar(255) DEFAULT NULL,
  6.   `albumQuery` text COMMENT '专辑查询sql 配置{ \n   "tableName":"article", \n   "where":"where articleId = ''10000'' ",\n   "limit":"50",\n   "queryType":"order",\n   "orderBy":"order by createTime desc"\n}',
  7.   `albumStatus` varchar(255) DEFAULT NULL COMMENT '专辑状态 active, disabled',
  8.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  9.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  10.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  11.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  12.   PRIMARY KEY (`id`) USING BTREE,
  13.   UNIQUE KEY `albumId_unique` (`albumId`) USING BTREE,
  14.   UNIQUE KEY `albumTitle_unique` (`albumTitle`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC

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

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

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 COMMENT '目录中需要省略的文字',
  6.   `categoryIntro` text CHARACTER SET utf8mb4 ,
  7.   `categoryTagList` varchar(255) DEFAULT NULL,
  8.   `categoryGroup` varchar(255) DEFAULT NULL,
  9.   `categoryGroupSort` varchar(255) DEFAULT NULL,
  10.   `categoryPublishStatus` varchar(255) DEFAULT '',
  11.   `categoryCreateTime` varchar(255) DEFAULT '',
  12.   `categoryCreateUserId` varchar(255) DEFAULT '',
  13.   `categoryCreateUsername` varchar(255) DEFAULT '',
  14.   `categoryUpdateTime` varchar(255) DEFAULT '',
  15.   `categoryUpdateUserId` varchar(255) DEFAULT '',
  16.   `categoryUpdateUsername` varchar(255) DEFAULT '',
  17.   `operation` varchar(255) DEFAULT '',
  18.   `operationByUserId` varchar(255) DEFAULT '',
  19.   `operationByUser` varchar(255) DEFAULT '',
  20.   `operationAt` varchar(255) DEFAULT '',
  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 = 323 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC

code_view

  1. CREATE TABLE `code_view` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `idSequence` bigint(20) DEFAULT NULL COMMENT '顺序Id',
  4.   `codeId` varchar(255) DEFAULT NULL COMMENT '代码Id',
  5.   `codeTitle` varchar(255) DEFAULT NULL COMMENT '标题',
  6.   `codeContent` text CHARACTER SET utf8mb4 COMMENT '代码块',
  7.   `language` varchar(255) DEFAULT NULL COMMENT '类型：html/sql',
  8.   `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '操作: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  9.   `operationByUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '操作者userId',
  10.   `operationByUser` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '操作者用户名',
  11.   `operationAt` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00',
  12.   PRIMARY KEY (`id`) USING BTREE
  13. ) ENGINE = InnoDB AUTO_INCREMENT = 3006 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC

comment

  1. CREATE TABLE `comment` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `articleId` int(11) DEFAULT NULL,
  4.   `username` varchar(255) DEFAULT NULL,
  5.   `content` varchar(255) DEFAULT NULL,
  6.   `email` varchar(255) DEFAULT NULL,
  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 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC

seo_ui

  • 常量表;
  1. CREATE TABLE `seo_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 = 18 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC 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.   `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.   `xfPageDescription` varchar(255)  DEFAULT NULL COMMENT '描述',
  15.   `xfPageCreateTime` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  16.   `xfPageCreateUserId` varchar(255)  DEFAULT '' COMMENT '创建者用户ID',
  17.   `xfPageCreateUsername` varchar(255)  DEFAULT '' COMMENT '创建者用户名',
  18.   `xfPageUpdateTime` varchar(255)  DEFAULT '' COMMENT '更新时间',
  19.   `xfPageUpdateUserId` varchar(255)  DEFAULT '' COMMENT '更新者用户ID',
  20.   `xfPageUpdateUsername` varchar(255)  DEFAULT '' COMMENT '更新者用户名',
  21.   `xfPageConfig` mediumtext  COMMENT '配置',
  22.   `template` varchar(255)  DEFAULT NULL 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.   PRIMARY KEY (`id`) USING BTREE,
  28.   UNIQUE KEY `xf_page_xfPageId_uindex` (`xfPageId`) USING BTREE
  29. ) ENGINE = InnoDB AUTO_INCREMENT = 47 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC 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.   `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.   `xfPageDescription` 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.   `xfPageCreateTime` varchar(255)  DEFAULT NULL COMMENT '创建时间',
  16.   `xfPageCreateUserId` varchar(255)  DEFAULT '' COMMENT '创建者用户ID',
  17.   `xfPageCreateUsername` varchar(255)  DEFAULT '' COMMENT '创建者用户名',
  18.   `xfPageUpdateTime` varchar(255)  DEFAULT '' COMMENT '更新时间',
  19.   `xfPageUpdateUserId` varchar(255)  DEFAULT '' COMMENT '更新者用户ID',
  20.   `xfPageUpdateUsername` varchar(255)  DEFAULT '' COMMENT '更新者用户名',
  21.   `xfPageConfig` text  COMMENT '配置',
  22.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  23.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  24.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  25.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  26.   `template` varchar(255) CHARACTER SET armscii8  DEFAULT NULL COMMENT '模板',
  27.   PRIMARY KEY (`id`) USING BTREE
  28. ) ENGINE = InnoDB AUTO_INCREMENT = 374 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC

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 ROW_FORMAT = DYNAMIC COMMENT = '旋风定制页面表'

业务视图

_view02_user_app

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
  2. select
  3.   (
  4.     case `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId`
  5.       when 'jianghu-doc' then 'seo'
  6.       when 'jianghu-doc-admin' then 'admin'
  7.       else NULL
  8.     end
  9.   ) AS `jhId`,
  10.   `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  11.   `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  12.   `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
  13. from
  14.   `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`
  15. where
  16.   (
  17.     `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` in ('jianghu-doc', 'jianghu-doc-admin')
  18.   )

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`.`articlePublishStatus` AS `articlePublishStatus`,
  9.   `article`.`articlePublishTime` AS `articlePublishTime`,
  10.   `article`.`articleTitle` AS `articleTitle`,
  11.   `article`.`articleCoverImage` AS `articleCoverImage`,
  12.   `article`.`articleAudioUrl` AS `articleAudioUrl`,
  13.   `article`.`articleVideoUrl` AS `articleVideoUrl`,
  14.   `article`.`articleCreateTime` AS `articleCreateTime`,
  15.   `article`.`articleCreateUserId` AS `articleCreateUserId`,
  16.   `article`.`articleCreateUsername` AS `articleCreateUsername`,
  17.   `article`.`articleUpdateTime` AS `articleUpdateTime`,
  18.   `article`.`articleUpdateUserId` AS `articleUpdateUserId`,
  19.   `article`.`articleUpdateUsername` AS `articleUpdateUsername`,
  20.   `article`.`operation` AS `operation`,
  21.   `article`.`operationByUserId` AS `operationByUserId`,
  22.   `article`.`operationByUser` AS `operationByUser`,
  23.   `article`.`operationAt` AS `operationAt`,
  24.   `category`.`categoryName` AS `categoryName`,
  25.   `category`.`categoryIntro` AS `categoryIntro`,
  26.   `category`.`categoryGroup` AS `categoryGroup`,
  27.   `category`.`categoryGroupSort` AS `categoryGroupSort`,
  28.   `article`.`articleContent` AS `articleContent`,
  29.   `article`.`articleContentForSeo` AS `articleContentForSeo`
  30. from
  31.   (
  32.     `article`
  33.     left join `category` on (
  34.       (`article`.`categoryId` = `category`.`categoryId`)
  35.     )
  36.   )

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`