drizzle-orm-fk-references-must-be-explicit-no-auto-enforcement
Drizzle ORM does not automatically enforce referential integrity on integer columns even when they represent foreign keys. Columns like teamId, assigneeId, creatorId defined as plain int() without .references() will silently allow orphaned rows on deletion. Every FK column must explicitly call .references(() ⇒ table.id) to generate the constraint in the migration and enforce integrity at the database level.
Related
- drizzle-orm-does-not-auto-enforce-foreign-keys
- drizzle-orm-foreign-keys-not-implicit-must-use-references
- drizzle-orm-fk-constraints-not-auto-enforced
- drizzle-orm-foreign-key-omission-causes-orphaned-rows
- drizzle-fk-references-omitted-by-default-causes-orphans
- drizzle-orm-fk-omission-causes-orphaned-rows
- drizzle-no-fk-enforcement-by-default
- drizzle-orm-fk-not-auto-applied-must-use-references
- drizzle-orm-supports-fk-references-must-be-declared-explicit
- drizzle-orm-foreign-keys-not-implicit
- drizzle-orm-foreign-keys-not-added-automatically
drizzle-foreign-keys-not-enforced-without-explicit-reference- drizzle-fk-constraints-not-automatic-must-use-references