Plan 20 Data Model

20 — Data Model

This document is 2 pages on the wiki because GitHub renders very large pages slowly. Headings and their anchors are unchanged; the contents below link to each one.

Contents

• 1. Provisioning (outside migrations)
• 2. Foundations
• 3. Identity
• 4. Classes and join codes (§6)
• 5. Audit (§13.4)
• 6. Media (§11)
• 7. Question bank
• 8. Tests, drafts, and versions
• 9. Assignments
• 10. Attempts
• 11. Privileges and the student-payload rule
• 12. Deviation register
• 13. Migration inventory
• 14. Query discipline (§13.8)
• 15. Approved retention maintenance (2026-09-22)
• 14. Approved admin lifecycle changes (spec v0.6)
• 16. Inline option content (W-05a, spec v0.10)
• 17. Question prose (W-05b, spec v0.11)
• 18. Stable gap bindings (W-06b, spec v0.13)
• 19. Independent group ownership and graph storage (W-07b)
• 20. Frozen group graph (W-08)
• 21. Shared recording accounting (W-09c)
• 22. Frozen delivery algorithm (W-09d)
• 23. Private import sources (W-10a)
• 24. Durable import runs (W-11a)
• 25. Private stage artifacts (W-13b)
• 26. Review drafts and commits (W-18, W-20)
• 27. Maintenance windows (T-R1.12)
• 28. Advisory-lock registry
• 29. Roles and permissions (T-R2.1)
• 30. A role per user, the session epoch and the last Admin (T-R2.2)
• 31. Ownership (T-R2.9)
• 32. Ownership indexes (T-R2.10)
• 33. Encrypted join codes (T-R2.14a)
• 34. Notifications (T-R4.10a)
• 35. Caller profile and preferences (T-R4.7)
• 36. Question level, skill and legacy choice compatibility (T-R4.15)
• 37. Alt text for a question's image (T-R4.62a)
• 38. Per-student overrides (T-R4.12)
• 39. Where a device last refreshed (T-R4.9)
• 40. Composed text (F-37)
• 41. When and where a class meets (T-R4.18)
• 42. The legacy role goes (T-R4.49, T-R3.1)
• 43. Ownership is validated and the fill triggers go (T-R4.49, T-R3.2)
• 44. Students can pause (T-D4.13)
• 45. A file that left the library (F-68)
• 46. The AI assistant's credits (T-D4.31)
• 47. Reading a scan with AI (T-D4.33)
• 48. Moving a question across the group boundary (E1)

---

_{Generated from docs/plan/20-data-model.md. Edit that file in the repository; changes made on this page are overwritten.}