Block Zoola Module Name Table Schema (block_zoola_module_name)


Description

Module names

block_zoola_module_name table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
coursemoduleid BIGINT 19 null
course.id Implied Constraint R

Course module id

moduletype VARCHAR 20

Module type (lesson, quiz, ...)

instanceid BIGINT 19 null

Instance id

name VARCHAR 255

Module name

Table contained -1 rows

block_zoola_module_name table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
bloczoolmoduname_cou_uix Must be unique Asc coursemoduleid
bloczoolmoduname_modins_ix Performance Asc/Asc moduletype + instanceid

block_zoola_module_name table relationships