Summary of the "lyrSurveyResponse" columns in ListManager
Every survey response will have one row in this table, and
potentially multiple rows in the lyrSurveyResponseAnswer table, one for each question in the survey.
Below table stores the responses to a survey:
Primary key: ResponseID
|
Field Name |
Description |
Version Added |
|---|---|---|
|
ResponseID |
An auto-incrementing unique identifier (int, NOT NULL) |
|
|
MailingID |
If this survey was sent via email, what was the mailing ID, from the outmail_ table? (int, NULL) |
|
|
MemberID |
If this response was from a member, what is their member ID, from the members_ table? (int, NULL) |
|
|
ResponseTime |
When was this response received? (smalldatetime, NOT NULL) |
|
|
WebDocID |
The ID from the lyrWebDocs table that represents this survey in HTML form. (int, NOT NULL) |
|
|
Weight |
The relative weight of this response. (int, NULL) |