Reference · Data lifecycle

Schema migrations & state vocabularies

111 Prisma migrations across 13 schemas, and 62 declared lifecycle/status vocabularies across 9 contract domains — the change history and the state words, code-linked.

111migrations62vocabularies

This page deepens the data reference with the two parts a tables-and-columns dump leaves out: how each schema got to its current shape (its migration history) and the lifecycle/status vocabularies the contracts declare. Both are generated from a single authoritative source and kept fresh by the gate.

Schema migration history (111 migrations · 13 schemas)#

Every committed Prisma migration per database schema, in applied order, with a structural DDL summary parsed from the SQL. This is the real change history — the migration the database actually runs — not a hand-written changelog.

oshun/persistence66 migrations
  1. 2026-05-27 v1 initial 77 tables · 11 enums · 450 indexes
  2. 2026-05-28 nyx logged observation and library collection 2 tables · 3 enums · 12 indexes
  3. 2026-05-28 atelier studio metis canonical contracts 3 tables · 4 enums · 18 indexes
  4. 2026-05-28 tara completion messaging link scim identity 3 tables · 6 enums · 18 indexes
  5. 2026-05-29 iris memory entry revision 1 table · 3 indexes
  6. 2026-05-29 admin audit event 1 table · 3 indexes
  7. 2026-05-29 admin store snapshot 1 table · 1 index
  8. 2026-06-10 tara duration bucket cadence fields and tone review 3 alters
  9. 2026-07-16 v10 rail channel subscriptions 1 table · 1 index
  10. 2026-07-16 v10 rail loudness state 1 table · 1 alter · 1 index · 1 FK
  11. 2026-07-16 v10 rail daypart schedules 1 table
  12. 2026-07-16 v10 rail discretion preferences 1 table
  13. 2026-07-16 v10 rail ring opt ins 2 tables · 1 index
  14. 2026-07-18 v10 ori presence beta 5 tables · 8 indexes · 1 FK
  15. 2026-07-20 tara content workbench 12 tables · 15 enums · 72 indexes
  16. 2026-07-20 account protection screening 2 tables · 1 alter · 5 indexes · 1 FK
  17. 2026-07-20 artifact detection reports 2 tables · 1 alter · 4 indexes · 1 FK
  18. 2026-07-20 isis benchmark cases 2 tables · 1 alter · 4 indexes · 1 FK
  19. 2026-07-20 isis feedback eval samples 2 tables · 1 alter · 3 indexes · 1 FK
  20. 2026-07-20 isis model quality assessments 2 tables · 1 alter · 4 indexes · 1 FK
  21. 2026-07-21 tara program language preset 1 alter
  22. 2026-07-21 isis texture quality batches 3 tables · 2 alters · 3 indexes · 2 FKs
  23. 2026-07-21 tara review approval 1 table · 6 indexes
  24. 2026-07-21 tara review comment 1 table · 6 indexes
  25. 2026-07-21 tara review assignment 1 table · 6 indexes
  26. 2026-07-21 isis content safety screens 4 tables · 3 alters · 4 indexes · 3 FKs
  27. 2026-07-21 isis resource recommendations 2 tables · 1 alter · 4 indexes · 1 FK
  28. 2026-07-21 v10 stage cook candidates 1 table · 3 indexes
  29. 2026-07-21 isis intelligent routing 2 tables · 1 alter · 4 indexes · 1 FK
  30. 2026-07-21 isis cost tracking 2 tables · 1 alter · 5 indexes · 1 FK
  31. 2026-07-21 tara concept target publish date 1 alter
  32. 2026-07-21 v10 stage rendered catalog 1 table · 4 indexes
  33. 2026-08-04 product graph projection 2 tables · 4 indexes · 2 FKs
  34. 2026-08-04 workbench intent plane 5 tables · 4 indexes · 2 FKs
  35. 2026-08-04 work item graph refs view schema change
  36. 2026-08-28 workbench release completed leases schema change
  37. 2026-09-04 workbench queue semantics 2 alters
  38. 2026-09-11 human video project draft 2 tables · 4 indexes
  39. 2026-09-12 human video upload session 1 table · 3 indexes
  40. 2026-09-12 human video identity pack 1 table · 4 indexes
  41. 2026-09-12 human video audio take 1 table · 4 indexes
  42. 2026-09-12 human video job 1 table · 4 indexes
  43. 2026-09-12 human video likeness authorization 1 table · 4 indexes
  44. 2026-09-12 human video candidate 1 table · 5 indexes
  45. 2026-09-12 human video review decision 1 table · 2 indexes
  46. 2026-09-12 human video project draft created at 3 alters · 1 index
  47. 2026-09-12 human video destruction manifest 1 table · 2 indexes
  48. 2026-09-12 human video release 1 table · 3 indexes
  49. 2026-09-12 human video cast invitation 1 table · 4 indexes
  50. 2026-09-13 human video operator override 1 table · 3 indexes
  51. 2026-09-13 human video case and legal hold 2 tables · 7 indexes
  52. 2026-09-13 human video destruction legal hold 3 alters · 1 index
  53. 2026-09-13 planning goal requirement revisions 4 tables · 3 alters · 4 indexes · 4 FKs
  54. 2026-09-13 planning delivery plan revisions 8 tables · 2 alters · 4 indexes · 14 FKs
  55. 2026-09-13 planning fleet lifecycle 2 tables · 5 alters · 5 indexes · 4 FKs
  56. 2026-09-13 planning workbench event integrity 1 alter · 3 indexes · 3 FKs
  57. 2026-09-13 operator labor accounting 5 tables · 1 alter · 6 indexes · 6 FKs
  58. 2026-09-13 assistant online outcome 1 table · 2 indexes
  59. 2026-09-13 assistant online outcome drift slice 1 index
  60. 2026-09-14 workbench subject erasure 2 tables · 1 index · 1 FK
  61. 2026-09-15 workbench adjacent subject erasure 2 alters
  62. 2026-09-15 workbench fleet subject erasure 3 alters
  63. 2026-09-15 workbench fleet tombstone invariant schema change
  64. 2026-09-16 assistant model lifecycle 1 table
  65. 2026-09-19 assistant presentation notes 1 table · 2 indexes
  66. 2026-09-19 assistant presentation note digest version 2 alters
aphrodite/database25 migrations
  1. libs/aphrodite/database/prisma/migrations/00001_enable_rls/migration.sql 46 alters
  2. libs/aphrodite/database/prisma/migrations/00002_notifications/migration.sql 2 tables · 1 enum · 4 indexes · 2 FKs
  3. libs/aphrodite/database/prisma/migrations/00003_direct_messages/migration.sql 2 tables · 1 enum · 4 indexes
  4. libs/aphrodite/database/prisma/migrations/00004_analytics_events/migration.sql 1 table · 5 indexes
  5. libs/aphrodite/database/prisma/migrations/00005_live_media_publisher_grants/migration.sql 1 table · 2 alters · 2 indexes · 1 FK
  6. libs/aphrodite/database/prisma/migrations/00006_retire_legacy_stream_keys/migration.sql 3 alters · 1 FK
  7. libs/aphrodite/database/prisma/migrations/00007_live_media_publisher_edge_sessions/migration.sql 1 table · 2 alters · 1 index · 1 FK
  8. libs/aphrodite/database/prisma/migrations/00008_live_media_publications/migration.sql 1 table · 2 alters · 1 index · 1 FK
  9. libs/aphrodite/database/prisma/migrations/00009_live_media_pipeline_jobs/migration.sql 2 tables · 4 alters · 3 indexes · 3 FKs
  10. libs/aphrodite/database/prisma/migrations/00010_live_media_viewer_sessions/migration.sql 3 tables · 6 alters · 4 indexes · 3 FKs
  11. libs/aphrodite/database/prisma/migrations/00011_live_media_chat/migration.sql 4 tables · 9 alters · 5 indexes · 9 FKs
  12. libs/aphrodite/database/prisma/migrations/00012_live_media_operational_telemetry/migration.sql 2 tables · 4 alters · 4 indexes · 1 FK
  13. libs/aphrodite/database/prisma/migrations/00013_live_media_content_analysis/migration.sql 1 table · 2 alters · 2 indexes · 1 FK
  14. libs/aphrodite/database/prisma/migrations/00014_live_media_recording/migration.sql 1 table · 2 alters · 2 indexes · 1 FK
  15. libs/aphrodite/database/prisma/migrations/00015_live_media_segment_encryption/migration.sql 1 table · 2 alters · 2 indexes · 1 FK
  16. libs/aphrodite/database/prisma/migrations/00016_live_media_watermark/migration.sql 1 table · 2 alters · 3 indexes · 2 FKs
  17. libs/aphrodite/database/prisma/migrations/00017_live_media_player_client/migration.sql 1 table · 3 alters · 3 indexes · 3 FKs
  18. libs/aphrodite/database/prisma/migrations/00018_live_media_publisher_client/migration.sql 1 table · 3 alters · 3 indexes · 2 FKs
  19. libs/aphrodite/database/prisma/migrations/00019_live_media_native_clients/migration.sql 4 alters
  20. libs/aphrodite/database/prisma/migrations/00020_live_media_immersive_sessions/migration.sql 1 table · 2 alters · 3 indexes · 3 FKs
  21. libs/aphrodite/database/prisma/migrations/00021_live_media_remote_guests/migration.sql 1 table · 2 alters · 6 indexes · 2 FKs
  22. libs/aphrodite/database/prisma/migrations/00022_live_media_compositions/migration.sql 1 table · 2 alters · 3 indexes · 3 FKs
  23. libs/aphrodite/database/prisma/migrations/00023_live_media_protected_playback_cleanup/migration.sql 6 alters · 1 index
  24. libs/aphrodite/database/prisma/migrations/00024_live_media_tenant_resource_registry/migration.sql 1 table · 16 alters · 14 FKs
  25. libs/aphrodite/database/prisma/migrations/00025_age_verification_requests/migration.sql 1 table · 2 alters · 2 indexes
hathor/database7 migrations
  1. 2026-01-11 init 20 tables · 20 enums · 23 alters · 74 indexes · 23 FKs
  2. 2026-04-18 add handler projection 1 table · 3 indexes
  3. 2026-07-17 add ideation models 12 tables · 11 enums · 12 alters · 27 indexes · 12 FKs · 1 drop
  4. 2026-07-18 add ladder artifacts 1 table · 3 enums · 1 alter · 2 indexes · 1 FK
  5. 2026-07-18 promotion target deletion mark 1 alter
  6. 2026-07-18 add audio ref idea kind schema change
  7. 2026-07-19 add note assignee 1 alter · 1 index
bellona/database2 migrations
  1. 2026-04-16 phase 8 bellona initial 11 tables · 14 enums · 4 alters · 59 indexes · 4 FKs
  2. 2026-05-28 d batch export job on delete 2 alters · 1 FK
isis/database2 migrations
  1. 2026-04-11 init 16 tables · 14 enums · 10 alters · 86 indexes · 10 FKs
  2. 2026-05-16 add pipeline state 6 tables · 5 alters · 11 indexes · 5 FKs
veritas/database2 migrations
  1. 2026-05-28 veritas initial 67 tables · 45 enums · 80 alters · 72 indexes · 80 FKs
  2. 2026-05-28 d batch payment amount decimal 1 alter
arete/database1 migrations
  1. 2026-05-28 arete initial 1 table · 4 indexes
iris/database1 migrations
  1. 2026-05-28 create iris auth user 1 table · 2 indexes
nisaba/database1 migrations
  1. 2026-05-28 nisaba initial 16 tables · 13 enums · 8 alters · 93 indexes · 8 FKs
psyche/database1 migrations
  1. 2026-05-28 psyche initial 2 tables · 8 indexes
sophia/database1 migrations
  1. 2026-04-12 initial schema 16 tables · 16 enums · 14 alters · 99 indexes · 14 FKs
tara/database1 migrations
  1. 2026-05-06 initial 24 tables · 18 enums · 30 alters · 67 indexes · 30 FKs
yemaya/database1 migrations
  1. 2026-04-11 separate capability domain data 38 tables · 21 enums · 85 alters · 142 indexes · 51 FKs · 14 drops

Lifecycle & status vocabularies (62 declared · 9 domains)#

The *Status / *State / *Phase z.enum fields the contracts declare — the states a value may take, code-linked to where each is defined. These are the declared vocabularies; the transitions and guards between states live in the consuming code and are not fabricated into a transition graph here.

metis27 vocabularies
approvalStatus ×3 approvedreview_onlyblocked
approvalStatus approvedpartialunsupportedrevoked
classificationStatus observedreportedderivedchallengedcorrected
completionState ×2 completedpassed
consentStatus activeexpiredrevoked
finalState confirmed-absentdeleted
lifecycleStage candidatereviewapprovedrestrictedretired
mappingStatus exactnarrowerbroadercontext-requiredunmapped
priorState copy-presentnever-copied
qualityStatus acceptablelimitedrejected
readinessStatus draftreviewpublish_readypublished
redactionState nonelearner_safeoperator_only
registryQtiStatus supportedunsupportednot-applicable
releaseStage internalpreviewgeneral_availabilitylimited_rollout
releaseState releasedretired
requiredExposureState sealedscheduledreleasedwithdrawn
requiredExposureState sealedscheduledreleased
reviewState no-signalreviewingresolvedwithheld-small-cell
reviewStatus draftreviewpublish_readypublished
rightsStatus clearedrestricted
scoreStatus not submittedsubmittedpartially gradedfully gradedexempt
supportStatus supportedpartialunsupported
supportStatus ×2 approvedpartialunsupportedrevoked
translationStatus sourcehuman-translatedmachine-translatedhuman-reviewed
translationStatus sourcehuman-reviewedmachine-reviewed
validationStatus verifiedunknown-provenancesynthetic-unverified
verificationState verifiedverified-external
common23 vocabularies
accessStatus activesuspendedrevoked
billingState currentwarningblocked
causalStatus observationhypothesisvalidated
conflictStatus clearedmitigatedconflicted
consentStatus grantednot_requireddeniedwithdrawnrevoked
deletionStatus activedeletion_requesteddeleted
disclosureStatus attachedplannednot-required
factCheckStatus pendingpartially_checkedcheckedblocked
integrityStatus validblocked
measurementStatus measuredbelow-noise-floorunavailable
measurementStatus ×2 measuredunavailable
nextStatus validateddry_run_completestagedcommittedcancelled
outcomeStatus observedunavailable
placementStatus observedmissing
receiptStatus activeexpiredrevoked
reportedState proposedimplemented
safetyState approvedrestrictedblocked
scanStatus cleardetectednot-scanned
sourceState proposedimplemented
validationStatus validinvalid
verificationStatus unverifiedverifieddisputed
verificationStatus validinvalid
content-coverage3 vocabularies
canonicalizationStatus incompletecomplete
ledgerStatus checkeduncheckedblocked
resolutionStatus resolvedunresolved
v33 vocabularies
activityState idlemovingspeakinglisteningperformingmoderating
backgroundCheckStatus clearpendingexpiredfailedwaived
observationWindowState pendingopenclouded-outcompletecancelled
events2 vocabularies
authorityVerificationState unverifiedself_attestedreviewer_verifieddocumentary_verifiedrevokedexpired
countersignatureState nonependingall_signedpartial
llm1 vocabularies
circuitState closedopenhalf_open
nyx1 vocabularies
syncState pendingsyncedconflictdisableddeleted
tts1 vocabularies
circuitState closedopenhalf_open
veritas1 vocabularies
peerReviewStatus positivemixednegativeunknown