# gauravbalodi123/turtle_finance_dashboard architecture

> Architecture diagram of the GitHub repository gauravbalodi123/turtle_finance_dashboard, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-09-16). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/gauravbalodi123/turtle_finance_dashboard
- Repository: https://github.com/gauravbalodi123/turtle_finance_dashboard

## Overview

##### Enumerate the Key Collections
- users
- advisors
- clients
- bookings
- tasks
- rowwisetasks
- subscriptionplans
- payments
- digioresponses
- files
- kycdata
- riskprofiles
- prospects
- members
- comments
- various form data (investmentForm, insuranceForm, taxPlanningForm, willDraftingForm, creditCardForm)

##### Collection Relationships
- bookings → users (refers to the client who booked)
- bookings → advisors
- tasks → users (owner/creator)
- rowwisetasks → tasks
- clients → riskprofiles
- clients → kycdata
- clients → digioresponses
- clients → payments
- subscriptionplans → users (active subscription)
- members → users (activated members)
- prospects → advisors (assigned prospect)
- comments → bookings or tasks (comment context)
- Use arrowheads to indicate “references” (e.g., ObjectId FK).

##### Indexes and Unique Constraints (optional)
- For critical collections (users, advisors), mark unique indexed fields such as email or userId.
- Notate them in small italics under each collection name.

##### Backup and Seed Scripts
- backup26june folder
- turtle-backup folders

- Admin routes → MongoDB
- Client routes → MongoDB
- Calendly/Fireflies integration scripts → MongoDB

##### Detail Level
- Only collections and relationships, not field‐level detail, unless a specific collection’s schema is critical.

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Database
    MongoDB["MongoDB Cluster"]:::db

    %% Collections - User-centric
    subgraph "User & Membership Collections"
        direction TB
        Users["users"]:::collection
        Advisors["advisors"]:::collection
        Clients["clients"]:::collection
        Members["members"]:::collection
        Prospects["prospects"]:::collection
        SubscriptionPlans["subscriptionplans"]:::collection
    end

    %% Collections - Booking-centric
    subgraph "Booking & Comments"
        direction TB
        Bookings["bookings"]:::collection
        Comments["comments"]:::collection
    end

    %% Collections - Task-centric
    subgraph "Task Collections"
        direction TB
        Tasks["tasks"]:::collection
        RowwiseTasks["rowwisetasks"]:::collection
    end

    %% Collections - Form Data
    subgraph "Form Data Collections"
        direction TB
        InvestmentForm["investmentForm"]:::collection
        InsuranceForm["insuranceForm"]:::collection
        TaxPlanningForm["taxPlanningForm"]:::collection
        WillDraftingForm["willDraftingForm"]:::collection
        CreditCardForm["creditCardForm"]:::collection
    end

    %% Collections - Financial & KYC
    subgraph "Financial & KYC Collections"
        direction TB
        Payments["payments"]:::collection
        DigioResponses["digioresponses"]:::collection
        KycData["kycdata"]:::collection
        RiskProfiles["riskprofiles"]:::collection
        Files["files"]:::collection
    end

    %% Relationships between collections (references)
    Bookings -->|refers to client| Users
    Bookings -->|refers to advisor| Advisors
    Comments -->|context of booking/task| Bookings
    Comments -->|context of booking/task| Tasks
    Tasks -->|owner/creator| Users
    RowwiseTasks -->|belongs to task| Tasks
    Clients -->|has risk profile| RiskProfiles
    Clients -->|has kyc data| KycData
    Clients -->|has digio responses| DigioResponses
    Clients -->|has payments| Payments
    SubscriptionPlans -->|active subscription| Users
    Members -->|activated member| Users
    Prospects -->|assigned to advisor| Advisors

    %% Data Flow from Services to DB
    subgraph "Backend Routes"
        direction LR
        AdminRoutes["Admin Routes"]:::service
        ClientRoutes["Client Routes"]:::service
        IntegrationScripts["Calendly/Fireflies Integration"]:::service
    end

    AdminRoutes -->|CRUD| MongoDB
    ClientRoutes -->|CRUD| MongoDB
    IntegrationScripts -->|Read/Write| MongoDB

    %% Backup and Seed Jobs
    subgraph "Auxiliary Jobs" 
        direction TB
        BackupRestore["Backup / Restore"]:::job
        SeedScripts["Seed Scripts"]:::job
    end

    BackupRestore -->|backup/restore| MongoDB
    SeedScripts -->|seed data| MongoDB

    %% Click Events for models
    click Users "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/user.js"
    click Advisors "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/advisor.js"
    click Clients "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/client.js"
    click Bookings "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/booking.js"
    click Tasks "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/task.js"
    click RowwiseTasks "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/rowwisetask.js"
    click SubscriptionPlans "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/subscription.js"
    click Payments "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/payment.js"
    click DigioResponses "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/digioResponse.js"
    click Files "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/fileModel.js"
    click KycData "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/kycData.js"
    click RiskProfiles "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/riskProfile.js"
    click Prospects "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/prospect.js"
    click Members "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/member.js"
    click Comments "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/comment.js"
    click InvestmentForm "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/investmentForm.js"
    click InsuranceForm "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/insuranceForm.js"
    click TaxPlanningForm "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/taxPlanningForm.js"
    click WillDraftingForm "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/willDraftingForm.js"
    click CreditCardForm "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/models/creditCardForm.js"
    click BackupRestore "https://github.com/gauravbalodi123/turtle_finance_dashboard/tree/main/backend/backup26june/turtle-finance-db/"
    click BackupRestore "https://github.com/gauravbalodi123/turtle_finance_dashboard/tree/main/backend/turtle-backup/turtle-finance-db/"
    click SeedScripts "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/seed.js"
    click SeedScripts "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/advisorsSeed.js"
    click SeedScripts "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/prospectseed.js"
    click SeedScripts "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/tasksSeed.js"
    click SeedScripts "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/clientseed.js"
    click SeedScripts "https://github.com/gauravbalodi123/turtle_finance_dashboard/blob/main/backend/seedRowWiseTasksFromTranscript.js"

    %% Styles
    classDef db fill:#d1e8ff,stroke:#1f77b4,stroke-width:2px;
    classDef collection fill:#eef7ff,stroke:#1f77b4,stroke-width:1px;
    classDef service fill:#e0ffe0,stroke:#2ca02c,stroke-width:1px;
    classDef job fill:#fcf8e3,stroke:#ff7f0e,stroke-width:1px;
```
