PUBG_WEAPON

Tables (5)

match (Untitled2)

  • matchid (경기아이디) — varchar — Primary key — NOT NULL
  • createdAt (게임생성시간) — date
  • game_mode (게임모드(solo, duo ...)) — varchar
  • shard (플렛폼) — varchar
  • map_id (맵 아이디) — varchar
  • matchtype (경쟁전 or not) — varchar
  • assetid (Field) — varchar

participant (Untitled5)

  • participant_id (Key) — varchar — Primary key — NOT NULL
  • rosterId (roster_id) — varchar — Foreign key → roster.rosterId — NOT NULL
  • DBNOs (die but not out(기절횟수)) — int
  • assists (Field3) — int
  • damageDefault (피해 입힌 총량) — int
  • deathtype (죽음 당한 종류) — varchar
  • killplace (kill이 발생한 장소) — int
  • name (게임명(nickname)) — varchar
  • revives (다시 살아난 횟수) — int
  • total_distance (유저 이동거리) — float
  • timeSurvived (생존 시간) — float
  • player_id (유저고유명)

player (Untitled)

  • matchid (경기아이디) — varchar — Foreign key → match.matchid — NOT NULL
  • nicknaem (게임명) — varchar
  • shard (플렛폼) — varchar
  • playerid (유저고유명) — varchar

roster (Untitled3)

  • rosterId (roster_id) — varchar — Primary key — NOT NULL
  • matchid (경기아이디) — varchar — Foreign key → match.matchid — NOT NULL
  • rank (순위) — int
  • team_id (게임 내의 팀 번호) — int
  • won (승리유무) — bool
  • shard (플렛폼) — varchar

telemetry (Untitled4)

  • matchid (경기아이디) — varchar — Foreign key → match.matchid — NOT NULL
  • info_style (kill, dbno, finish) — float
  • damage_causer_name (가해 총기) — varchar
  • additional_info (가해 총기의 부착물) — text
  • damage_reason (Field) — varchar
  • damage_type_category (가해 종류) — varchar
  • distance (유저 이동 거리) — flloat
  • victim_weapon (피해자 소유 총기) — varchar
  • victim_weapon_additional_info (피해자 소유 총기의 부착물) — text
  • location_x (플레이어 x좌표) — float
  • location_y (플에이어y좌표) — float
  • Field2