event 8th, 1/4, 1/2 and final

[mbk28]

Hello,

I'm looking for a DB model that allows me to have a table with the different phases of a competition, it concerns the headings, the links and the model, hence the fact that I post here.

the examples are the beach volleybal,l competition of tennis, ...

So I enter the competitors and if winner, it automatically goes to the next round, so no need to enter

Thanks in advance

[comment]

Not sure what exactly your question is. 

In terms of tables, you would usually have participants and matches, with each match related to 2 participants (home and away). The generation of the matches in each round would be scripted according to the rules of the game (for example, a league is not the same as a tournament).

Here's a previous thread discussing the generation of a "round robin" schedule of matches:
https://fmforums.com/topic/91143-sports-scheduling-problem-combinations-for-fixtures/#comment-418892

 

[mbk28]

Hi,

thanks for your answer, but it's not what I search, I'd like to make the complete table of a tennis (exemple) competition with 16th, 8th finals, quarter semifinal and finals