aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_keycard_staykey
Parameters
Name
Type
Mode
room_id
integer
IN
booking_id
integer
IN
register_id
integer
IN
Definition
SELECT room_id||'-'||coalesce('B'||booking_id, 'W'||register_id);