course_sections

0 rows


Description

to define the sections for each course

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
course BIGINT 19 0
course.id course_sections_erd_course_idR
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.

timemodified BIGINT 19 0

Time at which the course section was last changed.

Indexes

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

Relationships