Home / Questions / 31678
Accepted
Juan Pablo B
Asked: 2020-11-04 18:42:03 +0800 CST 2020-11-04 18:42:03 +0800 CST

pivot table with 3 models in laravel

  • 772

I have 3 tables: Draw, player and round, and in turn a common table for all three having as attributes: id, id_draw, id_player, id_round.

What I don't know is how to build this type of relationships and how to insert data. Since in a many-to-many relationship with two tables it would be: draw->player()->attach(...);

With this type of relationship of 3 tables, I don't know how to insert data and build the belongsToMany relationship.

Relations:

enter image description here

The ternary relationship is given by draw - PlayerATP - Round being the resulting table Matches

laravel-5

1 Answers

  1. Best Answer

    Considering that Eloquent does not support composite primary keys , I recommend that you approach your database structure in a different way to save yourself some headaches.

    Assuming (I don't know if this will be the case, but it can be adapted) that a round has several rolls (draws) and one roll belongs to a player, you can set up some relationships:

    player 1 - N draw (player hasMany draws, draw belongsTo player)

    round 1 - N draw (round hasMany draws, draw belongsTo round)

    Provide more information about the relationships you want to make so I can show you a more complex example.

    UPDATE

    It's tennis... - a Draw has many players and many rounds. - A player will be in many draws and many rounds. - A round will be in many draws and will have many players.

    draw M - N player (draw player belongsToMany , draw player belongsToMany )

    draw M - round N (draw belongsToMany round, draw belongsToMany round )

    player M - round N (player belongsToMany round, round player belongsToMany )

    There you have three pivot table relationships between them, but more information is needed, since you're using a ternary but haven't provided enough detail to know what you're trying to do.

    • 2