javascript - 在 Express-Sequelize MySql 中创建 2 个模型之间的关联

Question

免责声明:我很陌生

Node/Express/Sequelize

问题:

1. 我是否需要将visitors.js 导入到visitorsInfo.js 以便我可以在两者之间创建关联？

2. 如果没有，我如何将visitorsInfo_id 设置为来自visitors.js 列visitors_id 的外键？

片段:
...模型/visitors.js

'use strict'

module.exports = ( sequelize , type ) => {
    return sequelize.define( 'visitors' , {
        visitor_id: {
            type: type.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },
        web_status: {
            type: type.BOOLEAN
        },
        digital_status: {
            type: type.BOOLEAN
        },
        hosting_status: {
            type: type.BOOLEAN
        },
        training_status: {
            type: type.BOOLEAN
        },
    })
}

.../model/visitors_info.js

'use strict'

module.exports = ( sequelize , type) => {
    return sequelize.define( 'user_info' , {
        visitorsInfo_id: {
            type: type.INTEGER,
            /* 
                How to set up foreign key...?
            */
        },
        firstname: {
            type: type.STRING
        },
        lastname: {
            type: type.STRING
        },
        company: {
            type: type.STRING
        },
        contact_info: {
            type: type.INTEGER
        }
    })
}

Answer 1

无需将visitors.js 导入到visitorsInfo.js

基于 Sequelize 的文档，在文件访问者信息.js

'use strict'
module.exports = ( sequelize , type) => {
var user_info = sequelize.define( 'user_info' , {
    visitorsInfo_id: {
        type: type.INTEGER,
    },
    firstname: {
        type: type.STRING
    },
    lastname: {
        type: type.STRING
    },
    company: {
        type: type.STRING
    },
    contact_info: {
        type: type.INTEGER
    }
});

   user_info.associate = function (models) {
     // associations can be defined here
     user_info.belongsTo(models.visitors, {
        as: 'visitors',
        foreignKey: 'visitorsInfo_id',
        targetKey: 'visitor_id'
     });
    }
    return user_info
}