LMS Assessment Storage
Summary
Source-backed Assessment and question persistence reference.
Audience
Engineering, QA, architecture, security, product, and data-governance reviewers.
Reference Content
Assessment is a tenant entity with a logical course reference, title, converted passing threshold, and owned question collection. Questions are tenant entities with assessment parent, type, prompt, optional option/answer material, and points. This public page intentionally omits assessment content and values.
Assessment-to-Question is a required foreign key with cascade deletion. Course association is not a database foreign key. Questions receive a tenant index and generated foreign-key index; no ordering, uniqueness, version, or publication index is defined.
Creation validates the course through a tenant-filtered query and saves assessment/questions together. Stored answer material has no separately documented encryption, redaction, versioning, or access policy evidence. Those controls require confirmation.
Source References
microservices/src/training-service/Infrastructure/TrainingDbContext.csmicroservices/src/training-service/Domain/TrainingEntities.csmicroservices/src/training-service/Api/TrainingEndpoints.csmicroservices/src/training-service/Infrastructure/Migrations/TrainingDbContextModelSnapshot.cs
Related Articles
See Also
Keywords
- LMS database
- Training persistence
- Source-backed model
Revision Information
- Status: Draft
- Last reviewed: 2026-07-17
- Review cycle: Quarterly