Booking System

A reservation is a time slot bound to a specific court within a venue. On creation the booking engine runs a two-pass conflict check: first against other bookings on the same court, then against competition allocations and maintenance windows surfaced by Court Management. Overlap detection uses half-open intervals so back-to-back slots never collide, and any conflict aborts the booking with a structured error indicating which entity blocked it.

The booking calendar exposes a public availability view that includes bookings, allocations, and recurring series so external apps and embedded widgets on club websites can render an accurate occupancy grid without authentication. Recurring bookings are stored as series definitions (weekly, biweekly, or monthly) and expanded into individual instances; the expansion is conflict-aware, skipping or flagging dates that collide with existing reservations or future competition blocks rather than silently failing.

Competition court blocking is enforced at allocation time: when a tournament director allocates courts for a session, the booking layer marks those courts unavailable for the duration and rejects new reservations or recurring instances that would overlap. This guarantees that ranked tournaments never lose courts to ad-hoc club bookings.

Payment is integrated as part of the booking record itself. Each booking carries a fee, currency, payment_status, and invoice_id, and a successful payment automatically transitions the booking to confirmed. For bookings that are taken over the phone or at reception, the explicit /confirm endpoint lets staff move a pending booking to confirmed with a confirmed_at timestamp without payment.

The system distinguishes reservation bookings from walk-ins via booking_type, supporting venues that operate hybrid models — pre-booked competitive players plus drop-in casual play. Cancellations are handled in two flavours: a hard DELETE for staff cleanup and a POST /cancel that records reason, cancelled_at, and cancelled_by for audit and refund processing.