eternal_data

테이블 (7)

게임전적상세 (gameinfo_data)

  • 게임전적상세ID (gameinfo_id) — Integer — 기본 키 — NOT NULL
  • 게임ID (gameId) — Integer
  • 닉네임 (nickname) — varchar(50)
  • 유저번호 (userNum) — Integer
  • 시즌ID (seasonId) — Integer
  • 매칭모드 (matchingMode) — Integer — NOT NULL
  • 팀매칭모드 (matchingTeamMode) — Integer
  • 게임내순위 (gameRank) — Integer
  • 게임내케릭터Level (characterLevel) — Integer
  • 게임전MMR (mmrBefore) — Integer
  • 게임후MMR (mmrGain) — Integer
  • 게임내플레이어데미지양 (damageToPlayer) — Integer
  • 게임내동물데미지양 (damageToMonster) — Integer
  • 플레이어킬 (playerKill) — Integer
  • 플레이어어시 (playerAssistant) — Integer
  • 동물킬 (monsterKill) — Integer
  • 케릭터번호 (characterNum) — Integer
  • 장착한스킨번호 (skinCode) — Integer
  • 1번장비 (equipment_0) — Integer
  • 2번장비 (equipment_1) — Integer
  • 3번장비 (equipment_2) — Integer
  • 4번장비 (equipment_3) — Integer
  • 5번장비 (equipment_4) — Integer
  • 6번장비 (equipment_5) — Integer
  • 메인특성 (traitFirstCore) — Integer
  • 메인보조특성1 (traitFirstSub_1) — Integer
  • 메인보조특성2 (traitFirstSub_2) — Integer
  • 두번째보조특성1 (traitSecondSub_1) — Integer
  • 두번째보조특성2 (traitSecondSub_2) — Integer

계정정보상세_노말 (maininfo_user_normal)

  • 계정정보상세ID (id) — Integer — 기본 키 — NOT NULL
  • 유저번호 (userNum) — Integer
  • 닉네임 (nickname) — varchar(50)
  • 노말솔로MMR (normal_solo_mmr) — varchar(50)
  • 노말솔로총게임수 (normal_solo_totalgames) — varchar(50)
  • 노말솔로총승 (normal_solo_totalwins) — varchar(50)
  • 노말솔로TOP3 (normal_solo_top3) — varchar(50)
  • 노말솔로평균순위 (normal_solo_averagerank) — varchar(50)
  • 노말솔로평균킬 (normal_solo_averagekills) — varchar(50)
  • 노말솔로평균어시 (normal_solo_averageassistants) — varchar(50)
  • 노말솔로케릭터코드 (normal_solo_charactercode_1) — varchar(50)
  • 노말듀오MMR (normal_duo_mmr) — varchar(50)
  • 노말듀오총게임수 (normal_duo_totalgames) — varchar(50)
  • 노말듀오총승 (normal_duo_totalwins) — varchar(50)
  • 노말듀오TOP3 (normal_duo_top3) — varchar(50)
  • 노말듀오평균순위 (normal_duo_averagerank) — varchar(50)
  • 노말듀오평균킬 (normal_duo_averagekills) — varchar(50)
  • 노말듀오평균어시 (normal_duo_averageassistants) — varchar(50)
  • 노말듀오케릭터코드 (normal_duo_charactercode_1) — varchar(50)
  • 노말스쿼드MMR (normal_squad_mmr) — varchar(50)
  • 노말스쿼드총게임수 (normal_squad_totalgames) — varchar(50)
  • 노말스쿼드총승 (normal_squad_totalwins) — varchar(50)
  • 노말스쿼드TOP3 (normal_squad_top3) — varchar(50)
  • 노말스쿼드평균순위 (normal_squad_averagerank) — varchar(50)
  • 노말스쿼드평균킬 (normal_squad_averagekills) — varchar(50)
  • 노말스쿼드평균어시 (normal_squad_averageassistants) — varchar(50)
  • 노말스쿼드케릭터코드 (normal_squad_charactercode_1) — varchar(50)
  • 업데이트날짜 (date) — date

계정정보상세_시즌4 (maininfo_user_season4)

  • 계정정보상세ID (id) — Integer — 기본 키 — NOT NULL
  • 유저번호 (userNum) — Integer
  • 닉네임 (nickname) — varchar(50)
  • 랭크솔로MMR (rank_solo_mmr) — varchar(50)
  • 랭크솔로총게임수 (rank_solo_totalgames) — varchar(50)
  • 랭크솔로총승 (rank_solo_totalwins) — varchar(50)
  • 랭크솔로TOP3 (rank_solo_top3) — varchar(50)
  • 랭크솔로평균순위 (rank_solo_averagerank) — varchar(50)
  • 랭크솔로평균킬 (rank_solo_averagekills) — varchar(50)
  • 랭크솔로평균어시 (rank_solo_averageassistants) — varchar(50)
  • 랭크솔로케릭터코드 (rank_solo_charactercode_1) — varchar(50)
  • 랭크듀오MMR (rank_duo_mmr) — varchar(50)
  • 랭크듀오총게임수 (rank_duo_totalgames) — varchar(50)
  • 랭크듀오총승 (rank_duo_totalwins) — varchar(50)
  • 랭크듀오TOP3 (rank_duo_top3) — varchar(50)
  • 랭크듀오평균순위 (rank_duo_averagerank) — varchar(50)
  • 랭크듀오평균킬 (rank_duo_averagekills) — varchar(50)
  • 랭크듀오평균어시 (rank_duo_averageassistants) — varchar(50)
  • 랭크듀오케릭터코드 (rank_duo_charactercode_1) — varchar(50)
  • 랭크스쿼드MMR (rank_squad_mmr) — varchar(50)
  • 랭크스쿼드총게임수 (rank_squad_totalgames) — varchar(50)
  • 랭크스쿼드총승 (rank_squad_totalwins) — varchar(50)
  • 랭크스쿼드TOP3 (rank_squad_top3) — varchar(50)
  • 랭크스쿼드평균순위 (rank_squad_averagerank) — varchar(50)
  • 랭크스쿼드평균킬 (rank_squad_averagekills) — varchar(50)
  • 랭크스쿼드평균어시 (rank_squad_averageassistants) — varchar(50)
  • 랭크스쿼드케릭터코드 (rank_squad_charactercode_1) — varchar(50)
  • 업데이트날짜 (date) — date

계정정보상세_시즌5 (maininfo_user_season5)

  • 계정정보상세ID (id) — Integer — 기본 키 — NOT NULL
  • 유저번호 (userNum) — Integer
  • 닉네임 (nickname) — varchar(50)
  • 랭크솔로MMR (rank_solo_mmr) — varchar(50)
  • 랭크솔로총게임수 (rank_solo_totalgames) — varchar(50)
  • 랭크솔로총승 (rank_solo_totalwins) — varchar(50)
  • 랭크솔로TOP3 (rank_solo_top3) — varchar(50)
  • 랭크솔로평균순위 (rank_solo_averagerank) — varchar(50)
  • 랭크솔로평균킬 (rank_solo_averagekills) — varchar(50)
  • 랭크솔로평균어시 (rank_solo_averageassistants) — varchar(50)
  • 랭크솔로케릭터코드 (rank_solo_charactercode_1) — varchar(50)
  • 랭크듀오MMR (rank_duo_mmr) — varchar(50)
  • 랭크듀오총게임수 (rank_duo_totalgames) — varchar(50)
  • 랭크듀오총승 (rank_duo_totalwins) — varchar(50)
  • 랭크듀오TOP3 (rank_duo_top3) — varchar(50)
  • 랭크듀오평균순위 (rank_duo_averagerank) — varchar(50)
  • 랭크듀오평균킬 (rank_duo_averagekills) — varchar(50)
  • 랭크듀오평균어시 (rank_duo_averageassistants) — varchar(50)
  • 랭크듀오케릭터코드 (rank_duo_charactercode_1) — varchar(50)
  • 랭크스쿼드MMR (rank_squad_mmr) — varchar(50)
  • 랭크스쿼드총게임수 (rank_squad_totalgames) — varchar(50)
  • 랭크스쿼드총승 (rank_squad_totalwins) — varchar(50)
  • 랭크스쿼드TOP3 (rank_squad_top3) — varchar(50)
  • 랭크스쿼드평균순위 (rank_squad_averagerank) — varchar(50)
  • 랭크스쿼드평균킬 (rank_squad_averagekills) — varchar(50)
  • 랭크스쿼드평균어시 (rank_squad_averageassistants) — varchar(50)
  • 랭크스쿼드케릭터코드 (rank_squad_charactercode_1) — varchar(50)
  • 업데이트날짜 (date) — date

듀오랭크순위 (ranking_duo)

  • 순위 (rank) — Integer — 기본 키 — NOT NULL
  • 닉네임 (nickname) — varchar(50) — NOT NULL
  • MMR (mmr) — varchar(50) — NOT NULL
  • 날짜 (date) — date — NOT NULL

솔로랭크순위 (ranking_solo)

  • 순위 (rank) — Integer — 기본 키 — NOT NULL
  • 닉네임 (nickname) — varchar(50) — NOT NULL
  • MMR (mmr) — varchar(50) — NOT NULL
  • 날짜 (date) — date — NOT NULL

스쿼드랭크순위 (ranking_squad)

  • 순위 (rank) — Integer — 기본 키 — NOT NULL
  • 닉네임 (nickname) — varchar(50) — NOT NULL
  • MMR (mmr) — varchar(50) — NOT NULL
  • 날짜 (date) — date — NOT NULL