Archive - Historical Database Documentation¶
This directory contains archived database design documents from the initial development phase.
Files in This Archive¶
db_info.md¶
Date: November 27, 2024
Status: Superseded by ../database-schema.md
Description: - Initial PostgreSQL schema design document (v1) - Complete SQL DDL statements for all tables - Includes enum types, constraints, and relationships - Comprehensive coverage of all entities: - Multi-tenant structure (universities, departments) - Domains & subjects taxonomy - Courses and course offerings - Modules and content items - Users, enrollments, progress tracking - Assessments, grades, certificates - Discussions and reviews
Why Archived:
- A newer, more maintained version exists: docs/reference/database-schema.md (updated Jan 20, 2026)
- This document served its purpose as the initial design spec
- Keeping for historical reference and to understand design evolution
db_schema.mmd¶
Date: November 27, 2024
Status: Historical reference
Description: - Mermaid diagram (ERD) of the database schema - Visual representation of entity relationships - Shows primary entities and their connections - 6.8KB diagram file
Why Archived: - Part of the initial design phase - Current schema may have evolved - Kept as historical reference for the v1 design
For Current Documentation¶
📖 For the latest database schema documentation, see:
- docs/reference/database-schema.md - Current, maintained schema reference
🔧 For database migrations:
- docs/how-to/database-migrations.md - How to work with Alembic migrations
Note¶
These files are preserved for historical reference and to understand the evolution of the database design. They should not be used as the source of truth for current development. Always refer to the current documentation and the actual database models in app/models/.
Last Updated: January 26, 2026