无法使用semelize添加外键约束

Question

尝试使用quelize创建一个待办事项列表，但我总是遇到这个错误： “也无法使用semelize添加外键约束”，即使在Stackoverflow中寻找一些线索，Somone也可以提供帮助？

！

module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable('Todos', {
      id: {
        allowNull: false,
        autoIncrement: true,
        primaryKey: true,
        type: Sequelize.INTEGER,
      },
      description: {
        type: Sequelize.STRING,
        allowNull: false,
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE,
      },
      status_id: {
        type: Sequelize.INTEGER,
        allowNull: false,
        references: {
          model: 'Statuses',
          key: 'id',
        },
      },
    });
  },
  async down(queryInterface) {
    await queryInterface.dropTable('Todos');
  },
};

如果有人有任何想法，

module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable('Statuses', {
      id: {
        allowNull: false,
        autoIncrement: true,
        primaryKey: true,
        type: Sequelize.INTEGER,
      },
      name: {
        type: Sequelize.STRING,
        allowNull: false,
      },
    });
  },
  async down(queryInterface) {
    await queryInterface.dropTable('Statuses');
  },
};

Relationship in models

// Status model
  Status.associate = (models) => {
    Status.belongsTo(models.Todo, { foreignKey: 'status_id', as: 'todo' });
  };

// Todo model
  Todo.associate = (models) => {
    Todo.hasMany(models.Status, { foreignKey: 'status_id', as: 'statuses' });
  };

我真的很感激 谢谢

Answer 1

当“ todos”表具有“ status_id”时，

它必须“属于“状态”表。

或者，您应该将“ todo_id”保存在“状态”表中。

  // Status model
  Status.associate = (models) => {
    Status.hasMany(models.Todo, { foreignKey: 'status_id', as: 'todos' });
  };

  // Todo model
  Todo.associate = (models) => {
    Todo.belongsTo(models.Status, { foreignKey: 'status_id', as: 'status' });
  };