Table Overview
Pages
PageID |
Unique page identifier |
SID |
Foreign key reference to unique survey identifier |
Heading |
Page title |
Subheading |
Page description |
Position |
Position of page within survey |
Questions
QID |
Unique question identifier |
PageID |
Foreign key reference to unique page identifier |
Position |
Position of question within page |
QType |
Unique value for each question type |
Heading |
Question description |
QuestionOptions
OptionID |
Unique question option identifier |
OptionType |
Value depends on QType (see QuestionOptionsKey.htm) |
OptionNum |
Value depends on QType (see QuestionOptionsKey.htm) |
QID |
Foreign key reference to unique question identifier |
OptionText |
Question option description |
Respondents
RespondentID |
Unique respondent identifier |
SID |
Foreign key reference to unique survey identifier |
IPAddress |
IP address of respondent |
Email |
Email of respondent (only if list management was used to send
tracked messages) |
FirstName |
First name of respondent (only if list management was used to
send tracked messages) |
LastName |
Last name of respondent (only if list management was used to
send tracked messages) |
CustomData |
Custom alphanumeric value associated with respondent (only if
list management was used to send tracked messages, or if "C="
parameter was used in anonymous link) |
Responses
RespondentID |
Foreign key reference to unique respondent identifier |
QID |
Foreign key reference to unique question identifier |
Key1 |
Value depends on QType (see ResponsesKey.htm) |
Key2 |
Value depends on QType (see ResponsesKey.htm) |
Key3 |
Value depends on QType (see ResponsesKey.htm) |
Value |
Value depends on QType (see ResponsesKey.htm) |
DateAdded |
Date the response was added (in Central Time, USA) |