How to name a pivot table in many-to-many in Laravel

The default naming convention of Laravel many-to-many pivot table is xxxxx_yyyyy, where "xxxxx" and "yyyyy" are names of related tables, in singular form, in alphabetical order.

Example: pivot table between users and locations should be called location_user.

The wrong names would be location_users (because it's not singular) or user_location (because "user" and "location" is not in alphabetical order).

If you follow those naming conventions, you can define the belongsToMany relation without extra parameters:

app/Models/User.php

public function locations()
{
    return $this->belongsToMany(Location::class);
}

If you name this table differently, you need to pass its name as a second parameter:

public function locations()
{
    return $this->belongsToMany(Location::class, 'users_locations');
}
avatar
Pablo

Why the following does not work?

Table 1: businesses

Table 2: business_tags

Pivot Table: business_business_tag

avatar
Povilas Korop

Probably Laravel misinterprets some repeating word differenly, not sure.

You can specify that table as the second parameter in your pivot function in the Model.

Or, if I were you, I would rename tables differently, it's quite confusing.

avatar
You can use Markdown
avatar
You can use Markdown

Recent New Courses