Local Ld Course Day Table Schema (local_ld_course_day)


Time spent on a course at day level

local_ld_course_day table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
ldcourseid BIGINT 19 null
local_ld_course.id localdcourday_ldc2_fk R

Foreign key to the local_ld_course table

daytime BIGINT 19 null

Timestamp of the beginning of the day

day VARCHAR 10

Day formatted as 'YYYY-MM-DD'

dedication BIGINT 19 0

Time spent on course within this day

roles VARCHAR 50 null

Users role in course

Table contained -1 rows

local_ld_course_day table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
localdcourday_ldc_ix Performance Asc ldcourseid
localdcourday_ldcdayrol_uix Must be unique Asc/Asc/Asc ldcourseid + daytime + roles

local_ld_course_day table relationships