question_categories

Columns

Related columns Constraint Comments

Search:

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

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

Showing 1 to 9 of 9 entries

Indexes

Search:

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

Showing 1 to 5 of 5 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation