-> Version: 1
------------------------> Table: Answers
uniqueID ID location peopleWith interruptible energetic happy stressed
------------------------> Table: PagesOfQuestions
uniqueRowID page orderIndex questionID
14 1 1 14
1 1 2 1
6 2 1 6
7 2 2 7
8 2 3 8
13 2 4 13
9 2 5 9
30 2 6 25
4 3 1 3
27 4 1 10
28 4 2 11
29 4 3 12
------------------------> Table: QuestionChoices
uniqueRowID choice questionID orderIndex
1 "Work" 6 1
2 "Home" 6 2
3 "Other" 6 3
4 "I am alone" 7 1
5 "One other person" 7 2
6 "More than one" 7 3
7 "Yes" 8 1
8 "No" 8 2
9 "Strongly Disagree" 9 1
10 "Disagree" 9 2
11 "In Between" 9 3
12 "Agree" 9 4
13 "Strongy Agree" 9 5
14 "Strongly Disagree" 18 1
15 "" 18 2
16 "Neither Agree Nor Disagree" 18 3
17 "" 18 4
18 "Strongly Agree" 18 5
19 "Choice 1" 20 1
20 "Choice 2" 20 2
21 "Choice 3" 20 3
22 "a" 21 1
23 "b" 21 2
24 "choice 1" 22 1
28 "choice 1" 22 1
25 "choice d1" 22 2
29 "choice d1" 22 2
26 "choice 2" 22 3
30 "choice 2" 22 3
27 "choice d2" 22 4
31 "choice d2" 22 4
32 "Strongly Disagree" 24 1
33 "" 24 2
34 "Neither Agree Nor Disagree" 24 3
35 "" 24 4
36 "Strongly Agree" 24 5
------------------------> Table: Questions
questionID question endQuestion typeOfQuestion dbField typeOfAnswer sourceOfAnswerChoices numberOfChoices pageIDInsideThis questionIDForAnswerTable randomizeAnswerOrder cacheRandomizeAnswerOrder ReverseScore autoSubmitWhenFinishedWithThisQuestion backgroundColor helpText
1 "Please stop what you're doing and fill out this survey." "PlainText" "ffffff"
6 "Where are you now?" "" "RadioButton" "location" "string" "table" ""
7 "Who are you with?" "" "RadioButton" "peopleWith" "string" "table" ""
8 "Are you interruptible?" "" "RadioButton" "interruptible" "string" "table" ""
2 "Email" "Text" "Email" "stringKey"
3 "
Thank you for filling out the survey. You may now continue whatever
activity you were doing.
" "PlainText"
9 "" "" "HorizontalRadioHeaders" "" "string" "table" ""
10 "I am energetic" "" "RadioButton" "energetic" "number" "likert" 5 ""
11 "I am happy" "" "RadioButton" "happy" "number" "likert" 5 ""
12 "I am stressed" "" "RadioButton" "stressed" "number" "likert" 5 ""
4 "You're Done!" "Title"
5 "" "Title"
13 "On the following questions, please rate how you are feeling right now on
the following questions." "" "PlainText" "" "string" "" 1 "" ""
14 "This is a survey designed for a small device like a PalmPilot. You need to design your surveys differently for these platforms. This survey provides an example." "" "Notes" "" "string" "" 1 "" ""
18 "" "" "HorizontalRadioHeaders" "" "number" "table" 5 1 "" ""
22 "" "" "Abstract" "" "string" "" 1 "" ""
23 "You're Done!" "Title"
25 "" "" "PageGroup" "indexSelected1" "number" "" 4 1 1 0 "" ""
------------------------> Table: QuestionsAuxillaryOptions
uniqueRowID questionID orderIndex typeOfOption auxillaryOptionTextA auxillaryOptionTextB auxillaryOptionTextC auxillaryOptionTextD auxillaryOptionTextE auxillaryOptionTextF auxillaryOptionTextG auxillaryOptionNumberA auxillaryOptionNumberB auxillaryOptionNumberC auxillaryOptionNumberD
1 6 0 "Default Value" "" "" "" "" "" "" ""
2 7 0 "Default Value" "" "" "" "" "" "" ""
3 8 0 "Default Value" "" "" "" "" "" "" ""
4 9 0 "Default Value" "" "" "" "" "" "" ""
5 10 0 "Default Value" "" "" "" "" "" "" ""
6 11 0 "Default Value" "" "" "" "" "" "" ""
7 12 0 "Default Value" "" "" "" "" "" "" ""
8 17 0 "Default Value" "" "" "" "" "" "" ""
9 17 1 "Default Value" "" "" "" "" "" "" ""
10 19 0 "Default Value" "" "" "" "" "" "" ""
11 19 1 "Default Value" "" "" "" "" "" "" ""
12 20 0 "Default Value" "" "" "" "" "" "" ""
13 20 1 "Default Value" "" "" "" "" "" "" ""
14 20 1 "Other Text Field" "question4" "string" "" "" "" "" ""
15 21 0 "Default Value" "" "" "" "" "" "" ""
16 22 1 "RadioButton" "variable" "number" "table" "" "" "" "1" 0 0
17 22 2 "DropDown" "variable2" "number" "table" "" "" "" "1" 0 0
18 25 0 "Default Value" "" "" "" "" "" "" ""
------------------------> Table: SurveyPages
page orderIndex name answersTable submitButtonLabel repeatedMeasureTable repeatedMeasureNumber jumpToPage
4 "Page" "Answers"
1 1 "Login" "Users"
2 2 "Page 1" "Answers"
3 3 "Done With Survey" "Answers"
------------------------> Table: TableVersion
uniqueID TableName Version
1 "TableVersion" 1
2 "Users" 1
3 "Answers" 1
4 "QuestionsAuxillaryOptions" 1
5 "QuestionChoices" 1
6 "Questions" 1
7 "PagesOfQuestions" 1
8 "SurveyPages" 1
------------------------> Table: Users
ID Email Started Finished IPAddress PreviousIDs CurrentPage question1 question2 question4 question3 variable variable2