act_id_user.md 693 Bytes

Edit Raw Blame History



act_id_user (view)


VIEW


Updatable: NO

Definer: xlyprint@%


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


Narrative

No human-written narrative yet.