0 rows


Each question bank entry. This table has one row for each question that appears in the question bank.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
question_references.questionbankentryid quesrefe_que2_fkR
question_versions.questionbankentryid quesvers_que3_fkR
questioncategoryid BIGINT 19 0 quesbankentr_que2_fkR

ID of the category this question is part of.

idnumber VARCHAR 100 null

Unique identifier, useful especially for mapping to external entities.

ownerid BIGINT 19 null quesbankentr_own2_fkR

userid of person who owns this question bank entry.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesbankentr_own_ix Performance Asc ownerid
quesbankentr_que_ix Performance Asc questioncategoryid
quesbankentr_queidn_uix Must be unique Asc/Asc questioncategoryid + idnumber