reaz's avatar

reaz wrote a reply+100 XP

5mos ago

Do you mind sharing what sports is this relates to? In general knowledge, it seems like player participate in a game, which belongs to a tournament. Can player be part of a tournament with out being part of a game? Second layer is , can a player participate in a game without being part of a club? If they cant, then again players belong to club, club participates in game, which is belongs to a tournament.

reaz's avatar

reaz liked a comment+100 XP

5mos ago

Can a club/player really participate in a tournament? Or in fact they can participate in a game which is a part of a tournament?

Can a player participate in a game/tournament by himself, without a club?

Maybe your real relations are:

Player -> belongsTo -> Club  
Club   -> hasMany   -> Player

Club -> belongsToMany -> Game  
Game -> belongsToMany -> Club

Game       -> belongsTo -> Tournament  
Tournament -> hasMany   -> Game

And Player is related to a Tournament/Game not directly but through several other relations.