Modified on: Wed, 30 Nov, 2022 at 12:21 PM


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.


Field nameTypeDescription/Notes
idINTEGERUnique identifier of the booking_guest across the entire Clock PMS+ ecosystem*
booking_idINTEGERReference to the bookings table*
main_booking_guestBOOLEANtrue for the main guest, false for the others*
guest_profile_idINTEGERReference to guests table. The record in guests table will have the up to data details of the guest*
guest_first_nameSTRINGFirst name
guest_last_nameSTRINGLast name
guest_middle_nameSTRINGMiddle name
guest_countrySTRINGCountry of the guest ALPHA-2 (ISO 3166)
guest_languageSTRINGGuest's language (as defined by the customer)
guest_zip_codeSTRINGZIP code
guest_phone_numberSTRINGPhone number
guest_fax_numberSTRINGFax Number
guest_e_mailSTRINGe-mail address
guest_person_title_idINTEGERGuest title identification
guest_titleSTRINGGuest title text
registration_card_numberSTRINGRegistration card number
registration_cardBOOLEANtrue if the guest is included In hotel register report, false otherwise*
created_atTIMESTAMPTime created (Date and time in UTC)*
updated_atTIMESTAMPTime updated (Date and time in UTC)*
verified_atTIMESTAMPWhen the Verified checkbox was ticked for a staff member (Date and time in UTC)
verified_by_idINTEGERThe ID of the user ticked the Verified checkbox
signature_idINTEGERIdentification of the digital signature of the registration card.
* Field will have value for every record

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

On this page