Migration ledger

State, schema, secrets · schema files. On a deployment this row is a control; the demo shows the row with the reading its source supports.

Evidence

Running: 35 schema files, all in the ledger (schema_migrations, core/db/components_schema.sql)
Built: 27 in core/db, 8 in www-demo/sql; DDL held by no application role
Latest known: 35 files, checksums as committed
Source: core/db/*.sql, www-demo/sql/*.sql
Checked: 2 hours ago
Cadence: none — on demand
Mode: guided
State: current
Backup unit: pg_dump of the affected schemas, taken by the updater before the up.
Recovery: Run the down; restore the dump if the down cannot.

The five steps

Plan, back up, apply, verify, recover — in guided mode. On a deployment each step runs, is verified and lands on the audit trail; every component on the demo is current, so every step reads done.

✓ done Plan The SQL that will run, its checksum, whether it ships a down, and the schemas it touches; the admin confirms and, for direct mode, enters the DDL credential for this job only.
✓ done Back up The updater takes pg_dump of the affected schemas to system/backups/ and records the checksum; no verified dump, no apply.
✓ done Apply Direct with the moment-of-use credential when a down exists; otherwise the screen shows the exact SQL and the admin runs it.
✓ done Verify information_schema shows the column or table, the ledger row is written with the checksum, and the healthcheck is green.
✓ done Recover Run the down; if there is none, restore the dump; verify again.

Every row behind this reading (35)

Tree	File	Tables	Bytes	SHA-256	Ledger
core/db	bootstrap_aws.sql	none	10,713	95405119492d	applied
core/db	bootstrap_azure.sql	none	8,804	29170fafa4db	applied
core/db	bootstrap_gcp.sql	none	7,467	d3003afb9cb4	applied
core/db	components_schema.sql	platform_backups, platform_component_acks, platform_releases, platform_update_steps, platform_updates, schema_migrations	4,832	8301d6fb8670	applied
core/db	identity_schema.sql	identity.patient_identity	6,090	8155bc1c449e	applied
core/db	imaging_schema.sql	dicom_instances, dicom_series, dicom_studies	5,776	947f2eeb58f8	applied
core/db	omop_bootstrap_aws.sql	none	18,110	335291ed0e30	applied
core/db	omop_bootstrap_azure.sql	none	11,627	e26452930403	applied
core/db	omop_bootstrap_gcp.sql	none	11,985	03125e42653a	applied
core/db	omop_schema.sql	cdm.care_site, cdm.condition_occurrence, cdm.drug_exposure, cdm.measurement, cdm.observation, cdm.person, cdm.procedure_occurrence, cdm.visit_occurrence	24,257	f5128266f57f	applied
core/db	omop_vocab_schema.sql	vocab.concept	3,324	af31ff60a225	applied
core/db	platform_state_schema.sql	platform_config, platform_consents, platform_crosswalk, platform_exchanges, platform_links, platform_models, platform_orch_runs, platform_orchestration	3,656	3a05c5add24b	applied
core/db	prompts_schema.sql	assistant_prompts	2,313	ea09144e30e6	applied
core/db	retrieval_bootstrap_aws.sql	none	4,110	77e49a73ddff	applied
core/db	retrieval_bootstrap_azure.sql	none	3,050	4ad117917838	applied
core/db	retrieval_bootstrap_gcp.sql	none	2,728	ed8e744a043d	applied
core/db	retrieval_schema.sql	retrieval.clinical_text, retrieval.psychotherapy_text	6,008	22efc7d9e547	applied
core/db	schema.sql	index_state, roi_requests, stored_resources	9,228	65894c37604e	applied
core/db	schema_partitioned.sql	index_state, roi_requests, stored_resources, stored_resources_adverseevent, stored_resources_allergyintolerance, stored_resources_condition, stored_resources_consent, stored_resources_default, stored_resources_diagnosticreport, stored_resources_documentreference, stored_resources_encounter, stored_resources_explanationofbenefit, stored_resources_immunization, stored_resources_medicationadministration, stored_resources_medicationrequest, stored_resources_observation, stored_resources_patient, stored_resources_procedure, stored_resources_servicerequest	11,863	d6e8c2f07d89	applied
core/db	telemetry_bootstrap_aws.sql	none	1,200	b5730eb35813	applied
core/db	telemetry_bootstrap_azure.sql	none	1,005	e45bcd496552	applied
core/db	telemetry_bootstrap_gcp.sql	none	953	22b678a0bb64	applied
core/db	telemetry_schema.sql	aiops.assistant_feedback, aiops.assistant_interactions	4,126	4b6bc2fa82f3	applied
core/db	users_bootstrap_aws.sql	none	4,571	69d8a285abeb	applied
core/db	users_bootstrap_azure.sql	none	3,908	24f014a880e7	applied
core/db	users_bootstrap_gcp.sql	none	4,412	2ac98f02b44b	applied
core/db	users_schema.sql	authn.local_sessions, authn.local_user_roles, authn.local_users	10,224	3d9561a20af7	applied
www-demo/sql	2026-09-02_answer_text.sql	none	476	ee824fac718d	applied
www-demo/sql	2026-09-07_metrics.sql	web_eval_rubric, web_eval_score	5,784	55ef397d2c66	applied
www-demo/sql	analytics.sql	web_ai_calls, web_analytics_meta, web_events, web_pageviews, web_sessions	12,354	ba7af4bfa62a	applied
www-demo/sql	analytics_views.sql	none	11,192	8ea48d4516a3	applied
www-demo/sql	patch_admin_fees.sql	none	1,797	23d2a3ff9d36	applied
www-demo/sql	patch_models_dedupe.sql	none	1,397	997b125de878	applied
www-demo/sql	schema.sql	allergies, audit_log, bulk_exports, bulk_runs, claim_lines, claims, conditions, demo_config, documents, encounters, imaging_studies, immunizations, medications, model_alerts, models, observations, patients, procedures, prompts, psychotherapy_notes, roi_requests, signature_drafts, stream_exports, stream_partitions	15,334	a35996740b32	applied
www-demo/sql	seed.sql	model_alerts, models	21,422,761	9e893c426f2c	applied

History

Applies and recoveries of this row, from the update journal. On a deployment every apply and every recovery lands here as it completes.

No apply or recovery recorded for this row. The demo's journal holds one completed update, of Running image.

Acknowledge: keep as is until <date> because <reason> — on a deployment this line is a form, audited as system.component_acknowledged; the demo shows the words.

← Back to Components