leaderboard

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id SMALLINT UNSIGNED 5 null
leaderboard.initializer_id leaderboard_ibfk_1 R
leaderboard_rating.leaderboard_id leaderboard_rating_ibfk_2 R
leaderboard_rating_journal.leaderboard_id leaderboard_rating_journal_ibfk_2 R
matchmaker_queue.leaderboard_id matchmaker_queue_ibfk_2 R
updates_balancetesting.id Implied Constraint R
updates_blackops.id Implied Constraint R
updates_civilians.id Implied Constraint R
updates_claustrophobia.id Implied Constraint R
updates_coop.id Implied Constraint R
updates_diamond.id Implied Constraint R
updates_equilibrium.id Implied Constraint R
updates_faf.id Implied Constraint R
updates_fafbeta.id Implied Constraint R
updates_fafdevelop.id Implied Constraint R
updates_gw.id Implied Constraint R
updates_koth.id Implied Constraint R
updates_labwars.id Implied Constraint R
updates_murderparty.id Implied Constraint R
updates_nomads.id Implied Constraint R
updates_phantomx.id Implied Constraint R
updates_tutorials.id Implied Constraint R
updates_vanilla.id Implied Constraint R
updates_xtremewars.id Implied Constraint R

This table is managed by Flyway. Do not manually edit records.
technical_name VARCHAR 255 null
name_key VARCHAR 255 null
description_key VARCHAR 255 null

The leaderboard’s i18n description key
create_time TIMESTAMP 19 current_timestamp()
update_time TIMESTAMP 19 current_timestamp()
initializer_id SMALLINT UNSIGNED 5 √ null
leaderboard.id leaderboard_ibfk_1 R

Initialize rating based on existing entries from another leaderboard.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
initializer_id Performance Asc initializer_id
technical_name Must be unique Asc technical_name

Relationships

Close relationships within degrees of separation