Part 1: System Overview
1. Project Identity & Purpose - What it is, who it's for, design philosophy
2. Architecture Overview - Server-rendered monolith, no SPA, key decisions and rationale
3. Technology Stack - Every dependency with version, why each was chosen
Part 2: Infrastructure
4. Server & Network Topology - Server specs, Docker containers, networking, ports
5. Docker Configuration - Dockerfile, docker-compose equivalent, volume mounts, environment
6. Nginx & SSL - Reverse proxy config, certificate paths, domain routing
7. Database Configuration - PostgreSQL setup, 3 databases (dev/prod/test), connection pooling
Part 3: Database Schema
8. Schema Conventions - Universal column patterns, soft deletes, search vectors, triggers
9. Core Entity Tables (31 tables) - Full DDL for every table with column types, defaults, constraints, indexes
10. Junction Tables (17 tables) - All many-to-many relationships with composite PKs and FKs
11. Database Functions & Triggers - search_vector update triggers, any custom functions
12. Entity Relationship Map - Text-based ERD showing all FK relationships
Part 4: Backend Application
13. Application Bootstrap - main.py structure, lifespan, middleware, router registration
14. Core Modules - database.py, base_repository.py, sidebar.py with full API documentation
15. Router Pattern - The universal CRUD pattern every router follows
16. Router Reference (23 routers) - Every endpoint with method, path, parameters, behavior
17. Business Logic - Timer constraints, capture conversions, focus sync, status transitions, search algorithm
18. Key Enums & Constants - All status values, priority mappings, process types
Part 5: Frontend
19. Template Architecture - base.html shell, block inheritance, template inventory
20. CSS Design System - All custom properties, theme tokens, component classes
21. JavaScript Interactions - app.js modules: search modal, timer pill, theme, sidebar, mobile nav
22. Page Patterns - List view, form view, detail view, tabbed detail view patterns
23. Responsive & Mobile - Breakpoints, mobile nav, touch targets
Part 6: Testing
24. Test Architecture - Dynamic introspection, route discovery, auto-parametrization
25. Test Suite Reference - All test files, fixtures, seed data, run commands
Part 7: Operations
26. Deployment & Hot Reload - How changes are applied, no-rebuild workflow
27. Backup & Restore - Database backup/restore procedures
28. Build Roadmap - Current state, remaining Tier 3/4 features, Phase 2/3 plans