Navigation discovery fails for pivot table

[mgerzabek]

Hi @27pchrisl,

I have a Premise model that is connected via a pivot table to a Customer model. On that model I have three relations:

#[LodataRelationship]
public function customers(): BelongsToMany {
    return $this->belongsToMany(Customer::class)
        ->using(CustomerPremise::class)
        ->withPivot(['valid_from', 'valid_to']);
}

#[LodataRelationship]
public function actual_customer(): BelongsToMany {
    return $this->customers()->wherePivot('valid_to', '=', '9999-12-31');
}

#[LodataRelationship]
public function customer_premises(): HasMany {
    return $this->hasMany(CustomerPremise::class);
}

The first two relationships are transformed into NavigationPropertyBindings:

<EntitySet Name="Customers" EntityType="io.pragmatiqu.Customer">
  <NavigationPropertyBinding Path="premises" Target="Premises"/>
  <NavigationPropertyBinding Path="actual_premises" Target="Premises"/>
  …
</>
…

The inverse relationships are on the Customer models side and have the same effect in $metadata.

However for the customer_premises() relationship, where direct access to the pivot table should be realized, is not transformed into a NavigationPropertyBinding.

The relationships on the pivot model CustomerPremise are:

#[LodataRelationship]
public function customer(): BelongsTo {
    return $this->belongsTo(Customer::class);
}

#[LodataRelationship]
public function premise(): BelongsTo {
    return $this->belongsTo(Premise::class);
}

When I try to access the binding, e.g. Premises(113)?$expand=customer_premises($expand=customer) I get the expanded customer but not the pivot.

Is this desired behaviour? Am I missing something?

How can I access properties on the pivot table?

Any hints welcomed.

[mgerzabek]

The reason was that I did have no id column in the model.

[mgerzabek]

After adding the id the relationship is detected and the NavigationPropertyBinding is created.