Summary of the "lyrSurveyAnswers" columns in ListManager

Below table describes a possible answer to a question, such as "Strongly agree":

Primary key: AnswerID

Field Name

Description

Version Added

AnswerID

An auto-incrementing unique identifier (int, NOT NULL)

AnswerText

The text of this answer. (varchar(255), NOT NULL)

AnswerCollectionID

If this answer is part of a collection, such as a matrix, what is the collection ID from the lyrSurveyAnswerCollections . (int, NULL)

AnswerOrder

The order that the answers should be provided to the user. (smallint, NOT NULL)

AnswerWeight

The weight that this answer should be considered. Some questions have much more importance, so this allows the answer to be considered more or less important that other answers. (int, NULL)