aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_log_room
Parameters
Name
Type
Mode
room_id
integer
IN
log_type
text
IN
log_text
text
IN
user_name
text
IN (DEFAULT NULL)
Definition
INSERT INTO room_log (room_id, log_type, log_text, log_user, log_date) VALUES($1, $2, $3, COALESCE($4, fn_current_user()), fn_system_date()) RETURNING id;