Course Format Options Table Schema (course_format_options)


Description

Stores format-specific options for the course or course section

course_format_options table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
courseid bigint 10 null
course.id courformopti_cou2_fk R

Id of the course

format varchar 21

Format this option is for

sectionid bigint 10 0

Null if this is a course option, otherwise id of the section this option is for

name varchar 100

Name of the format option

value longtext 2147483647 null

Value of the format option

Table contained -1 rows

course_format_options table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courformopti_cou_ix Performance Asc courseid
courformopti_couforsecnam_uix Must be unique Asc/Asc/Asc/Asc courseid + format + sectionid + name

course_format_options table relationships