aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_replace_guest_assign_passport_json
Parameters
Name
Type
Mode
p_data
jsonb
IN
i_photo
bytea
IN (DEFAULT NULL)
Definition
-- ให้เอา guest profile ของคนใหม่ ไป update ใส่คนเดิม /* { "register_id" : int, "guest_doc_id": int "mode" : 2025-06-20 "arrival_date": 2025-06-20 } */ Select sp_assign_guest_document( (p_data ->> 'guest_doc_id')::int, (p_data ->> 'register_id')::int, create_new_guest := false )