Why aren't there properties relating to foreign keys fields in the entities?

I understand you solved your issue, then? Can you please share the solution for other users?