Home > Technical > Table Definitions > SURVEYQUESTION

SURVEYQUESTION

Each survey can have up to five questions. This table stores details about the five questions.

Column Type Description

INTCODE

INT(4)

The code of the survey this question belongs to.

SURVEYHDR.ctrCode

INTQUESTIONNUM

INT(4)

The question number within the survey. This can be a number from 1 to 5.

STRQUESTION

VARCHAR(30)

The question to be displayed to the user. If left empty, POS will not ask a question.

STRANSWERTYPE

VARCHAR(1)

The type of answer required for this question. 'T'=Free-format text, 'C'=Combo box selection. If you select 'C' then the actual combo box details are stored in SURVEYANSWER.

INTMAXLENGTH

INT(4)

The maximum number of characters which can be entered for the answer. This can be a number from 1 to 20.

 

Primary Key: INTCODE + INTQUESTIONNUM

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)