arena_team
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 | INT | UNSIGNED | PRI | NO | 0 | Unique | |
| name | VARCHAR(24) | SIGNED | NO | ||||
| captainGuid | INT | UNSIGNED | NO | 0 | |||
| type | TINYINT | UNSIGNED | NO | 0 | |||
| rating | SMALLINT | UNSIGNED | NO | 0 | |||
| seasonGames | SMALLINT | UNSIGNED | NO | 0 | |||
| seasonWins | SMALLINT | UNSIGNED | NO | 0 | |||
| weekGames | SMALLINT | UNSIGNED | NO | 0 | |||
| weekWins | SMALLINT | UNSIGNED | NO | 0 | |||
| rank | INT | UNSIGNED | NO | 0 | |||
| BackgroundColor | INT | UNSIGNED | NO | 0 | |||
| emblemStyle | TINYINT | UNSIGNED | NO | 0 | |||
| emblemColor | INT | UNSIGNED | NO | 0 | |||
| borderStyle | TINYINT | UNSIGNED | NO | 0 | |||
| borderColor | INT | UNSIGNED | NO | 0 |
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.
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).