aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_save_issued_keycard_json
Parameters
Name
Type
Mode
issue_data
jsonb
IN
Definition
begin return sp_save_keycard_log( issue_data->>'issue_user', issue_data->>'issue_type', (issue_data->>'room_id')::int, (issue_data->>'register_id')::int, (issue_data->>'booking_id')::int, (issue_data->>'valid_from')::timestamp, (issue_data->>'valid_until')::timestamp, issue_data->>'card_serial', (issue_data->>'card_index')::int, (issue_data->>'card_qty')::int ); end;