Tournament and team missing fields

[ShiroUsagi-san]

Somes fields and constrains are missing:

• max players in a team
• max teams in a tournament
• cashprize of a tournament

[ShiroUsagi-san]

We also need to define how is handled the captain of a team. This special player can change their team mates, kick them for instance

[Lymkwi]

On it chief

[Lymkwi]

• What would be a reasonable upper limit to the number of players in a team? (I'd say 48 just because that's the maximum amount of people we can fit on one of our switches)
• Isn't the maximum number of teams dependent on the game? Would the upper limit be, for example, the number of players we get in singleplayer games like TM2020 (I don't remember how many there were last year, something like 64 people)
• Cashprize field can go with Missing tournament features #31 . Can I just making an Int or should we also detail other cash prizes (1st wins this, second wins this, and so on)

[ShiroUsagi-san]

• the upper limite should be configurable by admins
• You're right, the upper limit is determined by the game type
• I think the cashprize repartion is better and the total can be computed with ease

[Lymkwi]

• I'm not sure you can modify a SQL constraint through a form admins can fill in. The best I can do is try and force a registration to fail if there are too many, dynamically at save time, but that's gonna be dirty. A DB hard limit would be easier
• Should I also set a fixed number of teams per tournament, or try and handle it at runtime? What happens
• In both cases, what happens if we lower the limit below the current number of teams? Should I prevent that from being possible?
• How should the cashprize be formatted? I can make it an ordered list of ints, I just do not know what representation makes the most sense

[ShiroUsagi-san]

• the admin have to set the max number of players and teams in a tournament
• that's a good question, we need to refer to the tournament team(but seems an impossible case )
• your idea sounds great to me

[Lugrim]

While working on previous DB migration, I stumbled on some possibly missing fields :

• The participant type (team vs single player) (not needed)
• Minimal number of players to consider a team as valid (computed at runtime)
• Registration open & closing datetimes
• Price related fields (Online price, onsite price)
• Locked tournaments / events ?
• Maximum manager count

[Lymkwi]

I think once #97 is good we can close this.

EDIT: almost, we would still be missing public/private tournaments, and manager counts

[KwikKill]

Closing this as this is quite old and only one thing's missing (#162 will take over)