question

0 rows


Description

The questions themselves

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_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 Implied ConstraintR
question_statistics.questionid question_statistics_erd_question_idR
question_truefalse.question questrue_que2_fkR
quiz_slots.questionid quizslot_que3_fkR
category BIGINT 19 0
question_categories.id ques_cat2_fkR
parent BIGINT 19 0
question.id ques_par2_fkR
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
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
idnumber VARCHAR 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ques_cat4_ix Performance Asc category
ques_catidn2_uix Must be unique Asc/Asc category + idnumber
ques_cre4_ix Performance Asc createdby
ques_mod4_ix Performance Asc modifiedby
ques_par4_ix Performance Asc parent
ques_qty2_ix Performance Asc qtype

Relationships

Close relationships within degrees of separation