Learning Database

Why This Exists

This document defines conceptual database responsibilities for the Learning Domain. It does not define physical SQL implementation.

Owner

The owner is the Chief Product Officer and Enterprise Architect.

Business Value

Learning records are evidence of education, progress, maturity, and certification. Database responsibilities must protect history, auditability, and cross-domain references.

Conceptual Tables Or Collections

Table or collection	Responsibility
learning_courses	Course identity, version, status, objectives, target audience, and metadata.
learning_modules	Module structure and ordering within courses.
learning_lessons	Lesson records, content type, objective, completion rule, and status.
learning_video_lessons	Video media references, duration, transcript references, and captions metadata.
learning_interactive_lessons	Scenario steps, prompts, and branching configuration.
learning_quizzes	Quiz metadata, pass thresholds, question references, and scoring policy.
learning_quiz_attempts	User quiz attempts, answers, scores, status, and timestamps.
learning_practical_exercises	Exercise prompts, rubrics, and review requirements.
learning_exercise_submissions	Submitted exercise evidence, review status, feedback, and timestamps.
learning_certificates	Certificate records, status, issue date, course/path version, and recipient.
learning_paths	Learning path goal, audience, status, and owner metadata.
learning_path_steps	Ordered content references within a learning path.
learning_user_progress	User progress by course, path, lesson, quiz, or exercise.
organization_learning_profiles	Organization-level learning maturity, progress summary, and learning state.
procurement_maturity_assessments	Assessment responses, score, maturity level, and rubric version.
learning_knowledge_gaps	Identified knowledge gaps, severity, evidence, and status.
learning_recommendations	Recommended learning actions, priority, reason, status, and source trigger.
learning_ai_tutor_sessions	Tutor session records, references, confidence, guardrail result, and summary.
learning_audit_log	Append-only learning audit events for critical changes.

Indexing Considerations

Learning should support indexes for:

• organization_id.
• user_id.
• course_id.
• path_id.
• lesson_id.
• certificate_id.
• recommendation_status.
• maturity_level.
• created_at and updated_at.
• Cross-domain source references for triggers.

Audit Requirements

Audit logging is required for:

• Course publication.
• Quiz scoring.
• Exercise review.
• Certificate issuance, revocation, or expiry.
• AI tutor sessions.
• Maturity assessment scoring.
• Recommendation creation and dismissal.

Relational And Future Memory Model

The initial model can be relational because Learning records have strong identity, lifecycle, and reporting needs. Over time, Learning may publish selected events into the Organization Intelligence Graph or Organizational Memory so Intelligence can reason about education history. That future graph or semantic memory layer must not replace Learning as the source of record.

Data Retention

Learning records should preserve certificate and progress history even when content is revised or archived. Deletion and retention policies must consider audit, customer evidence, privacy, and contractual obligations.