aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_addnew_guest_assign_passport_json
Parameters
Name
Type
Mode
p_data
jsonb
IN
i_photo
bytea
IN (DEFAULT NULL)
Definition
/* { "mode": "NEW", "register_id": 4, "guest_doc_id": 2814, "arrival_date": "2025-06-20" } */ Select sp_assign_guest_document( (p_data ->> 'guest_doc_id')::int4, (p_data ->> 'register_id')::int4, create_new_guest := true )