my_database
Queries
Tables
gamedata
game_id, season_id, away_team_id, away_team_score, home_team_id, home_team_score, game_status, game_date, game_attendance, home_team_shots, away_team_shots, game_number, venue_id
25,649 rows
gamegoals
id, game_id, home, period_id, time_of_goal_seconds, team_id, goal_type, x_location, y_location, location_set, power_play, empty_net, penalty_shot, short_handed, insurance_goal, game_winning, game_tieing, scorer_goal_num, goal_scorer_player_id, assist1_player_id, assist2_player_id
148,068 rows
gamepenalties
id, game_id, home, period_id, powerplay, bench, penalty_shot, minutes, penalty, time_of_penalty_seconds, player_penalized, player_server
304,075 rows
player
id, first_name, last_name, position, height, weight, shoots, birth, birth_place, draft_team, draft_round, draft_pick
8,253 rows