Lewati ke isi

Data Ownership dan Domain Invariants — OS-v1.0

Last verified: 2026-09-12. Target specification; migration/implementation pending. Acuan: baseline, authorization. Tidak menganggap tabel target sudah ada; bukti gap baseline tetap di finding ledger.

1. Identitas dan mapping

Aggregate Kepemilikan/relasi target Existing atau perlu diperbaiki
Organizer tenant root, status active Existing; bukan Organization kedua
User/Membership/ScopedAssignment staff identity, live role, event/room scope, revocation version Membership existing; scope/revocation perlu remediasi
Event competition root milik organizer Existing; olympiad v1, tryout retained non-certified
Category/Round/ExamDefinition competition hierarchy minimum dengan ordering/scope Baru; pilot topology DEC-03, tidak membuat tournament engine umum
ExamSession scheduled sitting: event/exam, duration, start/end window Existing; bukan attempt
ProctorRoom/RoomAssignment session, encrypted Zoom ref, assigned proctors/participants Baru; same-organizer/session consistency
Participant/Enrollment organizer participant external code; event enrollment; specific session/room assignment Existing perlu assignment eksplisit; tidak memerlukan op.student
QuestionVersion/RubricVersion/ScoringPolicyVersion immutable content/key/tolerance/rubric/scoring metadata Existing perlu validation/version enforcement
ExamForm/ExamFormItem frozen version dan ordered question-version refs, scoring/rubric refs, checksum ExamForm existing; persistent items/snapshot gap A02
Attempt enrollment + session + frozen form, immutable deadline, active device generation, status Existing perlu snapshot/lock/revocation
AnswerRevision attempt + question-version + server revision + payload + accepted_at Existing revision rows perlu acceptance atomic; latest derived safely
IdempotencyRecord/SubmissionReceipt scoped command key, request hash, durable result, receipt ID Baru/remediasi; atomik dengan business mutation
GradeRevision/Moderation attempt/question, criteria, grader/reviewer, reason, revision Existing; bounded rubric dan unique revisions perlu perbaikan
ScoreSnapshot/RankingSnapshot/RankingEntry input/version/checksum, objective/manual totals, shared ranks Baru/remediasi; append-only, no live mutable official result
ResultPublication snapshot ID, publisher/approver, time, supersedes/withdrawal refs/reason Existing perlu immutable history; jangan delete snapshot lama
ReadinessSession/LaunchAuthorization enrollment/device/SEB policy, one-time token hash, expiry/revocation Baru
EvidenceCapturePolicy/CameraEvidence versioned policy + attempt/room/org + object ref/checksum/state Baru; metadata dan binary terpisah
ProctorAction/IncidentDisposition observed fact, actor, response, reason, evidence refs, authorized decision Baru/remediasi; machine event bukan penalty
AuditEvent/OutboxEvent tenant/actor/target/correlation, append-only business facts; delivery state terpisah Existing foundation belum terintegrasi penuh

Tenant ID ditentukan server dari identity dan resource chain, bukan mass-assigned dari payload. Relasi lintas organizer/session dilarang meskipun FK individual valid; gunakan composite constraints bila sesuai dan service validation pada semua writes. Deletion cascade tidak boleh memusnahkan evidence/results/audit yang masih dalam retention.

2. Invariants mandatory

  1. Frozen form mencatat persis question/version/order/option order/rubric/scoring policy. Freeze atomik sebelum publish/admission. Perubahan menghasilkan versi baru; existing attempts tidak berpindah.
  2. Satu active attempt per authorized enrollment/session/attempt number. Start idempoten dan concurrent-safe. Form tunggal aktif per session pilot.
  3. deadline = min(start + duration, session window end); immutable untuk pilot. now >= deadline menolak jawaban baru, termasuk request yang menunggu lock. Client clock/heartbeat/recovery tidak memperpanjang.
  4. Save/submit/sweep serialize per attempt, validate active device generation dan current authorization. Key sama+payload sama mengembalikan original ACK; key sama+payload berbeda conflict.
  5. Jawaban hanya untuk item snapshot sendiri dan typed payload benar. Unanswered dikirim eksplisit sesuai API contract, bukan skor esai default nol.
  6. Unique revision per attempt/question/revision; grade revision unik serupa; unique durable submission receipt per attempt. Auto-submit melakukan terminal transition satu kali.
  7. Esai: criteria lengkap/unik/valid, finite, 0 ≤ awarded ≤ max_points; sum(max_points)=rubric.max_score. Weight hanya derived ratio, tidak dikalikan lagi. Rubric totals dan score memakai precision/rounding approved, bukan float drift.
  8. Grader assigned, reviewer berbeda, seluruh esai yang relevan harus dinilai dan dimoderasi sebelum publication. Missing/ungraded bukan otomatis nol. Rubric baseline belum mengizinkan pengecualian sampling.
  9. Grade correction mencatat revision baru. Frozen ranking/publication tidak berubah; correction membuat snapshot/publication baru dengan supersession/withdrawal audit dan approved disposition.
  10. Mutasi kritis + audit + idempotency/outbox commit bersama. Critical audit-write failure menggagalkan transaksi; worker delivery boleh retry. Consumer deduplication persisted.
  11. Data ownership internal CBT; connector memakai mapping external IDs, tidak bergabung ke tabel Odoo.

3. State machine

Domain Transisi Tidak boleh
Attempt in_progress → submitted → graded → finalized offline sebagai terminal state; membuka submitted untuk participant edits
Submission manual/deadline/manager reason → satu receipt receipt/grade ganda akibat retry
Presence online/offline/reconnecting; derived heartbeat mengubah waktu atau skor
Readiness pending/ready/failed + policy version client true dianggap bukti keamanan
Evidence requested → uploaded → verified → retained → deleted; failed/expired terpisah public URL, silent replay, indefinite retry buffer
Publication preview → frozen snapshot → approved publication; withdrawal/supersession event overwrite/delete official history

Force submit adalah authorized manager action, bukan hukuman otomatis. Disqualification ditentukan role/customer authority melalui incident disposition terpisah; tidak menghapus jawaban atau mengganti grade menjadi nol tanpa policy.

4. Evidence metadata dan lifecycle

CameraEvidence minimal: id, organizer_id, session_id, room_id, attempt_id, device_generation, capture_request_id, policy_version, trigger, requested_at, client_captured_at_untrusted, server_received_at, object_key, content_type, byte_count, checksum, verification_state, expires_at, deletion_state, hold_ref. Simpan tanpa permanent public URL; timestamps client hanya informasi.

Policy mencakup scope round, notice/consent version, cadence/trigger allowlist, max image bytes/count, upload expiry/retry limits, retention/viewer rights. Approval fields tidak default true. Capture request single-use dan bound; duplicate completion idempoten. Orphan binary cleanup, access audit, thumbnails/version/backups dan reapply deletion tombstones setelah restore masuk retention design.

Image checksum membuktikan byte integrity, bukan keaslian wajah/liveness. PII minimum dan tidak direplikasi ke grading DTO. Grader/reviewer skor tidak otomatis boleh melihat camera evidence.

5. Migrasi dan kompatibilitas

Baseline hanya data uji menurut keputusan pengguna, tetapi bukan izin drop/reset. Migration additive, manifest/backups sebelum perubahan, test upgrade dari known fixture serta forward-fix. Jangan import create_all.

A02 berarti beberapa form/attempt historis tidak dapat direkonstruksi secara sah. Tandai legacy_unverified, keep read-only/non-certified; jangan menyimpulkan question set dari semua frozen organizer. Fresh rehearsal fixture dibuat melalui API yang diperbaiki. State/response aliases didokumentasikan sebelum breaking contract; no mass rename session/attempt.

6. Retention dan akses

Answers, question keys, PII, images, Zoom refs, audit, exports dan backups punya klasifikasi terpisah. Nilai TTL/retention/viewers final di DEC-06/07/08/11/12; no production activation sebelum approved. App role tidak diberi akses bebas update/delete audit/snapshot; retention worker privileged scope terbatas dan diaudit.