Local Ld Module Day Table Schema (local_ld_module_day)


Description

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 10 null
ldmoduleid bigint 10 null
local_ld_module.id localdmoduday_ldm2_fk R

Foreign key to the local_ld_module 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 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