Turn the following set of CSV files into a relational schema DDL in MySQL syntax with primary and foreign key declarations. Keep the schema as small as possible and do not repeat fields. Make the labels human-readable and understandable by expanding abbreviations when applicable but do not introduce additional prefixes or suffixes to the labels unless necessary. Output only the MySQL schema and no additional text explanation.

player.csv
id,player_api_id,player_name,player_fifa_api_id,birthday,height,weight
5,23780,NAME_1 NAME_2,17725,1979-11-08 00:00:00,182.88,154

team.csv
id,team_api_id,team_fifa_api_id,team_long_name,team_short_name
1,9987,673.0,KRC Genk,GEN
2,9993,675.0,Beerschot AC,BAC

match.csv
match_id,country_id,away_team_id,home_team_id,away_player_id,home_player_id
3249,1729,8472,9825,33863,31013
3249,1729,8472,9825,175947,31013

country.csv
id,name
1,Belgium
1729,England
 Write your response with exactly 7 paragraphs, separated with the markdown divider: ***.
user