How unb-mds/2026-02-tambureteiunb works
Tamburetei UnB combines an academic-data portal with a collaborative course hub. Students browse courses and disciplines, authenticate, and contribute pseudonymous difficulty reports or materials; reports and content can be moderated. A separate ETL capability extracts, anonymizes, and loads academic datasets, while student-contributed statistics are consolidated into quorum-backed analytics. The graph preserves these documented branches. Some API, pipeline, and frontend integrations are unsampled; dashed edges mark relationships not confirmed by excerpts.
Main entry points: main.py FastAPI application · denuncia_service.py Report and moderation rules · doacao_service.py Statistics donations and quorum · database.py PostgreSQL database
Components 30
Student portal
- Web portal
frontend/src/app/page.tsx - Login and signup
frontend/src/services/authService.ts - Course and discipline browsing
frontend/src/app/disciplinas/page.tsx - Difficulty reports
frontend/src/services/difficultyService.ts - Study materials
frontend/components/MateriaisApoio.tsx - Moderation interface
frontend/src/app/moderacao/page.tsx - HTTP client
frontend/src/services/httpClient.ts
API capabilities
- FastAPI application
backend/app/main.py - Authentication routes
backend/app/api/routers/auth.py - Curriculum routes
backend/app/api/routers/catalogo.py - Comments and reports
backend/app/api/routers/comentarios.py - Materials routes
backend/app/api/routers/materiais.py - Moderation routes
backend/app/api/routers/moderacao.py - Consolidated statistics
backend/app/api/routers/estatisticas_consolidadas.py
Persistence and domain
- Auth service
backend/app/services/auth_service.py - Comment service
backend/app/services/comentario_service.py - Report and moderation rules
backend/app/services/denuncia_service.py - User repository
backend/app/repositories/usuario_repo.py - Comment repository
backend/app/repositories/comentario_repo.py - Report repository
backend/app/repositories/denuncia_repo.py - PostgreSQL database
backend/app/core/database.py
Academic data pipeline
- ETL pipeline
backend/app/pipeline/runner.py - SIGAA extraction
backend/app/pipeline/extractors/sigaa_extractor.py - Sanitize and transform
backend/app/pipeline/transformers/sigaa_transformer.py - Database and export loaders
backend/app/pipeline/loaders/db_loader.py
Community analytics
- Statistics donations and quorum
backend/app/services/doacao_service.py - Consolidated statistics repository
backend/app/repositories/estatistica_repo.py - Dashboard and metrics
backend/app/api/routers/dashboard.py
Other components
- Student
- SIGAA and DPO/UnB data
Connections 35
- Student → Web portal: uses
README.md - Web portal → Login and signup: offers sign-in
- Web portal → Course and discipline browsing: browses curriculum
- Student → Difficulty reports: contributes reports
README.md - Student → Study materials: shares materials
README.md - Student → Moderation interface: moderates content
README.md - Login and signup → HTTP client: sends requests
frontend/src/services/authService.ts - Difficulty reports → HTTP client: sends requests
frontend/src/services/difficultyService.ts - HTTP client → FastAPI application: calls API
- FastAPI application → Authentication routes: registers routes
backend/app/main.py - FastAPI application → Curriculum routes: registers routes
backend/app/main.py - FastAPI application → Comments and reports: registers routes
backend/app/main.py - FastAPI application → Materials routes: registers routes
backend/app/main.py - FastAPI application → Moderation routes: registers routes
backend/app/main.py - FastAPI application → Consolidated statistics: registers routes
backend/app/main.py - Authentication routes → Auth service: calls
backend/app/api/routers/auth.py - Auth service → User repository: reads and writes
backend/app/services/auth_service.py - Authentication routes → PostgreSQL database: obtains session
backend/app/api/routers/auth.py - Comments and reports → Comment service: routes comment actions
backend/app/api/routers/comentarios.py - Comments and reports → Report and moderation rules: routes report actions
backend/app/api/routers/comentarios.py - Comment service → Comment repository: queries comments
backend/app/services/comentario_service.py - Report and moderation rules → Report repository: persists reports
backend/app/services/denuncia_service.py - Moderation routes → Report and moderation rules: handles decisions
- Materials routes → Report and moderation rules: supports reported materials
- Comment repository → PostgreSQL database: persists data
- Report repository → PostgreSQL database: persists data
- SIGAA and DPO/UnB data → SIGAA extraction: provides academic data
README.md - ETL pipeline → SIGAA extraction: runs extraction
- SIGAA extraction → Sanitize and transform: transforms records
backend/app/pipeline/extractors/sigaa_extractor.py - ETL pipeline → Database and export loaders: loads results
- Database and export loaders → PostgreSQL database: writes records
- Student → Statistics donations and quorum: donates statistics
README.md - Consolidated statistics → Statistics donations and quorum: serves consolidation
backend/app/api/routers/estatisticas_consolidadas.py - Statistics donations and quorum → Consolidated statistics repository: saves consensus
backend/app/services/doacao_service.py - Dashboard and metrics → Statistics donations and quorum: shows analytical results