Course Categories Table Schema (course_categories)


Course categories

course_categories table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
course.category courcate_cat_fk R
course_categories.parent courcate_par2_fk R
tool_recyclebin_category.categoryid toolrecycate_cat2_fk R
name varchar 255
idnumber varchar 100 null
description longtext 2147483647 null
descriptionformat tinyint 2 0
parent bigint 10 0 courcate_par2_fk R
sortorder bigint 10 0
coursecount bigint 10 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 10 0
depth bigint 10 0
path varchar 255
theme varchar 50 null

Theme for the category

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