How to define Multiple foreignKeys in Laravel?

Question

In my Model class; Currently I have defined like;

return $this->belongsTo(related: Site::class, foreignKey:'SiteId', ownerKey:'SiteId');; ----->This works.

But I want to define a combination as Foreign key, eg: CompanyCode+SiteId

My Current and Target model has both columns(ie:CompanyCode+SiteId). That combination will return a single entry.I want to retrieve that in my current model.

How can I do that?

My Site Model is like;

class Site extends Model
{
    protected $table = 'vwSitesPortal';
    protected $primaryKey = 'SiteId';

...

My Current model is like;

class Alarm extends Model
{
 protected $table = 'vwAlarm';
    protected $primaryKey = 'AlarmId';
...
  public function Site()
    {
       return $this->belongsTo(**related**: Site::class,
**foreignKey**:'SiteId', **ownerKey:**'SiteId'
    }

Maybe you just need to create a new column to save combined foreignKey. — Dharma Saputra, Aug 21 '17 at 03:53
@DharmaSaputra I have updated my question. Sorry, I couldn't get your point. Where should I store it? — Ratha, Aug 21 '17 at 03:56
Look at this issue, I think laravel doesn't support composite foreign keys https://github.com/laravel/framework/issues/5355 — Sagar Gautam, Aug 21 '17 at 04:46
This may help you, please visit this question https://stackoverflow.com/questions/31415213/how-i-can-put-composite-keys-in-models-in-laravel-5 — Sagar Gautam, Aug 21 '17 at 04:55
@SagarGautam, So how can I achieve my requirement? Is there any alternative way available? — Ratha, Aug 21 '17 at 04:55
I've just added link of similar question. look at answer with 34 votes, I think that may help you. — Sagar Gautam, Aug 21 '17 at 04:56

score -1 · Answer 1 · answered Aug 21 '17 at 04:32

-1

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 this example

answered Aug 21 '17 at 04:32

Kuldeep Mishra

3,846
1
21
26

Im not using any schema. My models are talking to existing Tables/Views. – Ratha Aug 21 '17 at 04:37
https://stackoverflow.com/questions/31419953/laravel-5-how-to-add-multiple-foreign-key-constraints-to-a-user-on-creation See this example – Kuldeep Mishra Aug 21 '17 at 04:45

How to define Multiple foreignKeys in Laravel?

1 Answers1