course_categories

0 rows


Description

Course categories

Columns

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_brickfield_areas.categoryid toolbricarea_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 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

Indexes

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

Relationships

Close relationships within degrees of separation