Plan 20 Data Model - SekiroKenjii/Quizzivy GitHub Wiki
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.
- 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.