authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_work_shift
Parameters
Name
Type
Mode
prop_id
integer
IN
user_name
text
IN
Definition
SELECT p.work_shift FROM user_property p INNER JOIN users u ON u.id = p.user_id WHERE p.prop_id = $1 AND u.user_name = $2::citext