Summary of the "lyrSurveyAnswerCollections" columns in ListManager

Below table associates an integer identifier with a group of answers to a single survey question.

This is used for questions that allow multiple answers, such as a matrix.

Primary key: CollectionID

Field Name

Description

Version Added

CollectionID

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

CollectionShortName

A short name to refer to this row, as an alternative key. (varchar(15), NOT NULL)

CollectionDescription

A textual description of this collection. (varchar(255), NULL)