Question Statistics Table Schema (question_statistics)


Description

Statistics for individual questions used in an activity.

question_statistics table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
hashcode VARCHAR 40

sha1 hash of serialized qubaids_condition class. Unique for every combination of class name and property.
timemodified BIGINT 19 null
questionid BIGINT 19 null
question.id quesstat_que_fk R
slot BIGINT 19 √ null

The position in the quiz where this question appears
subquestion SMALLINT 5 null
variant BIGINT 19 √ null
s BIGINT 19 0
effectiveweight DECIMAL 15,5 √ null
negcovar TINYINT 3 0
discriminationindex DECIMAL 15,5 √ null
discriminativeefficiency DECIMAL 15,5 √ null
sd DECIMAL 15,10 √ null
facility DECIMAL 15,10 √ null
subquestions LONGTEXT 2147483647 √ null
maxmark DECIMAL 12,7 √ null
positions LONGTEXT 2147483647 √ null

positions in which this item appears. Only used for random questions.
randomguessscore DECIMAL 12,7 √ null

An estimate of the score a student would get by guessing randomly.

Table contained -1 rows

question_statistics table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesstat_que_fk Performance Asc questionid

question_statistics table relationships

Close relationships within degrees of separation