How to write Relationships correctly?

Question

Laravel

I have three tables, I need to link them together, but I don't know how to do it correctly. User

tables

• id
  
• name
  

Purchases

• id
  
• car_id
  
• subscription_id
  
• type (String - subscription | car )
  
• (Foreign)
  
• user_id
  

Cars

• id
  
• name
  

Subscription

• id
  
• name
  

How to write Relationships so that I get the cars bought by the user?

Is it possible so? $user->purchases->cars? In the user model (hasMany), we get all purchases by user_id, and then separate where type = subscriptionand where type = car.

I wrote (helped by the docs) as follows, but one thing, we do not match by type .

return $this->hasManyThrough(
            'App\Car',
            'App\Purchase',
            'id',
            'id',
            'id', 
            'id'
        );

Give advice, please.

Answer 1

Of course you can.
make a carsPurchase() relay
hasMany(...)->where('type', Purchase::TYPE__CAR)
and that's it. all along the docks.