fetching foreign key data in sequelize
Generic : TableB.belongsTo(models.TableA, { foreignKey: 'someID', targetKey: 'notTableAID' } ); TableA.hasOne(TableB, { sourceKey: 'someNonPrimaryKeyColumnOnTheSOurceModel', foreignKey: 'matchingColumnOnTheTargetModel' }); Example : // associations assetAuditSubmissionsModel.hasOne(assetInfoModel, { foreignKey: "assetSerialNumber", sourceKey: "assetSerialNumber", }); assetInfoModel.belongsTo(assetAuditSubmissionsModel, { foreignKey: "assetSerialNumber", targetKey: "assetSerialNumber", });