Course Categories Table Schema (course_categories)


Description

Course categories

course_categories table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
course.category cour_cat_fk R
course_categories.parent courcate_par2_fk R
prog.category prog_cat3_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 1
visibleold BIT 1 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
programcount BIGINT 19 0

Totara program count from totara_program
certifcount BIGINT 19 0

Totara certification count from totara_program

Table contained -1 rows

course_categories table indexes

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

course_categories table relationships

Close relationships within degrees of separation