I am trying to set up an app where I track games between teams and the
winners… So I have one “teams” table with info like the name and
coach and whatever with one row per team.
I then have a “game” table with the home, away, and winners. But each
of these fields is a “team” really. How can I set up the model so that
game.home and game.away make sense and both refer to the same “team”
object. I want to be able to do things like “if game.winner ==
game.home”. Is that clear?
I will put the relavent pieces that I have been trying below so you can
laugh at my noobness. (and understand what I have)
t.column :home_id, :integer
t.column :away_id, :integer
t.column :winner_id, :integer
t.column :name, :string
t.column :coach, :string
Game model: (I dont know what this should look like at all but this is
Can anyone help me understand how this should look and why?