数据库结构允许用户对某个主题进行投票

Question

I have a Job model and a User model. I need each User to be able to answer several questions based on a particular Job. Each question is marked from 1 to 10 (or unanswered).

I believe i need a hasMany through associations, but have been confused by these before.

Can someone help me with my database/model layout. Thanks.

EDIT:

• The only tables I have at the moment are users and jobs
• The questions are the same for every job, there are six of them (maybe more in the future)
• The Questions will always be numbers from 1 to 10 (or unanswered)

Answer 1

Yes, perfect candidat for hasMany through, and I'll do it like so:

User hasMay JobQuestion
Job hasMany JobQuestion

JobQuestion belongsTo Job, User

put all your questions in the JobQuestion model. There might be a more appropriate name for this model. Do you need more details for the models keys?

Edit:

A row in the JobQuestion model would:

id | user_id | job_id | question1 | ... | questionN

Your data array would something like

Array
(
    [0] => Array
        (
            [JobQuestion] => Array
                (
                    [id] => 1
                    [user_id] => 1
                    [job_id] => 1
                    [question1] => answer1
                    [question2] => answer2
                )

            [Job] => Array
                (
                    [id] => 1
                    [name] => somejob
                )

            [User] => Array
                (
                    [id] => 1
                    [username] => someuser
                )

        )

)