authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_login_token
Parameters
Name
Type
Mode
user_name
text
IN
prop_id
integer
IN
Definition
SELECT login_token FROM work_log w WHERE upper(w.user_name) = upper($1) and w.prop_id = $2 and logout_time is null and coalesce(w.app_code, 'pms') = 'pms' ORDER BY id desc LIMIT 1