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)