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)