System Tables
Framework M manages several internal system tables to track the state of migrations, background jobs, and other core services.
__schema_versions__
Used by the Deterministic Schema Migration engine to optimize database synchronization.
| Column | Type | Description |
|---|---|---|
doctype_name | VARCHAR(255) | Primary Key. The name of the DocType. |
checksum | VARCHAR(64) | The SHA-256 hash of the DocType's DDL representation. |
Behavior
- Automatic Initialization: Created during the first run of
m migrate sync. - Ignore List: This table is automatically ignored by the migration engine's "drop detection" logic. It will never be suggested for deletion during a sync or migration.
- Cleanup: If a DocType is deleted from the code, its entry remains in this table until a cleanup command is explicitly run (planned feature).
alembic_version
Managed by Alembic.
| Column | Type | Description |
|---|---|---|
version_num | VARCHAR(32) | Primary Key. The current revision ID of the database schema. |
Behavior
- Tracks the current "head" of versioned migration patches.
- Updated automatically during
m migrate runorm migrate all.