...
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
bigint | unsigned | PRI | NO |
|
|
| |
winnercharacter_factionguid | tinyint |
| NO |
|
|
| |
bracketscore_killing_idblows | tinyint | unsigned |
| NO |
|
| |
tinyint | unsigned |
| NO |
|
| ||
datetime |
|
| NO |
|
| ||
datetime | NO | ||||||
datetime | NO | ||||||
datetime | NO | ||||||
datetime | NO | ||||||
datetime | NO | ||||||
datetime | NO | ||||||
datetime | NO | ||||||
datetime | NO |
Description of the fields
battleground_id
An unique value which identifies a BattleGround.
winner_faction
The faction which won the BattleGround:
0 = HORDE
1 = ALLIANCE
2 = NOONE
bracket_id
Identifies the bracket level range:
1 = 10-19
2 = 20-29
3 = 30-39
4 = 40-49
5 = 50-59
6 = 60-69
7 = 70-79
8 = 80
type
The BattleGround type:
1 = Alterac Valley
2 = Warsong Gulch
3 = Arathi Basin
7 = Eye of the Storm
9 = Strand of the Ancients
30 = Isle of Conquest
date
Date and time of BattleGround ending.Link to pvpstats_battlegrounds.id
character_guid
Link to characters.guid
score_*
All scores which are in common between all BattleGrounds
attr_*
All scores which are not in common between all BattleGrounds. This fields changes their mean according to pvpstats_battlegrounds.type