Glossary
This glossary defines core terms used across the DBModeler documentation.
Catalog
Section titled “Catalog”The configuration source that defines supported engines, canonical types, fallbacks, and SQL command behavior.
Canonical type
Section titled “Canonical type”A database-agnostic type ID used by DBModeler in the editor before engine-specific SQL is generated.
Fallback
Section titled “Fallback”The alternative type or SQL expression DBModeler uses when an engine does not support a canonical type directly.
Project
Section titled “Project”The top-level DBModeler unit that contains the diagram, engine configuration, versions, and integration settings.
Version
Section titled “Version”A saved schema checkpoint used for diffing, migration SQL generation, and rollback.
Work in progress (WIP)
Section titled “Work in progress (WIP)”The current unsaved editing state of the diagram compared with the latest finalized version.
Migration SQL
Section titled “Migration SQL”The version-oriented SQL generated from differences between schema snapshots rather than from a full schema rebuild.
Custom SQL script
Section titled “Custom SQL script”Version-scoped SQL attached to a pre-table or post-table phase and included in generated export output.
Secret manager
Section titled “Secret manager”The encrypted vault used to protect provider credentials with a master password.
Validator export
Section titled “Validator export”The process of generating validation-library schemas from the same DBModeler project used for SQL generation.