booking_guests represents the guests section of the bookings. That is the relation between the bookings and the guests table. At check out the systems snapshots the guest's data and they don't change.
Fields
| Field name | Type | Description/Notes |
| id | INTEGER | Unique identifier of the booking_guest across the entire Clock PMS+ ecosystem* |
| booking_id | INTEGER | Reference to the bookings table* |
| main_booking_guest | BOOLEAN | true for the main guest, false for the others* |
| guest_profile_id | INTEGER | Reference to guests table. The record in guests table will have the up to data details of the guest* |
| guest_first_name | STRING | First name |
| guest_last_name | STRING | Last name |
| guest_middle_name | STRING | Middle name |
| guest_country | STRING | Country of the guest ALPHA-2 (ISO 3166) |
| guest_language | STRING | Guest's language (as defined by the customer) |
| guest_state | STRING | State |
| guest_city | STRING | City |
| guest_zip_code | STRING | ZIP code |
| guest_address | STRING | Address |
| guest_phone_number | STRING | Phone number |
| guest_fax_number | STRING | Fax Number |
| guest_e_mail | STRING | e-mail address |
| guest_person_title_id | INTEGER | Guest title identification |
| guest_title | STRING | Guest title text |
| guest_salutation | STRING | Salutation |
| registration_card_number | STRING | Registration card number |
| registration_card | BOOLEAN | true if the guest is included In hotel register report, false otherwise* |
| created_at | TIMESTAMP | Time created (Date and time in UTC)* |
| updated_at | TIMESTAMP | Time updated (Date and time in UTC)* |
| verified_at | TIMESTAMP | When the Verified checkbox was ticked for a staff member (Date and time in UTC) |
| verified_by_id | INTEGER | The ID of the user ticked the Verified checkbox |
| signature_id | INTEGER | Identification of the digital signature of the registration card. |
* Field will have value for every record