Relationship error and method not found

Question

I am studying Laravel and I have difficulties to realize the relationship of an associative table that connects 3 tables of domain. example of my model:

The problem is that I can’t map from my command to other entities. Just follow my code:

Model da Comanda:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Comanda extends Model
{

    public function mesas(){
        return $this->belongsToMany('App\Mesa');
    }
    public function garcom(){
        return $this->hasOne('App\Garcom');
    }


}

Model of the Waiter:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Garcom extends Model
{
    protected $fillable = ['nome', 'setor'];
}

Bureau model:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Mesa extends Model
{
    protected $fillable = ['setor'];

    public function garcoms(){
        return $this->belongsToMany('App\Garcom')->withtimestamps();
    }
    public function produtos(){
        return $this->belongsToMany('App\Produto')->withtimestamps();
    }
}

Product Model:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Produto extends Model
{
    protected $fillable = ['nome', 'valor'];
}

To test all this, I used the Artisan Tinker and typed the following:

$comanda = App\Comanda::first()
$comanda->mesas()

But I had the following error in return:

  BadMethodCallException with message 'Call to undefined method Illuminate\Database\Query\Builder::mesas()'

At this point I do not know why the object commands does not find the method table, nor if this mapping I did is correct. You could help me with that ?

Answer 1

In your Command model you must indicate your field id in the second relationship parameter as below:

public function mesas(){
   return $this->belongsToMany('App\Mesa', 'mesa_id');
}

This should work

--

Edit 2: The undefinied method error I would try without the '()' parentheses on tables()