# Data Model

### DB Schema

The schema serves as a blueprint for creating and maintaining the database that supports the ML Projects Services data storage and retrieval operations.

![ML-Projects Service](https://ml-services-uploads.s3.ap-south-1.amazonaws.com/DBSchema/ML-Project.png)

#### Here are examples of sample data for each collection

#### [programs](https://github.com/shikshalokam/ml-projects-service/blob/master/DBSchema/programs.json)

Programs collection is tasked with housing high-level program information, encompassing program specifics, resource listings, and program categorizations.

#### [solutions](https://github.com/shikshalokam/ml-projects-service/blob/master/DBSchema/solutions.json)

The solutions collection will serve as a repository for various types of resources, encompassing observations, improvement projects, and surveys, among others.

#### [projects](https://github.com/shikshalokam/ml-projects-service/blob/master/DBSchema/projects.json)

The projects collection will house projects generated by users, along with their respective status updates.

#### [projectTemplates](https://github.com/shikshalokam/ml-projects-service/blob/master/DBSchema/projectTemplates.json)

The projectTemplates collection will store foundational project structures that will serve as templates for creating individual projects.

#### [certificateTemplates](https://github.com/shikshalokam/ml-projects-service/blob/master/DBSchema/certificateTemplates.json)

The certificateTemplates collection will be established for solutions and associated with certificate templates to facilitate the generation of certificates, incorporating predefined criteria.

#### [projectTemplateTasks](https://github.com/shikshalokam/ml-projects-service/blob/master/DBSchema/projectTemplateTasks.json)

The projectTemplateTasks collection will be used to store tasks associated with a specific project template.

#### [programUsers](https://github.com/shikshalokam/ml-projects-service/blob/master/DBSchema/programUsers.json)

The programUsers Collection holds user data of those who have become part of the program and have provided their consent status.

[Click here](https://ml-services-uploads.s3.ap-south-1.amazonaws.com/DBSchema/ML-Project.pdf) for DB schema and corresponding examples in a PDF format.