Issue: the matchId in the fixtures is unique but really should be a compound key from category + tournament + "match number in that competion". Not doing so complicates the logic and requires pretty complex rules for importing, exporting and reporting.
All queries should include the category/competition. Otherwise, match numbers will required and additional code to track or will need to be increased by, say, 100 for me and 200 for women.
This requirement should also take the unique tournament id into consideration for all queries
Acceptance criteria:
gcp-builder is refactored to use the numbers it's given
All ids are numbered and there is no upper limit (currently after 100 it could cause problems)
v_match_results view is refactored not to substring the output
Issue: the matchId in the fixtures is unique but really should be a compound key from category + tournament + "match number in that competion". Not doing so complicates the logic and requires pretty complex rules for importing, exporting and reporting.
All queries should include the category/competition. Otherwise, match numbers will required and additional code to track or will need to be increased by, say, 100 for me and 200 for women.
This requirement should also take the unique tournament id into consideration for all queries
Acceptance criteria: