NBA Player Data By Game From 1949 To 2019

CREATE TABLE all_game_scores (
  "id" BIGINT,
  "home_team_id" BIGINT,
  "home_team_score" BIGINT,
  "away_team_id" BIGINT,
  "away_team_score" BIGINT,
  "away_team_scores" VARCHAR,
  "home_team_scores" VARCHAR,
  "number_of_ots" DOUBLE,
  "date" VARCHAR,
  "attendance" DOUBLE,
  "playoff" BOOLEAN,
  "season" VARCHAR,
  "notes" VARCHAR
);

CREATE TABLE all_star_game_data (
  "id" BIGINT,
  "season" VARCHAR,
  "location" VARCHAR,
  "team_1_name" VARCHAR,
  "team_1_score" BIGINT,
  "team_2_name" VARCHAR,
  "team_2_score" BIGINT,
  "team_a_by_q" VARCHAR,
  "team_b_by_q" VARCHAR
);

CREATE TABLE allstar_mvps (
  "id" BIGINT,
  "game_id" BIGINT,
  "player_id" BIGINT,
  "season" VARCHAR
);

CREATE TABLE all_star_player_data (
  "id" BIGINT,
  "n__game_id" BIGINT  -- Game Id,
  "n__player_id" BIGINT  -- Player Id,
  "n__minutes_in_seconds" DOUBLE  -- Minutes(in Seconds),
  "n__fg" BIGINT  -- Fg,
  "n__fga" BIGINT  -- Fga,
  "n__fg_pct" DOUBLE  -- Fg Pct,
  "n__fg3" DOUBLE  -- Fg3,
  "n__fg3a" DOUBLE  -- Fg3a,
  "n__fg3_pct" DOUBLE  -- Fg3 Pct,
  "n__ft" BIGINT  -- Ft,
  "n__fta" BIGINT  -- Fta,
  "n__ft_pct" DOUBLE  -- Ft Pct,
  "n__orb" DOUBLE  -- Orb,
  "n__drb" DOUBLE  -- Drb,
  "n__trb" BIGINT  -- Trb,
  "n__ast" BIGINT  -- Ast,
  "n__stl" DOUBLE  -- Stl,
  "n__blk" DOUBLE  -- Blk,
  "n__tov" DOUBLE  -- Tov,
  "n__pf" BIGINT  -- Pf,
  "n__pts" BIGINT  -- Pts,
  "n__reserve" BOOLEAN  -- Reserve
);

CREATE TABLE champions (
  "team_id" BIGINT,
  "season" VARCHAR
);

CREATE TABLE coach_awards (
  "id" BIGINT,
  "coach_id" BIGINT,
  "season" VARCHAR,
  "award" VARCHAR
);

CREATE TABLE coaches (
  "id" BIGINT,
  "name" VARCHAR,
  "birth" VARCHAR,
  "died" VARCHAR,
  "high_school" VARCHAR,
  "college" VARCHAR,
  "started_coaching" BIGINT,
  "last_coach_season" BIGINT,
  "years_coaching" BIGINT,
  "retired" BOOLEAN,
  "currently_coaching" VARCHAR,
  "all_teams_coached" VARCHAR,
  "link" VARCHAR
);

CREATE TABLE coaches_stats_season (
  "id" BIGINT,
  "coach_id" BIGINT,
  "season" VARCHAR,
  "regular_season_games" BIGINT,
  "regular_season_wins" BIGINT,
  "regular_season_losses" BIGINT,
  "regular_season_win_loss_pct" DOUBLE,
  "playoff_games" DOUBLE,
  "playoff_wins" DOUBLE,
  "playoff_losses" DOUBLE,
  "playoff_win_loss_pct" DOUBLE
);

CREATE TABLE game_player_data (
  "id" BIGINT,
  "game_id" BIGINT,
  "team_id" BIGINT,
  "opponent_team_id" BIGINT,
  "player_id" BIGINT,
  "minutes" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fgp" DOUBLE,
  "fg3" DOUBLE,
  "fg3a" DOUBLE,
  "fg3p" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ftp" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE,
  "plus_minus" DOUBLE,
  "reason_not_to_play" VARCHAR,
  "reserve" BOOLEAN,
  "season" VARCHAR,
  "playoff" BOOLEAN
);

CREATE TABLE miscellaneous_stats (
  "id" BIGINT,
  "team_id" BIGINT,
  "season" VARCHAR,
  "age" DOUBLE,
  "wins" DOUBLE,
  "losses" VARCHAR,
  "wins_pyth" DOUBLE,
  "losses_pyth" DOUBLE,
  "mov" DOUBLE,
  "sos" DOUBLE,
  "srs" DOUBLE,
  "off_rtg" DOUBLE,
  "def_rtg" DOUBLE,
  "net_rtg" DOUBLE,
  "pace" DOUBLE,
  "fta_per_fga_pct" DOUBLE,
  "fg3a_per_fga_pct" DOUBLE,
  "ts_pct" DOUBLE,
  "efg_pct" DOUBLE,
  "tov_pct" DOUBLE,
  "orb_pct" DOUBLE,
  "ft_rate" DOUBLE,
  "opp_efg_pct" DOUBLE,
  "opp_tov_pct" DOUBLE,
  "drb_pct" DOUBLE,
  "opp_ft_rate" DOUBLE,
  "arena_name" VARCHAR,
  "attendance" DOUBLE,
  "attendance_per_g" DOUBLE
);

CREATE TABLE monthly_coach_awards (
  "id" BIGINT,
  "coach_id" BIGINT,
  "season" VARCHAR,
  "month" VARCHAR,
  "conference" VARCHAR,
  "award_type" VARCHAR
);

CREATE TABLE monthly_player_awards (
  "id" BIGINT,
  "player_id" BIGINT,
  "season" VARCHAR,
  "month" VARCHAR,
  "conference" VARCHAR,
  "award_type" VARCHAR
);

CREATE TABLE opponent_per_100_poss_stats (
  "id" BIGINT,
  "team_id" BIGINT,
  "season" VARCHAR,
  "g" BIGINT,
  "mp" BIGINT,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_pct" DOUBLE,
  "fg3" DOUBLE,
  "fg3a" DOUBLE,
  "fg3_pct" DOUBLE,
  "fg2" DOUBLE,
  "fg2a" DOUBLE,
  "fg2_pct" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_pct" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE
);

CREATE TABLE opponent_per_game_stats (
  "id" BIGINT,
  "team_id" BIGINT,
  "season" VARCHAR,
  "g" DOUBLE,
  "mp" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_pct" DOUBLE,
  "fg3" DOUBLE,
  "fg3a" DOUBLE,
  "fg3_pct" DOUBLE,
  "fg2" DOUBLE,
  "fg2a" DOUBLE,
  "fg2_pct" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_pct" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE
);

CREATE TABLE opponent_season_shooting (
  "id" BIGINT,
  "team_id" VARCHAR,
  "season" BIGINT,
  "g" VARCHAR,
  "mpfg_pct" DOUBLE,
  "avg_dist" DOUBLE,
  "fg2a_ct_fga" VARCHAR,
  "pct_fga_00_03" DOUBLE,
  "pct_fga_03_10" DOUBLE,
  "pct_fga_10_16" DOUBLE,
  "pct_fga_16_xx" DOUBLE,
  "fg3a_pct_fga" DOUBLE,
  "fg2_pct" DOUBLE,
  "fg_pct_00_03" DOUBLE,
  "fg_pct_03_10" DOUBLE,
  "fg_pct_10_16" DOUBLE,
  "fg_pct_16_xx" DOUBLE,
  "fg3_pct" DOUBLE,
  "fg2_pct_ast" DOUBLE,
  "pct_fg2_dunk" DOUBLE,
  "fg2_dunk" BIGINT,
  "pct_fg2_layup" DOUBLE,
  "fg2_layup" DOUBLE,
  "fg3_pct_ast" DOUBLE,
  "pct_fg3a_corner" DOUBLE,
  "fg3_pct_corner" DOUBLE,
  "fg3a_heave" VARCHAR,
  "fg3_heave" VARCHAR
);

CREATE TABLE opponent_season_stats (
  "id" BIGINT,
  "team_id" BIGINT,
  "season" VARCHAR,
  "g" DOUBLE,
  "mp" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_pct" DOUBLE,
  "fg3" DOUBLE,
  "fg3a" DOUBLE,
  "fg3_pct" DOUBLE,
  "fg2" DOUBLE,
  "fg2a" DOUBLE,
  "fg2_pct" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_pct" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE
);

CREATE TABLE other_player_awards (
  "id" BIGINT,
  "payer_id" BIGINT,
  "award" VARCHAR,
  "year" BIGINT
);

CREATE TABLE player_awards (
  "id" BIGINT,
  "player_id" BIGINT,
  "season" VARCHAR,
  "award" VARCHAR
);

CREATE TABLE player_data_per_100_poss (
  "id" BIGINT,
  "player_id" BIGINT,
  "season" VARCHAR,
  "total_games" BIGINT,
  "games_started" DOUBLE,
  "minutes_played" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fgp" DOUBLE,
  "fg3" DOUBLE,
  "fg3a" DOUBLE,
  "fg3p" DOUBLE,
  "fg2" DOUBLE,
  "fg2a" DOUBLE,
  "fg2p" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ftp" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE,
  "ortg" DOUBLE,
  "drtg" DOUBLE
);

CREATE TABLE player_data_per_36_min (
  "id" BIGINT,
  "player_id" BIGINT,
  "season" VARCHAR,
  "total_games" DOUBLE,
  "games_started" DOUBLE,
  "minutes_played" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fgp" DOUBLE,
  "fg3" DOUBLE,
  "fg3a" DOUBLE,
  "fg3p" DOUBLE,
  "fg2" DOUBLE,
  "fg2a" DOUBLE,
  "fg2p" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ftp" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE
);

CREATE TABLE players (
  "id" BIGINT,
  "name" VARCHAR,
  "full_name" VARCHAR,
  "position" VARCHAR,
  "height" VARCHAR,
  "weight" DOUBLE,
  "birth_date" VARCHAR,
  "birth_place" VARCHAR,
  "retired" BOOLEAN,
  "player_url" VARCHAR,
  "current_team_id" DOUBLE,
  "teams" VARCHAR,
  "text" VARCHAR
);

CREATE TABLE team_per_100_poss_stast (
  "id" BIGINT,
  "team_id" BIGINT,
  "season" VARCHAR,
  "g" BIGINT,
  "mp" BIGINT,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_pct" DOUBLE,
  "fg3" DOUBLE,
  "fg3a" DOUBLE,
  "fg3_pct" DOUBLE,
  "fg2" DOUBLE,
  "fg2a" DOUBLE,
  "fg2_pct" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_pct" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE
);

CREATE TABLE team_per_game_stats (
  "id" BIGINT,
  "team_id" BIGINT,
  "season" VARCHAR,
  "g" DOUBLE,
  "mp" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_pct" DOUBLE,
  "fg3" DOUBLE,
  "fg3a" DOUBLE,
  "fg3_pct" DOUBLE,
  "fg2" DOUBLE,
  "fg2a" DOUBLE,
  "fg2_pct" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_pct" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE
);

CREATE TABLE teams (
  "team_id" BIGINT,
  "team_name" VARCHAR,
  "short_name" VARCHAR,
  "years" BIGINT,
  "total_games" BIGINT,
  "total_wins" BIGINT,
  "total_losses" BIGINT,
  "win_loss_percentage" DOUBLE,
  "champions" BIGINT,
  "other_names" VARCHAR,
  "link" VARCHAR,
  "active" BOOLEAN
);

CREATE TABLE team_season_shooting (
  "id" BIGINT,
  "team_id" VARCHAR,
  "season" BIGINT,
  "g" BIGINT,
  "mpfg_pct" DOUBLE,
  "avg_dist" DOUBLE,
  "fg2a_ct_fga" VARCHAR,
  "pct_fga_00_03" DOUBLE,
  "pct_fga_03_10" DOUBLE,
  "pct_fga_10_16" DOUBLE,
  "pct_fga_16_xx" DOUBLE,
  "fg3a_pct_fga" DOUBLE,
  "fg2_pct" DOUBLE,
  "fg_pct_00_03" DOUBLE,
  "fg_pct_03_10" DOUBLE,
  "fg_pct_10_16" DOUBLE,
  "fg_pct_16_xx" DOUBLE,
  "fg3_pct" DOUBLE,
  "fg2_pct_ast" DOUBLE,
  "pct_fg2_dunk" DOUBLE,
  "fg2_dunk" BIGINT,
  "pct_fg2_layup" DOUBLE,
  "fg2_layup" DOUBLE,
  "fg3_pct_ast" DOUBLE,
  "pct_fg3a_corner" DOUBLE,
  "fg3_pct_corner" DOUBLE,
  "fg3a_heave" BIGINT,
  "fg3_heave" BIGINT
);