# `viw_msguser` (view)

> VIEW


- **Updatable:** NO
- **Definer:** `xlyprint@%`

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 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 |

## Definition

```sql
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`
```

## Narrative

_No human-written narrative yet._