...
Each league/tournament/etc allocates sequences of game numbers to each schedule
Game numbers are only unique within each schedule and may be reused in other schedules
Game numbers often have a prefix and suffix to identify which league and category
A schedule with groups/flights will have a sequences per group (flight 1 will have 1000-1999, flight 2 will have 2000-2999, etc within the same U13 schedule)
Draft games can Games should have their numbers re- sorted based on the date/time at time prior to of publishing, but and published games cannot be re-sorted
Renumbering is a manual action. Automatically doing so may cause confusion as people use numbers as a reference while scheduling, so it’s usually only done in preparation for publishingDraft games do not use sequences
Existing behaviour
Currently we have a (published) games table and a drafts table, where drafts essentially act as isolated containers of a schedule.
...
Creating a game, regardless of whether it’s published directly or a draft game, will pull the next sequence number available. Drafts will require sequences to be configured in the schedule as draft games cannot rely on the game ID sequence
Draft games will use temporary IDs as identifiers until they are published. There is no need to renumber these while they’re a draft as they will be numbered in the correct order upon publishing. This also avoids a situation where there’s a publicly perceived gap in the schedule numbering because that gap is used by draft games. This also avoids needing to edit a sequence after draft games have been deleted and need to be recreated.
If the next sequenced number already exists for whatever reason (e.g., that number was manually provided when creating a game or in case of an error updating the sequence), the next available sequence number will be produced until a non-conflicting number is available.
If a numbering sequence exists in the schedule, the user is not given the option to manually enter or change game numbers in the schedule as they will be automated. This will prevent potential user errors.
When a game is deleted, creating a gap in the sequence, that number in the sequence will not be reused, despite the leaving a gap in numbering.Assuming a sequence of U13L1000-1999, it is possible for a user to create 100 draft games, which will use sequence numbers 1000-1099, then before publishing, a user may create a published game in the same scheduling, which will use the next number in the sequence, 1100. Publishing the pending draft games would retain their original 1000-1099 range of game numbers. Publicly, a gap in the game numbers would appear as 1000-1099 hasn’t been published yet, but this is not a concern
If the applicable sequence is exhausted, then games cannot be created and drafts cannot be published until this is resolved.
Groups
If a schedule has no groups, it is limited to one sequence for the schedule. If a schedule has groups, it is limited to one group per sequence.
...