Intermediate relationship between two Laravel tables

Question

Good evening I have the following tables in my application.

Doacao 
-id
-nome
-doador_id

Instituicao
-id
-nome

Doador
-id
-nome

I need to carry out the relationship, in a third table among the Donations and Institutions who are interested in the donation, which in my view would be in the following architecture.

id doacao_id  instituicao_id
1   20          5
2   20          6
3   25          7

PS: This table will only be for the donor (owner of the donation) see which institutions are interested, and he selects only one, other records of the same donation will be deleted...

how should I make this relationship in the Latin?

Answer 1

Kasio, it’s actually quite simple to do the relationships in the Aravel, so let’s go.

The relationship that you want and that makes all logical sense to your problem is Many to Many

N:M -> Many To Many (Muitos para Muitos)

It would look like :D

---

Model - Institution

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Instituicao extends Model
{
    /**
     * Definindo que instituição possui várias doações.
     */
    public function doacoes()
    {
       return $this->belongsToMany('App\Doacoes', 'doacao_instituicao', 'instituicao_id', 'doacao_id');
    }
}

Model - Donations

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Doacao extends Model
{
    /**
     * Definindo que doação possui várias instituições.
     */
    public function instituicoes()
    {
       return $this->belongsToMany('App\instituicoes', 'doacao_instituicao', 'doacao_id', 'instituicao_id');
    }
}

Ready now you have finished the relationship Many to Many :D

---

In his Controller you can use the following way to access the relationship

$instituicao = App\Instituicao::find(1);

foreach ($instituicao->doacoes as $doacao) {
    //
}

Or

$doacoes = App\Instituicao::find(1)->doacoes()->orderBy('nome')->get();
//Lembrando que você pode fazer o inverso também :D

---

Remarks

The Laravel followed a standard of naming tables and foreign key for your relationships.

To define this relationship, three database tables are required: instituicoes, doacoes, e doacao_instituicao. To doacao_instituicao table is derived from the alphabetical order of the related template names and contains the columns doacao_id and instituicao_id.