Skip to content

DB Schema

Ankit Shahu edited this page Aug 2, 2023 · 1 revision

In the context of Managed Learn core services, we utilize six collections to manage various aspects of the platform:

programs

This collection stores comprehensive information related to programs. It includes components that are associated with a particular program, creating a structured representation of the program's content and structure.

solutions

Within this collection, different types of solutions exist, such as improvement projects, observations, and surveys. Program Users Collection: In this collection, we store information about users who join programs. This includes details about their enrollment, progress, and program participation.

certificateTemplates

This collection holds data relevant to certificate issuance. It includes the certificate URL, solution ID, issuer information, and criteria for issuing certificates. With this information, we can efficiently generate and manage certificates for program participants.

certificateBaseTemplates

Here, we store standardized certificate names and their corresponding URLs. These base templates can be mapped to certificate templates, streamlining the certificate generation process and ensuring consistent formatting across the platform.

userExtension

Within this collection, we keep track of additional user-specific attributes. For instance, we record whether a user is a program designer or manager for a particular program, enabling role-based functionalities and permissions.

By organizing data into these six collections, Managed Learn core services can efficiently manage, track, and optimize the learning experience for users. The structured representation of programs, solutions, certificates, and user roles ensures a seamless learning journey and allows us to improve the platform based on user needs and feedback continuously.

ML Core DB schema

Click here for DB schema and corresponding examples in a PDF format.

Clone this wiki locally