naming tables in many to many relationships laravel

php laravel laravel-5 eloquent laravel-migrations
Pedram marandi picture Pedram marandi · Jan 20, 2016 · Viewed 30.9k times · Source

I concerned about auto naming tables in many-to-many Laravel relationship.

for example: 

Schema::create('feature_product', function (Blueprint $table) {}

when change the table name to:

Schema::create('product_feature', function (Blueprint $table) {}

I have an error in my relationship.

What's the matter with product_feature?

Answer

patricus picture patricus · Jan 20, 2016

Laravel's naming convention for pivot tables is snake_cased model names in alphabetical order separated by an underscore. So, if one model is Feature, and the other model is Product, the pivot table will be feature_product.

You are free to use any table name you want (such as product_feature), but you will then need to specify the name of the pivot table in the relationship. This is done using the second parameter to the belongsToMany() function.

// in Product model
public function features()
{
    return $this->belongsToMany('App\Feature', 'product_feature');
}

// in Feature model
public function products()
{
    return $this->belongsToMany('App\Product', 'product_feature');
}

You can read more about many to many relationships in the docs.

Related questions

Laravel Checking If a Record Exists

I am new to Laravel. Please excuse the newbie question but how do I find if a record exists? $user = User::where('email', '=', Input::get('email')); What can I do here to see if $user has a record?

Read More
Laravel Check If Related Model Exists

I have an Eloquent model which has a related model: public function option() { return $this->hasOne('RepairOption', 'repair_item_id'); } public function setOptionArrayAttribute($values) { $this->option->update($values); } When I create the model, it does not necessarily …

Read More
Eloquent ORM laravel 5 Get Array of ids

I'm using Eloquent ORM laravel 5.1, i want to return an array of ids greater than 0, My model called test. I have tried : $test=test::select('id')->where('id' ,'>' ,0)->get()->toarray(); It …

Read More