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- 2026-05-27 v1 initial 77 tables · 11 enums · 450 indexes
- 2026-05-28 nyx logged observation and library collection 2 tables · 3 enums · 12 indexes
- 2026-05-28 atelier studio metis canonical contracts 3 tables · 4 enums · 18 indexes
- 2026-05-28 tara completion messaging link scim identity 3 tables · 6 enums · 18 indexes
- 2026-05-29 iris memory entry revision 1 table · 3 indexes
- 2026-05-29 admin audit event 1 table · 3 indexes
- 2026-05-29 admin store snapshot 1 table · 1 index
- 2026-06-10 tara duration bucket cadence fields and tone review 3 alters
- 2026-07-16 v10 rail channel subscriptions 1 table · 1 index
- 2026-07-16 v10 rail loudness state 1 table · 1 alter · 1 index · 1 FK
- 2026-07-16 v10 rail daypart schedules 1 table
- 2026-07-16 v10 rail discretion preferences 1 table
- 2026-07-16 v10 rail ring opt ins 2 tables · 1 index
- 2026-07-18 v10 ori presence beta 5 tables · 8 indexes · 1 FK
- 2026-07-20 tara content workbench 12 tables · 15 enums · 72 indexes
- 2026-07-20 account protection screening 2 tables · 1 alter · 5 indexes · 1 FK
- 2026-07-20 artifact detection reports 2 tables · 1 alter · 4 indexes · 1 FK
- 2026-07-20 isis benchmark cases 2 tables · 1 alter · 4 indexes · 1 FK
- 2026-07-20 isis feedback eval samples 2 tables · 1 alter · 3 indexes · 1 FK
- 2026-07-20 isis model quality assessments 2 tables · 1 alter · 4 indexes · 1 FK
- 2026-07-21 tara program language preset 1 alter
- 2026-07-21 isis texture quality batches 3 tables · 2 alters · 3 indexes · 2 FKs
- 2026-07-21 tara review approval 1 table · 6 indexes
- 2026-07-21 tara review comment 1 table · 6 indexes
- 2026-07-21 tara review assignment 1 table · 6 indexes
- 2026-07-21 isis content safety screens 4 tables · 3 alters · 4 indexes · 3 FKs
- 2026-07-21 isis resource recommendations 2 tables · 1 alter · 4 indexes · 1 FK
- 2026-07-21 v10 stage cook candidates 1 table · 3 indexes
- 2026-07-21 isis intelligent routing 2 tables · 1 alter · 4 indexes · 1 FK
- 2026-07-21 isis cost tracking 2 tables · 1 alter · 5 indexes · 1 FK
- 2026-07-21 tara concept target publish date 1 alter
- 2026-07-21 v10 stage rendered catalog 1 table · 4 indexes
- 2026-08-04 product graph projection 2 tables · 4 indexes · 2 FKs
- 2026-08-04 workbench intent plane 5 tables · 4 indexes · 2 FKs
- 2026-08-04 work item graph refs view schema change
- 2026-08-28 workbench release completed leases schema change
- 2026-09-04 workbench queue semantics 2 alters
- 2026-09-11 human video project draft 2 tables · 4 indexes
- 2026-09-12 human video upload session 1 table · 3 indexes
- 2026-09-12 human video identity pack 1 table · 4 indexes
- 2026-09-12 human video audio take 1 table · 4 indexes
- 2026-09-12 human video job 1 table · 4 indexes
- 2026-09-12 human video likeness authorization 1 table · 4 indexes
- 2026-09-12 human video candidate 1 table · 5 indexes
- 2026-09-12 human video review decision 1 table · 2 indexes
- 2026-09-12 human video project draft created at 3 alters · 1 index
- 2026-09-12 human video destruction manifest 1 table · 2 indexes
- 2026-09-12 human video release 1 table · 3 indexes
- 2026-09-12 human video cast invitation 1 table · 4 indexes
- 2026-09-13 human video operator override 1 table · 3 indexes
- 2026-09-13 human video case and legal hold 2 tables · 7 indexes
- 2026-09-13 human video destruction legal hold 3 alters · 1 index
- 2026-09-13 planning goal requirement revisions 4 tables · 3 alters · 4 indexes · 4 FKs
- 2026-09-13 planning delivery plan revisions 8 tables · 2 alters · 4 indexes · 14 FKs
- 2026-09-13 planning fleet lifecycle 2 tables · 5 alters · 5 indexes · 4 FKs
- 2026-09-13 planning workbench event integrity 1 alter · 3 indexes · 3 FKs
- 2026-09-13 operator labor accounting 5 tables · 1 alter · 6 indexes · 6 FKs
- 2026-09-13 assistant online outcome 1 table · 2 indexes
- 2026-09-13 assistant online outcome drift slice 1 index
- 2026-09-14 workbench subject erasure 2 tables · 1 index · 1 FK
- 2026-09-15 workbench adjacent subject erasure 2 alters
- 2026-09-15 workbench fleet subject erasure 3 alters
- 2026-09-15 workbench fleet tombstone invariant schema change
- 2026-09-16 assistant model lifecycle 1 table
- 2026-09-19 assistant presentation notes 1 table · 2 indexes
- 2026-09-19 assistant presentation note digest version 2 alters
aphrodite/database25 migrations- libs/aphrodite/database/prisma/migrations/00001_enable_rls/migration.sql 46 alters
- libs/aphrodite/database/prisma/migrations/00002_notifications/migration.sql 2 tables · 1 enum · 4 indexes · 2 FKs
- libs/aphrodite/database/prisma/migrations/00003_direct_messages/migration.sql 2 tables · 1 enum · 4 indexes
- libs/aphrodite/database/prisma/migrations/00004_analytics_events/migration.sql 1 table · 5 indexes
- libs/aphrodite/database/prisma/migrations/00005_live_media_publisher_grants/migration.sql 1 table · 2 alters · 2 indexes · 1 FK
- libs/aphrodite/database/prisma/migrations/00006_retire_legacy_stream_keys/migration.sql 3 alters · 1 FK
- libs/aphrodite/database/prisma/migrations/00007_live_media_publisher_edge_sessions/migration.sql 1 table · 2 alters · 1 index · 1 FK
- libs/aphrodite/database/prisma/migrations/00008_live_media_publications/migration.sql 1 table · 2 alters · 1 index · 1 FK
- libs/aphrodite/database/prisma/migrations/00009_live_media_pipeline_jobs/migration.sql 2 tables · 4 alters · 3 indexes · 3 FKs
- libs/aphrodite/database/prisma/migrations/00010_live_media_viewer_sessions/migration.sql 3 tables · 6 alters · 4 indexes · 3 FKs
- libs/aphrodite/database/prisma/migrations/00011_live_media_chat/migration.sql 4 tables · 9 alters · 5 indexes · 9 FKs
- libs/aphrodite/database/prisma/migrations/00012_live_media_operational_telemetry/migration.sql 2 tables · 4 alters · 4 indexes · 1 FK
- libs/aphrodite/database/prisma/migrations/00013_live_media_content_analysis/migration.sql 1 table · 2 alters · 2 indexes · 1 FK
- libs/aphrodite/database/prisma/migrations/00014_live_media_recording/migration.sql 1 table · 2 alters · 2 indexes · 1 FK
- libs/aphrodite/database/prisma/migrations/00015_live_media_segment_encryption/migration.sql 1 table · 2 alters · 2 indexes · 1 FK
- libs/aphrodite/database/prisma/migrations/00016_live_media_watermark/migration.sql 1 table · 2 alters · 3 indexes · 2 FKs
- libs/aphrodite/database/prisma/migrations/00017_live_media_player_client/migration.sql 1 table · 3 alters · 3 indexes · 3 FKs
- libs/aphrodite/database/prisma/migrations/00018_live_media_publisher_client/migration.sql 1 table · 3 alters · 3 indexes · 2 FKs
- libs/aphrodite/database/prisma/migrations/00019_live_media_native_clients/migration.sql 4 alters
- libs/aphrodite/database/prisma/migrations/00020_live_media_immersive_sessions/migration.sql 1 table · 2 alters · 3 indexes · 3 FKs
- libs/aphrodite/database/prisma/migrations/00021_live_media_remote_guests/migration.sql 1 table · 2 alters · 6 indexes · 2 FKs
- libs/aphrodite/database/prisma/migrations/00022_live_media_compositions/migration.sql 1 table · 2 alters · 3 indexes · 3 FKs
- libs/aphrodite/database/prisma/migrations/00023_live_media_protected_playback_cleanup/migration.sql 6 alters · 1 index
- libs/aphrodite/database/prisma/migrations/00024_live_media_tenant_resource_registry/migration.sql 1 table · 16 alters · 14 FKs
- libs/aphrodite/database/prisma/migrations/00025_age_verification_requests/migration.sql 1 table · 2 alters · 2 indexes
hathor/database7 migrations- 2026-01-11 init 20 tables · 20 enums · 23 alters · 74 indexes · 23 FKs
- 2026-04-18 add handler projection 1 table · 3 indexes
- 2026-07-17 add ideation models 12 tables · 11 enums · 12 alters · 27 indexes · 12 FKs · 1 drop
- 2026-07-18 add ladder artifacts 1 table · 3 enums · 1 alter · 2 indexes · 1 FK
- 2026-07-18 promotion target deletion mark 1 alter
- 2026-07-18 add audio ref idea kind schema change
- 2026-07-19 add note assignee 1 alter · 1 index
bellona/database2 migrations- 2026-04-16 phase 8 bellona initial 11 tables · 14 enums · 4 alters · 59 indexes · 4 FKs
- 2026-05-28 d batch export job on delete 2 alters · 1 FK
isis/database2 migrations- 2026-04-11 init 16 tables · 14 enums · 10 alters · 86 indexes · 10 FKs
- 2026-05-16 add pipeline state 6 tables · 5 alters · 11 indexes · 5 FKs
veritas/database2 migrations- 2026-05-28 veritas initial 67 tables · 45 enums · 80 alters · 72 indexes · 80 FKs
- 2026-05-28 d batch payment amount decimal 1 alter
arete/database1 migrations- 2026-05-28 arete initial 1 table · 4 indexes
iris/database1 migrations- 2026-05-28 create iris auth user 1 table · 2 indexes
nisaba/database1 migrations- 2026-05-28 nisaba initial 16 tables · 13 enums · 8 alters · 93 indexes · 8 FKs
psyche/database1 migrations- 2026-05-28 psyche initial 2 tables · 8 indexes
sophia/database1 migrations- 2026-04-12 initial schema 16 tables · 16 enums · 14 alters · 99 indexes · 14 FKs
tara/database1 migrations- 2026-05-06 initial 24 tables · 18 enums · 30 alters · 67 indexes · 30 FKs
yemaya/database1 migrations- 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 vocabulariesapprovalStatus approvedpartialunsupportedrevokedclassificationStatus observedreportedderivedchallengedcorrectedconsentStatus activeexpiredrevokedfinalState confirmed-absentdeletedlifecycleStage candidatereviewapprovedrestrictedretiredmappingStatus exactnarrowerbroadercontext-requiredunmappedpriorState copy-presentnever-copiedqualityStatus acceptablelimitedrejectedreadinessStatus draftreviewpublish_readypublishedredactionState nonelearner_safeoperator_onlyregistryQtiStatus supportedunsupportednot-applicablereleaseStage internalpreviewgeneral_availabilitylimited_rolloutreleaseState releasedretiredrequiredExposureState sealedscheduledreleasedwithdrawnrequiredExposureState sealedscheduledreleasedreviewState no-signalreviewingresolvedwithheld-small-cellreviewStatus draftreviewpublish_readypublishedrightsStatus clearedrestrictedscoreStatus not submittedsubmittedpartially gradedfully gradedexemptsupportStatus supportedpartialunsupportedtranslationStatus sourcehuman-translatedmachine-translatedhuman-reviewedtranslationStatus sourcehuman-reviewedmachine-reviewedvalidationStatus verifiedunknown-provenancesynthetic-unverifiedverificationState verifiedverified-externalcommon23 vocabulariesaccessStatus activesuspendedrevokedbillingState currentwarningblockedcausalStatus observationhypothesisvalidatedconflictStatus clearedmitigatedconflictedconsentStatus grantednot_requireddeniedwithdrawnrevokeddeletionStatus activedeletion_requesteddeleteddisclosureStatus attachedplannednot-requiredfactCheckStatus pendingpartially_checkedcheckedblockedintegrityStatus validblockedmeasurementStatus measuredbelow-noise-floorunavailablenextStatus validateddry_run_completestagedcommittedcancelledobservedGateStatus passblockoutcomeStatus observedunavailableplacementStatus observedmissingreceiptStatus activeexpiredrevokedreportedState proposedimplementedsafetyState approvedrestrictedblockedscanStatus cleardetectednot-scannedsourceState proposedimplementedvalidationStatus validinvalidverificationStatus unverifiedverifieddisputedverificationStatus validinvalidcontent-coverage3 vocabulariescanonicalizationStatus incompletecompleteledgerStatus checkeduncheckedblockedresolutionStatus resolvedunresolvedv33 vocabulariesactivityState idlemovingspeakinglisteningperformingmoderatingbackgroundCheckStatus clearpendingexpiredfailedwaivedobservationWindowState pendingopenclouded-outcompletecancelledevents2 vocabulariesauthorityVerificationState unverifiedself_attestedreviewer_verifieddocumentary_verifiedrevokedexpiredcountersignatureState nonependingall_signedpartialllm1 vocabulariescircuitState closedopenhalf_opennyx1 vocabulariessyncState pendingsyncedconflictdisableddeletedtts1 vocabulariescircuitState closedopenhalf_openveritas1 vocabulariespeerReviewStatus positivemixednegativeunknown