Model relationship for Composite Keys ?

[siddiquipro]

Package version

4.1.0

Node.js and npm version

node - 8.11.1
npm - 6.4.1

Sample Code (to reproduce the issue)

All these 3 fields have their master tables. I need to have a relationship matching the two PK fields from other models. I am not able to get it. Any help? Is it even possible?

[RomainLanz]

Hey @mohammadsiddiqui! 👋

Composite keys aren't supported for the moment by Lucid.
@benjamincanac was working on a PR to make it works so we will see how it goes.

#382

[benjamincanac]

Hi @mohammadsiddiqui,

Why do you need a primary key matching two PKs?

You could just references them and add a unique constraint on both of those fields:

'use strict'

const Schema = use('Schema')

class AssessmentModuleSchema extends Schema {
  up () {
    this.create('assessment_modules', (table) => {
      table.increments()
      table.integer('assessmentid').unsigned().references('id').inTable('assessments').notNullable()
      table.integer('surveyid').unsigned().references('id').inTable('surveys').notNullable()
      table.integer('ratingid').unsigned().references('id').inTable('ratings')
      table.unique(['assessmentid', 'surveyid'])
      table.timestamps()
    })
  }

  down () {
    this.drop('assessment_modules')
  }
}

module.exports = AssessmentModuleSchema