Indian Super League

CREATE TABLE isl_player_final (
  "tour_id" BIGINT,
  "tour_name" VARCHAR,
  "id" BIGINT,
  "jersey_no" BIGINT,
  "name" VARCHAR,
  "short_name" VARCHAR,
  "position_id" BIGINT,
  "position" VARCHAR,
  "position_short" VARCHAR,
  "team_id" BIGINT,
  "team_name" VARCHAR,
  "team_short_name" VARCHAR,
  "is_started" BIGINT,
  "is_onbench" BIGINT,
  "is_goalkeeper" BIGINT,
  "is_substitute" BIGINT,
  "minutes_played" BIGINT,
  "bonus_points" BIGINT,
  "injury_minutes_played" BIGINT,
  "actual_minutes_played" BIGINT,
  "goaltenders" BIGINT,
  "events_goals" BIGINT,
  "events_own_goals" BIGINT,
  "events_assists" BIGINT,
  "events_key_passes" BIGINT,
  "events_chances_created" BIGINT,
  "events_shots" BIGINT,
  "events_shots_on_target" BIGINT,
  "events_shots_off_target" BIGINT,
  "events_fouls_committed" BIGINT,
  "events_fouls_suffered" BIGINT,
  "events_yellow_cards" BIGINT,
  "events_red_cards" BIGINT,
  "events_is_second_yellow_card" BIGINT,
  "events_offsides" BIGINT,
  "events_corner_kicks" BIGINT,
  "events_crosses" BIGINT,
  "events_free_kicks" BIGINT,
  "events_throw_in" BIGINT,
  "events_punches" BIGINT,
  "events_catches" BIGINT,
  "events_goals_conceded" BIGINT,
  "events_clean_sheet" BIGINT,
  "events_cleansheet" BIGINT,
  "events_fantasy_assists" BIGINT,
  "events_penalties_saved" BIGINT,
  "events_penalties_earned" BIGINT,
  "events_penalties_conceded" BIGINT,
  "events_penalties_missed" BIGINT,
  "events_freekicks_conceded_goal" BIGINT,
  "events_freekicks_earned_goal" BIGINT,
  "events_blocked_shots" BIGINT,
  "events_defensive_blocked_shots" BIGINT,
  "events_penalty_kicks_total" BIGINT,
  "events_penalty_kicks_goals" BIGINT,
  "touches_total" BIGINT,
  "touches_total_passes" BIGINT,
  "touches_good_passes" BIGINT,
  "touches_bad_passes" BIGINT,
  "touches_interceptions" BIGINT,
  "touches_blocks" BIGINT,
  "touches_tackles" BIGINT,
  "touches_successful_tackles" BIGINT,
  "touches_unsuccessful_tackles" BIGINT,
  "touches_clearance" BIGINT,
  "touches_saves" BIGINT,
  "touches_take_on_total" BIGINT,
  "touches_take_on_successful" BIGINT,
  "touches_take_on_unsuccessful" BIGINT,
  "touches_last_man_tackle_successful" BIGINT,
  "touches_last_man_tackle_unsuccessful" BIGINT,
  "touches_successful_passes" BIGINT,
  "touches_interceptions_won" BIGINT,
  "touches_aerial_duel_total" BIGINT,
  "touches_aerial_duel_won" BIGINT,
  "touches_aerial_duel_lost" BIGINT,
  "touches_ground_duel_total" BIGINT,
  "touches_ground_duel_won" BIGINT,
  "touches_ground_duel_lost" BIGINT,
  "goaltenders_shots_faced" BIGINT,
  "goaltenders_shots_on_goal_faced" BIGINT,
  "goaltenders_goals_allowed" BIGINT,
  "goaltenders_saves" BIGINT,
  "goaltenders_catches" BIGINT,
  "goaltenders_punches" BIGINT,
  "goaltenders_penalty_kicks_shots_faced" BIGINT,
  "goaltenders_penalty_kicks_goals_allowed" BIGINT,
  "goaltenders_penalty_kicks_saves" BIGINT,
  "country_id" BIGINT,
  "country_name" VARCHAR,
  "dob" VARCHAR,
  "player_foot" VARCHAR,
  "height" DOUBLE
);