You are here: ListManager Programmer's Guide > ListManager Tables > Surveys > lyrSurveyResponseAnswers

lyrSurveyResponseAnswers

 

This table stores the reponses to a specific question in a survey. Every survey response will have one row in the lyrSurveyResponse table, and potentially multiple rows in this table, one for each question in the survey.

 

Primary key: ResponseID, QuestionID, AnswerID

 

Field Name

Description

Version Added

ResponseID

The identifier of the response from the lyrSurveyResponse table. (int, NOT NULL)

Added in 7.8

AnswerID

The identifier of the answer from the lyrSurveyAnswers table. (int, NOT NULL)

Added in 7.8

QuestionID

The identifier of the question from the lyrSurveyQuestions table. (int, NOT NULL)

Added in 7.8

FreeFormAnswer

Any free form response to a question. (text, NULL)

Added in 7.8