Use two foreign key and two owner key

Question

In laravel Eloquent: Relationships I want to use two foreign key and two owner key.

How can I do this?

public function user()
{
    return $this->belongsTo(
        User::class,
        'foreign_key1',
        'owner_key1',
        'foreign_key2',
        'owner_key2'
    );
}

Please share what are you trying to achieve with this. – linktoahref Oct 13 '21 at 04:35 — linktoahref, Oct 13 '21 at 04:35
Providing more context will be useful. – Eugene van der Merwe Oct 16 '21 at 08:22 — Eugene van der Merwe, Oct 16 '21 at 08:22

score 0 · Answer 1 · answered Oct 13 '21 at 04:38

The work around is you can create 2 relationship methods to specify each User's relationship, if this is what you really want:

public function firstUser()
{
    return $this->belongsTo(User::class, 'foreign_key1', 'owner_key1');
}

public function secondUser()
{
    return $this->belongsTo(User::class, 'foreign_key2', 'owner_key2');
}

I don't think there is any other way to solve this.

If this answer is not good for you, consider adding more explanation to the question like what linktoahref said.

score 0 · Answer 2 · answered Oct 16 '21 at 08:21

0

I don't think Eloquent supports composite keys, see this post.

In that post they mention this package https://github.com/topclaudy/compoships that provides support for it.

answered Oct 16 '21 at 08:21

Eugene van der Merwe

4,390
1
35
48

Use two foreign key and two owner key

2 Answers2