# sriram750/data-management architecture

> Architecture diagram of the GitHub repository sriram750/data-management, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-07). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/sriram750/data-management
- Repository: https://github.com/sriram750/data-management

## Overview

DataMatrix is a self-hosted dynamic data management platform. Its main user journey is setup or sign-in, then creating and configuring a table, managing records in a grid, and using import, export, document, and analytics capabilities. The React application calls a FastAPI API backed by PostgreSQL; backend services implement domain operations, authorization, encryption, versioning, and audit. The graph preserves README-described capabilities whose individual implementation paths were not sampled; those links are omitted or marked unverified rather than inferred from names alone.

Main entry points: [`frontend/src/App.tsx`](https://github.com/sriram750/data-management/blob/main/frontend/src/App.tsx) (App routing), [`frontend/src/api/client.ts`](https://github.com/sriram750/data-management/blob/main/frontend/src/api/client.ts) (API client), [`backend/app/services/audit_service.py`](https://github.com/sriram750/data-management/blob/main/backend/app/services/audit_service.py) (Audit service), [`backend/app/services/record_service.py`](https://github.com/sriram750/data-management/blob/main/backend/app/services/record_service.py) (Record service)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web application"]
  node_app["App routing<br/>[App.tsx]"]
  node_authctx["Auth state<br/>[AuthContext.tsx]"]
  node_apiclient["API client<br/>[client.ts]"]
  node_setupui["Setup and login"]
  node_tableui["Table management<br/>[TableListPage.tsx]"]
  node_gridui["Record grid"]
  node_importui["Excel import"]
  node_docsui["Document studio<br/>[DocumentsPage.tsx]"]
  node_dashui["Dashboard<br/>[DashboardPage.tsx]"]
  node_securityui["Security and audit UI<br/>[UsersPage.tsx]"]
end

subgraph group_api["API and identity"]
  node_apiroot["FastAPI application<br/>[main.py]"]
  node_authapi["Authentication routes<br/>[auth.py]"]
  node_authsvc["Authentication service<br/>[auth_service.py]"]
  node_ldap["LDAP provider<br/>[auth_provider.py]"]
end

subgraph group_data["Dynamic data"]
  node_tablesvc["Table and column services<br/>[table_service.py]"]
  node_recordsvc["Record service<br/>[record_service.py]"]
  node_datamodels["Dynamic data models<br/>[dynamic_table.py]"]
  node_database["Database session layer<br/>[database.py]"]
end

subgraph group_operations["Data operations"]
  node_importsvc["Import service<br/>[import_service.py]"]
  node_exports["Export service<br/>[export_service.py]"]
  node_attachments["Attachment service"]
end

subgraph group_trust["Security and oversight"]
  node_audit["Audit service<br/>[audit_service.py]"]
  node_rbac["RBAC service<br/>[rbac_service.py]"]
  node_encryption["Field encryption<br/>[encryption.py]"]
end

node_user(("Organization user"))
node_postgres[("PostgreSQL")]

node_user -->|"uses"| node_app
node_app -->|"provides auth"| node_authctx
node_app -->|"routes to"| node_setupui
node_app -->|"routes to"| node_tableui
node_app -->|"routes to"| node_gridui
node_app -->|"routes to"| node_importui
node_app -->|"routes to"| node_docsui
node_app -->|"routes to"| node_dashui
node_app -->|"routes to"| node_securityui
node_authctx -->|"requests status"| node_apiclient
node_setupui -.->|"submits credentials"| node_apiclient
node_tableui -->|"requests tables"| node_apiclient
node_gridui -->|"requests records"| node_apiclient
node_importui -.->|"uploads data"| node_apiclient
node_docsui -->|"requests documents"| node_apiclient
node_apiclient -->|"calls REST API"| node_apiroot
node_apiroot -->|"registers routes"| node_authapi
node_authapi -->|"delegates auth"| node_authsvc
node_authsvc -->|"loads permissions"| node_rbac
node_authsvc -->|"records events"| node_audit
node_authsvc -.->|"may authenticate"| node_ldap
node_tablesvc -->|"uses models"| node_datamodels
node_recordsvc -->|"uses models"| node_datamodels
node_recordsvc -->|"checks access"| node_rbac
node_recordsvc -->|"records changes"| node_audit
node_recordsvc -->|"encrypts fields"| node_encryption
node_importsvc -->|"uses table logic"| node_tablesvc
node_importsvc -->|"checks access"| node_rbac
node_importsvc -->|"records imports"| node_audit
node_exports -.->|"audits exports"| node_audit
node_attachments -->|"records events"| node_audit
node_datamodels -->|"uses base"| node_database
node_database -.->|"connects to"| node_postgres

click node_app "https://github.com/sriram750/data-management/blob/main/frontend/src/App.tsx"
click node_authctx "https://github.com/sriram750/data-management/blob/main/frontend/src/context/AuthContext.tsx"
click node_apiclient "https://github.com/sriram750/data-management/blob/main/frontend/src/api/client.ts"
click node_setupui "https://github.com/sriram750/data-management/blob/main/frontend/src/features/auth/SetupWizardPage.tsx"
click node_tableui "https://github.com/sriram750/data-management/blob/main/frontend/src/features/tables/TableListPage.tsx"
click node_gridui "https://github.com/sriram750/data-management/blob/main/frontend/src/features/records/DynamicGridPage.tsx"
click node_importui "https://github.com/sriram750/data-management/blob/main/frontend/src/features/imports/ExcelImportWizard.tsx"
click node_docsui "https://github.com/sriram750/data-management/blob/main/frontend/src/features/documents/DocumentsPage.tsx"
click node_dashui "https://github.com/sriram750/data-management/blob/main/frontend/src/features/dashboard/DashboardPage.tsx"
click node_securityui "https://github.com/sriram750/data-management/blob/main/frontend/src/features/security/UsersPage.tsx"
click node_apiroot "https://github.com/sriram750/data-management/blob/main/backend/app/main.py"
click node_authapi "https://github.com/sriram750/data-management/blob/main/backend/app/api/v1/auth.py"
click node_authsvc "https://github.com/sriram750/data-management/blob/main/backend/app/services/auth_service.py"
click node_ldap "https://github.com/sriram750/data-management/blob/main/backend/app/ldap/auth_provider.py"
click node_tablesvc "https://github.com/sriram750/data-management/blob/main/backend/app/services/table_service.py"
click node_recordsvc "https://github.com/sriram750/data-management/blob/main/backend/app/services/record_service.py"
click node_datamodels "https://github.com/sriram750/data-management/blob/main/backend/app/models/dynamic_table.py"
click node_importsvc "https://github.com/sriram750/data-management/blob/main/backend/app/services/import_service.py"
click node_exports "https://github.com/sriram750/data-management/blob/main/backend/app/services/export_service.py"
click node_attachments "https://github.com/sriram750/data-management/blob/main/backend/app/services/attachment_service.py"
click node_audit "https://github.com/sriram750/data-management/blob/main/backend/app/services/audit_service.py"
click node_rbac "https://github.com/sriram750/data-management/blob/main/backend/app/services/rbac_service.py"
click node_encryption "https://github.com/sriram750/data-management/blob/main/backend/app/core/encryption.py"
click node_database "https://github.com/sriram750/data-management/blob/main/backend/app/core/database.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_app,node_authctx,node_apiclient,node_setupui,node_tableui,node_gridui,node_importui,node_docsui,node_dashui,node_securityui,node_user toneBlue
class node_apiroot,node_authapi,node_authsvc,node_ldap,node_postgres toneAmber
class node_tablesvc,node_recordsvc,node_datamodels,node_database toneMint
class node_importsvc,node_exports,node_attachments toneRose
class node_audit,node_rbac,node_encryption toneIndigo
```

## Components

### Web application

- [App routing](https://github.com/sriram750/data-management/blob/main/frontend/src/App.tsx): `frontend/src/App.tsx`
- [Auth state](https://github.com/sriram750/data-management/blob/main/frontend/src/context/AuthContext.tsx): `frontend/src/context/AuthContext.tsx`
- [API client](https://github.com/sriram750/data-management/blob/main/frontend/src/api/client.ts): `frontend/src/api/client.ts`
- [Setup and login](https://github.com/sriram750/data-management/blob/main/frontend/src/features/auth/SetupWizardPage.tsx): `frontend/src/features/auth/SetupWizardPage.tsx`
- [Table management](https://github.com/sriram750/data-management/blob/main/frontend/src/features/tables/TableListPage.tsx): `frontend/src/features/tables/TableListPage.tsx`
- [Record grid](https://github.com/sriram750/data-management/blob/main/frontend/src/features/records/DynamicGridPage.tsx): `frontend/src/features/records/DynamicGridPage.tsx`
- [Excel import](https://github.com/sriram750/data-management/blob/main/frontend/src/features/imports/ExcelImportWizard.tsx): `frontend/src/features/imports/ExcelImportWizard.tsx`
- [Document studio](https://github.com/sriram750/data-management/blob/main/frontend/src/features/documents/DocumentsPage.tsx): `frontend/src/features/documents/DocumentsPage.tsx`
- [Dashboard](https://github.com/sriram750/data-management/blob/main/frontend/src/features/dashboard/DashboardPage.tsx): `frontend/src/features/dashboard/DashboardPage.tsx`
- [Security and audit UI](https://github.com/sriram750/data-management/blob/main/frontend/src/features/security/UsersPage.tsx): `frontend/src/features/security/UsersPage.tsx`

### API and identity

- [FastAPI application](https://github.com/sriram750/data-management/blob/main/backend/app/main.py): `backend/app/main.py`
- [Authentication routes](https://github.com/sriram750/data-management/blob/main/backend/app/api/v1/auth.py): `backend/app/api/v1/auth.py`
- [Authentication service](https://github.com/sriram750/data-management/blob/main/backend/app/services/auth_service.py): `backend/app/services/auth_service.py`
- [LDAP provider](https://github.com/sriram750/data-management/blob/main/backend/app/ldap/auth_provider.py): `backend/app/ldap/auth_provider.py`

### Dynamic data

- [Table and column services](https://github.com/sriram750/data-management/blob/main/backend/app/services/table_service.py): `backend/app/services/table_service.py`
- [Record service](https://github.com/sriram750/data-management/blob/main/backend/app/services/record_service.py): `backend/app/services/record_service.py`
- [Dynamic data models](https://github.com/sriram750/data-management/blob/main/backend/app/models/dynamic_table.py): `backend/app/models/dynamic_table.py`
- [Database session layer](https://github.com/sriram750/data-management/blob/main/backend/app/core/database.py): `backend/app/core/database.py`

### Data operations

- [Import service](https://github.com/sriram750/data-management/blob/main/backend/app/services/import_service.py): `backend/app/services/import_service.py`
- [Export service](https://github.com/sriram750/data-management/blob/main/backend/app/services/export_service.py): `backend/app/services/export_service.py`
- [Attachment service](https://github.com/sriram750/data-management/blob/main/backend/app/services/attachment_service.py): `backend/app/services/attachment_service.py`

### Security and oversight

- [Audit service](https://github.com/sriram750/data-management/blob/main/backend/app/services/audit_service.py): `backend/app/services/audit_service.py`
- [RBAC service](https://github.com/sriram750/data-management/blob/main/backend/app/services/rbac_service.py): `backend/app/services/rbac_service.py`
- [Field encryption](https://github.com/sriram750/data-management/blob/main/backend/app/core/encryption.py): `backend/app/core/encryption.py`

### Other components

- **Organization user**
- **PostgreSQL**

## Connections

- Organization user → App routing: uses (evidence: `frontend/src/App.tsx`)
- App routing → Auth state: provides auth (evidence: `frontend/src/App.tsx`)
- App routing → Setup and login: routes to (evidence: `frontend/src/App.tsx`)
- App routing → Table management: routes to (evidence: `frontend/src/App.tsx`)
- App routing → Record grid: routes to (evidence: `frontend/src/App.tsx`)
- App routing → Excel import: routes to (evidence: `frontend/src/App.tsx`)
- App routing → Document studio: routes to (evidence: `frontend/src/App.tsx`)
- App routing → Dashboard: routes to (evidence: `frontend/src/App.tsx`)
- App routing → Security and audit UI: routes to (evidence: `frontend/src/App.tsx`)
- Auth state → API client: requests status (evidence: `frontend/src/context/AuthContext.tsx`)
- Setup and login → API client: submits credentials
- Table management → API client: requests tables (evidence: `frontend/src/features/tables/TableListPage.tsx`)
- Record grid → API client: requests records (evidence: `frontend/src/features/records/DynamicGridPage.tsx`)
- Excel import → API client: uploads data
- Document studio → API client: requests documents (evidence: `frontend/src/features/documents/DocumentsPage.tsx`)
- API client → FastAPI application: calls REST API (evidence: `README.md`)
- FastAPI application → Authentication routes: registers routes (evidence: `backend/app/main.py`)
- Authentication routes → Authentication service: delegates auth (evidence: `backend/app/api/v1/auth.py`)
- Authentication service → RBAC service: loads permissions (evidence: `backend/app/services/auth_service.py`)
- Authentication service → Audit service: records events (evidence: `backend/app/services/auth_service.py`)
- Authentication service → LDAP provider: may authenticate
- Table and column services → Dynamic data models: uses models (evidence: `backend/app/services/table_service.py`)
- Record service → Dynamic data models: uses models (evidence: `backend/app/services/record_service.py`)
- Record service → RBAC service: checks access (evidence: `backend/app/services/record_service.py`)
- Record service → Audit service: records changes (evidence: `backend/app/services/record_service.py`)
- Record service → Field encryption: encrypts fields (evidence: `backend/app/services/record_service.py`)
- Import service → Table and column services: uses table logic (evidence: `backend/app/services/import_service.py`)
- Import service → RBAC service: checks access (evidence: `backend/app/services/import_service.py`)
- Import service → Audit service: records imports (evidence: `backend/app/services/import_service.py`)
- Export service → Audit service: audits exports
- Attachment service → Audit service: records events (evidence: `backend/app/services/attachment_service.py`)
- Dynamic data models → Database session layer: uses base (evidence: `backend/app/models/dynamic_table.py`)
- Database session layer → PostgreSQL: connects to
