title: Django : One model has two foreign keys is this the right approach in this case
body: <p>I am currently learning about Django Models. Here is my current situation. I have three models</p>
  
  <pre><code>1-Patient_Names
  2-Patient_Responses
  3-Doctor_Questions
  </code></pre>
  
  <p>Now here is the relationship there will be multiple patients which will be represented by the model <code>Patient_Names</code>. Now each patient will have specific responses to the questions asked by a doctor these responses are represented by the model <code>Patient_Responses</code>. Because of this the <code>Patient_Responses</code> model will have a field that is a foreignKey to the <code>Patient_Names</code> model.Also since the responses will be for the questions from the model <code>Doctor_Questions</code>the Patient_Response has another field that is foreignKey to the model  <code>Doctor_Questions</code>. Is this the right approach ? Can a model have two foreign keys? </p>
  
  <pre><code>Patient_Names                 Doctor_Questions
     |                                  |
     |---------Patient_Responses -------|       
                   |
                   pname = models.ForeignKey(Patient_Names)
                   doctor_questions = models.ForeignKey(Doctor_Questions)  
  </code></pre>