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