Summary of the "lyrSurveyResponse" columns in ListManager
This table stores the reponses to a survey. 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.
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) |
|