Summary of the "lyrSurveyQuestions" columns in ListManager

Below table describes a question on a survey:

Primary key: QuestionID

Field Name

Description

Version Added

QuestionID

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

UserQuestionNumber

What question number should this be for the user? (int, NOT NULL)

UserPartNumber

If this is a question that has multiple answers, such as a matrix, what part number is this of the question? (smallint, NOT NULL)

QuestionText

The text of the question. (varchar(255), NOT NULL)