When applying to round applicants typically answer some questions. Questions and answers are stored in metadata column of round_applications table.
This model builds main.application_answers table where each row contains question + answer + question_type triplets and all id information needed to recover who authored the answer for which round etc.
It could be more space efficient to have two separate tables questions/answers so we don't repeat question text for each row, but current way is easier to query.
When applying to round applicants typically answer some questions. Questions and answers are stored in
metadata
column ofround_applications
table.This model builds
main.application_answers
table where each row containsquestion + answer + question_type
triplets and allid
information needed to recover who authored the answer for which round etc.It could be more space efficient to have two separate tables
questions/answers
so we don't repeat question text for each row, but current way is easier to query.