course_categories

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

course.category	course_erd_category_idR
course_categories.parent	course_categories_erd_course_idR
event.categoryid	even_cat2_fkR
tool_recyclebin_category.categoryid	toolrecycate_cat2_fkR

name

VARCHAR

255

idnumber

VARCHAR

100

√

null

description

LONGTEXT

2147483647

√

null

descriptionformat

TINYINT

3

0

parent

BIGINT

19

0

course_categories.id

course_categories_erd_course_idR

sortorder

BIGINT

19

0

coursecount

BIGINT

19

0

visible

BIT

1

visibleold

BIT

1

the state of visible field when hiding parent category, this helps us to recover hidden states when unhiding the parent category later

Showing 1 to 10 of 14 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
courcate_par4_ix	Performance	Asc	parent

Showing 1 to 2 of 2 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation