question_bank_entries

0 rows


Description

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

Columns

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
question_categories.id 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
user.id quesbankentr_own2_fkR

userid of person who owns this question bank entry.

Indexes

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

Relationships