Tournament

Tables (7)

GAME (Untitled4)

  • GameId (Key) — Primary key — NOT NULL
  • StartDate (Field)
  • EndDate (Field2)
  • Type (Field3)
  • TotalRound (Field4)
  • TotalParticipants (Field5)

GAME_PLAYER (Untitled7)

  • GameId (Key) — Foreign key → GAME.GameId — NOT NULL
  • PlayerId (Key2) — Foreign key → PLAYER.PlayerId — NOT NULL

MATCHES (Untitled)

  • MatchesId (Key) — Primary key — NOT NULL
  • GameId (Key2) — Foreign key → GAME.GameId — NOT NULL
  • Round (Field)
  • Order (Field3)
  • Date (Field2)
  • Winner (Field4)

PLAYER (Untitled2)

  • PlayerId (Key) — Primary key — NOT NULL
  • TeamId (Field6) — Foreign key → TEAM.TeamId
  • PlayerName (Field)
  • Profile (Field2)
  • Gender (Field3)
  • Birth (Field4)
  • Win (Field5)
  • Lose (Field7)
  • Draw (Field8)
  • height (Field9)
  • weight (Field10)

SOLOMATCHES (Untitled5)

  • MatchesId (Key) — Foreign key → MATCHES.MatchesId — NOT NULL
  • PlayerId (Key22) — Foreign key → GAME_PLAYER.PlayerId — NOT NULL

TEAM (Untitled3)

  • TeamId (Field) — Primary key
  • TeamName (Key) — NOT NULL

TEAMMATCHES (Untitled6)