logo
ExamplesEditorPricingDocs
37.1kSign in

Multiplayer matchmaking database schema

How a competitive game backend matches players: skill ratings with uncertainty and full rating history, parties, regional queues, accept-or-decline proposals, server allocation, match rosters with backfill and abandonment penalties.

Matchmaking ER diagram

Multiplayer matchmaking database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 11 n1 n1 n1 n1 n1 n1 n1 n1 n1 players idBIGINT external_idVARCHAR display_nameVARCHAR home_region_codeVARCHAR platformVARCHAR created_atTIMESTAMPTZ last_match_atTIMESTAMPTZ playlists idBIGINT codeVARCHAR nameVARCHAR team_countSMALLINT team_sizeSMALLINT max_party_sizeSMALLINT is_rankedBOOLEAN rating_systemVARCHAR initial_muNUMERIC initial_sigmaNUMERIC is_enabledBOOLEAN skill_ratings player_idBIGINT playlist_idBIGINT muNUMERIC sigmaNUMERIC volatilityNUMERIC display_ratingINTEGER matches_playedINTEGER is_placedBOOLEAN last_match_atTIMESTAMPTZ updated_atTIMESTAMPTZ rating_history idBIGINT player_idBIGINT playlist_idBIGINT match_idBIGINT reasonVARCHAR mu_beforeNUMERIC sigma_beforeNUMERIC mu_afterNUMERIC sigma_afterNUMERIC expected_scoreNUMERIC occurred_atTIMESTAMPTZ parties idBIGINT leader_player_idBIGINT playlist_idBIGINT region_codeVARCHAR stateVARCHAR created_atTIMESTAMPTZ disbanded_atTIMESTAMPTZ party_members party_idBIGINT player_idBIGINT is_readyBOOLEAN joined_atTIMESTAMPTZ queue_tickets idBIGINT party_idBIGINT playlist_idBIGINT region_codeVARCHAR party_sizeSMALLINT search_muNUMERIC search_radiusNUMERIC stateVARCHAR enqueued_atTIMESTAMPTZ last_widened_atTIMESTAMPTZ state_changed_atTIMESTAMPTZ game_servers idBIGINT region_codeVARCHAR providerVARCHAR hostVARCHAR portINTEGER build_versionVARCHAR capacitySMALLINT active_matchesSMALLINT stateVARCHAR heartbeat_atTIMESTAMPTZ match_proposals idBIGINT playlist_idBIGINT region_codeVARCHAR server_idBIGINT stateVARCHAR required_acceptsSMALLINT accept_countSMALLINT quality_scoreNUMERIC expires_atTIMESTAMPTZ created_atTIMESTAMPTZ proposal_responses idBIGINT proposal_idBIGINT ticket_idBIGINT player_idBIGINT team_indexSMALLINT responseVARCHAR responded_atTIMESTAMPTZ matches idBIGINT proposal_idBIGINT playlist_idBIGINT region_codeVARCHAR server_idBIGINT stateVARCHAR is_rankedBOOLEAN backfill_openBOOLEAN winning_team_indexSMALLINT started_atTIMESTAMPTZ ended_atTIMESTAMPTZ created_atTIMESTAMPTZ match_slots idBIGINT match_idBIGINT team_indexSMALLINT slot_indexSMALLINT player_idBIGINT party_idBIGINT ticket_idBIGINT is_backfillBOOLEAN rating_mu_at_startNUMERIC joined_atTIMESTAMPTZ left_atTIMESTAMPTZ abandonedBOOLEAN placementSMALLINT scoreINTEGER player_penalties idBIGINT player_idBIGINT playlist_idBIGINT match_idBIGINT reasonVARCHAR severity_levelSMALLINT starts_atTIMESTAMPTZ ends_atTIMESTAMPTZ waived_atTIMESTAMPTZ

Related database schemas

PostgreSQL
Gaming

Game leaderboards and achievements database schema

How a game backend models progression: score submissions, leaderboards scoped global or regional or friends across daily and seasonal periods, rank derived rather than stored, multi-step achievements with progress, unlock rewards and anti-cheat flags.

MySQL
Gaming

Esports tournament and bracket database schema

How a tournament platform models competition: single and double elimination, round robin and Swiss stages, teams with roster locks, a bracket stored as a node tree, best-of series with per-map results, venues and prize distribution.

PostgreSQL
Gaming

In-game economy and virtual currency database schema

How a game backend models virtual currency: hard and soft currencies, player wallets, an append-only double-entry ledger of every source and sink, a personalised item shop, validated store receipts, refunds and a battle pass.

PostgreSQL
Gaming

MMO game inventory and item database schema

How an online game models items: templates versus instances, stacking rules, affixes rolled per copy, bags and bank and equipped slots, soulbinding, durability, two-sided player trades, mail with attachments and an append-only item audit log.