Build web app for my booking -- 2

--- dashboard - php myadmin types PHP language; mysql db; db dashboard- using php myadmin. Storage : 1. Facility Sport (fsid) data storage .... max capacity any other detail 2. Capacity management: date, slot(time), fsid, max capacity, remaining capacity, price, last updated, 3. Booking table - booking date, slot(time), fsid, source id, # courts booked, status , created date 4. source id : non numeric - uuid types. ----- Api 1. availability api - get available courts by fsid, date, slot -> remaining capacity, price 2. booking - fsid, booking date, slot,#courts - > reference id(randomized). /failure 3. cancellation (reference)- reference id -> success /failure. --validations / authentication/ source- unique id etc.