# `act_id_user` (view)


- **Updatable:** NO

## Columns

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

## Definition

```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 `sftlogininfo` `u` group by `u`.`sUserName`
```

## Narrative

_No human-written narrative yet._