viw_process_classify.md
1.79 KB
viw_process_classify (view)
VIEW
- Updatable: NO
-
Definer:
xlyprint@%
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 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 |
Definition
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`)
Narrative
No human-written narrative yet.