booking_guests

Contacts attached to a booking and their role (guest, lead guest, guarantor, booking agent).

Column	Description
id	Unique identifier for the booking guest record
booking_id	Identifier of the booking the contact is attached to
external_contact_id	External contact reference; matches crm_contact_informations.unique_reference
role	Role of the contact on the booking: GUEST, LEAD_GUEST, GUARANTOR or BOOKING_AGENT
is_lead	Whether the contact is the lead guest of the booking
created_at	Timestamp indicating when the record was created
updated_at	Timestamp indicating when the record was last updated
timestamp	Date when the table was last synchronized