Laravel belongsToMany non standard pivot column

Question

I was trying to setup a BelongsToMany relationship where one of the columns is not an ID reference, but rather a string reference.

return $this->belongsToMany('User', 'chats_users', 'chat_id', 'user_email');

Is it possible to do this?

please check this http://stackoverflow.com/questions/24391759/laravel-belongstomany-relationship-defining-local-key-on-both-tables — Pardeep Pathania, Apr 20 '16 at 12:23
If by `id` reference you mean primary key. Then make the column to primary key. — Utkarsh Vishnoi, Apr 20 '16 at 13:19

score 2 · Accepted Answer · edited May 23 '17 at 12:24

2

This should work as long as the string reference is a primary key of the parent table although it's not recommended. Be sure to check this explanation on using strings as primary keys

return $this->belongsToMany('User', 'chats_users', 'chat_id', 'user_email');

edited May 23 '17 at 12:24

Community

answered Apr 20 '16 at 12:41

Mushangi Derrick

1 Answers1