CAP CDS Association 1-N mapped to SQL DDL .hdbtable N-N association statement

[Pedro]

Hi, CAP developers!

I'm trying to understand why the cds conversion of an one-to-many association defined at .cds is resulting in an .hdbtable with a many-to-many statement.

I'm following the example at the documentation

Anyway, I deployed the artifacts to the HANA Cloud HDI Container and the Create Statement obtained at Database Explorer was:

I noticed that even if I modify manually the Association statement at Authors .hdbtable to "ONE TO MANY" and deploy to the HANA Cloud HDI I get exactly the same result of create statement above.

Here my main doubts:

1. I'm doing the Association 'one to many' correctly at the cds?

2. The Create Statement is the same at the 2 cases (1-N and N-N). This means that the .hdbtable statements about cardinality in association are noneffective?

I would appreciate any advices.

Regards