Table relation problems


I need to know if it’s possible to do something like this:

The table game_guesses has 2 keys for team: home_key and guest_key. The problem is that a normal relation would be team has_many/has_one game_guess but that is not the case.

I just want to see the team information using or (or other information of the Team object)

Is there a way to solve it? I tried to change the model, but eventually it would lead to a situation like this one.