logs_battleground Table¶
Per-participant battleground log rows written once, when a battleground finishes.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
time |
timestamp | YES | current_timestamp() | ||
bgid |
int(11) | YES | |||
bgtype |
int(11) | YES | |||
bgteamcount |
int(11) | YES | |||
bgduration |
int(11) | YES | |||
playerGuid |
int(11) | YES | |||
team |
int(11) | YES | |||
deaths |
int(11) | YES | |||
honorBonus |
int(11) | YES | |||
honorableKills |
int(11) | YES |
Field Breakdown¶
time- Row timestamp (insert time).bgid- Battleground instance id of the finished match.bgtype- Battleground type id (AV/WSG/AB; matchesbattleground_template.id).bgteamcount- Player count on this player's team when the match ended.bgduration- Match duration seconds.playerGuid- Participant character guid (fromcharacters.guid).team- Player's team inside the BG.deaths- Deaths by this player in the match.honorBonus- Bonus honour granted.honorableKills- Honourable kills credited.