Data Structures

12132

Table Overview

General Tables

Business Tables

_app_account

Account Table

CREATE TABLE `_app_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account ID; can be abbreviated or in Chinese; cannot be modified',
  `appaName` varchar(255)  DEFAULT NULL COMMENT 'Account Name;',
  `appaStatus` varchar(255)  DEFAULT NULL COMMENT 'Account Status; account enabled, account disabled',
  `appaType` varchar(255)  DEFAULT 'Regular Account' COMMENT 'Account Type; template account, null',
  `periodIdStart` varchar(255)  DEFAULT NULL COMMENT 'Account Start Year and Month;',
  `periodIdEnd` varchar(255)  DEFAULT NULL COMMENT 'Account End Year and Month; for audit purposes',
  `appaStandard` varchar(255)  DEFAULT NULL COMMENT 'Accounting Standards;',
  `appaIndustry` varchar(255)  DEFAULT NULL COMMENT 'Industry;',
  `appaVATType` varchar(255)  DEFAULT NULL COMMENT 'VAT Type; spare',
  `appaManagerId` varchar(255)  DEFAULT NULL COMMENT 'Account Manager ID',
  `appaManagerName` varchar(255)  DEFAULT NULL COMMENT 'Account Manager Name',
  `appaMemberIdList` varchar(255)  DEFAULT NULL COMMENT 'Account Member IDs',
  `appaMemberList` text  COMMENT 'Account Member Names',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_unique` (`appaId`) USING BTREE,
  UNIQUE KEY `appaName_unique` (`appaName`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Account Table'

_ui

UI Construction Plan

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 Action Type, e.g.: fetchData, postData, changeUi',
  `uiActionId` varchar(255)  DEFAULT NULL COMMENT 'Action ID; E.g: selectXXXByXXX',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `uiActionConfig` text  COMMENT 'UI Action Data',
  `appDataSchema` text  COMMENT 'UI Validation Data',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'UI Construction Plan'

audit_project

Audit - Project List

CREATE TABLE `audit_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `isTemplate` varchar(255)  DEFAULT 'No' COMMENT 'Is it an audit template',
  `auditProjectId` varchar(255)  DEFAULT NULL COMMENT 'Audit Project; Company Name-202306',
  `auditProjectIdOfTemplate` varchar(255)  DEFAULT NULL COMMENT 'Used Audit Template; auditProjectId',
  `auditProjectType` varchar(255)  DEFAULT NULL COMMENT 'Audit Project Type; Financial Audit, Tax Audit, Asset Evaluation',
  `auditStatus` varchar(255)  DEFAULT 'In Audit' COMMENT 'Audit Status; In Audit, Completed',
  `auditManagerId` varchar(255)  DEFAULT NULL COMMENT 'Project Leader, Audit Manager User ID',
  `auditManagerName` varchar(255)  DEFAULT NULL COMMENT 'Project Leader, Audit Manager',
  `auditMemberIdList` varchar(512)  DEFAULT NULL COMMENT 'Project Member ID List; concatenated with "," userId',
  `auditMemberList` text  COMMENT 'Project Member Information List; [{ auditMemberId, auditMemberName }, {}]',
  `auditContent` text  COMMENT 'Audit Division Content; {}',
  `customer` varchar(255)  DEFAULT NULL COMMENT 'Customer',
  `projectDescription` varchar(255)  DEFAULT NULL COMMENT 'Project Description',
  `auditPeriodStartDate` varchar(255)  DEFAULT NULL COMMENT 'Audit Period - Start Date',
  `auditPeriodEndDate` varchar(255)  DEFAULT NULL COMMENT 'Audit Period - End Date',
  `reviewStep` varchar(255)  DEFAULT NULL COMMENT 'Review Stage; null, Review 1, Review 2, Review 3',
  `reviewUserId1` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer User ID 1',
  `reviewUserId2` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer User ID 2',
  `reviewUserId3` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer User ID 3',
  `reviewUsername1` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer Username 1',
  `reviewUsername2` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer Username 2',
  `reviewUsername3` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer Username 3',
  `auditSymbol` varchar(255)  DEFAULT NULL COMMENT 'Audit Document Number',
  `remark` text  COMMENT 'Remarks;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `auditProjectId_unique` (`auditProjectId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 632 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Audit - Project List'

audit_review

Audit - Project Review

CREATE TABLE `audit_review` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `auditProjectId` varchar(255)  DEFAULT NULL COMMENT 'Audit Project',
  `fileName` varchar(255)  DEFAULT NULL COMMENT 'File Name',
  `relativePath` varchar(512)  DEFAULT NULL COMMENT 'Relative Path',
  `reviewContent1` text  COMMENT 'Review Opinion 1',
  `reviewContent2` text  COMMENT 'Review Opinion 2',
  `reviewContent3` text  COMMENT 'Review Opinion 3',
  `reviewComment1` text  COMMENT 'Review Comment 1',
  `reviewComment2` text  COMMENT 'Review Comment 2',
  `reviewComment3` text  COMMENT 'Review Comment 3',
  `reviewResponse1` text  COMMENT 'Review Content 1',
  `reviewResponse2` text  COMMENT 'Review Content 2',
  `reviewResponse3` text  COMMENT 'Review Content 3',
  `reviewResult1` varchar(255)  DEFAULT NULL COMMENT 'Review Result 1; Reviewing, Review Completed',
  `reviewResult2` varchar(255)  DEFAULT NULL COMMENT 'Review Result 2; Reviewing, Review Completed',
  `reviewResult3` varchar(255)  DEFAULT NULL COMMENT 'Review Result 3; Reviewing, Review Completed',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `auditProjectId_unique` (`auditProjectId`, `relativePath`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Audit - Project Review'

Business Views

_view02_user_app

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
from
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`
where
  (
    `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` = 'jianghu-audit'
  )

view01_audit_project

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_audit_project` AS
select
  `ap`.`id` AS `id`,
  `ap`.`isTemplate` AS `isTemplate`,
  `appa`.`appaId` AS `financeAppaId`,
  `ap`.`auditProjectId` AS `auditProjectId`,
  `ap`.`auditProjectType` AS `auditProjectType`,
  `ap`.`auditStatus` AS `auditStatus`,
  `ap`.`auditManagerId` AS `auditManagerId`,
  `ap`.`auditManagerName` AS `auditManagerName`,
  `ap`.`auditMemberIdList` AS `auditMemberIdList`,
  `ap`.`auditMemberList` AS `auditMemberList`,
  `ap`.`auditContent` AS `auditContent`,
  `ap`.`remark` AS `remark`,
  `ap`.`operation` AS `operation`,
  `ap`.`operationByUserId` AS `operationByUserId`,
  `ap`.`operationByUser` AS `operationByUser`,
  `ap`.`operationAt` AS `operationAt`,
  `ap`.`customer` AS `customer`,
  `ap`.`projectDescription` AS `projectDescription`,
  `ap`.`auditPeriodStartDate` AS `auditPeriodStartDate`,
  `ap`.`auditPeriodEndDate` AS `auditPeriodEndDate`,
  `ap`.`reviewStep` AS `reviewStep`,
  `ap`.`auditSymbol` AS `auditSymbol`,
  `ap`.`reviewUserId1` AS `reviewUserId1`,
  `ap`.`reviewUserId2` AS `reviewUserId2`,
  `ap`.`reviewUserId3` AS `reviewUserId3`,
  `ap`.`reviewUsername1` AS `reviewUsername1`,
  `ap`.`reviewUsername2` AS `reviewUsername2`,
  `ap`.`reviewUsername3` AS `reviewUsername3`,
  `ap`.`auditProjectIdOfTemplate` AS `auditProjectIdOfTemplate`
from
  (
    `audit_project` `ap`
    left join `_app_account` `appa` on ((`appa`.`appaId` = `ap`.`auditProjectId`))
  )

view01_user_select

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_user_select` AS
select
  `_user`.`id` AS `id`,
  `_user`.`userId` AS `userId`,
  `_user`.`username` AS `username`,
  `_user`.`userStatus` AS `userStatus`,
  `_user`.`userType` AS `userType`
from
  `_user`
where
  (`_user`.`userStatus` = 'active')

# Table Overview

## General Tables

- [_user](/__appId__/page/article/12324#_user)
- [_user_session](/__appId__/page/article/12324#_user_session)
- [_role](/__appId__/page/article/12324#_role)
- [_page](/__appId__/page/article/12324#_page)
- [_resource](/__appId__/page/article/12324#_resource)
- [_group](/__appId__/page/article/12324#_group)
- [_user_group_role](/__appId__/page/article/12324#_user_group_role)
- [_user_group_role_page](/__appId__/page/article/12324#_user_group_role_page)
- [_user_group_role_resource](/__appId__/page/article/12324#_user_group_role_resource)
- [_constant](/__appId__/page/article/12324#_constant)
- [_constant_ui](/__appId__/page/article/12324#_constant_ui)
- [_record](/__appId__/page/article/12324#_record)
- [_record_history](/__appId__/page/article/12324#_record_history)
- [_cache](/__appId__/page/article/12324#_cache)
- [_file](/__appId__/page/article/12324#_file)
- [_view01_user](/__appId__/page/article/12324#_view01_user)

## Business Tables

### _app_account

- Account Table

```sql
CREATE TABLE `_app_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account ID; can be abbreviated or in Chinese; cannot be modified',
  `appaName` varchar(255)  DEFAULT NULL COMMENT 'Account Name;',
  `appaStatus` varchar(255)  DEFAULT NULL COMMENT 'Account Status; account enabled, account disabled',
  `appaType` varchar(255)  DEFAULT 'Regular Account' COMMENT 'Account Type; template account, null',
  `periodIdStart` varchar(255)  DEFAULT NULL COMMENT 'Account Start Year and Month;',
  `periodIdEnd` varchar(255)  DEFAULT NULL COMMENT 'Account End Year and Month; for audit purposes',
  `appaStandard` varchar(255)  DEFAULT NULL COMMENT 'Accounting Standards;',
  `appaIndustry` varchar(255)  DEFAULT NULL COMMENT 'Industry;',
  `appaVATType` varchar(255)  DEFAULT NULL COMMENT 'VAT Type; spare',
  `appaManagerId` varchar(255)  DEFAULT NULL COMMENT 'Account Manager ID',
  `appaManagerName` varchar(255)  DEFAULT NULL COMMENT 'Account Manager Name',
  `appaMemberIdList` varchar(255)  DEFAULT NULL COMMENT 'Account Member IDs',
  `appaMemberList` text  COMMENT 'Account Member Names',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_unique` (`appaId`) USING BTREE,
  UNIQUE KEY `appaName_unique` (`appaName`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Account Table'
```

### _ui

- UI Construction Plan

```sql
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 Action Type, e.g.: fetchData, postData, changeUi',
  `uiActionId` varchar(255)  DEFAULT NULL COMMENT 'Action ID; E.g: selectXXXByXXX',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `uiActionConfig` text  COMMENT 'UI Action Data',
  `appDataSchema` text  COMMENT 'UI Validation Data',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'UI Construction Plan'
```

### audit_project

- Audit - Project List

```sql
CREATE TABLE `audit_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `isTemplate` varchar(255)  DEFAULT 'No' COMMENT 'Is it an audit template',
  `auditProjectId` varchar(255)  DEFAULT NULL COMMENT 'Audit Project; Company Name-202306',
  `auditProjectIdOfTemplate` varchar(255)  DEFAULT NULL COMMENT 'Used Audit Template; auditProjectId',
  `auditProjectType` varchar(255)  DEFAULT NULL COMMENT 'Audit Project Type; Financial Audit, Tax Audit, Asset Evaluation',
  `auditStatus` varchar(255)  DEFAULT 'In Audit' COMMENT 'Audit Status; In Audit, Completed',
  `auditManagerId` varchar(255)  DEFAULT NULL COMMENT 'Project Leader, Audit Manager User ID',
  `auditManagerName` varchar(255)  DEFAULT NULL COMMENT 'Project Leader, Audit Manager',
  `auditMemberIdList` varchar(512)  DEFAULT NULL COMMENT 'Project Member ID List; concatenated with "," userId',
  `auditMemberList` text  COMMENT 'Project Member Information List; [{ auditMemberId, auditMemberName }, {}]',
  `auditContent` text  COMMENT 'Audit Division Content; {}',
  `customer` varchar(255)  DEFAULT NULL COMMENT 'Customer',
  `projectDescription` varchar(255)  DEFAULT NULL COMMENT 'Project Description',
  `auditPeriodStartDate` varchar(255)  DEFAULT NULL COMMENT 'Audit Period - Start Date',
  `auditPeriodEndDate` varchar(255)  DEFAULT NULL COMMENT 'Audit Period - End Date',
  `reviewStep` varchar(255)  DEFAULT NULL COMMENT 'Review Stage; null, Review 1, Review 2, Review 3',
  `reviewUserId1` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer User ID 1',
  `reviewUserId2` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer User ID 2',
  `reviewUserId3` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer User ID 3',
  `reviewUsername1` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer Username 1',
  `reviewUsername2` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer Username 2',
  `reviewUsername3` varchar(255)  DEFAULT NULL COMMENT 'Project Reviewer Username 3',
  `auditSymbol` varchar(255)  DEFAULT NULL COMMENT 'Audit Document Number',
  `remark` text  COMMENT 'Remarks;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `auditProjectId_unique` (`auditProjectId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 632 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Audit - Project List'
```

### audit_review

- Audit - Project Review

```sql
CREATE TABLE `audit_review` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `auditProjectId` varchar(255)  DEFAULT NULL COMMENT 'Audit Project',
  `fileName` varchar(255)  DEFAULT NULL COMMENT 'File Name',
  `relativePath` varchar(512)  DEFAULT NULL COMMENT 'Relative Path',
  `reviewContent1` text  COMMENT 'Review Opinion 1',
  `reviewContent2` text  COMMENT 'Review Opinion 2',
  `reviewContent3` text  COMMENT 'Review Opinion 3',
  `reviewComment1` text  COMMENT 'Review Comment 1',
  `reviewComment2` text  COMMENT 'Review Comment 2',
  `reviewComment3` text  COMMENT 'Review Comment 3',
  `reviewResponse1` text  COMMENT 'Review Content 1',
  `reviewResponse2` text  COMMENT 'Review Content 2',
  `reviewResponse3` text  COMMENT 'Review Content 3',
  `reviewResult1` varchar(255)  DEFAULT NULL COMMENT 'Review Result 1; Reviewing, Review Completed',
  `reviewResult2` varchar(255)  DEFAULT NULL COMMENT 'Review Result 2; Reviewing, Review Completed',
  `reviewResult3` varchar(255)  DEFAULT NULL COMMENT 'Review Result 3; Reviewing, Review Completed',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `auditProjectId_unique` (`auditProjectId`, `relativePath`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Audit - Project Review'
```

## Business Views

### _view02_user_app

```sql
CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
from
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`
where
  (
    `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` = 'jianghu-audit'
  )
```

### view01_audit_project

```sql
CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_audit_project` AS
select
  `ap`.`id` AS `id`,
  `ap`.`isTemplate` AS `isTemplate`,
  `appa`.`appaId` AS `financeAppaId`,
  `ap`.`auditProjectId` AS `auditProjectId`,
  `ap`.`auditProjectType` AS `auditProjectType`,
  `ap`.`auditStatus` AS `auditStatus`,
  `ap`.`auditManagerId` AS `auditManagerId`,
  `ap`.`auditManagerName` AS `auditManagerName`,
  `ap`.`auditMemberIdList` AS `auditMemberIdList`,
  `ap`.`auditMemberList` AS `auditMemberList`,
  `ap`.`auditContent` AS `auditContent`,
  `ap`.`remark` AS `remark`,
  `ap`.`operation` AS `operation`,
  `ap`.`operationByUserId` AS `operationByUserId`,
  `ap`.`operationByUser` AS `operationByUser`,
  `ap`.`operationAt` AS `operationAt`,
  `ap`.`customer` AS `customer`,
  `ap`.`projectDescription` AS `projectDescription`,
  `ap`.`auditPeriodStartDate` AS `auditPeriodStartDate`,
  `ap`.`auditPeriodEndDate` AS `auditPeriodEndDate`,
  `ap`.`reviewStep` AS `reviewStep`,
  `ap`.`auditSymbol` AS `auditSymbol`,
  `ap`.`reviewUserId1` AS `reviewUserId1`,
  `ap`.`reviewUserId2` AS `reviewUserId2`,
  `ap`.`reviewUserId3` AS `reviewUserId3`,
  `ap`.`reviewUsername1` AS `reviewUsername1`,
  `ap`.`reviewUsername2` AS `reviewUsername2`,
  `ap`.`reviewUsername3` AS `reviewUsername3`,
  `ap`.`auditProjectIdOfTemplate` AS `auditProjectIdOfTemplate`
from
  (
    `audit_project` `ap`
    left join `_app_account` `appa` on ((`appa`.`appaId` = `ap`.`auditProjectId`))
  )
```

### view01_user_select

```sql
CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_user_select` AS
select
  `_user`.`id` AS `id`,
  `_user`.`userId` AS `userId`,
  `_user`.`username` AS `username`,
  `_user`.`userStatus` AS `userStatus`,
  `_user`.`userType` AS `userType`
from
  `_user`
where
  (`_user`.`userStatus` = 'active')
```  
```