Multiple primary keys in table using adonis migration / nodejs

Question

I have this table:

BookUnit
-------------------
id PK
unit PK
sequence PK
book_id FK

So, i can have records with data:

id: 1
unit: 1
sequence: 1

id: 2
unit: 1
sequence: 2

but i can't have more than one repetead:

id: 3
unit: 1
sequence: 2

So, i need to create a composed primary key with id,sequence and unit.

I try this way:

class BookUnitSchema extends Schema {
  up () {
    this.create('book_unit', (table) => {
      table.increments()
      table.integer('book_id').references('id').inTable('books').notNullable()
      table.integer('unit').notNullable().primary()
      table.integer('sequence').notNullable().primary()
      table.string('description')
      table.integer('qt_question')
      table.boolean('status').defaultTo(false)
      table.integer('user_id').references('id').inTable('users')
      table.timestamps()
    })
  }

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

But i'm getting:

error: multiple primary keys for table "book_unit" are not allowed

I don't find in docs example with more than one primary key...

You can't create multiple primary keys, but you can create multiple foreign keys — Rajeev Radhakrishnan, Nov 07 '19 at 08:55

Amit Kadivar · Answer 1 · 2019-11-05T12:03:54.663

5

you also use primary

table.primary(['unit','sequence'])

it's work for me
More information visit knex.js

edited Nov 05 '19 at 12:03

answered Nov 05 '19 at 11:55

Amit Kadivar

798
4
12

score 2 · Answer 2 · answered Nov 05 '19 at 11:23

2

It's simple, i fixed using:

table.unique(['unit', 'sequence'])

answered Nov 05 '19 at 11:23

bla

995
3
11
44

Multiple primary keys in table using adonis migration / nodejs

2 Answers2