Course Sections Table Schema (course_sections)


to define the sections for each course

course_sections table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
course BIGINT 19 0 coursect_cou_fk R
section BIGINT 19 0
name VARCHAR 255 null
summary LONGTEXT 2147483647 null
summaryformat TINYINT 3 0
sequence LONGTEXT 2147483647 null
visible BIT 1 1
availability LONGTEXT 2147483647 null

Availability restrictions for viewing this section, in JSON format. Null if no restrictions.

Table contained -1 rows

course_sections table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
coursect_cousec_uix Must be unique Asc/Asc course + section

course_sections table relationships