Fantasy Premier League - 2017/18

CREATE TABLE player_info (
  "assists" BIGINT,
  "bonus" BIGINT,
  "bps" BIGINT,
  "chance_of_playing_next_round" DOUBLE,
  "chance_of_playing_this_round" DOUBLE,
  "clean_sheets" BIGINT,
  "code" BIGINT,
  "cost_change_event" BIGINT,
  "cost_change_event_fall" BIGINT,
  "cost_change_start" BIGINT,
  "cost_change_start_fall" BIGINT,
  "creativity" DOUBLE,
  "dreamteam_count" BIGINT,
  "ea_index" BIGINT,
  "elementstatus" DOUBLE,
  "element_type" BIGINT,
  "element_type_id" BIGINT,
  "element_type_singular_name" VARCHAR,
  "element_type_singular_name_short" VARCHAR,
  "ep_next" DOUBLE,
  "ep_this" DOUBLE,
  "event_points" BIGINT,
  "first_name" VARCHAR,
  "form" DOUBLE,
  "goals_conceded" BIGINT,
  "goals_scored" BIGINT,
  "iconinfo" VARCHAR,
  "ict_index" DOUBLE,
  "id" BIGINT,
  "in_dreamteam" BOOLEAN,
  "influence" DOUBLE,
  "infostub" VARCHAR,
  "iselement" BOOLEAN,
  "istransfer" BOOLEAN,
  "loaned_in" BIGINT,
  "loaned_out" BIGINT,
  "loans_in" BIGINT,
  "loans_out" BIGINT,
  "minutes" BIGINT,
  "news" VARCHAR,
  "next_event_fixture" VARCHAR,
  "now_cost" BIGINT,
  "own_goals" BIGINT,
  "penalties_missed" BIGINT,
  "penalties_saved" BIGINT,
  "photo" VARCHAR,
  "photo_url" VARCHAR,
  "points_per_game" DOUBLE,
  "red_cards" BIGINT,
  "saves" BIGINT,
  "search_name" VARCHAR,
  "second_name" VARCHAR,
  "selected_by_percent" DOUBLE,
  "shirt_id" VARCHAR,
  "shirt_image_url" VARCHAR,
  "special" BOOLEAN,
  "squad_number" DOUBLE,
  "status" VARCHAR,
  "team" BIGINT,
  "team_code" BIGINT,
  "team_name" VARCHAR,
  "team_short_name" VARCHAR,
  "threat" DOUBLE,
  "total_points" BIGINT,
  "transfers_in" BIGINT,
  "transfers_in_event" BIGINT,
  "transfers_out" BIGINT,
  "transfers_out_event" BIGINT,
  "value_form" DOUBLE,
  "value_season" DOUBLE,
  "web_name" VARCHAR,
  "yellow_cards" BIGINT
);