I'm using Michael Durrant's design as a starting place for designing my own survey-like database.
With this design, is it possible to order answer's, by datetime, for a question for a survey_section was complete? - for example, if a user completed the survey section twice is it possible to tell which set of answers relates to which completed_on in the user_survey_section?
possible repeating myself, I interpreted this design to allow for knowing:
- What user completed what section and when
- what the answers were for which section
- The completed_date of the answers themselves.
Thus it wouldn't know which set of answers was last submitted for a section.