====== arena_team 表 ====== ---- [[数据库:characters数据库:首页|<-返回:Characters 数据库]] 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. **表结构** ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ |[[#arenaTeamId|arenaTeamId]]|INT|UNSIGNED|PRI|NO|0|Unique| | |[[#name|name]]|VARCHAR(24)|SIGNED| |NO| | | | |[[#captainGuid|captainGuid]]|INT|UNSIGNED| |NO|0| | | |[[#type|type]]|TINYINT|UNSIGNED| |NO|0| | | |[[#rating|rating]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#seasonGames|seasonGames]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#seasonWins|seasonWins]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#weekGames|weekGames]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#weekWins|weekWins]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#rank|rank]]|INT|UNSIGNED| |NO|0| | | |[[#BackgroundColor|BackgroundColor]]|INT|UNSIGNED| |NO|0| | | |[[#emblemStyle|emblemStyle]]|TINYINT|UNSIGNED| |NO|0| | | |[[#emblemColor|emblemColor]]|INT|UNSIGNED| |NO|0| | | |[[#borderStyle|borderStyle]]|TINYINT|UNSIGNED| |NO|0| | | |[[#borderColor|borderColor]]|INT|UNSIGNED| |NO|0| | | ===== 字段说明 ===== ---- ==== 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).