# booking_guests

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

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 |