blob: 32eda0f7c1dd87887ca6918ad1f0dbf662a9b66d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
# arena\_team
[<-Back-to:Characters](database-characters.md)
**The \`arena\_team\` table**
This table holds the main ArenaTeam information. All created teams or all teams in the process of being created have a record in this table.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------------|-------------|------------|-----|------|---------|--------|---------|
| [arenaTeamId][1] | int(10) | unsigned | PRI | NO | | Unique | |
| [name][2] | varchar(24) | | | NO | | | |
| [captainGuid][3] | int(10) | unsigned | | NO | | | |
| [type][4] | tinyint(3) | unsigned | | NO | | | |
| [rating][5] | smallint(5) | unsigned | | NO | | | |
| [seasonGames][6] | smallint(5) | unsigned | | NO | | | |
| [seasonWins][7] | smallint(5) | unsigned | | NO | | | |
| [weekGames][8] | smallint(5) | unsigned | | NO | | | |
| [weekWins][9] | smallint(5) | unsigned | | NO | | | |
| [rank][10] | int(10) | unsigned | | NO | | | |
| [BackgroundColor][11] | int(10) | unsigned | | NO | | | |
| [EmblemStyle][12] | tinyint(3) | unsigned | | NO | | | |
| [EmblemColor][13] | int(10) | unsigned | | NO | | | |
| [BorderStyle][14] | tinyint(3) | unsigned | | NO | | | |
| [BorderColor][15] | int(10) | unsigned | | NO | | | |
[1]: #arenateamid
[2]: #name
[3]: #captainguid
[4]: #type
[5]: #rating
[6]: #seasongames
[7]: #seasonwins
[8]: #weekgames
[9]: #weekwins
[10]: #rank
[11]: #backgroundcolor
[12]: #emblemstyle
[13]: #emblemcolor
[14]: #borderstyle
[15]: #bordercolor
**Description of the fields**
### arenaTeamId
The ID of the ArenaTeam. This number is unique to each team and is the main method to identify a team.1
### name
Name of the Arena team
### captainGuid
The GUID of the character who created the ArenaTeam. See [characters.guid](2129969.html#characters(table)-guid)
### type
Defines the ArenaType:
- 2 – 2vs2 Team
- 3 – 3vs3 Team
- 5 – 5vs5 Team
### rating
Rating of arena team.
### seasonGames
Number of games played this **season**.
### seasonWins
Number of games won this **season**.
### weekGames
Number of games played this **week**.
### weekWins
Number of games won this **week**.
### rank
Rank of teams in the competition by rating.
### BackgroundColor
Team-tabard BackgroundColor (same as guild-tabard)
### EmblemStyle
Team-tabard Emblem (same as guild-tabard)
### EmblemColor
Team-tabard EmblemColor (same as guild-tabard)
### BorderStyle
Team-tabard Bordertype (same as guild-tabard)
### BorderColor
Team-tabard BorderColor (same as guild-tabard)
|
