轮询数据库架构

最适合轮询的数据库架构是什么?一对多关系对此有好处吗?我正在考虑有两个表:

What is the best database schema for polls? Is one-to-many relationship good for this? I'm thinking about having two tables:

poll_questions
    int id
    varchar body
    datetime created_at
    datetime updated_at

poll_answers
    int id
    varchar body
    int votes default 0
    int question_id (foreign key to poll_questions.id)
    datetime created_at
    datetime updated_at

然后还有第三张表，用于跟踪谁对答案投票，因此用户只能投票一次:

Then there would also be third table for tracking who voted for an answer so users are able to vote only once:

poll_voting_history
    int id
    int question_id (foreign key to poll_questions.id)
    int answer_id (foreign key to poll_answers.id)
    int user_id (foreign key to the id in the users table)
    datetime created_at
    datetime updated_at

您有什么想法?我在想对吗?

What are your thoughts? Am I thinking about it right?