{"country": {"columns": [[0, "Country_id", "INT", 0, null, 1], [1, "Country_name", "TEXT", 0, null, 0], [2, "Capital", "TEXT", 0, null, 0], [3, "Official_native_language", "TEXT", 0, null, 0]], "primary_keys": ["Country_id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Country_id"]]], "check_constraints": []}, "team": {"columns": [[0, "Team_id", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0]], "primary_keys": ["Team_id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Team_id"]]], "check_constraints": []}, "match_season": {"columns": [[0, "Season", "REAL", 0, null, 1], [1, "Player", "TEXT", 0, null, 0], [2, "Position", "TEXT", 0, null, 0], [3, "Country", "INT", 0, null, 0], [4, "Team", "INT", 0, null, 0], [5, "Draft_Pick_Number", "INT", 0, null, 0], [6, "Draft_Class", "TEXT", 0, null, 0], [7, "College", "TEXT", 0, null, 0]], "primary_keys": ["Season"], "foreign_keys": [[0, 0, "team", "Team", "Team_id", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "country", "Country", "Country_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Season"]]], "check_constraints": []}, "player": {"columns": [[0, "Player_ID", "INT", 0, null, 1], [1, "Player", "TEXT", 0, null, 0], [2, "Years_Played", "TEXT", 0, null, 0], [3, "Total_WL", "TEXT", 0, null, 0], [4, "Singles_WL", "TEXT", 0, null, 0], [5, "Doubles_WL", "TEXT", 0, null, 0], [6, "Team", "INT", 0, null, 0]], "primary_keys": ["Player_ID"], "foreign_keys": [[0, 0, "team", "Team", "Team_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Player_ID"]]], "check_constraints": []}}
CREATE TABLE country (
    Country_id INT   PRIMARY KEY,
    Country_name TEXT,
    Capital TEXT,
    Official_native_language TEXT,
    UNIQUE (Country_id)
);

CREATE TABLE team (
    Team_id INT   PRIMARY KEY,
    Name TEXT,
    UNIQUE (Team_id)
);

CREATE TABLE match_season (
    Season REAL   PRIMARY KEY,
    Player TEXT,
    Position TEXT,
    Country INT,
    Team INT,
    Draft_Pick_Number INT,
    Draft_Class TEXT,
    College TEXT,
    UNIQUE (Season),
    FOREIGN KEY (Team) REFERENCES team(Team_id),
    FOREIGN KEY (Country) REFERENCES country(Country_id)
);

CREATE TABLE player (
    Player_ID INT   PRIMARY KEY,
    Player TEXT,
    Years_Played TEXT,
    Total_WL TEXT,
    Singles_WL TEXT,
    Doubles_WL TEXT,
    Team INT,
    UNIQUE (Player_ID),
    FOREIGN KEY (Team) REFERENCES team(Team_id)
);