0

I have a problem with connecting database models in Laravel. 

Tables: users, companies, company_details

Now, I want to connect them, like, each user can have multiple companies, and every company has its company_details.

users: user_id, user_username...  

companies: company_id, company_....  

company_details: company_detail_id, ..., company_detail_company_id

[Pivot table] = company_user: id, user_id, company_id

My User.php Model looks like this: 

public function companies()
{
    return $this->belongsToMany('App\Models\Company');
}

How can I get the values from company_details table?

Mark Davidson
  • 5,503
  • 5
  • 35
  • 54
sk4yb3n
  • 244
  • 1
  • 4
  • 9

1 Answers1

0

Does your Company Model have a details() method?

pebbo
  • 581
  • 5
  • 15
  • Yes: `public function companyDetails() { return $this->hasOne('App\Models\CompanyDetails', 'company_detail_company_id'); }` @pebbo – sk4yb3n Jan 18 '16 at 11:58
  • You can help from this answer about pivot tables and query http://stackoverflow.com/questions/23336145/laravel-how-to-use-multiple-pivot-table-relationships?answertab=votes#tab-top – Kabir Hossain Apr 23 '16 at 04:52