# OSHUN V1 Persistence Index and EXPLAIN Checks

This document is generated from
`libs/oshun/persistence/src/index-requirements.ts`. Static coverage is checked
against `libs/oshun/persistence/prisma/schema.prisma`; live CI environments can
run the emitted `EXPLAIN (FORMAT JSON)` SQL against `OSHUN_V1_DATABASE_URL`.

## Required Query Patterns

- `identity_lookup`: tenant + contract schema + source record lookup, backed by
  a unique index.
- `live_contract_scan`: tenant + contract schema + live-row scan, backed by
  `tombstoned_at` ordering/filter coverage.
- `payload_hash_drift`: tenant + contract schema + payload hash lookup for
  backfill drift checks.
- CI runs `pnpm nx run @oshun/persistence:explain:check` with
  `OSHUN_V1_DATABASE_URL` set; the validator disables sequential scans and
  explicit sorts for the session, then fails unless each `EXPLAIN (FORMAT JSON)`
  plan names the Prisma-mapped index for the query pattern.

| Model                                 | Table                                        | Query pattern      | Required fields                            |
| ------------------------------------- | -------------------------------------------- | ------------------ | ------------------------------------------ |
| `TaraDurationBucket`                  | `v1_tara_duration_bucket`                    | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `TaraDurationBucket`                  | `v1_tara_duration_bucket`                    | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `TaraDurationBucket`                  | `v1_tara_duration_bucket`                    | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `TaraLineageTaxonomy`                 | `v1_tara_lineage_taxonomy`                   | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `TaraLineageTaxonomy`                 | `v1_tara_lineage_taxonomy`                   | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `TaraLineageTaxonomy`                 | `v1_tara_lineage_taxonomy`                   | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `TaraRitualStep`                      | `v1_tara_ritual_step`                        | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `TaraRitualStep`                      | `v1_tara_ritual_step`                        | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `TaraRitualStep`                      | `v1_tara_ritual_step`                        | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `TaraRitualTemplate`                  | `v1_tara_ritual_template`                    | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `TaraRitualTemplate`                  | `v1_tara_ritual_template`                    | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `TaraRitualTemplate`                  | `v1_tara_ritual_template`                    | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `TaraContinuationState`               | `v1_tara_continuation_state`                 | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `TaraContinuationState`               | `v1_tara_continuation_state`                 | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `TaraContinuationState`               | `v1_tara_continuation_state`                 | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `TaraRitualSession`                   | `v1_tara_ritual_session`                     | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `TaraRitualSession`                   | `v1_tara_ritual_session`                     | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `TaraRitualSession`                   | `v1_tara_ritual_session`                     | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteHabit`                          | `v1_arete_habit`                             | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteHabit`                          | `v1_arete_habit`                             | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteHabit`                          | `v1_arete_habit`                             | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteGoal`                           | `v1_arete_goal`                              | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteGoal`                           | `v1_arete_goal`                              | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteGoal`                           | `v1_arete_goal`                              | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteRoutine`                        | `v1_arete_routine`                           | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteRoutine`                        | `v1_arete_routine`                           | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteRoutine`                        | `v1_arete_routine`                           | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteCheckIn`                        | `v1_arete_check_in`                          | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteCheckIn`                        | `v1_arete_check_in`                          | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteCheckIn`                        | `v1_arete_check_in`                          | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteJournalEntry`                   | `v1_arete_journal_entry`                     | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteJournalEntry`                   | `v1_arete_journal_entry`                     | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteJournalEntry`                   | `v1_arete_journal_entry`                     | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteWeeklyReview`                   | `v1_arete_weekly_review`                     | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteWeeklyReview`                   | `v1_arete_weekly_review`                     | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteWeeklyReview`                   | `v1_arete_weekly_review`                     | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteStreakRecord`                   | `v1_arete_streak_record`                     | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteStreakRecord`                   | `v1_arete_streak_record`                     | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteStreakRecord`                   | `v1_arete_streak_record`                     | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteFrictionSignal`                 | `v1_arete_friction_signal`                   | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteFrictionSignal`                 | `v1_arete_friction_signal`                   | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteFrictionSignal`                 | `v1_arete_friction_signal`                   | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteIntervention`                   | `v1_arete_intervention`                      | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteIntervention`                   | `v1_arete_intervention`                      | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteIntervention`                   | `v1_arete_intervention`                      | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AreteCoachingSummary`                | `v1_arete_coaching_summary`                  | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AreteCoachingSummary`                | `v1_arete_coaching_summary`                  | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AreteCoachingSummary`                | `v1_arete_coaching_summary`                  | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasStory`                        | `v1_veritas_story`                           | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasStory`                        | `v1_veritas_story`                           | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasStory`                        | `v1_veritas_story`                           | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasClaim`                        | `v1_veritas_claim`                           | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasClaim`                        | `v1_veritas_claim`                           | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasClaim`                        | `v1_veritas_claim`                           | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasSource`                       | `v1_veritas_source`                          | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasSource`                       | `v1_veritas_source`                          | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasSource`                       | `v1_veritas_source`                          | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasEvidencePack`                 | `v1_veritas_evidence_pack`                   | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasEvidencePack`                 | `v1_veritas_evidence_pack`                   | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasEvidencePack`                 | `v1_veritas_evidence_pack`                   | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasCounterclaim`                 | `v1_veritas_counterclaim`                    | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasCounterclaim`                 | `v1_veritas_counterclaim`                    | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasCounterclaim`                 | `v1_veritas_counterclaim`                    | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasTopicHub`                     | `v1_veritas_topic_hub`                       | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasTopicHub`                     | `v1_veritas_topic_hub`                       | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasTopicHub`                     | `v1_veritas_topic_hub`                       | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasTimeline`                     | `v1_veritas_timeline`                        | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasTimeline`                     | `v1_veritas_timeline`                        | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasTimeline`                     | `v1_veritas_timeline`                        | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasStoryUpdate`                  | `v1_veritas_story_update`                    | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasStoryUpdate`                  | `v1_veritas_story_update`                    | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasStoryUpdate`                  | `v1_veritas_story_update`                    | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasCorrectionNote`               | `v1_veritas_correction_note`                 | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasCorrectionNote`               | `v1_veritas_correction_note`                 | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasCorrectionNote`               | `v1_veritas_correction_note`                 | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `VeritasRetractionCascade`            | `v1_veritas_retraction_cascade`              | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `VeritasRetractionCascade`            | `v1_veritas_retraction_cascade`              | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `VeritasRetractionCascade`            | `v1_veritas_retraction_cascade`              | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NyxSkyEvent`                         | `v1_nyx_sky_event`                           | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NyxSkyEvent`                         | `v1_nyx_sky_event`                           | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NyxSkyEvent`                         | `v1_nyx_sky_event`                           | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NyxObservationWindow`                | `v1_nyx_observation_window`                  | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NyxObservationWindow`                | `v1_nyx_observation_window`                  | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NyxObservationWindow`                | `v1_nyx_observation_window`                  | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NyxPredictionSourceRef`              | `v1_nyx_prediction_source_ref`               | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NyxPredictionSourceRef`              | `v1_nyx_prediction_source_ref`               | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NyxPredictionSourceRef`              | `v1_nyx_prediction_source_ref`               | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NyxCalendarSyncEntry`                | `v1_nyx_calendar_sync_entry`                 | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NyxCalendarSyncEntry`                | `v1_nyx_calendar_sync_entry`                 | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NyxCalendarSyncEntry`                | `v1_nyx_calendar_sync_entry`                 | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NyxLoggedObservation`                | `v1_nyx_logged_observation`                  | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NyxLoggedObservation`                | `v1_nyx_logged_observation`                  | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NyxLoggedObservation`                | `v1_nyx_logged_observation`                  | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `LibraryLibraryCollection`            | `v1_library_library_collection`              | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `LibraryLibraryCollection`            | `v1_library_library_collection`              | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `LibraryLibraryCollection`            | `v1_library_library_collection`              | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `AtelierAtelierScene`                 | `v1_atelier_atelier_scene`                   | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `AtelierAtelierScene`                 | `v1_atelier_atelier_scene`                   | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `AtelierAtelierScene`                 | `v1_atelier_atelier_scene`                   | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `StudioStudioScene`                   | `v1_studio_studio_scene`                     | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `StudioStudioScene`                   | `v1_studio_studio_scene`                     | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `StudioStudioScene`                   | `v1_studio_studio_scene`                     | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisCourseProposal`                 | `v1_metis_course_proposal`                   | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisCourseProposal`                 | `v1_metis_course_proposal`                   | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisCourseProposal`                 | `v1_metis_course_proposal`                   | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `TaraSittingCompletionEvent`          | `v1_tara_sitting_completion_event`           | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `TaraSittingCompletionEvent`          | `v1_tara_sitting_completion_event`           | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `TaraSittingCompletionEvent`          | `v1_tara_sitting_completion_event`           | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MessagingAccountLink`                | `v1_messaging_account_link`                  | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MessagingAccountLink`                | `v1_messaging_account_link`                  | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MessagingAccountLink`                | `v1_messaging_account_link`                  | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `IdentityScimIdentity`                | `v1_identity_scim_identity`                  | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `IdentityScimIdentity`                | `v1_identity_scim_identity`                  | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `IdentityScimIdentity`                | `v1_identity_scim_identity`                  | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaPassage`                       | `v1_nisaba_passage`                          | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaPassage`                       | `v1_nisaba_passage`                          | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaPassage`                       | `v1_nisaba_passage`                          | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaManuscript`                    | `v1_nisaba_manuscript`                       | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaManuscript`                    | `v1_nisaba_manuscript`                       | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaManuscript`                    | `v1_nisaba_manuscript`                       | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaEdition`                       | `v1_nisaba_edition`                          | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaEdition`                       | `v1_nisaba_edition`                          | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaEdition`                       | `v1_nisaba_edition`                          | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaTranslation`                   | `v1_nisaba_translation`                      | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaTranslation`                   | `v1_nisaba_translation`                      | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaTranslation`                   | `v1_nisaba_translation`                      | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaLexiconEntry`                  | `v1_nisaba_lexicon_entry`                    | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaLexiconEntry`                  | `v1_nisaba_lexicon_entry`                    | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaLexiconEntry`                  | `v1_nisaba_lexicon_entry`                    | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaMorphologyEntry`               | `v1_nisaba_morphology_entry`                 | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaMorphologyEntry`               | `v1_nisaba_morphology_entry`                 | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaMorphologyEntry`               | `v1_nisaba_morphology_entry`                 | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaAnnotation`                    | `v1_nisaba_annotation`                       | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaAnnotation`                    | `v1_nisaba_annotation`                       | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaAnnotation`                    | `v1_nisaba_annotation`                       | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaConceptGraphNode`              | `v1_nisaba_concept_graph_node`               | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaConceptGraphNode`              | `v1_nisaba_concept_graph_node`               | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaConceptGraphNode`              | `v1_nisaba_concept_graph_node`               | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaConceptGraphEdge`              | `v1_nisaba_concept_graph_edge`               | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaConceptGraphEdge`              | `v1_nisaba_concept_graph_edge`               | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaConceptGraphEdge`              | `v1_nisaba_concept_graph_edge`               | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaNotebook`                      | `v1_nisaba_notebook`                         | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaNotebook`                      | `v1_nisaba_notebook`                         | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaNotebook`                      | `v1_nisaba_notebook`                         | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaStudyPlan`                     | `v1_nisaba_study_plan`                       | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaStudyPlan`                     | `v1_nisaba_study_plan`                       | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaStudyPlan`                     | `v1_nisaba_study_plan`                       | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaCitation`                      | `v1_nisaba_citation`                         | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaCitation`                      | `v1_nisaba_citation`                         | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaCitation`                      | `v1_nisaba_citation`                         | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `NisabaScholarProfile`                | `v1_nisaba_scholar_profile`                  | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `NisabaScholarProfile`                | `v1_nisaba_scholar_profile`                  | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `NisabaScholarProfile`                | `v1_nisaba_scholar_profile`                  | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisLearningSourceBundle`           | `v1_metis_learning_source_bundle`            | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisLearningSourceBundle`           | `v1_metis_learning_source_bundle`            | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisLearningSourceBundle`           | `v1_metis_learning_source_bundle`            | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisGroundingPack`                  | `v1_metis_grounding_pack`                    | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisGroundingPack`                  | `v1_metis_grounding_pack`                    | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisGroundingPack`                  | `v1_metis_grounding_pack`                    | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisCourseBuild`                    | `v1_metis_course_build`                      | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisCourseBuild`                    | `v1_metis_course_build`                      | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisCourseBuild`                    | `v1_metis_course_build`                      | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisLessonAssetBundle`              | `v1_metis_lesson_asset_bundle`               | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisLessonAssetBundle`              | `v1_metis_lesson_asset_bundle`               | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisLessonAssetBundle`              | `v1_metis_lesson_asset_bundle`               | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisPublicationPackage`             | `v1_metis_publication_package`               | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisPublicationPackage`             | `v1_metis_publication_package`               | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisPublicationPackage`             | `v1_metis_publication_package`               | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisTutorPersonaProfile`            | `v1_metis_tutor_persona_profile`             | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisTutorPersonaProfile`            | `v1_metis_tutor_persona_profile`             | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisTutorPersonaProfile`            | `v1_metis_tutor_persona_profile`             | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisTutorSessionMemory`             | `v1_metis_tutor_session_memory`              | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisTutorSessionMemory`             | `v1_metis_tutor_session_memory`              | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisTutorSessionMemory`             | `v1_metis_tutor_session_memory`              | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisLearningObjectiveMap`           | `v1_metis_learning_objective_map`            | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisLearningObjectiveMap`           | `v1_metis_learning_objective_map`            | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisLearningObjectiveMap`           | `v1_metis_learning_objective_map`            | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisAssessmentEvidencePack`         | `v1_metis_assessment_evidence_pack`          | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisAssessmentEvidencePack`         | `v1_metis_assessment_evidence_pack`          | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisAssessmentEvidencePack`         | `v1_metis_assessment_evidence_pack`          | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisLearningTelemetryStatement`     | `v1_metis_learning_telemetry_statement`      | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisLearningTelemetryStatement`     | `v1_metis_learning_telemetry_statement`      | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisLearningTelemetryStatement`     | `v1_metis_learning_telemetry_statement`      | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `MetisAcademicIntegrityVerdict`       | `v1_metis_academic_integrity_verdict`        | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `MetisAcademicIntegrityVerdict`       | `v1_metis_academic_integrity_verdict`        | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `MetisAcademicIntegrityVerdict`       | `v1_metis_academic_integrity_verdict`        | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingPersona`                 | `v1_cross_cutting_persona`                   | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingPersona`                 | `v1_cross_cutting_persona`                   | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingPersona`                 | `v1_cross_cutting_persona`                   | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingVoiceProfile`            | `v1_cross_cutting_voice_profile`             | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingVoiceProfile`            | `v1_cross_cutting_voice_profile`             | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingVoiceProfile`            | `v1_cross_cutting_voice_profile`             | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingAvatarPack`              | `v1_cross_cutting_avatar_pack`               | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingAvatarPack`              | `v1_cross_cutting_avatar_pack`               | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingAvatarPack`              | `v1_cross_cutting_avatar_pack`               | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingConsentRecord`           | `v1_cross_cutting_consent_record`            | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingConsentRecord`           | `v1_cross_cutting_consent_record`            | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingConsentRecord`           | `v1_cross_cutting_consent_record`            | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingMemoryScope`             | `v1_cross_cutting_memory_scope`              | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingMemoryScope`             | `v1_cross_cutting_memory_scope`              | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingMemoryScope`             | `v1_cross_cutting_memory_scope`              | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingEvidencePack`            | `v1_cross_cutting_evidence_pack`             | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingEvidencePack`            | `v1_cross_cutting_evidence_pack`             | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingEvidencePack`            | `v1_cross_cutting_evidence_pack`             | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingCitationTrail`           | `v1_cross_cutting_citation_trail`            | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingCitationTrail`           | `v1_cross_cutting_citation_trail`            | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingCitationTrail`           | `v1_cross_cutting_citation_trail`            | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingGroundedAnswerEnvelope`  | `v1_cross_cutting_grounded_answer_envelope`  | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingGroundedAnswerEnvelope`  | `v1_cross_cutting_grounded_answer_envelope`  | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingGroundedAnswerEnvelope`  | `v1_cross_cutting_grounded_answer_envelope`  | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingWorkflowTemplate`        | `v1_cross_cutting_workflow_template`         | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingWorkflowTemplate`        | `v1_cross_cutting_workflow_template`         | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingWorkflowTemplate`        | `v1_cross_cutting_workflow_template`         | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingModelCard`               | `v1_cross_cutting_model_card`                | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingModelCard`               | `v1_cross_cutting_model_card`                | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingModelCard`               | `v1_cross_cutting_model_card`                | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingModelVersion`            | `v1_cross_cutting_model_version`             | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingModelVersion`            | `v1_cross_cutting_model_version`             | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingModelVersion`            | `v1_cross_cutting_model_version`             | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingProvenanceBundle`        | `v1_cross_cutting_provenance_bundle`         | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingProvenanceBundle`        | `v1_cross_cutting_provenance_bundle`         | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingProvenanceBundle`        | `v1_cross_cutting_provenance_bundle`         | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingReviewPackage`           | `v1_cross_cutting_review_package`            | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingReviewPackage`           | `v1_cross_cutting_review_package`            | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingReviewPackage`           | `v1_cross_cutting_review_package`            | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingIncident`                | `v1_cross_cutting_incident`                  | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingIncident`                | `v1_cross_cutting_incident`                  | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingIncident`                | `v1_cross_cutting_incident`                  | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingPolicyBundle`            | `v1_cross_cutting_policy_bundle`             | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingPolicyBundle`            | `v1_cross_cutting_policy_bundle`             | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingPolicyBundle`            | `v1_cross_cutting_policy_bundle`             | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingSupportCase`             | `v1_cross_cutting_support_case`              | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingSupportCase`             | `v1_cross_cutting_support_case`              | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingSupportCase`             | `v1_cross_cutting_support_case`              | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingTenant`                  | `v1_cross_cutting_tenant`                    | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingTenant`                  | `v1_cross_cutting_tenant`                    | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingTenant`                  | `v1_cross_cutting_tenant`                    | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingTenantHierarchyEdge`     | `v1_cross_cutting_tenant_hierarchy_edge`     | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingTenantHierarchyEdge`     | `v1_cross_cutting_tenant_hierarchy_edge`     | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingTenantHierarchyEdge`     | `v1_cross_cutting_tenant_hierarchy_edge`     | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingTenantPolicyInheritance` | `v1_cross_cutting_tenant_policy_inheritance` | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingTenantPolicyInheritance` | `v1_cross_cutting_tenant_policy_inheritance` | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingTenantPolicyInheritance` | `v1_cross_cutting_tenant_policy_inheritance` | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
| `CrossCuttingAgentRun`                | `v1_cross_cutting_agent_run`                 | identity_lookup    | `tenantId, contractSchema, sourceRecordId` |
| `CrossCuttingAgentRun`                | `v1_cross_cutting_agent_run`                 | live_contract_scan | `tenantId, contractSchema, tombstonedAt`   |
| `CrossCuttingAgentRun`                | `v1_cross_cutting_agent_run`                 | payload_hash_drift | `tenantId, contractSchema, payloadHash`    |
