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
Post a Comment