-> 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