Local Ld Course Table Schema (local_ld_course)


Description

Total time spent within a course

local_ld_course table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
local_ld_course_day.ldcourseid localdcourday_ldc2_fk R
local_ld_module.ldcourseid localdmodu_ldc2_fk R
userid BIGINT 19 null
user.id localdcour_use2_fk R

Foreign key to the user
courseid BIGINT 19 null
course.id localdcour_cou2_fk R

Foreign key to the course
totaldedication BIGINT 19 null

Total time that user spent within the course, in seconds

Table contained -1 rows

local_ld_course table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
localdcour_cou_ix Performance Asc courseid
localdcour_use_ix Performance Asc userid
localdcour_usecou_uix Must be unique Asc/Asc userid + courseid

local_ld_course table relationships

Close relationships within degrees of separation