Premier League Player's Stats

CREATE TABLE events (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "deadline_time" VARCHAR,
  "average_entry_score" DOUBLE,
  "highest_scoring_entry" DOUBLE,
  "deadline_time_epoch" BIGINT,
  "highest_score" DOUBLE,
  "is_previous" BOOLEAN,
  "is_current" BOOLEAN,
  "cup_leagues_created" BOOLEAN,
  "h2h_ko_matches_created" BOOLEAN,
  "ranked_count" DOUBLE,
  "chip_plays" VARCHAR,
  "most_selected" BIGINT,
  "most_transferred_in" BIGINT,
  "top_element" BIGINT,
  "top_element_info" VARCHAR,
  "transfers_made" BIGINT,
  "most_captained" BIGINT,
  "most_vice_captained" BIGINT
);

CREATE TABLE fixtures (
  "unnamed_0" BIGINT,
  "code" BIGINT,
  "event" BIGINT,
  "finished" BOOLEAN,
  "finished_provisional" BOOLEAN,
  "id" BIGINT,
  "kickoff_time" VARCHAR,
  "minutes" DOUBLE,
  "provisional_start_time" BOOLEAN,
  "started" BOOLEAN,
  "team_a" BIGINT,
  "team_a_score" DOUBLE,
  "team_h" BIGINT,
  "team_h_score" DOUBLE,
  "stats" VARCHAR,
  "team_h_difficulty" DOUBLE,
  "team_a_difficulty" DOUBLE,
  "pulse_id" BIGINT,
  "end_time" VARCHAR
);

CREATE TABLE fixture_stats (
  "unnamed_0" BIGINT,
  "element" BIGINT,
  "fixture" BIGINT,
  "opponent_team" BIGINT,
  "total_points" DOUBLE,
  "was_home" BOOLEAN,
  "kickoff_time" VARCHAR,
  "team_h_score" DOUBLE,
  "team_a_score" DOUBLE,
  "round" BIGINT,
  "minutes" DOUBLE,
  "goals_scored" DOUBLE,
  "assists" DOUBLE,
  "clean_sheets" DOUBLE,
  "goals_conceded" DOUBLE,
  "own_goals" DOUBLE,
  "penalties_saved" DOUBLE,
  "penalties_missed" DOUBLE,
  "yellow_cards" DOUBLE,
  "red_cards" DOUBLE,
  "saves" DOUBLE,
  "bonus" DOUBLE,
  "bps" DOUBLE,
  "influence" DOUBLE,
  "creativity" DOUBLE,
  "threat" DOUBLE,
  "ict_index" DOUBLE,
  "starts" DOUBLE,
  "expected_goals" DOUBLE,
  "expected_assists" DOUBLE,
  "expected_goal_involvements" DOUBLE,
  "expected_goals_conceded" DOUBLE,
  "value" BIGINT,
  "transfers_balance" BIGINT,
  "selected" BIGINT,
  "transfers_in" BIGINT,
  "transfers_out" BIGINT
);

CREATE TABLE players (
  "unnamed_0" BIGINT,
  "chance_of_playing_next_round" DOUBLE,
  "chance_of_playing_this_round" DOUBLE,
  "code" BIGINT,
  "cost_change_start" DOUBLE,
  "cost_change_start_fall" DOUBLE,
  "dreamteam_count" BIGINT,
  "element_type" BIGINT,
  "ep_next" DOUBLE,
  "ep_this" DOUBLE,
  "event_points" DOUBLE,
  "first_name" VARCHAR,
  "form" DOUBLE,
  "id" BIGINT,
  "in_dreamteam" BOOLEAN,
  "news" VARCHAR,
  "news_added" VARCHAR,
  "now_cost" DOUBLE,
  "photo" VARCHAR,
  "points_per_game" DOUBLE,
  "second_name" VARCHAR,
  "selected_by_percent" DOUBLE,
  "status" VARCHAR,
  "team" BIGINT,
  "team_code" BIGINT,
  "total_points" DOUBLE,
  "transfers_in" BIGINT,
  "transfers_out" BIGINT,
  "value_form" DOUBLE,
  "value_season" DOUBLE,
  "web_name" VARCHAR,
  "minutes" DOUBLE,
  "goals_scored" DOUBLE,
  "assists" DOUBLE,
  "clean_sheets" DOUBLE,
  "goals_conceded" DOUBLE,
  "own_goals" DOUBLE,
  "penalties_saved" DOUBLE,
  "penalties_missed" DOUBLE,
  "yellow_cards" DOUBLE,
  "red_cards" DOUBLE,
  "saves" DOUBLE,
  "bonus" DOUBLE,
  "bps" DOUBLE,
  "influence" DOUBLE,
  "creativity" DOUBLE,
  "threat" DOUBLE,
  "ict_index" DOUBLE,
  "starts" DOUBLE,
  "expected_goals" DOUBLE,
  "expected_assists" DOUBLE,
  "expected_goal_involvements" DOUBLE,
  "expected_goals_conceded" DOUBLE,
  "influence_rank" DOUBLE,
  "influence_rank_type" DOUBLE,
  "creativity_rank" DOUBLE,
  "creativity_rank_type" DOUBLE,
  "threat_rank" DOUBLE,
  "threat_rank_type" DOUBLE,
  "ict_index_rank" DOUBLE,
  "ict_index_rank_type" DOUBLE,
  "corners_and_indirect_freekicks_order" DOUBLE,
  "direct_freekicks_order" DOUBLE,
  "penalties_order" DOUBLE,
  "expected_goals_per_90" DOUBLE,
  "saves_per_90" DOUBLE,
  "expected_assists_per_90" DOUBLE,
  "expected_goal_involvements_per_90" DOUBLE,
  "expected_goals_conceded_per_90" DOUBLE,
  "goals_conceded_per_90" DOUBLE,
  "now_cost_rank" DOUBLE,
  "now_cost_rank_type" DOUBLE,
  "form_rank" DOUBLE,
  "form_rank_type" DOUBLE,
  "points_per_game_rank" DOUBLE,
  "points_per_game_rank_type" DOUBLE,
  "selected_rank" DOUBLE,
  "selected_rank_type" DOUBLE,
  "starts_per_90" DOUBLE,
  "clean_sheets_per_90" DOUBLE
);

CREATE TABLE teams (
  "unnamed_0" BIGINT,
  "code" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "short_name" VARCHAR,
  "strength" DOUBLE,
  "strength_overall_home" DOUBLE,
  "strength_overall_away" DOUBLE,
  "strength_attack_home" DOUBLE,
  "strength_attack_away" DOUBLE,
  "strength_defence_home" DOUBLE,
  "strength_defence_away" DOUBLE,
  "pulse_id" BIGINT
);