How to create composite primary key in sequelize nodejs?

Question

Node.js

const UserRole = sequelize.define(
  'user_role',
  {
    user_id: {
      type: Sequelize.INTEGER,
      allowNull: false,
      references: {
        model: User,
        key: 'id'
      }
    },
    role_id: {
      type: Sequelize.INTEGER,
      allowNull: false,
      references: {
        model: Role,
        key: 'id'
      }
    }
  },
  {
    identifier: false,
    timestamps: false,
    indexes: [
      {
        primaryKey: true,
        fields: ['user_id', 'role_id']
      }
    ]
  }
);

the meaning is visible in the code, you need to make a primary key in two columns, I did not find such an example in the documentation

Answer 1

Try this https://github.com/sequelize/sequelize/issues/1485...