Laravel composite primary keys relationship

Question

I'm trying to call this hasOne function, but I have 2 primary keys, how can I do it?

    public function user_ratings()
    {
        return $this->hasOne('App\User_rating', 'id_user', 'id');
    }

User_rating table

Schema::create('user_rating', function (Blueprint $table) {
            $table->integer('id_user')->unsigned(); //Increments es unsigned por defecto
            $table->integer('id_item')->unsigned();
            $table->integer('rating');
            $table->text('comment');
            $table->timestamps();

            $table->primary(['id_user', 'id_item']);

            $table->foreign('id_user')->references('id')->on('users')
                ->onUpdate('restrict')
                ->onDelete('cascade');

            $table->foreign('id_item')->references('id')->on('products')
                ->onUpdate('restrict')
                ->onDelete('cascade');
        });

This is my database

see https://stackoverflow.com/a/31415545/4468423 – Erich Jun 11 '19 at 19:01 — Erich, Jun 11 '19 at 19:01
@erich That's from 2015, now they're supported – Tiberius Jun 11 '19 at 19:04 — Tiberius, Jun 11 '19 at 19:04

score 0 · Answer 1 · answered Jun 11 '19 at 18:59

0

    public function user_ratings()
    {
        return $this->hasOne('App\User_rating', 'id_user', 'id');
    }

The second param is the foreign key and the third is the local key.

answered Jun 11 '19 at 18:59

Fabián Montero Rodríguez

488
2
7

Erich · Answer 2 · 2019-06-11T19:12:28.080

0

While the Laravel framework supports creating database tables with composite primary keys, Eloquent (the ORM) doesn't support them, and probably never will.

edited Jun 11 '19 at 19:12

answered Jun 11 '19 at 19:06

Erich

2,408
18
40

Laravel composite primary keys relationship

2 Answers2