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