Local Ld Module Day Table Schema (local_ld_module_day)


Time spent on a module at day level

local_ld_module_day table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
ldmoduleid BIGINT 19 null
local_ld_module.id localdmoduday_ldm2_fk R

Foreign key to the local_ld_module 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 module within this day

Table contained -1 rows

local_ld_module_day table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
localdmoduday_ldm_ix Performance Asc ldmoduleid
localdmoduday_ldmday_uix Must be unique Asc/Asc ldmoduleid + daytime

local_ld_module_day table relationships