From Emmanuel (in OGM-481):

Now that's a bit trickier since the user has provided the metadata for the key column name. But I think you are right.

On a general note, I think we can see it as two strategies:

• be natural and lean but do not differentiate between values and fk / id in the document schema
• be explicit and add the column names which will express the notion of fk / id

In the end, it's probably on of these opinion things and we will need to offer support for both via the option system. I agree that by default, the lean mode is preferable as it feels more natural.

BTW all this work must also be done on all document supported backend (ie CouchDB).