Skip to content

Database

tilttek/escape-room-bundle

The bundle adds five tables to the schema the ORM generates for its connection; without the ORM, create them from Tilttek\EscapeRoomBundle\Infrastructure\Doctrine\EscapeRoomTables::configure($schema). Moments are written by the type datetime_utc_immutable, in UTC, to the second.

tilttek_escape_room_game

ColumnHolds
idThe game's identifier, 64 characters at most; the primary key
room, team, sessionThe room, the team's reference and the session, beside the state for the queries
deadlineWhen the countdown reaches zero; null while the game is paused or over; indexed
stateThe JSON of the plain values Game::toArray() writes, every time in UTC to the microsecond

tilttek_escape_room_result

ColumnHolds
gameThe game; the primary key
room, team, sessionAs above
final_seconds, played_seconds, penalty_seconds, hints, skipsThe result
escaped_at, escaped_microThe moment of the escape, and its microseconds, which order two teams that escaped within the same second
publicWhether the team agreed to show it

The index tilttek_escape_room_result_rank reads the leaderboard of a room in order.

tilttek_escape_room_screen

One row per game: what the hint screen shows — kind (hint, message or cleared), the host who showed it, shown_at, and the puzzle, tier and penalty of a hint or the message, 280 characters at most.

tilttek_escape_room_booking

The bookings of the sessions: id, session, room, party, seats, private, booked_at, and position, the order of the booking in its session.

tilttek_escape_room_session_lock

One row per session booked, written by each booking before it decides: the lock of the bookings.