DATABASE1

Tables (5)

Game

  • GameId — int — Primary key — NOT NULL

Participated

  • PlayerId — int — Foreign key → Player.PlayerId — NOT NULL
  • GameId — int — Foreign key → Game.GameId — NOT NULL
  • PositionInGame — varchar
  • ParticipatedYN — char

Player

  • PlayerId — int — Primary key — NOT NULL
  • TeamId — int — Foreign key → Team.TeamId — NOT NULL
  • PlayerName — varchar
  • Position — char

Result

  • GameId — int — Foreign key → Game.GameId — NOT NULL
  • TeamId — int — Foreign key → Team.TeamId — NOT NULL
  • Score — int
  • WinOrLose — char

Team

  • TeamId — int — Primary key — NOT NULL
  • TeamName — varchar