0 rows


Each question bank entry. This table has one row for each qu


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_own2_ix Performance Asc ownerid
quesbankentr_que2_ix Performance Asc questioncategoryid
quesbankentr_queidn2_uix Must be unique Asc/Asc questioncategoryid + idnumber