search for: favorite_games

...ying to migrate a less-than-ideal schema for a Rails app that helps role-playing gamers (the pencil-and-paper type) connect with each other, at http://findplay.anvilwerks.com (the source is available there too, for the curious). The schema currently uses columns for played_games, wanted_games, and favorite_games in the players table; each of these holds a foreign key to the games table, as you might expect. Code has to be written three times to address these different columns. An obvious solution is a games_players join table with a status column to contain "wanted," "played," or "...