Qtype Match Subquestions Table Schema (qtype_match_subquestions)


Description

The subquestions that make up a matching question

qtype_match_subquestions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
questionid BIGINT 19 0
question.id qtypmatcsubq_que2_fk R

Foreign key link to question.id.
questiontext LONGTEXT 2147483647 null
questiontextformat TINYINT 3 0
answertext VARCHAR 255

Table contained -1 rows

qtype_match_subquestions table indexes

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

qtype_match_subquestions table relationships

Close relationships within degrees of separation