Column booking

booking_id: Unique identifier for a booking.

booking_creation_date: Date when the booking was created.

booking_created_at: Timestamp when the booking was created.

booking_quantity: Quantity of offer booked. Can be 1, or 2 if booking was made using the duo option.

booking_amount: Total amount for the booking for one quantity.

booking_status: Current status of the booking.

booking_is_cancelled: Boolean. Indicates if the booking is cancelled.

booking_is_used: Boolean. Indicates if the booking has been used.

booking_reimbursed: Boolean. Indicates if the booking amount was reimbursed or not.

booking_cancellation_date: Date when the booking was cancelled.

booking_cancellation_reason: Reason for booking cancellation.

booking_intermediary_amount: The amount of the booking multiplied by the booking quantity. This field is used when we calculate the revenue.

booking_rank: Rank of the booking in the user's booking history.

booking_used_date: Date when the booking was used.

booking_used_recredit_type: The type of recredit associated with the booking, linking a booking to a specific user cohort.

user_booking_rank: Rank of the user booking.

same_category_booking_rank: Rank of the user booking within the same offer_category.

first_individual_booking_date: Date of the first individual booking.

first_booking_date: Date of the first booking.

last_booking_date: Date of the last booking.

last_individual_booking_date: Date of the last individual booking.