[SD-182] - Villages Refactor

Orestis Athanasopoulos Antoniourequested to merge
feat/SD-182-village-refactor into main

Closes SD-182

Verify existing data in dev DB before deploying

  • Village entity: The MR implements a new village table for managing villages related to the competition. This way the BE becomes the single source of truth for village related data.

  • Village service and controller: The MR introduces a service and the corresponding endpoints for village CRUD operations

  • Data migration: It regroups and migrates the data scattered in differents parts of the FE and inserts them in the the corresponding tables that are created based on the existing team tracks for competitions up to 2024.

  • team and award updates: It adds a villageUUID FK to the team and award tables and drops the track and village columns respectively. It also updates and recreates the views and the services previously using these columns

BE of !1258

Edited by Orestis Athanasopoulos Antoniou

Merge request reports