Table representing the options for a closed-ended question type with multiple options
Data model

Fields
Field |
Type |
Description |
id* |
INT |
Unique Answer Choice Identifier, Integer Type Primary Key |
questionid* |
INT |
Identifier of the question to which this option relates, reference to the AFW_SURVEY_QUESTION.id table of integer type |
responseorder* |
INT |
It represents the order (lowest to highest) that the options are presented in the form when the user is going to answer the survey, it is of integer type |
text* |
NVARCHAR (400) |
Text of the nvarchar answer option |
Primary Key
PK_AFW_SURVEY_QRESP_CHOICE |
id |
References