game_stats

9997 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
coop_leaderboard.gameuid coop_leaderboard_ibfk_1 R
game_player_stats.gameId game_id_fk R
game_review.game_id game_review_ibfk_2 R
game_reviews_summary.game_id game_reviews_summary_game R
matchmaker_queue_game.game_stats_id matchmaker_queue_game_ibfk_2 R
moderation_report.game_id game_id_of_moderation_report R
teamkills.game_id teamkills_game_stats_id_fk R
startTime TIMESTAMP 19 current_timestamp()
endTime TIMESTAMP 19 √ null
replay_ticks INT UNSIGNED 10 √ null

The total number of ticks present in the replay. The SCFA tick rate is 10 ticks/second
gameType enum('0', '1', '2', '3') 1 null
gameMod TINYINT UNSIGNED 3 null
game_featuredMods.id game_stats_game_featuredMods_id_fk R
host MEDIUMINT UNSIGNED 8 null
login.id fk_game_stats_host R
mapId MEDIUMINT UNSIGNED 8 √ null
map_version.id mapid_fkey R
gameName VARCHAR 128 null
validity TINYINT UNSIGNED 3 null
game_validity.id game_stats_game_validity_id_fk R
replay_available BIT 1 0

If false, no replay is available for download. The replay server needs to set this field to true once replay is written to disk.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_game_stats_host Performance Asc host
game_stats_endTime_index Performance Asc endTime
game_stats_gameMod_index Performance Asc gameMod
game_stats_gameName_index Performance Asc gameName
game_stats_gameType_index Performance Asc gameType
game_stats_mapId_index Performance Asc mapId
game_stats_startTime_index Performance Asc startTime
game_stats_validity_index Performance Asc validity
startTime Performance Asc startTime
validity_gameMod_endTime Performance Asc/Asc/Asc validity + gameMod + endTime

Relationships

Close relationships within degrees of separation