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 10 null
ldcourseid bigint 10 null
local_ld_course.id localdcourday_ldc2_fk R

Foreign key to the local_ld_course table

daytime bigint 10 null

Timestamp of the beginning of the day

day varchar 10

Day formatted as 'YYYY-MM-DD'

dedication bigint 10 0

Time spent on course within this day

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_ldcday_uix Must be unique Asc/Asc ldcourseid + daytime

local_ld_course_day table relationships