Many To Many Relationship 3 Models Laravel [5.6]

Question

I've 3 models in my app Company, User, Role

The business rule is like this:

• User is Role at Company
• Elon is CEO at SpaceX
• Cindy is Manager at SpaceX
• Elon is CEO at Tesla

I'm thinking about creating a 4th model, something like Employees.

But I don't have any idea how to create a migration and define relationship between these models.

Answer 1

I would also go for 4 tables as

• users
• roles
• companies
• user_role_company

First three tables will save the regular data without holding any foreign key from other tables, 4 table will related these tables to each other with following attributes

• user_id
• role_id
• company_id

Now your owing side tables which are users , roles and companies will define a relationship with user_role_company as hasMany and user_role_company will define inverse relation with these 3 tables as belongsTo

class User extends Model{

    public function userRoleCompany()
    {
        return $this->hasMany('App\UserRoleCompany', 'user_id','id');
    }

}

class Role extends Model{

    public function userRoleCompany()
    {
        return $this->hasMany('App\UserRoleCompany', 'role_id','id');
    }

}

class Company extends Model{

    public function userRoleCompany()
    {
        return $this->hasMany('App\UserRoleCompany', 'company_id','id');
    }

}


class UserRoleCompany extends Model{

    public function user()
    {
        return $this->belongsTo('App\User', 'user_id');
    }

    public function role()
    {
        return $this->belongsTo('App\Role', 'role_id');
    }

    public function company()
    {
        return $this->belongsTo('App\Company', 'company_id');
    }

}