ansaurus

Question

Structuring question and answer database in RoR

Answer 1

A:

surveys have questions. questions have answers

Survey
  has_many :questions
  has_many :answers, :through => :questions
end

Question
  belongs_to :survey
  has_many :answers
end

Answer
  belongs_to :question
end

Jed Schneider 2010-08-30 19:44:10

So then it's OK to have a table just with just one column? (or 4, really, but only one used practically)

Reactor5 2010-08-30 19:50:06

Given that you don't opt out, tables usually get id, created_at, modified_at column. belongs_to means the table gets association_id column. Apart from that if that were me, Survey would have a name, question text and answer text minimally. All in all much more than just one column table.

Hugo 2010-08-30 20:22:00

you dont define the columns in the activerecord model classes. you define the relationships. in order to hook up the above ar classes, you need to have a survey_id column on the question table, and a question_id on the answer table. the other data attributes will be evident as you build your app.

Jed Schneider 2010-08-31 10:31:20

ansaurus

tags:

views:

answers:

Structuring question and answer database in RoR

related questions