从Sequelize中的关联创建复合主键

const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

const Model1 = sequelize.define('model1', {
  column1: {
    type: Sequelize.STRING,
    primaryKey: true
  },
  column2: {
    type: Sequelize.STRING,
    primaryKey: true
  },
  // other columns
});

const Model2 = sequelize.define('model2', {
  // columns
});

// Define the association
Model1.hasMany(Model2, { foreignKey: ['column1', 'column2'] });

Model1.hasMany(Model2, { foreignKey: ['column1', 'column2'] });

Model1.create({
  column1: 'value1',
  column2: 'value2',
  // other column values
}).then((model1) => {
  model1.createModel2({
    // Model2 column values
  });
});