What relation to apply for 4 tables?

Question

Laravel

There are 4 tables:
Homes (id name)
Users (id name)
Home_Users (user_id home_id)
Phones (user_id home_id phone)

A user can have multiple homes
A user can have only one phone for one home

User's home via belongsToMany
belongsToMany(Home: :class, 'users_homes')
Everything is ok. I bind $user->homes()->attach($home);

But how to bind the phone now and which method to use?

Answer 1

make the user have the relationship "phones" hasMany, then:

$user->phones()->save(new Phone(['home_id' => $home->id, 'phone' => '[phone]']));

or like this:

Phone::create(['user_id' => $user->id, 'home_id' => $home->id, 'phone' => '[phone]']);

The only thing I don't know is whether this will work with a composite key. In any case, I advise you to make a regular id key for phones, because eloquent does not support composite keys (out of the box and without crutches)