drizzle-orm-does-not-auto-enforce-foreign-keys
Drizzle ORM schema definitions with plain int columns for foreign key fields (e.g., teamId, assigneeId) do NOT enforce referential integrity unless .references() is explicitly added. Orphaned rows are guaranteed on first deletion. Always add .references(() => table.id) to every FK column in Drizzle schemas or cascade deletes will silently corrupt data.
Related
- drizzle-orm-fk-constraints-not-auto-enforced
- drizzle-orm-foreign-keys-not-auto-enforced
- drizzle-orm-fk-references-commonly-omitted
- drizzle-orm-foreign-keys-not-implicit-must-use-references
- drizzle-orm-fk-not-implicit-requires-references
- drizzle-fk-references-omitted-by-default-causes-orphans
- drizzle-orm-missing-foreign-key-references-causes-orphaned-r
- drizzle-orm-schema-missing-foreign-keys-orphan-rows
- drizzle-orm-fk-references-must-be-explicit
- drizzle-orm-fk-not-implicit-must-use-references
- drizzle-orm-foreign-key-omission-causes-orphaned-rows
- drizzle-schema-fk-omission-causes-orphaned-rows
- drizzle-orm-fk-references-silently-omitted-causing-orphaned
- drizzle-orm-fk-references-must-be-explicit-no-auto-enforceme
- drizzle-orm-fk-omission-causes-orphaned-rows
- drizzle-orm-missing-foreign-keys-orphaned-rows
- drizzle-no-fk-enforcement-by-default
- drizzle-orm-fk-not-enforced-by-default-causes-orphans
- drizzle-orm-fk-not-auto-applied-must-use-references
- drizzle-orm-foreign-keys-not-enforced-by-default
- drizzle-orm-supports-fk-references-must-be-declared-explicit
- r-dash-dashboard-revision-append-only-rollback-pattern
- drizzle-orm-fk-not-auto-enforced-requires-explicit-reference
drizzle-foreign-keys-not-enforced-without-explicit-reference- drizzle-fk-constraints-not-automatic-must-use-references