Audit for Dev
Booking
On here you can find the list of booking table attributes. when the attributes value is nil it means that the attribute doesn’t have any value.
when you click the Full JSON button it will shows all the booking attributes as you can see bellow:
{
"id" -> booking ID
"user_id" -> user ID
"restaurant_id" -> restaurant ID
"date" -> booking date
"start_time" -> booking start time
"end_time" -> booking end time
"party_size" -> booking party size
"active" -> booking status (indicates if the booking is currently valid and open)
"created_at" -> booking created at
"updated_at" -> booking updated at
"name" -> user name
"email" -> user email
"phone" -> user phone
"no_show" -> booking no show status (true or false)
"arrived" -> booking arrival status (true or false)
"table" -> booking table number (if any)
"special_request" -> booking special request
"channel" -> booking channel (define from where the booking come)
"ack" -> booking acknoledge (indicates if the restaurant or system has confirmed the booking.)
"note" -> booking note
"cancel_url" -> booking cancel url
"gcal_id" -> google calender id
"remindered" -> booking reminder
"deleted_at" -> booking deleted at
"kids" -> booking kids number (if any)
"adult" -> booking adult number
"adjusted" -> indicates wheter the booking was being updated or not
"group_booking" -> indicates wheter the booking was group booking
"created_by" -> booking created by
"modified_by" -> booking updated by (define who edit the booking like (user, owner, admin))
"confirmed_by" -> booking confirmed by (for big group booking)
"cancelled_by" -> booking canceled by (define who cancel the booking like (user, owner, admin))
"medium" -> booking medium (its like utm source)
"special_bonus_id" -> not used anymore
"cancel_reason" -> booking cancel reason
"voucher_id" -> promo code id
"voucher_added_at" -> promo code added date time
"dining_occasion_id" -> dining occasion id (the dining occasion that user pick)
"service_type" -> service type (dine in)
"distance_to_restaurant" -> not used anymore (for h@h package)
"address_id" -> not used anymore(for h@h package)
"old_reservation_id" -> to save the old booking ID (if the user edits their booking, a new booking data will be created and the old booking ID will be listed here if this data was the new booking)
"driver_ack" -> not used anymore (for h@h package)
"is_temporary" -> indicates if the booking was temporary or not (the booking is temporary because it was made as a prepaid reservation, but payment has not yet been received)
"self_pickup_ack" -> not used anymore
"promptpay_provider" -> promptpay payment provider (omise or gbprimepay)
"cc_provider" -> credit card provider
"gb_merchant_id" -> gbprimepay merchant id (for restaurant that use)
"delivery_time" -> not used anymore
"skip_reorder_driver" -> not used anymore
"charge_price" -> the price that user paid (if the charge_percent is 100, the value is the same as the total_price)
"total_price" -> the total price of the reservation
"charge_amount_type" -> indicates the package charge amount type (fixed, relative, flat, per_person)
"charge_percent" -> the percentage amount of the payment
"charge_type" -> indicates the charge type if its on hold or not (on_hold, on_charge)
"delivery_fee" -> not used anymore
"delivery_fee_in_baht" -> not used anymore
"delivery_fee_per_km_in_baht" -> not used anymore
"guest_id" -> not used anymore
"prefix_number_cc" -> not used anymore
"confirmed_at" -> not used anymore
"delivery_subsidize_cents" -> not used anymore
"delivery_subsidize_currency" -> not used anymore
"is_order_now" -> not used anymore
"time_estimation" -> not used anymore
"skip_start_time" -> not used anymore
"delivery_discount_amount_cents" -> not used anymore
"delivery_discount_amount_currency" -> not used anymore
"prepared" -> not used anymore
"true_wallet_provider" -> not used anymore
"delivery_channel_id" -> not used anymore
"driver_called" -> not used anymore
"used_voucher_amount_by_hh_cents" -> voucher(subsidized by hh) amount that used on the reservation
"used_voucher_amount_by_hh_currency" -> voucher(subsidized by hh) currency
"used_voucher_amount_by_restaurant_cents" -> voucher(subsidized by restaurant) amount that used on the reservation
"used_voucher_amount_by_restaurant_currency" -> voucher(subsidized by restaurant) currency
"corporate_event_id" -> corporate event id (when user book using corporate event link)
"accept_we_travel_together" -> indicate if the reservation use we travel together promotions
"original_delivery_fee" -> not used anymore
"driving_duration" -> not used anymore
"driving_duration_checked" -> not used anymore
"for_locking_system" -> to lock inventory when user still in checkout process
"session_id" -> payment session id
"payment_start_from" -> payment start countdown
"shopee_pay_provider" -> not used anymore
"refund" -> indicates if the reservation was refunded
"card_id" -> user saved card information id
"pay_now" -> indicates if the reservation use pay_now payment method
"waiting_for_pick_up" -> not used anymore
"new_reservation_id" -> to save the new booking ID (if the user edits their booking, new booking data will be created and the new booking ID will be listed here if this data was the old booking)
"modify_with_prepaid" ->
"reservation_filter" ->
"is_valid_reservation" -> indicates if the reservation is valid or not
"alipay_provider" -> alipay payment provider number
"wechat_pay_provider" -> wechat payment provider number
"total_price_v2_cents" -> total reservation price
"charge_price_v2_cents" -> total price that charged (it can be differs because restaurant can set the percentage of the price that mus be prepaid)
"username" -> user name
}
Charge_amount_type:
relative is percentage-based
fixed is per person (for all package type except pp),per pack (for party pack)
flat is per booking
per_person is per person (party pack only)
Audit
On here you can find if there’s update on the booking. you can check by looking at the table, the before after attributes, all of the changes that was made on the booking will be listed on this table and show.
when you click the Full audit JSON button it will shows all the booking attributes as you can see bellow:
{
"id"-> audit ID
"auditable_id"-> booking ID
"auditable_type"-> type of edited data (reservation)
"associated_id"-> not used
"associated_type"-> not used
"user_id"-> user id
"user_type"-> user type (admin, owner, user)
"username"-> user name
"action"-> audit action (update, create)
"audited_changes": {} -> audited change listed here (all the change, from reservation status, package changes, etc.)
"version"-> audit version
"comment"-> audit comment
"remote_address"-> ip address
"created_at"-> audit log creqated at
"request_uuid"-> request audit uid
}
Property
On here you can find the details of booking property, like packages, payment, and campaign
{
"id": property ID
"custom_sms_by_owner":
"reservation_id": booking ID
"created_at":
"updated_at":
"campaign_source":
"campaign_medium":
"campaign_name":
"campaign_term":
"campaign_content":
"package": {
"package_type": package type
"package_data": [
{
"id": package ID
"type": package type
"quantity": package quantity
"price_cents": package price in cents
"price_currency": package price currency
"commision": package commision
"restaurant_package_id": restaurant package ID
"pricing_type": pricing type
"use_custom_price": indicates whether package using custom price or not
"prepayment_percent": indicates prepayment in percent
"total_adult_price": total adult price
"total_kids_price": total kids price
"pricing_groups": pricing group data
"restaurant_package_start_date":
"restaurant_package_end_date":
}
],
"price_cents": package price in cents
"price_currency": package price currency
"revenue": revenue
"use_dynamic_pricing": true
},
"business_booking": indicates company booking
"guest_booking_id": guest booking id
"klook_id": klook id
"is_prepayment": indicates whether the package was using prepayment or not
"prepayment_cents": total prepayment amount in cents
"prepayment_currency": prepayment currency
"last_minute": indicates whether the package was using last minutes booking
"lat":
"lng":
"skip_review":
"has_requested_bike": not used anymore
"pending_transaction_id":
"covered_by_hh": indicates whether the booking was covered by Hungryhub
"delivered_timestamp": not used anymore
"courier_called_at": not used anymore
"selected_packages": information about the selected package in this booking
"add_on": {},
"selected_add_ons": information about selected add on in this booking
"package_type": package type
"revenue": booking revenue
"price_cents": booking price in cents
"accept_refund": true,
"custom_refund_fee_cents": 0
}
Audit
On here you can find the audit if the booking property was edited.
{
"id"-> audit ID
"auditable_id"-> peoperty ID
"auditable_type"-> type of edited data (reservation, reservation property)
"associated_id"->
"associated_type"->
"user_id"-> user id
"user_type"-> user type (admin, owner, user)
"username"-> user name
"action"-> audit action (update, create)
"audited_changes": {} -> audited change listed here
"version"-> audit version
"comment"-> audit comment
"remote_address"->
"created_at"-
"request_uuid"->
}
Charges
On here you can find the detail of booking charges, when the booking was prepaid or using deposit. Private (https://app.clickup.com/9003122396/docs/8ca1fpw-31876/8ca1fpw-39856)
Customer
Reservation Vouchers
On here you can see the detail if the user user point or voucher on their booking. it will create new data on reservation voucher table
Vouchers
On here you can see the details of the voucher that user using while booking
Vendor Reservation
On here you can find the details of the payment if user use vendor payment
Notification
On here you can find list of notification that user receive
[
{
"id": 35584207,
"note": {
"sidekiq_job_ids_J2Cgi": {
"send_notifications_J2Cgi": "bb719a9b2b9e4fe545aeea66"
}
},
"parent_id": 4875845,
"parent_type": "Reservation",
"created_at": "2024-05-19T15:05:34.000Z",
"updated_at": "2024-05-19T15:05:34.000Z"
},
{
"id": 35584208,
"note": {
"notifications_480V7": {
"create_gcal_event": "g9l30mekm3i69gsrpid1k1i4q0",
"ack_has_offers_notif_confirmed_by_email_for_admin": "#",
"ack_has_offers_notif_confirmed_by_email_for_owner": "#",
"ack_has_offers_notif_confirmed_by_sms_for_owner": "NEW BOOKING!\nThe Lobby Lounge at Hyatt Regency Bangkok Sukhumvit\nBooking ID: 4875845\nTue, 21 May @ 13:15 for 4 adults",
"push_notification_booking_created_to_owner": null
},
"notification_paths_480V7": [
"create",
"by_guest",
"has_offers_not_last_minute",
"create_gcal_event",
"ack_has_offers_notif_confirmed_by_email",
"ack_has_offers_notif_confirmed_by_sms",
"ack_has_offers_ask_to_give_rating_by_email",
"push_notification_booking_created"
]
},
"parent_id": 4875845,
"parent_type": "Reservation",
"created_at": "2024-05-19T15:05:35.000Z",
"updated_at": "2024-05-19T15:05:35.000Z"
}
]
Reservation Packages
On here you can find the details information about the package on this reservation
OpenRice Notification (title name should same as the vendor or partner that user booked)
On here you can find list of vendor and partner notification
{
"id": 6534,
"reservation_id": 4875845,
"vendor_id": 3,
"created_at": "2024-05-19T15:05:13.000Z",
"updated_at": "2024-05-19T15:05:13.000Z",
"webhook_sent_at": null,
"webhook_reservation_status": null,
"reference_id": "20240519792229",
"supplier_reservation_id": null,
"inventory_source_id": null
}
Reservation Refund Guarantee
Detail information about the refund guarantee status:
claimed→ User cancel the bookingexpired→ User didn’t use the refund guarantee after the time limit
{
"id": refund guarantee id
"reservation_id": reservation id
"refundable_amount_cents": refundable amount that user will get
"refund_fee_cents": refund guarantee fee
"refund_currency": refund guarantee currency
"refundable_until": time limit to claim the refund guarantee
"status": refund guarantee status
"created_at": "2026-01-27T04:47:30.000Z",
"updated_at": "2026-01-27T04:52:47.000Z",
"voucher_id": voucher id that user get when the refund guarantee is being claimed
}
Reservation Tracking
{
"id": 128259,
"reservation_id": 8967815,
"country_id": 218,
"created_at": "2026-01-27 04:47:30 UTC",
"updated_at": "2026-01-27 04:47:30 UTC",
"utm_campaign": null,
"utm_medium": null,
"utm_source": null,
"country_name": "Thailand"
}