php - How to define Multiple foreignKeys in Laravel? -


in model class; have defined like;

return $this->belongsto(related: site::class, foreignkey:'siteid', ownerkey:'siteid');; ----->this works.

but want define combination foreign key, eg: companycode+siteid

my current , target model has both columns(ie:companycode+siteid). combination return single entry.i want retrieve in current model.

how can that?

my site model like;

class site extends model {     protected $table = 'vwsitesportal';     protected $primarykey = 'siteid'; 

...

my current model like;

class alarm extends model {  protected $table = 'vwalarm';     protected $primarykey = 'alarmid'; ...   public function site()     {        return $this->belongsto(**related**: site::class, **foreignkey**:'siteid', **ownerkey:**'siteid'     } 

schema::create('favorites', function (blueprint $table) {  $table->integer('lecture_id')->unsigned(); $table->integer('user_id')->unsigned(); $table->timestamps();  $table->primary(['lecture_id', 'user_id']);  $table->foreign('lecture_id')       ->references('id')->on('lectures')       ->ondelete('cascade');  $table->foreign('user_id')       ->references('id')->on('users')       ->ondelete('cascade'); 

});

see example 

Comments

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -