blob: 1857397d24038caf950b6609e4c52cf6a402f389 (
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 | UNSIGNED | PRI | NO | 0 | Unique | |
| [name][2] | VARCHAR(24) | SIGNED | | NO | | | |
| [captainGuid][3] | INT | UNSIGNED | | NO | 0 | | |
| [type][4] | TINYINT | UNSIGNED | | NO | 0 | | |
| [rating][5] | SMALLINT | UNSIGNED | | NO | 0 | | |
| [seasonGames][6] | SMALLINT | UNSIGNED | | NO | 0 | | |
| [seasonWins][7] | SMALLINT | UNSIGNED | | NO | 0 | | |
| [weekGames][8] | SMALLINT | UNSIGNED | | NO | 0 | | |
| [weekWins][9] | SMALLINT | UNSIGNED | | NO | 0 | | |
| [rank][10] | INT | UNSIGNED | | NO | 0 | | |
| [BackgroundColor][11] | INT | UNSIGNED | | NO | 0 | | |
| [emblemStyle][12] | TINYINT | UNSIGNED | | NO | 0 | | |
| [emblemColor][13] | INT | UNSIGNED | | NO | 0 | | |
| [borderStyle][14] | TINYINT | UNSIGNED | | NO | 0 | | |
| [borderColor][15] | INT | UNSIGNED | | NO | 0 | | |
[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.
### name
Name of the Arena team.
### captainGuid
The GUID of the character who created the ArenaTeam. See [characters.guid](characters#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).
|
