Course Categories Table Schema (course_categories)


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 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