# `viw_process_classify`（视图）


- **是否可更新：** NO
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sId` | `varchar(50)` | YES |
| 2 | `sParentId` | `varchar(50)` | YES |
| 3 | `sProcessName` | `varchar(100)` | NO |
| 4 | `sBrandsId` | `varchar(50)` | YES |
| 5 | `sSubsidiaryId` | `varchar(50)` | YES |
| 6 | `sMakePerson` | `varchar(50)` | NO |
| 7 | `tCreateDate` | `datetime` | NO |
| 8 | `bInvalid` | `bit(1)` | NO |

## 定义

```sql
select `xlyweberp_saas_ai`.`eleprocess`.`sId` AS `sId`,`xlyweberp_saas_ai`.`eleprocess`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`eleprocess`.`sProcessName` AS `sProcessName`,`xlyweberp_saas_ai`.`eleprocess`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`eleprocess`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`eleprocess`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`eleprocess`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`eleprocess`.`bInvalid` AS `bInvalid` from `xlyweberp_saas_ai`.`eleprocess` union select `xlyweberp_saas_ai`.`sisprocessclassify`.`sId` AS `sId`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sName` AS `sName`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`sisprocessclassify`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`sisprocessclassify`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`sisprocessclassify`.`bInvalid` AS `bInvalid` from `xlyweberp_saas_ai`.`sisprocessclassify` where `xlyweberp_saas_ai`.`sisprocessclassify`.`sId` in (select `xlyweberp_saas_ai`.`eleprocess`.`sParentId` from `xlyweberp_saas_ai`.`eleprocess`)
```

## 说明

_暂无人工说明。_
