Course Sections Table Schema (course_sections)


Description

to define the sections for each course

course_sections table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
course bigint 10 0
section bigint 10 0
name varchar 255 null
summary longtext 2147483647 null
summaryformat tinyint 2 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