...
0 = HORDE
1 = ALLIANCE
2 = NOONE
leaderguid
The GUID of the character who created the guild. See characters.guid
EmblemStyle
The emblem style of the guild tabard.
EmblemColor
The emblem color of the guild tabard.
BorderStyle
The border style of the guild tabard.
BorderColor
The border color of the guild tabard.
BackgroundColor
The background color of the guild tabard.
info
The text message that appears in the Guild Information box.
motd
The text that appears in the Message Of The Day box.
createdate
The date when the guild was created.
BankMoney
...
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.