mercredi 21 septembre 2016

Laravel Eloquent and 3 table relationship

I'm looking for some help in working out how to setup the Eloquent relationships for my application.

I have created migrations for three tables.

| users     |   | items     |   | user_items |
+-----------+   +-----------+   +------------+
| id        |   | id        |   | id         |
| username  |   | name      |   | user_id    |
                                | item_id    | 
                                | qty        | 

I have setup an unique index on the user_items table, limiting 1 user id to 1 item id, but with a qty column. I want to setup Eloquent so that I have two models, User and Item. Where I could say:

$item = $user->items()->first();
$name = $item->name;
$qty  = $item->qty;

The problem is I'm trying to figure out if I need a 3rd model, UserItem or not.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire