数据结构

12141

表总览

普通表

_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 ROW_FORMAT = DYNAMIC 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 = 22 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC 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 = 3 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '常量表;'

_page

  • 页面表; 软删除未启用;
  1. CREATE TABLE `_page` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  4. `pageFile` varchar(255) DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  5. `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  6. `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  7. `pageIcon` longtext COMMENT '页面icon,svg格式',
  8. `pageHook` varchar(255) DEFAULT NULL,
  9. `sort` varchar(255) DEFAULT NULL,
  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 = 130 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC 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` text NOT NULL COMMENT '数据',
  6. `packageContent` text NOT NULL 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 = 184 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC 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 = 524 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_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. `expectedResult` text COMMENT '期望结果',
  9. `operation` varchar(255) DEFAULT NULL COMMENT '操作; jhInsert, jhUpdate, jhDelete jhRestore',
  10. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId; recordContent.operationByUserId',
  11. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名; recordContent.operationByUser',
  12. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; recordContent.operationAt; E.g: 2021-05-28T10:24:54+08:00 ',
  13. PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC 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 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = 'ui 施工方案'

_user

  • 用户表
  1. CREATE TABLE `_user` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `userId` varchar(255) DEFAULT NULL COMMENT '主键id',
  4. `username` varchar(255) DEFAULT NULL COMMENT '用户名(登陆)',
  5. `clearTextPassword` varchar(255) DEFAULT NULL COMMENT '明文密码',
  6. `password` varchar(255) DEFAULT NULL COMMENT '密码',
  7. `md5Salt` varchar(255) DEFAULT NULL COMMENT 'md5Salt',
  8. `userStatus` varchar(255) DEFAULT 'active' COMMENT '用户账号状态:活跃或关闭',
  9. `userType` varchar(255) DEFAULT NULL COMMENT '用户类型; staff, student.',
  10. `config` mediumtext COMMENT '配置信息',
  11. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  12. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  13. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  14. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  15. PRIMARY KEY (`id`) USING BTREE,
  16. UNIQUE KEY `username_index` (`username`) USING BTREE,
  17. UNIQUE KEY `userId_index` (`userId`) USING BTREE
  18. ) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC 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. `userIpRegion` varchar(255) DEFAULT NULL COMMENT '用户Ip区域',
  6. `userAgent` text COMMENT '请求的 agent',
  7. `deviceId` varchar(255) DEFAULT NULL COMMENT '设备id',
  8. `deviceType` varchar(255) DEFAULT 'web' COMMENT '设备类型; flutter, web, bot_databot, bot_chatbot, bot_xiaochengxu',
  9. `socketStatus` varchar(255) DEFAULT 'offline' COMMENT 'socket状态',
  10. `authToken` varchar(255) DEFAULT NULL COMMENT 'auth token',
  11. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  12. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  13. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  14. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  15. PRIMARY KEY (`id`) USING BTREE,
  16. KEY `userId_index` (`userId`) USING BTREE,
  17. KEY `userId_deviceId_index` (`userId`, `deviceId`) USING BTREE,
  18. KEY `authToken_index` (`authToken`) USING BTREE
  19. ) ENGINE = InnoDB AUTO_INCREMENT = 37 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '用户session表; deviceId 维度;软删除未启用;'

视图

_directory_user_session

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

_group

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

_role

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

_user_group_role

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

_user_group_role_page

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

_user_group_role_resource

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

_view01_user

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

_view02_user_app

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