Implement Basic Data Structure

[onkeld]

Data we need to collect:

• [x] Tournament:
  • [x] Start Date
  • [x] End Date
  • [x] Registered Teams
• [x] Team:
  • [x] Team Name
  • [x] Club the team belongs to
  • [x] Contact Address for the Team
  • [x] Primary Colour
  • [x] Secondary Colour
  • [x] Team Leader
  • [x] Players
• [x] Players
  • [x] Name
  • [x] Contact Info (?)
  • [x] Player Number

Per-Tournament:

• [ ] Games
  • [x] Team 1
  • [x] Team 2
  • [x] Score Team 1
  • [x] Score Team 2
  • [ ] Cards Team 1
  • [ ] Cards Team 2
• [ ] Leaderboard
  • [ ] Points
  • [ ] score totals
  • [ ] score difference
• [ ] Tournament Schedule (automatically generated)
  • [ ] Round
  • [ ] Game Start Time
  • [ ] Game Duration
  • [ ] Referee
  • [ ] automatically selected from other teams with enough time to their own next game

Considerations for the Database Layout:

• Players can, but don't have to be users in the django app.
• Team Leaders should be users in the Django app.
  • Ability to change Team info themselves
• We will have to split some database tables into multiples:
  • e.g.: Teams should have a table storing core data (Team Name, contact info, maybe colours etc.) permanently, while a second table stores per-tournament info such as scores, cards etc. Same goes for players.

[onkeld]

For the first installment of the code, we do not need to store information about cards on the game. In order to get the tournament schedule program running, we only need scores for the games. The leaderboard points will be dynamically calculated from the game scores and not stored on the database.

Information about scorers, cards, etc. might be included later to actually fill in game report sheets properly, show scorer ranking and other fancy stuff. In order to determine a leaderboard, this information is not needed.

[onkeld]

Since Leaderboard is calculated and not actually stored data and the tournament schedule depends on tournament modes and also relies mainly on calculated instead of fixed (in the database) information, the basic data structure is complete in this state.