Local Ld Module Table Schema (local_ld_module)


Time spent on a module

local_ld_module table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
local_ld_module_day.ldmoduleid localdmoduday_ldm2_fk R
ldcourseid BIGINT 19 null
local_ld_course.id localdmodu_ldc2_fk R

Foreign key to the local_ld_course table

coursemoduleid BIGINT 19 null
course_modules.id localdmodu_cou2_fk R

Foreign key to the course_modules table

totaldedication BIGINT 19 0

Total time spent on this module, in seconds

Table contained -1 rows

local_ld_module table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
localdmodu_cou_ix Performance Asc coursemoduleid
localdmodu_ldc_ix Performance Asc ldcourseid
localdmodu_ldccou_uix Must be unique Asc/Asc ldcourseid + coursemoduleid

local_ld_module table relationships