I'm putting together an app to track scores for a kids sports league,
and I can't figure out how to name the columns in my "games" table.
I'll need a "home team ID" column and an "away team ID" column, but
since they both reference the "teams" table, Rails conventions would
give them both the name "team_id", which is obviously not going to
I've googled, and I've looked in the wiki, but I can't seem to find any
documentation on how to handle a situation like this. How would you
guys do it?
Also, is there a way for the many-to-many table to represent an object
with its own properties rather than being merely a link between two
other objects (e.g. a game has a date)?