aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_log_guest
Parameters
Name
Type
Mode
guest_id
integer
IN
log_type
text
IN
log_text
text
IN
user_name
text
IN (DEFAULT NULL)
Definition
INSERT INTO guest_log (guest_id, log_type, log_text, log_user, log_date) VALUES( guest_id, log_type, log_text, COALESCE(user_name, fn_current_user()), fn_system_date()) RETURNING id;