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