Matches ~ ERD

Entities

Match

Attributes:

• match_id (integer)
• game (integer)
• lobby (integer)
• date_played (date)

Player (User-Match Throughtable)

Attributes:

• player_id (integer)
• user (integer)
• match (integer)
• team (nullable string)
• role (nullable string)
• outcome (nullable string, one of "win", "lose", "draw", "withdrawal")
• victory_type (nullable string)

Relationships

• User and Match
  • Users (N) **play** Matches (M)