Question Categories Table Schema (question_categories)


Description

Categories are for grouping questions

question_categories table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
question.category ques_cat2_fk R
question_categories.parent quescate_par2_fk R
question_dataset_definitions.category quesdatadefi_cat2_fk R
name VARCHAR 255
contextid BIGINT 19 0
context.id Implied Constraint R

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_fk R
sortorder BIGINT 19 999

Table contained -1 rows

question_categories table indexes

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

question_categories table relationships

Close relationships within degrees of separation