Displaying 1 result from an estimated 1 matches for "contest_question".
2006 Jun 09
0
Calculations based on multiple tables
...all the contest_entries from a particular contest, and
then grab all the appropriate contest_ratings associated with the songs and
contest. The end result is an average score for each song involved in each
contest.
I made an ERD of my table structure which can be found at:
http://antrover.com/erd/contest_question.jpg
Here''s my model structure:
------------------------
class Contest < ActiveRecord::Base
has_many :contest_entries
has_many :songs, :through => :contest_entries
end
class ContestEntry < ActiveRecord::Base
belongs_to :song
belongs_to :contest
has_many :contest_ratings...