Tryout mvp

Tables (4)

club (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • league_id (Key3) — Foreign key → league.id — NOT NULL
  • link (Field)
  • average_age (Field2)
  • squad_size (Field3)
  • foreigners (Field4)
  • ratio_foreigners (Field5)
  • name (Field6)
  • national_team_players (Field7)

league (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • average_age (Field)
  • foreigners (Field2)
  • ratio_foreigners (Field3)
  • name (Field4)
  • number_of_teams (Field5)
  • players (Field6)
  • link (Field7)

player (Untitled)

  • id (Key) — Primary key — NOT NULL
  • club_id (Key2) — Foreign key → club.id — NOT NULL
  • league_id (Key3) — Foreign key → club.league_id — NOT NULL
  • name (Field)
  • birth (Field12)
  • age (Field4)
  • citizenship (Field2)
  • height (Field3)
  • national_player (Field6)
  • foot (Field11)
  • main_position (Field7)
  • other_positions (Field8)
  • further_information (Field9)
  • link (Field5)
  • uniform_number (Field10)

transfer_history (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • player_id (Key3) — Foreign key → player.id — NOT NULL
  • club_id (Key22) — Foreign key → player.club_id — NOT NULL
  • league_id (Key32) — Foreign key → player.league_id — NOT NULL
  • season (Field)
  • year (Field2)
  • from_team (Field3)
  • to_team (Field4)
  • date (Field5)