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 ORDER BY id desc LIMIT 1