Question Table Schema (question)


The questions themselves

question table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
qtype_ddimageortext.questionid qtypddim_que2_fk R
qtype_ddimageortext_drags.questionid qtypddimdrag_que2_fk R
qtype_ddimageortext_drops.questionid qtypddimdrop_que2_fk R
qtype_ddmarker.questionid qtypddma_que2_fk R
qtype_ddmarker_drags.questionid qtypddmadrag_que2_fk R
qtype_ddmarker_drops.questionid qtypddmadrop_que2_fk R
qtype_essay_options.questionid Implied Constraint R
qtype_match_options.questionid Implied Constraint R
qtype_match_subquestions.questionid qtypmatcsubq_que2_fk R
qtype_multichoice_options.questionid Implied Constraint R
qtype_randomsamatch_options.questionid Implied Constraint R
qtype_shortanswer_options.questionid Implied Constraint R
question.parent ques_par2_fk R
question_answers.question quesansw_que2_fk R
question_attempts.questionid quesatte_que3_fk R
question_calculated.question quescalc_que2_fk R
question_calculated_options.question quescalcopti_que2_fk R
question_datasets.question quesdata_que2_fk R
question_ddwtos.questionid quesddwt_que2_fk R
question_gapselect.questionid quesgaps_que2_fk R
question_hints.questionid queshint_que2_fk R
question_multianswer.question quesmult_que2_fk R
question_numerical.question quesnume_que2_fk R
question_numerical_options.question quesnumeopti_que2_fk R
question_numerical_units.question quesnumeunit_que2_fk R
question_response_analysis.questionid Implied Constraint R
question_statistics.questionid quesstat_que_fk R
question_truefalse.question questrue_que2_fk R
quiz_slots.questionid quizslot_que3_fk R
category BIGINT 19 0 ques_cat2_fk R
parent BIGINT 19 0 ques_par2_fk R
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
version VARCHAR 255
hidden BIT 1 0
timecreated BIGINT 19 0

time question was created

timemodified BIGINT 19 0

time that question was last modified

createdby BIGINT 19 null ques_cre2_fk R

userid of person who created this question

modifiedby BIGINT 19 null ques_mod2_fk R

userid of person who last edited this question

idnumber VARCHAR 100 null

Table contained -1 rows

question table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ques_cat_ix Performance Asc category
ques_catidn_uix Must be unique Asc/Asc category + idnumber
ques_cre_ix Performance Asc createdby
ques_mod_ix Performance Asc modifiedby
ques_par_ix Performance Asc parent
ques_qty_ix Performance Asc qtype

question table relationships