viw_msguser.md
2.54 KB
viw_msguser（视图）
- 是否可更新： NO
-
定义者：
xlyprint@%
字段
| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | sId |
varchar(100) |
NO |
| 2 | sBrandsId |
varchar(100) |
NO |
| 3 | sSubsidiaryId |
varchar(100) |
NO |
| 4 | sUserId |
varchar(100) |
NO |
| 5 | sUserName |
varchar(255) |
YES |
| 6 | sWxUserName |
varchar(255) |
YES |
| 7 | sDingTalk |
varchar(255) |
YES |
| 8 | sDingTalkUnionid |
varchar(50) |
NO |
| 9 | sEmail |
varchar(255) |
YES |
| 10 | sPhone |
varchar(255) |
YES |
| 11 | sDepartId |
varchar(100) |
YES |
| 12 | sUserType |
varchar(2) |
NO |
定义
select `xlyweberp_saas_ai`.`sftlogininfo`.`sId` AS `sId`,`xlyweberp_saas_ai`.`sftlogininfo`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`sftlogininfo`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`sftlogininfo`.`sId` AS `sUserId`,`xlyweberp_saas_ai`.`sftlogininfo`.`sUserName` AS `sUserName`,`xlyweberp_saas_ai`.`eleemployee`.`sWxUserName` AS `sWxUserName`,`xlyweberp_saas_ai`.`eleemployee`.`sDingTalk` AS `sDingTalk`,`xlyweberp_saas_ai`.`eleemployee`.`sDingTalkUnionid` AS `sDingTalkUnionid`,`xlyweberp_saas_ai`.`eleemployee`.`sEmail` AS `sEmail`,`xlyweberp_saas_ai`.`eleemployee`.`sMobile` AS `sPhone`,`xlyweberp_saas_ai`.`eleemployee`.`sDepartId` AS `sDepartId`,'员工' AS `sUserType` from (`xlyweberp_saas_ai`.`eleemployee` join `xlyweberp_saas_ai`.`sftlogininfo` on(((`xlyweberp_saas_ai`.`sftlogininfo`.`sEmployeeId` = `xlyweberp_saas_ai`.`eleemployee`.`sId`) and (`xlyweberp_saas_ai`.`sftlogininfo`.`sBrandsId` = `xlyweberp_saas_ai`.`eleemployee`.`sBrandsId`) and (`xlyweberp_saas_ai`.`sftlogininfo`.`sSubsidiaryId` = `xlyweberp_saas_ai`.`eleemployee`.`sSubsidiaryId`)))) union all select `xlyweberp_saas_ai`.`elecustomercontacts`.`sId` AS `sId`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sId` AS `sUserId`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sContacts` AS `sUserName`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sWxUserName` AS `sWxUserName`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sDingTalk` AS `sDingTalk`,'' AS `sDingTalkUnionid`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sEmail` AS `sEmail`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sMobile` AS `sPhone`,`xlyweberp_saas_ai`.`elecustomercontacts`.`sParentId` AS `sDepartId`,'客户' AS `sUserType` from `xlyweberp_saas_ai`.`elecustomercontacts`
说明
暂无人工说明。