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