# question

0 rows

### Description

This table stores the definition of one version of a question.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
qtype_ddimageortext.questionid | qtypddim_que2_fkR
qtype_ddimageortext_drags.questionid | qtypddimdrag_que2_fkR
qtype_ddimageortext_drops.questionid | qtypddimdrop_que2_fkR
qtype_ddmarker.questionid | qtypddma_que2_fkR
qtype_ddmarker_drags.questionid | qtypddmadrag_que2_fkR
qtype_ddmarker_drops.questionid | qtypddmadrop_que2_fkR
qtype_essay_options.questionid | qtypessaopti_que_fkR
qtype_match_options.questionid | qtypmatcopti_que_fkR
qtype_match_subquestions.questionid | qtypmatcsubq_que2_fkR
qtype_multichoice_options.questionid | qtypmultopti_que_fkR
qtype_ordering_options.questionid | qtypordeopti_que_fkR
qtype_randomsamatch_options.questionid | qtyprandopti_que_fkR
qtype_shortanswer_options.questionid | qtypshoropti_que_fkR
question.parent | ques_par2_fkR
question_answers.question | quesansw_que2_fkR
question_attempts.questionid | quesatte_que3_fkR
question_calculated.question | quescalc_que2_fkR
question_calculated_options.question | quescalcopti_que2_fkR
question_datasets.question | quesdata_que2_fkR
question_ddwtos.questionid | quesddwt_que2_fkR
question_gapselect.questionid | quesgaps_que2_fkR
question_hints.questionid | queshint_que2_fkR
question_multianswer.question | quesmult_que2_fkR
question_numerical.question | quesnume_que2_fkR
question_numerical_options.question | quesnumeopti_que2_fkR
question_numerical_units.question | quesnumeunit_que2_fkR
question_response_analysis.questionid | quesrespanal_que2_fkR
question_statistics.questionid | question_statistics_erd_question_idR
question_truefalse.question | questrue_que2_fkR
question_versions.questionid | quesvers_que4_fkR
parent | BIGINT | 19 |  |  | 0 |  |
question.id | ques_par2_fkR
| if bigger than 0 this is a (hidden) subquesiton, used by Cloze
name | VARCHAR | 255 |  |  |  |  |  |
questiontext | LONGTEXT | 2147483647 |  |  | null |  |  |
questiontextformat | TINYINT | 3 |  |  | 0 |  |  |
generalfeedback | LONGTEXT | 2147483647 |  |  | null |  |  | to store the question feedback
generalfeedbackformat | TINYINT | 3 |  |  | 0 |  |  |
defaultmark | DECIMAL | 12,7 |  |  | 1.0000000 |  |  |
penalty | DECIMAL | 12,7 |  |  | 0.3333333 |  |  |
qtype | VARCHAR | 20 |  |  |  |  |  |
length | BIGINT | 19 |  |  | 1 |  |  |
stamp | VARCHAR | 255 |  |  |  |  |  |
timecreated | BIGINT | 19 |  |  | 0 |  |  | time question was created
timemodified | BIGINT | 19 |  |  | 0 |  |  | time that question was last modified
createdby | BIGINT | 19 | √ |  | null |  |
user.id | ques_cre2_fkR
| userid of person who created this question
modifiedby | BIGINT | 19 | √ |  | null |  |
user.id | ques_mod2_fkR
| userid of person who last edited this question

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
ques_cre_ix | Performance | Asc | createdby
ques_mod_ix | Performance | Asc | modifiedby
ques_par_ix | Performance | Asc | parent
ques_qty_ix | Performance | Asc | qtype

### Relationships