{"Player_Attributes": {"columns": [[0, "id", "INTEGER", 0, null, 1], [1, "player_fifa_api_id", "INTEGER", 0, null, 0], [2, "player_api_id", "INTEGER", 0, null, 0], [3, "date", "TEXT", 0, null, 0], [4, "overall_rating", "INTEGER", 0, null, 0], [5, "potential", "INTEGER", 0, null, 0], [6, "preferred_foot", "TEXT", 0, null, 0], [7, "attacking_work_rate", "TEXT", 0, null, 0], [8, "defensive_work_rate", "TEXT", 0, null, 0], [9, "crossing", "INTEGER", 0, null, 0], [10, "finishing", "INTEGER", 0, null, 0], [11, "heading_accuracy", "INTEGER", 0, null, 0], [12, "short_passing", "INTEGER", 0, null, 0], [13, "volleys", "INTEGER", 0, null, 0], [14, "dribbling", "INTEGER", 0, null, 0], [15, "curve", "INTEGER", 0, null, 0], [16, "free_kick_accuracy", "INTEGER", 0, null, 0], [17, "long_passing", "INTEGER", 0, null, 0], [18, "ball_control", "INTEGER", 0, null, 0], [19, "acceleration", "INTEGER", 0, null, 0], [20, "sprint_speed", "INTEGER", 0, null, 0], [21, "agility", "INTEGER", 0, null, 0], [22, "reactions", "INTEGER", 0, null, 0], [23, "balance", "INTEGER", 0, null, 0], [24, "shot_power", "INTEGER", 0, null, 0], [25, "jumping", "INTEGER", 0, null, 0], [26, "stamina", "INTEGER", 0, null, 0], [27, "strength", "INTEGER", 0, null, 0], [28, "long_shots", "INTEGER", 0, null, 0], [29, "aggression", "INTEGER", 0, null, 0], [30, "interceptions", "INTEGER", 0, null, 0], [31, "positioning", "INTEGER", 0, null, 0], [32, "vision", "INTEGER", 0, null, 0], [33, "penalties", "INTEGER", 0, null, 0], [34, "marking", "INTEGER", 0, null, 0], [35, "standing_tackle", "INTEGER", 0, null, 0], [36, "sliding_tackle", "INTEGER", 0, null, 0], [37, "gk_diving", "INTEGER", 0, null, 0], [38, "gk_handling", "INTEGER", 0, null, 0], [39, "gk_kicking", "INTEGER", 0, null, 0], [40, "gk_positioning", "INTEGER", 0, null, 0], [41, "gk_reflexes", "INTEGER", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [[0, 0, "Player", "player_api_id", "player_api_id", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "Player", "player_fifa_api_id", "player_fifa_api_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [], "check_constraints": []}, "sqlite_sequence": {"columns": [[0, "name", "", 0, null, 0], [1, "seq", "", 0, null, 0]], "primary_keys": [], "foreign_keys": [], "unique_constraints": [], "check_constraints": []}, "Player": {"columns": [[0, "id", "INTEGER", 0, null, 1], [1, "player_api_id", "INTEGER", 0, null, 0], [2, "player_name", "TEXT", 0, null, 0], [3, "player_fifa_api_id", "INTEGER", 0, null, 0], [4, "birthday", "TEXT", 0, null, 0], [5, "height", "INTEGER", 0, null, 0], [6, "weight", "INTEGER", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 3, "player_fifa_api_id"]], [[0, 1, "player_api_id"]]], "check_constraints": []}, "League": {"columns": [[0, "id", "INTEGER", 0, null, 1], [1, "country_id", "INTEGER", 0, null, 0], [2, "name", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [[0, 0, "Country", "country_id", "id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 2, "name"]]], "check_constraints": []}, "Country": {"columns": [[0, "id", "INTEGER", 0, null, 1], [1, "name", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 1, "name"]]], "check_constraints": []}, "Team": {"columns": [[0, "id", "INTEGER", 0, null, 1], [1, "team_api_id", "INTEGER", 0, null, 0], [2, "team_fifa_api_id", "INTEGER", 0, null, 0], [3, "team_long_name", "TEXT", 0, null, 0], [4, "team_short_name", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 1, "team_api_id"]]], "check_constraints": []}, "Team_Attributes": {"columns": [[0, "id", "INTEGER", 0, null, 1], [1, "team_fifa_api_id", "INTEGER", 0, null, 0], [2, "team_api_id", "INTEGER", 0, null, 0], [3, "date", "TEXT", 0, null, 0], [4, "buildUpPlaySpeed", "INTEGER", 0, null, 0], [5, "buildUpPlaySpeedClass", "TEXT", 0, null, 0], [6, "buildUpPlayDribbling", "INTEGER", 0, null, 0], [7, "buildUpPlayDribblingClass", "TEXT", 0, null, 0], [8, "buildUpPlayPassing", "INTEGER", 0, null, 0], [9, "buildUpPlayPassingClass", "TEXT", 0, null, 0], [10, "buildUpPlayPositioningClass", "TEXT", 0, null, 0], [11, "chanceCreationPassing", "INTEGER", 0, null, 0], [12, "chanceCreationPassingClass", "TEXT", 0, null, 0], [13, "chanceCreationCrossing", "INTEGER", 0, null, 0], [14, "chanceCreationCrossingClass", "TEXT", 0, null, 0], [15, "chanceCreationShooting", "INTEGER", 0, null, 0], [16, "chanceCreationShootingClass", "TEXT", 0, null, 0], [17, "chanceCreationPositioningClass", "TEXT", 0, null, 0], [18, "defencePressure", "INTEGER", 0, null, 0], [19, "defencePressureClass", "TEXT", 0, null, 0], [20, "defenceAggression", "INTEGER", 0, null, 0], [21, "defenceAggressionClass", "TEXT", 0, null, 0], [22, "defenceTeamWidth", "INTEGER", 0, null, 0], [23, "defenceTeamWidthClass", "TEXT", 0, null, 0], [24, "defenceDefenderLineClass", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [[0, 0, "Team", "team_api_id", "team_api_id", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "Team", "team_fifa_api_id", "team_fifa_api_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [], "check_constraints": []}}
CREATE TABLE Player_Attributes (
    id INTEGER   PRIMARY KEY,
    player_fifa_api_id INTEGER,
    player_api_id INTEGER,
    date TEXT,
    overall_rating INTEGER,
    potential INTEGER,
    preferred_foot TEXT,
    attacking_work_rate TEXT,
    defensive_work_rate TEXT,
    crossing INTEGER,
    finishing INTEGER,
    heading_accuracy INTEGER,
    short_passing INTEGER,
    volleys INTEGER,
    dribbling INTEGER,
    curve INTEGER,
    free_kick_accuracy INTEGER,
    long_passing INTEGER,
    ball_control INTEGER,
    acceleration INTEGER,
    sprint_speed INTEGER,
    agility INTEGER,
    reactions INTEGER,
    balance INTEGER,
    shot_power INTEGER,
    jumping INTEGER,
    stamina INTEGER,
    strength INTEGER,
    long_shots INTEGER,
    aggression INTEGER,
    interceptions INTEGER,
    positioning INTEGER,
    vision INTEGER,
    penalties INTEGER,
    marking INTEGER,
    standing_tackle INTEGER,
    sliding_tackle INTEGER,
    gk_diving INTEGER,
    gk_handling INTEGER,
    gk_kicking INTEGER,
    gk_positioning INTEGER,
    gk_reflexes INTEGER,
    FOREIGN KEY (player_api_id) REFERENCES Player(player_api_id),
    FOREIGN KEY (player_fifa_api_id) REFERENCES Player(player_fifa_api_id)
);

CREATE TABLE sqlite_sequence (
    name,
    seq
);

CREATE TABLE Player (
    id INTEGER   PRIMARY KEY,
    player_api_id INTEGER,
    player_name TEXT,
    player_fifa_api_id INTEGER,
    birthday TEXT,
    height INTEGER,
    weight INTEGER,
    UNIQUE (player_fifa_api_id),
    UNIQUE (player_api_id)
);

CREATE TABLE League (
    id INTEGER   PRIMARY KEY,
    country_id INTEGER,
    name TEXT,
    UNIQUE (name),
    FOREIGN KEY (country_id) REFERENCES Country(id)
);

CREATE TABLE Country (
    id INTEGER   PRIMARY KEY,
    name TEXT,
    UNIQUE (name)
);

CREATE TABLE Team (
    id INTEGER   PRIMARY KEY,
    team_api_id INTEGER,
    team_fifa_api_id INTEGER,
    team_long_name TEXT,
    team_short_name TEXT,
    UNIQUE (team_api_id)
);

CREATE TABLE Team_Attributes (
    id INTEGER   PRIMARY KEY,
    team_fifa_api_id INTEGER,
    team_api_id INTEGER,
    date TEXT,
    buildUpPlaySpeed INTEGER,
    buildUpPlaySpeedClass TEXT,
    buildUpPlayDribbling INTEGER,
    buildUpPlayDribblingClass TEXT,
    buildUpPlayPassing INTEGER,
    buildUpPlayPassingClass TEXT,
    buildUpPlayPositioningClass TEXT,
    chanceCreationPassing INTEGER,
    chanceCreationPassingClass TEXT,
    chanceCreationCrossing INTEGER,
    chanceCreationCrossingClass TEXT,
    chanceCreationShooting INTEGER,
    chanceCreationShootingClass TEXT,
    chanceCreationPositioningClass TEXT,
    defencePressure INTEGER,
    defencePressureClass TEXT,
    defenceAggression INTEGER,
    defenceAggressionClass TEXT,
    defenceTeamWidth INTEGER,
    defenceTeamWidthClass TEXT,
    defenceDefenderLineClass TEXT,
    FOREIGN KEY (team_api_id) REFERENCES Team(team_api_id),
    FOREIGN KEY (team_fifa_api_id) REFERENCES Team(team_fifa_api_id)
);