course_format_options

0 rows


Description

Stores format-specific options for the course or course sect

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
courseid BIGINT 19 null
course.id courformopti_cou2_fkR

Id of the course

format VARCHAR 21

Format this option is for

sectionid BIGINT 19 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

Indexes

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

Relationships