Changes between Version 1 and Version 2 of DeveloperGuidelines/Survey

Timestamp:

10/01/11 14:53:51 (13 years ago)

Author:

graeme

Comment:

--

DeveloperGuidelines/Survey

@@ -18 +18 @@
 This is used to hold additional details of the question. The valid metadata that can be stored will be defined by the [#types (question type)].
 
+For example: if the question type is option, then valid metadata might be:
+||= Key =||= Descriptions =||= Value =||
+||count || the number of options that will be presented || 3 ||
+|| 1 || the first option || Female ||
+|| 2 || the second option || Male ||
+|| 3 || the third option || Not Specified ||
+
+So in the above case a question record will be associated with four question_metadata records. 
+
 === survey_question_list ===
+The survey_question_list table is a resolver between the survey_question and the survey_section tables.
+
+Along with ids mapping back to these tables it will have a code that can be used to reference the question it will have the position that the question will appear in the template.
 
 === survey_series ===
-=== survey_response ===
+The survey_series table is used to hold all uses of a template
+
+When a series is first created the template status will change from
+Pending to Active and at the stage no further changes to the
+template can be made.
+
+Typically a series will be created for an event, which may be a
+response to a natural disaster, an exercise,
+or regular data collection activity.
+
+The series is a container for all the responses for the event
+
+=== survey_complete ===
+The survey_complete table holds all of the answers for a completed
+response. It has a link back to the series this response belongs to.
+
+Whilst this table holds all of the answers in a text field during
+the onaccept each answer is extracted and then stored in the
+survey_answer table. This process of moving the answers to a 
+separate table makes it easier to analyse the answers
+for a given question across all responses.
+
 === survey_answer ===
+The survey_answer table holds the answer for a single response of a given question.
+
 == The Question Types [=#types]==
 == The Question Widgets ==