different primary key other than 'id'

Asked Nov 20 '17 at 08:33

Active Nov 20 '17 at 08:44

Viewed 539 times

I have the following User and Order table.

User

Order

And I have defined one to many relationship in a User model as,

protected $primaryKey = 'user_id';
public function orders() {
    return $this->hasMany(Order::class, 'user_id');
}

Now I am trying to get the orders based on a particular user whose user_id is '1'.

$orders = App\User::find(1)->orders;

I have two modifications here.

I have added protected $primaryKey = 'user_id'; in User Model.
I had to add 'user_id' parameter as $this->hasMany(Order::class, 'user_id')

Now the question is that I want to know if the above modifications are correct to reflect the proper relationship and get the proper data as mentioned in the following code.

$orders = App\User::find(1)->orders;

P.S. I have just started to explore the Laravel.

edited Nov 20 '17 at 08:44

asked Nov 20 '17 at 08:33

Dushyant Joshi

3,672
3
28
52

2

Take a look [here](https://stackoverflow.com/questions/34582535/laravel-5-2-use-a-string-as-a-custom-primary-key-for-eloquent-table-becomes-0) for more info. – Andrei Nov 20 '17 at 08:46
when you run that do you get the correct result? if not then no. – lagbox Nov 20 '17 at 09:09
1

Usually when you change the primaryKey to what ever you want , after that all the queries with primaryKey or relations will reference with new primaryKey that you have set . – Alireza Amrollahi Nov 20 '17 at 09:39
@lagbox, yes I do get correct results. – Dushyant Joshi Nov 20 '17 at 11:21
@AlirezaAmrollahi, Thanks – Dushyant Joshi Nov 20 '17 at 11:22
@DushyantJoshi if you could vote up the comment , would be appreciated – Alireza Amrollahi Nov 20 '17 at 11:36

different primary key other than 'id'

0 Answers0