A reader asked if the ten cycles Schemity found between the modules of my demo database were real. I moved two tables and all ten were gone.
The database is a 34-table store I had split into seven modules. I had filed addresses under shipping, next to warehouses. But users has a default address and every address belongs to a user, so accounts and shipping depended on each other.
I moved addresses to accounts. Three cycles left. I moved stock_levels from catalog to shipping. None left.
I had been ready to argue about which foreign keys to drop. All 43 are still there. The cycles were in my module list, not in the schema.
https://schemity.com/blog/circular-dependency-between-modules-misplaced-table/

schemity.comCircular Dependencies Between Modules in a Database: A Real Dependency, or One Table in the Wrong Module? - SchemityOn a 34-table store, ten cycles between modules came down to two misfiled tables. A query and Schemity's Context Map count the cycles; ownership says which are real.
commit 261c6d6