Rails: How to implement multiple FK's from same table

[ChrisHasenpflug]

How would I implement in Rails, a model that uses two foreign keys from the same table?

I am setting up a sports schedule database. I have a team's table that has a PK of id, and then there will be a game's table with two references to the team table, a home team and an away team. Since there are two columns, naming them the conventional way, team_id, won't work.

What do I need to do to implement this in Rails both on the DB side and within my Games model?

[sweatje]

I have not personally done this, but I think you can do something like:

class Game < ActiveRecord::Base
belongs_to :home,
    :class_name => "Team",
    :foreign_key => "home_team_id"
belongs_to :away,
    :class_name => "Team",
    :foreign_key => "away_team_id"
end