AzerothCore
Posts (Latest 10 updated) :
Read all

arena_team

<-Back-to:Characters

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(10)

unsigned

PRI

NO

0

Unique

 

name

varchar(24)

signed

 

NO

NULL

 

 

captainGuid

int(10)

unsigned

 

NO

0

 

 

type

tinyint(3)

unsigned

 

NO

0

 

 

rating

smallint(5)

unsigned

 

NO

0

 

 

seasonGames

smallint(5)

unsigned

 

NO

0

 

 

seasonWins

smallint(5)

unsigned

 

NO

0

 

 

weekGames

smallint(5)

unsigned

 

NO

0

 

 

weekWins

smallint(5)

unsigned

 

NO

0

 

 

rank

int(10)

unsigned

 

NO

0

 

 

BackgroundColor

int(10)

unsigned

 

NO

0

 

 

EmblemStyle

tinyint(3)

unsigned

 

NO

0

 

 

EmblemColor

int(10)

unsigned

 

NO

0

 

 

BorderStyle

tinyint(3)

unsigned

 

NO

0

 

 

BorderColor

int(10)

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.1

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)