Affects Version/s: None
Fix Version/s: None
Sample schema attached.
Now, keeping attached schema in mind.
We have core tables that lots of other tables refer via foreign keys to them, like user, company, etc.
We need to explicitly define foreign keys (like user_id) "definitely same as" User.id on each table. By design, this seems unnecessary, and has load on refactoring processes, ie. type change on User.id.
Doctrine is already parsing foreign relations from schema, It can use parent table field definition (User.id) in refering table fields (user_id) and on the schema user_id can be defined as: