question_versions

0 rows


Description

A join table linking the different question version definitions in the question table to the question_bank_entires.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
questionbankentryid BIGINT 19 0
question_bank_entries.id quesvers_que3_fkR

ID of the question bank entry this question version is part of.

version BIGINT 19 1

Version number for the question where the first version is always 1.

questionid BIGINT 19 0
question.id quesvers_que4_fkR

The question ID.

status VARCHAR 10 ready

If the question is ready, hidden or draft

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesvers_que2_ix Performance Asc questionid
quesvers_que_ix Performance Asc questionbankentryid

Relationships