3 Table Relation

Hi, i want to set relation between 3 tables with models in one method (hasManyThrough etc.) my tables;

-hotels
	-id

-certificate
	-id
	-name

-certificate_list
	-certificate
	-hotel

JohnBraun

6 years ago

Level 33

It looks to me like you need a Many to Many relationship which relates a certificate to a hotel instead of a hasManyThrough relationship.

https://laravel.com/docs/7.x/eloquent-relationships#many-to-many

The role_user pivot table in the example would be the certificate_list table in your case, having a hotel_id and certificate_id.

mkarakaya

6 years ago

Best Answer

Level 3

 return $this->belongsToMany(
            'App\Certificate',
            'App\CertificateList',
            'hotel',
            'certificate'
        );

Worked for me.

Please or to participate in this conversation.