league_season_division_subdivision

312 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
league_score_journal.subdivision_id_after league_score_journal_ibfk_3 R
league_score_journal.subdivision_id_before league_score_journal_ibfk_2 R
league_season_score.subdivision_id league_season_score_ibfk_1 R
league_season_division_id INT UNSIGNED 10 null
league_season_division.id league_season_division_subdivision_ibfk_1 R
subdivision_index SMALLINT UNSIGNED 5 null
name_key VARCHAR 255 null
description_key VARCHAR 255 null

The subdivision’s i18n flavor text key
min_rating FLOAT 12 null
max_rating FLOAT 12 null
highest_score INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
league_season_division_id Performance Asc league_season_division_id

Relationships

Close relationships within degrees of separation