# wizardpoka/albom architecture

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

- Interactive diagram: https://gitdiagram.com/wizardpoka/albom
- Repository: https://github.com/wizardpoka/albom

## Overview

This is a university timetable viewer. The main workflow uploads an Excel schedule, parses it into week/group/day/lesson records, persists those records, then lets users browse groups or search teachers and classrooms. The client also renders teacher- and classroom-specific schedules. The API and persistence calls are visible in sampled source; teacher-page retrieval is retained as a documented route capability, but its request implementation was not sampled.

Main entry points: [`server/main.py`](https://github.com/wizardpoka/albom/blob/main/server/main.py) (FastAPI endpoints), [`client/src/App.jsx`](https://github.com/wizardpoka/albom/blob/main/client/src/App.jsx) (App routing), [`client/src/components/TeacherSchedulePage.jsx`](https://github.com/wizardpoka/albom/blob/main/client/src/components/TeacherSchedulePage.jsx) (Teacher schedule page), [`client/src/components/ClassroomSchedulePage.jsx`](https://github.com/wizardpoka/albom/blob/main/client/src/components/ClassroomSchedulePage.jsx) (Classroom schedule page)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_client["Web client"]
  node_app["App routing<br/>[App.jsx]"]
  node_upload["Excel upload<br/>[UploadFile.jsx]"]
  node_groups["Group list<br/>[ListGroups.jsx]"]
  node_search["Teacher/classroom search<br/>[Search.jsx]"]
  node_groupview["Group schedule view<br/>[GroupSchedule.jsx]"]
  node_teacherpage["Teacher schedule page"]
  node_teacherview["Teacher schedule display"]
  node_classroompage["Classroom schedule page"]
  node_classroomview["Classroom schedule display"]
end

subgraph group_api["Schedule API"]
  node_api["FastAPI endpoints<br/>[main.py]"]
  node_schema["Schedule schemas<br/>[pydantic_model.py]"]
end

subgraph group_data["Schedule data"]
  node_dbaccess["Schedule queries and writes"]
  node_orm["Relational models<br/>[database_models.py]"]
  node_sqlite[("SQLite schedule store<br/>[test.db]")]
end

node_user(("Timetable user"))

node_user -->|"uses"| node_app
node_app -->|"routes to"| node_upload
node_app -->|"routes to"| node_groups
node_app -->|"routes to"| node_groupview
node_app -->|"routes to"| node_teacherpage
node_app -->|"routes to"| node_classroompage
node_groups -->|"renders"| node_search
node_upload -->|"uploads workbook"| node_api
node_search -->|"requests matches"| node_api
node_groupview -->|"requests group schedule"| node_api
node_classroompage -->|"requests room schedule"| node_api
node_classroompage -->|"renders"| node_classroomview
node_teacherpage -->|"renders"| node_teacherview
node_teacherpage -.->|"requests teacher schedule"| node_api
node_api -->|"uses schemas"| node_schema
node_api -->|"calls schedule data functions"| node_dbaccess
node_dbaccess -->|"queries and persists"| node_orm
node_dbaccess -->|"reads and writes"| node_sqlite

click node_app "https://github.com/wizardpoka/albom/blob/main/client/src/App.jsx"
click node_upload "https://github.com/wizardpoka/albom/blob/main/client/src/components/UploadFile/UploadFile.jsx"
click node_groups "https://github.com/wizardpoka/albom/blob/main/client/src/components/ListGroups/ListGroups.jsx"
click node_search "https://github.com/wizardpoka/albom/blob/main/client/src/components/Search.jsx"
click node_groupview "https://github.com/wizardpoka/albom/blob/main/client/src/components/GroupSchedule/GroupSchedule.jsx"
click node_teacherpage "https://github.com/wizardpoka/albom/blob/main/client/src/components/TeacherSchedulePage.jsx"
click node_teacherview "https://github.com/wizardpoka/albom/blob/main/client/src/components/TeacherSchedule.jsx"
click node_classroompage "https://github.com/wizardpoka/albom/blob/main/client/src/components/ClassroomSchedulePage.jsx"
click node_classroomview "https://github.com/wizardpoka/albom/blob/main/client/src/components/ClassroomSchedule.jsx"
click node_api "https://github.com/wizardpoka/albom/blob/main/server/main.py"
click node_schema "https://github.com/wizardpoka/albom/blob/main/server/pydantic_model.py"
click node_dbaccess "https://github.com/wizardpoka/albom/blob/main/server/database/database_functions.py"
click node_orm "https://github.com/wizardpoka/albom/blob/main/server/database/database_models.py"
click node_sqlite "https://github.com/wizardpoka/albom/blob/main/test.db"

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_upload,node_groups,node_search,node_groupview,node_teacherpage,node_teacherview,node_classroompage,node_classroomview,node_user toneBlue
class node_api,node_schema toneAmber
class node_dbaccess,node_orm,node_sqlite toneMint
```

## Components

### Web client

- [App routing](https://github.com/wizardpoka/albom/blob/main/client/src/App.jsx): `client/src/App.jsx`
- [Excel upload](https://github.com/wizardpoka/albom/blob/main/client/src/components/UploadFile/UploadFile.jsx): `client/src/components/UploadFile/UploadFile.jsx`
- [Group list](https://github.com/wizardpoka/albom/blob/main/client/src/components/ListGroups/ListGroups.jsx): `client/src/components/ListGroups/ListGroups.jsx`
- [Teacher/classroom search](https://github.com/wizardpoka/albom/blob/main/client/src/components/Search.jsx): `client/src/components/Search.jsx`
- [Group schedule view](https://github.com/wizardpoka/albom/blob/main/client/src/components/GroupSchedule/GroupSchedule.jsx): `client/src/components/GroupSchedule/GroupSchedule.jsx`
- [Teacher schedule page](https://github.com/wizardpoka/albom/blob/main/client/src/components/TeacherSchedulePage.jsx): `client/src/components/TeacherSchedulePage.jsx`
- [Teacher schedule display](https://github.com/wizardpoka/albom/blob/main/client/src/components/TeacherSchedule.jsx): `client/src/components/TeacherSchedule.jsx`
- [Classroom schedule page](https://github.com/wizardpoka/albom/blob/main/client/src/components/ClassroomSchedulePage.jsx): `client/src/components/ClassroomSchedulePage.jsx`
- [Classroom schedule display](https://github.com/wizardpoka/albom/blob/main/client/src/components/ClassroomSchedule.jsx): `client/src/components/ClassroomSchedule.jsx`

### Schedule API

- [FastAPI endpoints](https://github.com/wizardpoka/albom/blob/main/server/main.py): `server/main.py`
- [Schedule schemas](https://github.com/wizardpoka/albom/blob/main/server/pydantic_model.py): `server/pydantic_model.py`

### Schedule data

- [Schedule queries and writes](https://github.com/wizardpoka/albom/blob/main/server/database/database_functions.py): `server/database/database_functions.py`
- [Relational models](https://github.com/wizardpoka/albom/blob/main/server/database/database_models.py): `server/database/database_models.py`
- [SQLite schedule store](https://github.com/wizardpoka/albom/blob/main/test.db): `test.db`

### Other components

- **Timetable user**

## Connections

- Timetable user → App routing: uses
- App routing → Excel upload: routes to (evidence: `client/src/App.jsx`)
- App routing → Group list: routes to (evidence: `client/src/App.jsx`)
- App routing → Group schedule view: routes to (evidence: `client/src/App.jsx`)
- App routing → Teacher schedule page: routes to (evidence: `client/src/App.jsx`)
- App routing → Classroom schedule page: routes to (evidence: `client/src/App.jsx`)
- Group list → Teacher/classroom search: renders (evidence: `client/src/components/ListGroups/ListGroups.jsx`)
- Excel upload → FastAPI endpoints: uploads workbook (evidence: `client/src/components/UploadFile/UploadFile.jsx`)
- Teacher/classroom search → FastAPI endpoints: requests matches (evidence: `client/src/components/Search.jsx`)
- Group schedule view → FastAPI endpoints: requests group schedule (evidence: `client/src/components/GroupSchedule/GroupSchedule.jsx`)
- Classroom schedule page → FastAPI endpoints: requests room schedule (evidence: `client/src/components/ClassroomSchedulePage.jsx`)
- Classroom schedule page → Classroom schedule display: renders (evidence: `client/src/components/ClassroomSchedulePage.jsx`)
- Teacher schedule page → Teacher schedule display: renders (evidence: `client/src/components/TeacherSchedulePage.jsx`)
- Teacher schedule page → FastAPI endpoints: requests teacher schedule
- FastAPI endpoints → Schedule schemas: uses schemas (evidence: `server/main.py`)
- FastAPI endpoints → Schedule queries and writes: calls schedule data functions (evidence: `server/main.py`)
- Schedule queries and writes → Relational models: queries and persists (evidence: `server/database/database_functions.py`)
- Schedule queries and writes → SQLite schedule store: reads and writes (evidence: `server/database/database_functions.py`)
