System DesignReported in a candidate post, Jul 2025
Design the database schema for a movie booking site with seat locking
Filed under Gojek
The question
The candidate designed schemas for users, movies, auditoriums, reservations and screenings, extended it to multiple theatres across city locations, described how a search for a movie at a time and hall works, then added seat locking that releases after a timeout if payment is not completed.
No write-up yet. Related questions below have one.
Collected from public candidate posts and coding forums. Updated Nov 2026.