search for: played_gam

Hi folks, I''m trying 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,...