teamkills

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
teamkiller MEDIUMINT UNSIGNED 8 null
login.id teamkiller_fk R

login of the player who performed the teamkill
victim MEDIUMINT UNSIGNED 8 null
login.id victim_fk R

login of the player who got teamkilled and reported the tk
game_id INT UNSIGNED 10 null
game_stats.id teamkills_game_stats_id_fk R

game-id where teamkill was performed
gametime MEDIUMINT UNSIGNED 8 null

time of game in seconds when tk was performed
reported_at DATETIME 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
game_id Performance Asc game_id
teamkiller_fk Performance Asc teamkiller
victim_fk Performance Asc victim

Relationships

Close relationships within degrees of separation