title: Designing databse for questions and answers where some answers are text and some are multiple choice
body: <p>I know there are a few related posts but I didn't fully understand what to do.</p>
  
  <p>I have a general idea of how to go about this.  I am not too far into database design unfortunately so I require help.</p>
  
  <p>Have table with questions_id, have table for possible_answer_id for each question_id.</p>
  
  <p>Then have a linking table question_answers with user_id, question_id, answer_id, timestamp to register submitted forms.</p>
  
  <p>But my problem is that some questions are answered with just a string so I am having trouble conceptualizing what to do about it.</p>
  
  <pre>
  e,g 
  for some I need: question_id string_answer (any answer is allowed)
  for others:      question_id answer_id     (out of set of allowed answers)
  and perhaps:     question_id bool_answer   (true/false)
  </pre>
  
  <p>Do I add question_type somewhere so I have two different tables for this?</p>
  
  <p>If the question is not clear, please let me know. </p>