Audit for Dev
Booking
Here you can find key booking table attributes.
{
"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 acknowledge (indicates if the restaurant or system has confirmed the booking.)
"note" -> booking note
"cancel_url" -> booking cancel url
"gcal_id" -> google calendar 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.
{
"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 (define who update the booking)
"user_type"-> user type (user, staff (if its edited, created, deleted by staff owner please contact dev teams to check who is it))
"username"-> user name
"action"-> audit action (update, create)
"audited_changes": {} -> audited change listed here (all the change, from reservation status, package changes, modified by, canceled by, created by etc.)
"version"-> audit version
"comment"-> audit comment
"remote_address"-> ip address
"created_at"-> audit log creqated at
"request_uuid"-> request audit uid
}
Property
This section stores booking properties such as package and payment metadata.
{
"reservation_id": "booking ID",
"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
}
Property audit
Here you can find audit data if reservation properties were 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 (define who update the booking)
"user_type"-> user type (user, staff (if its edited, created, deleted by staff owner please contact dev teams to check who is it))
"username"-> user name
"action"-> audit action (update, create)
"audited_changes": {} -> audited change listed here (all the change, from reservation status, package changes, modified by, canceled by, created by etc.)
"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
Vendor Reservation
On here you can find the details of the payment if user use vendor payment
Vendor payment
Contains payment data when booking uses vendor payment channels.
Notification
Contains user notification records generated by booking flows.
[
{
"id": 35584207,
"parent_type": "Reservation"
}
]
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"
}