This 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) |
|