当 Sequelize 创建关联字段时,我有点困惑。
我已经使用sequelize-cli 创建了我的迁移。这生成了迁移和模型文件。然后在模型文件中我填充了我的关联。然后跑了npx sequelize-cli db:migrate
.
这将创建表,但不会创建模型中定义的关联所需的外键。
例如:
迁移问题:
"use strict";
module.exports = {
up: (queryInterface, Sequelize) => {
return queryInterface.createTable("questions", {
id: {
allowNull: false,
autoIncrement: true,
primaryKey: true,
type: Sequelize.INTEGER
},
category: {
type: Sequelize.INTEGER
},
question: {
type: Sequelize.STRING
},
createdAt: {
allowNull: false,
defaultValue: new Date(),
type: Sequelize.DATE
},
updatedAt: {
allowNull: false,
defaultValue: new Date(),
type: Sequelize.DATE
}
});
},
down: (queryInterface, Sequelize) => {
return queryInterface.dropTable("questions");
}
};
模型问题:
"use strict";
module.exports = (sequelize, DataTypes) => {
const questions = sequelize.define(
"questions",
{
question: DataTypes.STRING,
weight: DateTypes.INTEGER
},
{}
);
questions.associate = function(models) {
// associations can be defined here
models.questions.hasOne(models.question_categories);
models.questions.hasMany(models.question_answers);
};
return questions;
};