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_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
timemodified BIGINT 19 0
depth BIGINT 19 0
path VARCHAR 255
theme VARCHAR 50 null

Indexes

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

Relationships