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
The ID of the ArenaTeam. This number is unique to each team and is the main method to identify a team.
Name of the Arena team.
The GUID of the character who created the ArenaTeam. See characters.guid.
Defines the ArenaType:
Rating of arena team.
Number of games played this season.
Number of games won this season.
Number of games played this week.
Number of games won this week.
Rank of teams in the competition by rating.
Team-tabard BackgroundColor (same as guild-tabard).
Team-tabard Emblem (same as guild-tabard).
Team-tabard emblemColor (same as guild-tabard).
Team-tabard Bordertype (same as guild-tabard).
Team-tabard borderColor (same as guild-tabard).