On a diagram connected to a live database, a table I drew a minute ago looks as real as one in production for years.
Halfway through a feature, I could not tell my sketch from what was deployed.
In Schemity, the desktop database design software I build, a table I add has a dashed border until I save. Saving a connected diagram runs the migration first, so a dashed table I drew is one the database does not have yet.
A table pasted by accident shows up twice: dashed on the canvas, and as a CREATE TABLE in the migration I read before saving.
Why an entity has a dashed border: https://schemity.com/doc/resync-database/

schemity.comKeep Your ERD in Sync with the Database - Schemity DocsSchemity re-syncs a reverse-engineered ERD every time you open it - the live database is the source of truth, your layout is preserved, and your diagram never goes stale.
commit 5ebc4ff