Home > Technical > Table Definitions > SURVEYANSWER
This table stores details about answers which can be displayed for combo box questions stored in SURVEYQUESTION. You can have several records for each survey question.
| Column | Type | Description |
|
INTCODE |
INT(4) |
The code of the survey this question belongs to. |
|
INTQUESTIONNUM |
INT(4) |
The question number within the survey that these answers are for. This can be a number from 1 to 5. |
|
CTRCODE |
INT(4) |
A unique number assigned by the system. |
|
INTORDER |
INT(4) |
This number determines the order that the answers will be displayed in the combo box. If left as 0, the answers will be sorted in alphabetical order. |
|
STRANSWER |
VARCHAR(20) |
The answer to be displayed in the combo box. |
Primary Key: INTCODE + INTQUESTIONNUM + CTRCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |
