To be able to display leaderboards in a more organised manner in the client, subdivisions that are grouped together to form a division should be easily identifiable.
That probably means adding a new table for subdivisions, which reference the division they belong to.
Scores should only list the subdivision of the player in question.
Then on load these have to be sorted in the correct order to make up the whole league,
probably by keeping indexes on division and subdivision and sorting the subdivisions lexicographically by (division_index, subdivision_index).
To be able to display leaderboards in a more organised manner in the client, subdivisions that are grouped together to form a division should be easily identifiable. That probably means adding a new table for subdivisions, which reference the division they belong to. Scores should only list the subdivision of the player in question.
Then on load these have to be sorted in the correct order to make up the whole league, probably by keeping indexes on
division
andsubdivision
and sorting the subdivisions lexicographically by(division_index, subdivision_index)
.