aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_room_activity
Parameters
Name
Type
Mode
room_id
integer
IN
start_date
date
IN
end_date
date
IN
Definition
Select coalesce((select activity_code from sp_get_room_activity(room_id, false, start_date, end_date) limit 1), 0)