question_categories

0 rows


Description

Categories are for grouping questions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
question_bank_entries.questioncategoryid quesbankentr_que2_fkR
question_categories.parent quescate_par2_fkR
question_dataset_definitions.category quesdatadefi_cat2_fkR
name VARCHAR 255
contextid BIGINT 19 0
context.id Implied ConstraintR

context that this category is shared in

info LONGTEXT 2147483647 null
infoformat TINYINT 3 0
stamp VARCHAR 255
parent BIGINT 19 0
question_categories.id quescate_par2_fkR
sortorder BIGINT 19 999
idnumber VARCHAR 100 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quescate_con_ix Performance Asc contextid
quescate_conidn_uix Must be unique Asc/Asc contextid + idnumber
quescate_consta_uix Must be unique Asc/Asc contextid + stamp
quescate_par_ix Performance Asc parent

Relationships