public.learningmodules

public.learningmodules

Description

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false
name varchar(100) true
description varchar(100) true
version varchar(255) true
externalid varchar(50) true
source varchar(50) true
enforcecontentorder boolean true
isarchived boolean true
ispublished boolean true
completiontimeindays integer true
type varchar(50) true
datecreated timestamp without time zone true
datemodified timestamp without time zone true
lengthinminutes numeric(20,2) true
state varchar(50) true
updated timestamp without time zone true

Constraints

Name Type Definition
learningmodule_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
learningmodule_pkey CREATE UNIQUE INDEX learningmodule_pkey ON public.learningmodules USING btree (id)

    • Related Articles

    • public.vwlearningassignmentcorrelation

      Description Direct correlation view between learning assignments and their completion results. Tracks complete assignment lifecycle from assignment to completion with timing and performance metrics. Includes calculated fields for lifecycle status, ...

    • public.vwlearninguserassignmentsummary

      Description Comprehensive user-centric view combining learning assignments and results. Shows complete learning lifecycle per user including assignment status, completion status, and performance metrics. Key relationships: userdetails -> ...

    • public.vwlearningmodulecompletionanalytics

      Description Module-centric analytics view providing comprehensive completion rates, performance metrics, and assignment statistics. Calculates completion rates, pass rates, average scores, and timing analytics per learning module. Optimized for ...

    • public.learningassignmentresults

      Description Learning Assignment Results Table - Stores detailed results and completion data for learning module assignments. This table captures the outcome and performance metrics when users complete learning module assignments. It serves as the ...

    • public.learningmoduleassignments

      Description Learning Module Assignments Table - Stores assignment data for learning modules assigned to users. This table tracks the complete lifecycle of learning module assignments from initial assignment through completion. It serves as the ...