Question Response Analysis Table Schema (question_response_analysis)


Description

Analysis of student responses given to questions.

question_response_analysis table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
question_response_count.analysisid quesrespcoun_ana2_fk R
hashcode VARCHAR 40

sha1 hash of serialized qubaids_condition class. Unique for every combination of class name and property.
whichtries VARCHAR 255
timemodified BIGINT 19 null
questionid BIGINT 19 null
question.id Implied Constraint R
variant BIGINT 19 √ null
subqid VARCHAR 100
aid VARCHAR 100 √ null
response LONGTEXT 2147483647 √ null
credit DECIMAL 15,5 null

Table contained -1 rows

question_response_analysis table indexes

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

question_response_analysis table relationships

Close relationships within degrees of separation