Laravel Relationship Between Tables

Question

I have generate the following database table and need to create model form them.

Er Diagram

Creating a model seems to be an easy task, but I am confused how should i define the relationship between two tables. In users table RoleId is foreign key. My question is where and how should I define the relationship (in User model or Role model). Should I use hasOne, hasMany, or belongsTo

nesl247 · Accepted Answer · 2014-08-27 03:00:20Z

2

In your User model

public function roles()
{
    return $this->hasOne('Role', 'id', 'RoleId');
}

In your Role model

public function users()
{
    return $this->belongsTo('User', 'RoleId', 'id);
}

edited Aug 27, 2014 at 3:00

answered Aug 27, 2014 at 2:50

nesl247

1063 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

rishal Over a year ago

do i need to use both?

nesl247 Over a year ago

No you don't. The only reason you might want to add the users() function to your Role model is so that you can see what users have a specific role.

rishal Over a year ago

thanks. One more thing that confuses me is, one user can have only one role but you are using hasMany, is there any explanation for that or is my ER-Diagram wrong?

nesl247 Over a year ago

I corrected my answer. I did write the wrong function in there, should have been hasOne.

Pedro Henrique A. Oliveira Over a year ago

@rishal A hasOne in User and belongsTo in Role is a sign of a one-to-one relationship, but your ER diagram seems to indicate a one-to-many relationship (a USER associates to ONE ROLE, a ROLE associates to MANY USER). My guess is that you want to say that a user has one role. To do that, you can simply have a hasOne in User and nothing in Role.

Collectives™ on Stack Overflow

Laravel Relationship Between Tables

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related