act_id_user.md 637 Bytes

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

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.