lyrSurveyResponseAnswers
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.
Below table stores the responses to a specific question in a 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 |