222

Tables (4)

deficiency_nutrients

  • deficiency_nutrient_id — INT — Primary key
  • deficiency_id — INT — Foreign key
  • nutrient_id (nutrient_id2) — INT — Foreign key

detailed_questions

  • detailed_question_id — INT — Primary key
  • question_content — TEXT
  • deficiency_id (deficiency_id2) — INT — Foreign key

survey_answers

  • answer_id — INT — Primary key
  • answer_content — TEXT
  • question_id (question_id2) — INT — Foreign key → survey_questions.question_id
  • deficiency_id (deficiency_id2) — INT — Foreign key

survey_questions

  • question_id — INT — Primary key
  • question_content — TEXT
  • parent_question_id — INT