# siper7503/sgsis architecture

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

- Interactive diagram: https://gitdiagram.com/siper7503/sgsis
- Repository: https://github.com/siper7503/sgsis

## Overview

This is a school-infrastructure management system: authenticated school and administrative users maintain establishment and sector records, submit and review module data, and consult dashboards and reports. The frontend routes users into domain pages; API requests reach an Express backend, which applies authentication and workflow rules and persists records in PostgreSQL. The README also documents offline request queuing and cached reads. Some domain pages and server code were not excerpted, so their internal call paths are not expanded here.

Main entry points: [`src/App.tsx`](https://github.com/siper7503/sgsis/blob/main/src/App.tsx) (Application router), [`src/db/schema.ts`](https://github.com/siper7503/sgsis/blob/main/src/db/schema.ts) (PostgreSQL data), [`server.ts`](https://github.com/siper7503/sgsis/blob/main/server.ts) (Express API), [`src/middleware/auth.ts`](https://github.com/siper7503/sgsis/blob/main/src/middleware/auth.ts) (Request authentication)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_client["Web application"]
  node_app["Application router<br/>[App.tsx]"]
  node_api_client["API client<br/>[api.ts]"]
  node_offline_sync["Offline queue and cache<br/>[sync.ts]"]
end

subgraph group_identity["Identity and access"]
  node_admin["Administration<br/>[Admin.tsx]"]
  node_auth_provider["Session provider<br/>[AuthProvider.tsx]"]
  node_login["Login<br/>[Login.tsx]"]
  node_auth_middleware["Request authentication<br/>[auth.ts]"]
  node_roles["Roles and policy<br/>[roles.ts]"]
  node_authorization["Authorization rules<br/>[authorization.ts]"]
end

subgraph group_operations["School operations"]
  node_establishments["Establishments<br/>[Etablissements.tsx]"]
  node_infrastructure["Infrastructure"]
  node_sector_data["Sector modules"]
  node_module_forms["Module forms"]
end

subgraph group_reporting["Reporting and oversight"]
  node_dashboard["Dashboard<br/>[Dashboard.tsx]"]
  node_annual_reports["Annual reports"]
  node_reports["Reports and audit<br/>[Rapports.tsx]"]
  node_visitor_reports["Public report views"]
end

subgraph group_backend["API and persistence"]
  node_server["Express API<br/>[server.ts]"]
  node_annual_routes["Annual report routes<br/>[annual-reports.ts]"]
  node_facility_routes["Facility routes<br/>[facilities.ts]"]
  node_workflow["Submission workflow<br/>[module-workflow.ts]"]
  node_database[("PostgreSQL data<br/>[schema.ts]")]
  node_db_connection["Database connection<br/>[index.ts]"]
end

node_user(("School or admin user"))
node_firebase["Firebase Auth"]

node_user -->|"uses"| node_app
node_app -->|"routes to"| node_dashboard
node_app -->|"routes to"| node_establishments
node_app -->|"routes to"| node_infrastructure
node_app -->|"routes to"| node_sector_data
node_app -->|"routes to"| node_annual_reports
node_app -->|"routes to"| node_reports
node_app -->|"routes to"| node_admin
node_app -->|"routes to"| node_visitor_reports
node_app -->|"provides session"| node_auth_provider
node_establishments -->|"uses forms"| node_module_forms
node_infrastructure -->|"uses forms"| node_module_forms
node_dashboard -->|"fetches statistics"| node_api_client
node_auth_provider -->|"observes auth"| node_firebase
node_login -->|"sets session"| node_auth_provider
node_api_client -->|"queues writes"| node_offline_sync
node_server -->|"uses authentication"| node_auth_middleware
node_server -->|"registers routes"| node_annual_routes
node_server -->|"registers routes"| node_facility_routes
node_server -->|"invokes workflow"| node_workflow
node_auth_middleware -->|"checks account"| node_database
node_auth_middleware -->|"verifies token"| node_firebase
node_auth_middleware -.->|"resolves role"| node_roles
node_annual_routes -->|"uses workflow"| node_workflow
node_facility_routes -->|"uses workflow"| node_workflow
node_workflow -->|"reads and writes"| node_database
node_annual_routes -->|"reads and writes"| node_database
node_facility_routes -->|"reads and writes"| node_database
node_db_connection -->|"loads schema"| node_database
node_authorization -->|"uses role sets"| node_roles

click node_app "https://github.com/siper7503/sgsis/blob/main/src/App.tsx"
click node_dashboard "https://github.com/siper7503/sgsis/blob/main/src/pages/Dashboard.tsx"
click node_establishments "https://github.com/siper7503/sgsis/blob/main/src/pages/Etablissements.tsx"
click node_infrastructure "https://github.com/siper7503/sgsis/blob/main/src/pages/Infrastructures.tsx"
click node_sector_data "https://github.com/siper7503/sgsis/tree/main/src/pages"
click node_module_forms "https://github.com/siper7503/sgsis/tree/main/src/components"
click node_annual_reports "https://github.com/siper7503/sgsis/blob/main/src/pages/RapportsAnnuels.tsx"
click node_reports "https://github.com/siper7503/sgsis/blob/main/src/pages/Rapports.tsx"
click node_admin "https://github.com/siper7503/sgsis/blob/main/src/pages/Admin.tsx"
click node_visitor_reports "https://github.com/siper7503/sgsis/blob/main/src/pages/PublicAnnualReports.tsx"
click node_auth_provider "https://github.com/siper7503/sgsis/blob/main/src/components/AuthProvider.tsx"
click node_login "https://github.com/siper7503/sgsis/blob/main/src/components/Login.tsx"
click node_auth_middleware "https://github.com/siper7503/sgsis/blob/main/src/middleware/auth.ts"
click node_roles "https://github.com/siper7503/sgsis/blob/main/src/lib/roles.ts"
click node_authorization "https://github.com/siper7503/sgsis/blob/main/src/lib/authorization.ts"
click node_api_client "https://github.com/siper7503/sgsis/blob/main/src/lib/api.ts"
click node_offline_sync "https://github.com/siper7503/sgsis/blob/main/src/lib/sync.ts"
click node_server "https://github.com/siper7503/sgsis/blob/main/server.ts"
click node_annual_routes "https://github.com/siper7503/sgsis/blob/main/src/server/routes/annual-reports.ts"
click node_facility_routes "https://github.com/siper7503/sgsis/blob/main/src/server/routes/facilities.ts"
click node_workflow "https://github.com/siper7503/sgsis/blob/main/src/server/module-workflow.ts"
click node_database "https://github.com/siper7503/sgsis/blob/main/src/db/schema.ts"
click node_db_connection "https://github.com/siper7503/sgsis/blob/main/src/db/index.ts"

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_api_client,node_offline_sync,node_user toneBlue
class node_admin,node_auth_provider,node_login,node_auth_middleware,node_roles,node_authorization toneAmber
class node_establishments,node_infrastructure,node_sector_data,node_module_forms toneMint
class node_dashboard,node_annual_reports,node_reports,node_visitor_reports toneRose
class node_server,node_annual_routes,node_facility_routes,node_workflow,node_database,node_db_connection,node_firebase toneIndigo
```

## Components

### Web application

- [Application router](https://github.com/siper7503/sgsis/blob/main/src/App.tsx): `src/App.tsx`
- [API client](https://github.com/siper7503/sgsis/blob/main/src/lib/api.ts): `src/lib/api.ts`
- [Offline queue and cache](https://github.com/siper7503/sgsis/blob/main/src/lib/sync.ts): `src/lib/sync.ts`

### Identity and access

- [Administration](https://github.com/siper7503/sgsis/blob/main/src/pages/Admin.tsx): `src/pages/Admin.tsx`
- [Session provider](https://github.com/siper7503/sgsis/blob/main/src/components/AuthProvider.tsx): `src/components/AuthProvider.tsx`
- [Login](https://github.com/siper7503/sgsis/blob/main/src/components/Login.tsx): `src/components/Login.tsx`
- [Request authentication](https://github.com/siper7503/sgsis/blob/main/src/middleware/auth.ts): `src/middleware/auth.ts`
- [Roles and policy](https://github.com/siper7503/sgsis/blob/main/src/lib/roles.ts): `src/lib/roles.ts`
- [Authorization rules](https://github.com/siper7503/sgsis/blob/main/src/lib/authorization.ts): `src/lib/authorization.ts`

### School operations

- [Establishments](https://github.com/siper7503/sgsis/blob/main/src/pages/Etablissements.tsx): `src/pages/Etablissements.tsx`
- [Infrastructure](https://github.com/siper7503/sgsis/blob/main/src/pages/Infrastructures.tsx): `src/pages/Infrastructures.tsx`
- [Sector modules](https://github.com/siper7503/sgsis/tree/main/src/pages): `src/pages`
- [Module forms](https://github.com/siper7503/sgsis/tree/main/src/components): `src/components`

### Reporting and oversight

- [Dashboard](https://github.com/siper7503/sgsis/blob/main/src/pages/Dashboard.tsx): `src/pages/Dashboard.tsx`
- [Annual reports](https://github.com/siper7503/sgsis/blob/main/src/pages/RapportsAnnuels.tsx): `src/pages/RapportsAnnuels.tsx`
- [Reports and audit](https://github.com/siper7503/sgsis/blob/main/src/pages/Rapports.tsx): `src/pages/Rapports.tsx`
- [Public report views](https://github.com/siper7503/sgsis/blob/main/src/pages/PublicAnnualReports.tsx): `src/pages/PublicAnnualReports.tsx`

### API and persistence

- [Express API](https://github.com/siper7503/sgsis/blob/main/server.ts): `server.ts`
- [Annual report routes](https://github.com/siper7503/sgsis/blob/main/src/server/routes/annual-reports.ts): `src/server/routes/annual-reports.ts`
- [Facility routes](https://github.com/siper7503/sgsis/blob/main/src/server/routes/facilities.ts): `src/server/routes/facilities.ts`
- [Submission workflow](https://github.com/siper7503/sgsis/blob/main/src/server/module-workflow.ts): `src/server/module-workflow.ts`
- [PostgreSQL data](https://github.com/siper7503/sgsis/blob/main/src/db/schema.ts): `src/db/schema.ts`
- [Database connection](https://github.com/siper7503/sgsis/blob/main/src/db/index.ts): `src/db/index.ts`

### Other components

- **School or admin user**
- **Firebase Auth**

## Connections

- School or admin user → Application router: uses (evidence: `src/App.tsx`)
- Application router → Dashboard: routes to (evidence: `src/App.tsx`)
- Application router → Establishments: routes to (evidence: `src/App.tsx`)
- Application router → Infrastructure: routes to (evidence: `src/App.tsx`)
- Application router → Sector modules: routes to (evidence: `src/App.tsx`)
- Application router → Annual reports: routes to (evidence: `src/App.tsx`)
- Application router → Reports and audit: routes to (evidence: `src/App.tsx`)
- Application router → Administration: routes to (evidence: `src/App.tsx`)
- Application router → Public report views: routes to (evidence: `src/App.tsx`)
- Application router → Session provider: provides session (evidence: `src/App.tsx`)
- Establishments → Module forms: uses forms (evidence: `src/pages/Etablissements.tsx`)
- Infrastructure → Module forms: uses forms (evidence: `src/pages/Infrastructures.tsx`)
- Dashboard → API client: fetches statistics (evidence: `src/pages/Dashboard.tsx`)
- Session provider → Firebase Auth: observes auth (evidence: `src/components/AuthProvider.tsx`)
- Login → Session provider: sets session (evidence: `src/components/Login.tsx`)
- API client → Offline queue and cache: queues writes (evidence: `src/lib/api.ts`)
- Express API → Request authentication: uses authentication (evidence: `server.ts`)
- Express API → Annual report routes: registers routes (evidence: `server.ts`)
- Express API → Facility routes: registers routes (evidence: `server.ts`)
- Express API → Submission workflow: invokes workflow (evidence: `server.ts`)
- Request authentication → PostgreSQL data: checks account (evidence: `src/middleware/auth.ts`)
- Request authentication → Firebase Auth: verifies token (evidence: `src/middleware/auth.ts`)
- Request authentication → Roles and policy: resolves role
- Annual report routes → Submission workflow: uses workflow (evidence: `src/server/routes/annual-reports.ts`)
- Facility routes → Submission workflow: uses workflow (evidence: `src/server/routes/facilities.ts`)
- Submission workflow → PostgreSQL data: reads and writes (evidence: `src/server/module-workflow.ts`)
- Annual report routes → PostgreSQL data: reads and writes (evidence: `src/server/routes/annual-reports.ts`)
- Facility routes → PostgreSQL data: reads and writes (evidence: `src/server/routes/facilities.ts`)
- Database connection → PostgreSQL data: loads schema (evidence: `src/db/index.ts`)
- Authorization rules → Roles and policy: uses role sets (evidence: `src/lib/authorization.ts`)
