Build a CrossFit class booking system with class caps, a waitlist and a late-cancel rule, step by step

A 6am class with a 14-person cap looks simple until you write down what actually happens around it. Somebody books at 9pm, cancels at 5:40am, and the spot sits empty while three people on the waitlist