{"player": {"columns": [[0, "Player_ID", "INT", 0, null, 1], [1, "Sponsor_name", "TEXT", 0, null, 0], [2, "Player_name", "TEXT", 0, null, 0], [3, "Gender", "TEXT", 0, null, 0], [4, "Residence", "TEXT", 0, null, 0], [5, "Occupation", "TEXT", 0, null, 0], [6, "Votes", "INT", 0, null, 0], [7, "Rank", "TEXT", 0, null, 0]], "primary_keys": ["Player_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Player_ID"]]], "check_constraints": []}, "club": {"columns": [[0, "Club_ID", "INT", 0, null, 1], [1, "Club_name", "TEXT", 0, null, 0], [2, "Region", "TEXT", 0, null, 0], [3, "Start_year", "INT", 0, null, 0]], "primary_keys": ["Club_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Club_ID"]]], "check_constraints": []}, "coach": {"columns": [[0, "Coach_ID", "INT", 0, null, 1], [1, "Coach_name", "TEXT", 0, null, 0], [2, "Gender", "TEXT", 0, null, 0], [3, "Club_ID", "INT", 0, null, 0], [4, "Rank", "INT", 0, null, 0]], "primary_keys": ["Coach_ID"], "foreign_keys": [[0, 0, "club", "Club_ID", "Club_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Coach_ID"]]], "check_constraints": []}, "player_coach": {"columns": [[0, "Player_ID", "INT", 0, null, 1], [1, "Coach_ID", "INT", 0, null, 2], [2, "Starting_year", "INT", 0, null, 0]], "primary_keys": ["Player_ID", "Coach_ID"], "foreign_keys": [[0, 0, "coach", "Coach_ID", "Coach_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "player", "Player_ID", "Player_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Player_ID"], [1, 1, "Coach_ID"]]], "check_constraints": []}, "match_result": {"columns": [[0, "Rank", "INT", 0, null, 1], [1, "Club_ID", "INT", 0, null, 2], [2, "Gold", "INT", 0, null, 0], [3, "Big_Silver", "INT", 0, null, 0], [4, "Small_Silver", "INT", 0, null, 0], [5, "Bronze", "INT", 0, null, 0], [6, "Points", "INT", 0, null, 0]], "primary_keys": ["Rank", "Club_ID"], "foreign_keys": [[0, 0, "club", "Club_ID", "Club_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Rank"], [1, 1, "Club_ID"]]], "check_constraints": []}}
CREATE TABLE player (
    Player_ID INT   PRIMARY KEY,
    Sponsor_name TEXT,
    Player_name TEXT,
    Gender TEXT,
    Residence TEXT,
    Occupation TEXT,
    Votes INT,
    Rank TEXT,
    UNIQUE (Player_ID)
);

CREATE TABLE club (
    Club_ID INT   PRIMARY KEY,
    Club_name TEXT,
    Region TEXT,
    Start_year INT,
    UNIQUE (Club_ID)
);

CREATE TABLE coach (
    Coach_ID INT   PRIMARY KEY,
    Coach_name TEXT,
    Gender TEXT,
    Club_ID INT,
    Rank INT,
    UNIQUE (Coach_ID),
    FOREIGN KEY (Club_ID) REFERENCES club(Club_ID)
);

CREATE TABLE player_coach (
    Player_ID INT   PRIMARY KEY,
    Coach_ID INT   PRIMARY KEY,
    Starting_year INT,
    PRIMARY KEY (Player_ID, Coach_ID),
    UNIQUE (Player_ID, Coach_ID),
    FOREIGN KEY (Coach_ID) REFERENCES coach(Coach_ID),
    FOREIGN KEY (Player_ID) REFERENCES player(Player_ID)
);

CREATE TABLE match_result (
    Rank INT   PRIMARY KEY,
    Club_ID INT   PRIMARY KEY,
    Gold INT,
    Big_Silver INT,
    Small_Silver INT,
    Bronze INT,
    Points INT,
    PRIMARY KEY (Rank, Club_ID),
    UNIQUE (Rank, Club_ID),
    FOREIGN KEY (Club_ID) REFERENCES club(Club_ID)
);