erdtest2
Tables (3)
MatchRecords
- match_id (Key) — INT — Primary key — NOT NULL
- team_id (Key2) — INT — Foreign key → Teams.team_id — NOT NULL
- date_played — DATE
- home_team_id — INT
- away_team_id — INT
- player_id — INT
- goals_scored — INT
- assists — INT
- yellow_cards — INT
- red_cards — INT
Players
- player_id (Key) — INT — Primary key — NOT NULL
- team_id (Key2) — INT — Foreign key → Teams.team_id — NOT NULL
- match_id (Key3) — INT — Foreign key → MatchRecords.match_id — NOT NULL
- first_name — VARCHAR(50) — NOT NULL
- last_name — VARCHAR(50) — NOT NULL
- date_of_birth — DATE
- nationality — VARCHAR(50)
- position — VARCHAR(50)
- height_cm — DECIMAL(5, 2)
- weight_kg — DECIMAL(5, 2)
- team_id — INT
Teams
- team_id (Key) — INT — Primary key — NOT NULL
- team_name — VARCHAR(50) — NOT NULL
- coach_name — VARCHAR(50)
- foundation_year — INT
- country — VARCHAR(50)