soma 변경후

테이블 (7)

champion (Champion)

  • id — bigint(20) — 기본 키 — NOT NULL
  • img_url (imgUrl) — varchar255)

league (League)

  • id — bigint(20) — 기본 키 — NOT NULL
  • name — varchar255)
  • img_url (imgUrl) — varchar(255)
  • modified_at (modifiedAt) — datetime(6)
  • series — longtext
  • latest_series_id (LatestSeriesId) — bigint(20)
  • slug — varchar255)
  • url — varchar255)
  • video_game (videoGame) — longtext

lof_user (User)

  • id (userId) — bigint(20) — 기본 키 — NOT NULL
  • device_id (deviceId) — varchar255)
  • team_list (teamList) — longtext
  • token — varchar255)
  • selected (userSelected) — longtext

match_list (Match)

  • id — bigint(20) — 기본 키 — NOT NULL
  • begin_at — datetime(6)
  • end_at — datetime(6)
  • tournament (torunament) — longtext
  • league_id — bigint(20)
  • original_schedule_at — datetime(6)
  • winner_id — bigint(20)
  • status — varchar255)
  • live — longtext
  • results — longtext
  • games — longtext
  • streams_list — longtext
  • opponents — longtext

match_list (MatchList)

  • idi (id) — bigint(20) — 기본 키 — NOT NULL
  • rescheduled — tinyint(1)
  • winner — longtext
  • winner_type (winnerType) — varchar255)
  • scheduled_at (scheduledAt) — datetime(6)
  • streams_list (streamsList) — longtext
  • forfeit — tinyint(1)
  • official_stream_url (officialStreamUrl) — varchar255)
  • number_of_games (numberOfGames) — bigint(20)
  • opponents — longtext
  • tournament_id (tournamentId) — bigint(20)
  • name — varchar255)
  • league — longtext
  • tournament — longtext
  • begin_at (beginAt) — datetime(6)
  • slug — varchar255)
  • status — varchar255)
  • match_type (matchType) — varchar255)
  • live_embed_url (liveEmbedUrl) — varchar255)
  • winner_id (winnerId) — bigint(20)
  • serie — longtext
  • Field

team_list (Team)

  • id — bigint(20) — 기본 키 — NOT NULL
  • acronym — varchar(255)
  • image_url — varchar255)
  • location — varchar255)
  • name — varchar255)
  • players — longtext

team_ranking (TeamRanking)

  • id (Id) — bigint(20) — 기본 키 — NOT NULL
  • year — varchar255)
  • season — varchar255)
  • leaguel (league) — varchar255)
  • rank — bigint(20)
  • team_name (temaName) — varchar255)
  • series_win (seriesWin) — varchar255)
  • series_lose (seriesLose) — varchar255)
  • series_win_rate (seriesWinRate) — varchar255)
  • games_win (gamesWin) — varchar255)
  • games_lose (gamesLose) — varchar255)
  • games_win_rate (gamesWinRate) — varchar255)
  • points — bigint(20)
  • Field