drizzle-fk-references-omitted-by-default-causes-orphans
Drizzle ORM supports foreign key constraints via .references() on column definitions, but they are not added automatically. The TaskFlow schema had all relational columns (teamId, assigneeId, creatorId, etc.) as plain int with no .references(), guaranteeing orphaned rows on any deletion. Always explicitly add .references(() => table.col, { onDelete: 'cascade' }) for relational integrity.
Related
- drizzle-orm-does-not-auto-enforce-foreign-keys
- drizzle-orm-fk-references-commonly-omitted
- drizzle-orm-fk-constraints-not-auto-enforced
- drizzle-orm-foreign-keys-not-implicit-must-use-references
- drizzle-orm-foreign-keys-not-auto-enforced
- drizzle-orm-missing-foreign-key-references-causes-orphaned-r
- taskflow-drizzle-missing-foreign-keys-data-integrity
- drizzle-orm-schema-missing-foreign-keys-orphan-rows
- drizzle-orm-fk-references-must-be-explicit
- drizzle-orm-fk-not-implicit-must-use-references
- 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-missing-foreign-keys-orphaned-rows
- drizzle-orm-fk-references-commonly-omitted-causing-orphans
- drizzle-orm-fk-not-enforced-by-default-causes-orphans
- drizzle-orm-foreign-keys-not-implicit
- drizzle-orm-foreign-keys-not-added-automatically
drizzle-foreign-keys-not-enforced-without-explicit-reference