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.category ques_cat2_fkR
question_categories.parent quescate_par2_fkR
question_dataset_definitions.category quesdatadefi_cat2_fkR
quiz_slots.questioncategoryid quizslot_que4_fkR
name VARCHAR 255
contextid BIGINT 19 0
context.id Implied ConstraintR
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_con2_ix Performance Asc contextid
quescate_conidn2_uix Must be unique Asc/Asc contextid + idnumber
quescate_consta2_uix Must be unique Asc/Asc contextid + stamp
quescate_par4_ix Performance Asc parent

Relationships

Close relationships within degrees of separation