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)