I'm looking around since few days on how should I build my database to support full flexible tournaments. Let me explain my specs.
As a user I want to :
- Create a tournament
- Let other users register
- Generate brackets with a random limit of players or teams
- Assign result
- Handle winner / loser bracket
I believe that I am not the first one trying to achieve that kind of work and that many people are facing the same issue.
So, if anyone has some documentation, tutorial or some other knowledge to share on that matter, it would be great!
Edit: I am having trouble to find the right database config to handle Tournaments.
Tournament table - id - name - player_limit - start_date - end_date - etc. PlayerBracket table - id - tournament_id - player_id Player table - id
Starting from this, i don't know how i should make the tournament rounds or teams within the database in a proper way.
It seems like i need the right db architecture to articulate the front actions and i feel just lost about it right now...