Course Categories table / course_categories - Moodle LMS 3.9 Database schema / Zoola Analytics

course_categories table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

course.category	cour_cat2_fk R
course_categories.parent	courcate_par2_fk R
event.categoryid	even_cat2_fk R
tool_recyclebin_category.categoryid	toolrecycate_cat2_fk R

name

VARCHAR

255

idnumber

VARCHAR

100

√

null

description

LONGTEXT

2147483647

√

null

descriptionformat

TINYINT

3

0

parent

BIGINT

19

0

course_categories.id

courcate_par2_fk R

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

timemodified

BIGINT

19

0

depth

BIGINT

19

0

path

VARCHAR

255

theme

VARCHAR

50

√

null

Theme for the category

Showing 1 to 14 of 14 entries

Table contained -1 rows

course_categories table indexes

Search:

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

Showing 1 to 2 of 2 entries

Course Categories Table Schema (course_categories)

Description

course_categories table columns

course_categories table indexes

course_categories table relationships

Close relationships within degrees of separation