Naming convention for join tables, in a many to many relationship, in Laravel

Question

I have 3 tables.

The first two tables are Groups and Accounts.

An account can belong to many groups.
A group can have many accounts.
In other words it is a many to many relationship.

Therefore I need a 3rd table, which is a join table

What is the recommended naming convention of this join table in Laravel (or perhaps in general).

Is there any naming conventions?

I was planning to call it "GroupsAccountAssignment".

it should be `account_group` – jaysingkar Aug 22 '16 at 05:21 — jaysingkar, Aug 22 '16 at 05:21

jaysingkar · Accepted Answer · 2016-08-22T05:24:11.960

5

The name of the pivot table should be account_group.

As given in laravel docs

To define this relationship, three database tables are needed: users, roles, and role_user. The role_user table is derived from the alphabetical order of the related model names, and contains the user_id and role_id columns.

Though, you can always overwrite the default naming convention like below:
Account Model:

return $this->belongsToMany('App\Group', 'GroupsAccountAssignment', 'account_id', 'group_id');

edited Aug 22 '16 at 05:24

answered Aug 22 '16 at 05:21

jaysingkar

4,315
1
18
26

So what is the laravel command to make the model and migration. I use `./artisan make:model AccountGroup -m` but this will make a table called `account_groups`. – Yahya Uddin Aug 22 '16 at 05:23
In fact in this case do I have to even make a 3rd model? – Yahya Uddin Aug 22 '16 at 05:24
2

No.. you don't need to create the the 3rd model – jaysingkar Aug 22 '16 at 05:25
2

Laravel will handle the relation without model – jaysingkar Aug 22 '16 at 05:25

Naming convention for join tables, in a many to many relationship, in Laravel

1 Answers1