Questionnaire Table Schema (questionnaire)


Main questionnaire table.

questionnaire table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
questionnaire_response.questionnaireid quesresp_que2_fk R
course BIGINT 19 0 ques_cou2_fk R

Id of course

name VARCHAR 255

Name for questionnaire.

intro LONGTEXT 2147483647 null

Description text.

introformat SMALLINT 5 0

text format of intro field

qtype BIGINT 19 0

Questionnaire type code.

respondenttype VARCHAR 9 fullname

Eligible respondents

resp_eligible VARCHAR 8 all

Eligible respondents.

resp_view TINYINT 3 0

Questionnaire viewed?

notifications BIT 1 0

Send submission notifications.

opendate BIGINT 19 0

Timestamp to open access

closedate BIGINT 19 0

Timestamp to close access on

resume TINYINT 3 0

Questionnaire can be saved and resumed.

navigate TINYINT 3 0

Questionnaire can have page branching.

grade BIGINT 19 0

Assign a grade to be received on submission.

sid BIGINT 19 0 ques_sid2_fk R

The id entry in the questionnaire_survey field.

timemodified BIGINT 19 0

The timestamp record last modified.

completionsubmit BIT 1 0

Questionnaire marked as 'complete' when submitted.

autonum BIT 1 3

option for auto numbering questions and pages (both selected by default)

progressbar BIT 1 0

Display a progress bar at top of questionnaire.

Table contained -1 rows

questionnaire table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ques_cou_ix Performance Asc course
ques_res_ix Performance Asc resp_view
ques_sid_ix Performance Asc sid

questionnaire table relationships