viw_process_classify.md 1.34 KB

viw_process_classify (view)

  • Updatable: NO

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 `eleprocess`.`sId` AS `sId`,`eleprocess`.`sParentId` AS `sParentId`,`eleprocess`.`sProcessName` AS `sProcessName`,`eleprocess`.`sBrandsId` AS `sBrandsId`,`eleprocess`.`sSubsidiaryId` AS `sSubsidiaryId`,`eleprocess`.`sMakePerson` AS `sMakePerson`,`eleprocess`.`tCreateDate` AS `tCreateDate`,`eleprocess`.`bInvalid` AS `bInvalid` from `eleprocess` union select `sisprocessclassify`.`sId` AS `sId`,`sisprocessclassify`.`sParentId` AS `sParentId`,`sisprocessclassify`.`sName` AS `sName`,`sisprocessclassify`.`sBrandsId` AS `sBrandsId`,`sisprocessclassify`.`sSubsidiaryId` AS `sSubsidiaryId`,`sisprocessclassify`.`sMakePerson` AS `sMakePerson`,`sisprocessclassify`.`tCreateDate` AS `tCreateDate`,`sisprocessclassify`.`bInvalid` AS `bInvalid` from `sisprocessclassify` where `sisprocessclassify`.`sId` in (select `eleprocess`.`sParentId` from `eleprocess`)

Narrative

No human-written narrative yet.