Home > Technical > Table Definitions > SURVEYANSWER

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.

SURVEYQUESTION.intCode

INTQUESTIONNUM

INT(4)

The question number within the survey that these answers are for. This can be a number from 1 to 5.

SURVEYQUESTION.intQuestionNum

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)