At the moment the default is non-mandatory when you are adding an FK to an entity.

Understandable when the entity is already existing perhaps, but NOT when it's a new entity.

It should be mandatory by default because this is less errorprone. Developers need to explicit set it to non-mandatory if needed,

If it's default non-mandatory, and it should be mandatory you end up having some serious fixes to do.