title: Is my SQL table structure correct?
body: <p>I have a table named Answer where I stored the answer for different types of question that are like Google Forms Question (ShortAnswer, Paragraph, etc). The Answer table has the following structure:</p>
  
  <pre><code>id - integer - Primary Key
  question_id - integer - Foreign Key
  value - text
  </code></pre>
  
  <p>For simple types of question this table is sufficient because they only store the answer value for a specific question. However I've a Grid type of question, where I have to store an answer (or multiple answers) for a specific row of the grid, so I have to use a pivot table to store the relationship Answer-Row that keep a pair 'row_id - answer_id'. So my question is: is it correct to have this relationship in the same table that I've the other types of questions? Or should I use a different Answer table per question type?</p>