# `act_id_user`（视图）


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

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `ID_` | `varchar(255)` | NO |
| 2 | `REV_` | `int` | NO |
| 3 | `FIRST_` | `varchar(255)` | NO |
| 4 | `LAST_` | `char(0)` | NO |
| 5 | `EMAIL_` | `varchar(255)` | YES |
| 6 | `PWD_` | `varchar(255)` | YES |
| 7 | `PICTURE_ID_` | `char(0)` | NO |

## 定义

```sql
select `u`.`sUserName` AS `ID_`,0 AS `REV_`,`u`.`sUserName` AS `FIRST_`,'' AS `LAST_`,`u`.`sEmail` AS `EMAIL_`,`u`.`sUserPwd` AS `PWD_`,'' AS `PICTURE_ID_` from `xlyweberp_saas_ai`.`sftlogininfo` `u` group by `u`.`sUserName`
```

## 说明

_暂无人工说明。_