Local Ld Course Day table / local_ld_course_day - Moodle LMS 3.9 Database schema / Zoola Analytics

local_ld_course_day table columns

Related columns Constraint Comments

Search:

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

Showing 1 to 6 of 6 entries

Table contained -1 rows

local_ld_course_day table indexes

Search:

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

Showing 1 to 3 of 3 entries

local_ld_course_day table relationships

Close relationships within degrees of separation

One
Two degrees

Local Ld Course Day Table Schema (local_ld_course_day)

Description

local_ld_course_day table columns

local_ld_course_day table indexes

local_ld_course_day table relationships

Close relationships within degrees of separation