league_season

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id MEDIUMINT UNSIGNED 8 √ null
league_score_journal.league_season_id league_score_journal_ibfk_1 R
league_score_journal.login_id Implied Constraint R
league_season_division.league_season_id league_season_division_ibfk_1 R
league_season_score.league_season_id Implied Constraint R
league_season_score.login_id Implied Constraint R
league_id SMALLINT UNSIGNED 5 null
league.id league_season_ibfk_1 R
leaderboard_id SMALLINT UNSIGNED 5 null
leaderboard.id league_season_ibfk_2 R
placement_games INT 10 10
placement_games_returning_player INT 10 3
season_number INT 10 null
name_key VARCHAR 255 null
start_date DATETIME 19 null
end_date DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
leaderboard_id Performance Asc leaderboard_id
league_id Performance Asc league_id
start_date Performance Asc/Asc/Asc start_date + end_date + league_id

Relationships

Close relationships within degrees of separation