League Of Legends Esports

CREATE TABLE games (
  "match_id" BIGINT,
  "game_id" BIGINT,
  "number" BIGINT,
  "state" VARCHAR,
  "blue_team_id" BIGINT,
  "red_team_id" BIGINT,
  "vod_provider" VARCHAR,
  "vod_locale" VARCHAR,
  "vod_parameter" VARCHAR,
  "vods_json" VARCHAR
);

CREATE TABLE leagues (
  "id" BIGINT,
  "slug" VARCHAR,
  "name" VARCHAR,
  "region" VARCHAR,
  "image" VARCHAR,
  "priority" BIGINT,
  "displaypriority_position" BIGINT,
  "displaypriority_status" VARCHAR
);

CREATE TABLE matches (
  "event_id" BIGINT,
  "event_type" VARCHAR,
  "league_id" BIGINT,
  "league_slug" VARCHAR,
  "league_name" VARCHAR,
  "league_image" VARCHAR,
  "match_id" BIGINT,
  "match_strategy_count" BIGINT,
  "team1_id" BIGINT,
  "team1_code" VARCHAR,
  "team1_name" VARCHAR,
  "team1_image" VARCHAR,
  "team1_game_wins" BIGINT,
  "team2_id" BIGINT,
  "team2_code" VARCHAR,
  "team2_name" VARCHAR,
  "team2_image" VARCHAR,
  "team2_game_wins" BIGINT
);

CREATE TABLE players (
  "player_id" BIGINT,
  "summoner_name" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "player_image" VARCHAR,
  "role" VARCHAR,
  "team_id" BIGINT,
  "team_code" VARCHAR,
  "team_name" VARCHAR,
  "team_slug" VARCHAR,
  "home_league_name" VARCHAR,
  "home_league_region" VARCHAR
);

CREATE TABLE schedule_events (
  "league_id" BIGINT,
  "event_starttime" TIMESTAMP,
  "event_blockname" VARCHAR,
  "event_state" VARCHAR,
  "event_type" VARCHAR,
  "event_leaguename" VARCHAR,
  "event_leagueslug" VARCHAR,
  "match_id" BIGINT,
  "match_strategy_type" VARCHAR,
  "match_strategy_count" BIGINT,
  "match_flags" VARCHAR,
  "team1_code" VARCHAR,
  "team1_name" VARCHAR,
  "team1_image" VARCHAR,
  "team1_wins" BIGINT,
  "team1_losses" BIGINT,
  "team1_gamewins" BIGINT,
  "team1_outcome" VARCHAR,
  "team2_code" VARCHAR,
  "team2_name" VARCHAR,
  "team2_image" VARCHAR,
  "team2_wins" BIGINT,
  "team2_losses" BIGINT,
  "team2_gamewins" BIGINT,
  "team2_outcome" VARCHAR
);

CREATE TABLE standings (
  "tournament_id" BIGINT,
  "stage_name" VARCHAR,
  "stage_slug" VARCHAR,
  "section_name" VARCHAR,
  "ordinal" BIGINT,
  "team_id" BIGINT,
  "team_slug" VARCHAR,
  "team_code" VARCHAR,
  "team_name" VARCHAR,
  "team_image" VARCHAR,
  "wins" BIGINT,
  "losses" BIGINT
);

CREATE TABLE teams (
  "team_id" BIGINT,
  "team_slug" VARCHAR,
  "team_code" VARCHAR,
  "team_name" VARCHAR,
  "team_image" VARCHAR,
  "team_alternative_image" VARCHAR,
  "home_league_name" VARCHAR,
  "home_league_region" VARCHAR,
  "players_count" BIGINT
);

CREATE TABLE tournaments (
  "id" BIGINT,
  "slug" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "league_id" BIGINT,
  "league_slug" VARCHAR
);