Course Format Options table / course_format_options - Moodle LMS 3.9 Database schema / Zoola Analytics

course_format_options table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

courseid

BIGINT

19

null

course.id

courformopti_cou2_fk R

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

Showing 1 to 6 of 6 entries

Table contained -1 rows

course_format_options table indexes

Search:

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

Showing 1 to 3 of 3 entries

Course Format Options Table Schema (course_format_options)

Description

course_format_options table columns

course_format_options table indexes

course_format_options table relationships

Close relationships within degrees of separation