mysql - 使用 Sequelize 添加外键约束

Question

我正在与 Sequelize 协会合作。我见过很多添加外键的方法，我的做法正确吗？

我想做的是从我的父表(users，“user_id”)向我的 profile_personals 表添加外键约束

const Sequelize = require('sequelize')
const db = require('../database/db.js')
const Users = require('../model/User.js')

module.exports = db.sequelize.define(
    'profile_personals',
    {   
        id: {
            type: Sequelize.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },

        biography: {
            type: Sequelize.STRING
        },
        fk_user_id: {
            type: Sequelize.INTEGER,

            references: {
                // This is a reference to another model
                model: Users,
                // This is the column name of the referenced model
                key: 'user_id'
            }
        }
    },
    {
        timestamps: false
    }
)

Answer 1

你尝试过关联方法吗？我认为 HasMany 或 HasOne 方法会起作用。

http://docs.sequelizejs.com/class/lib/associations/has-many.js~HasMany.html

user.hasMany(db.profile_personals, {foreignKey: 'user_id'})