drizzle-orm-missing-foreign-keys-orphaned-rows
TaskFlow’s Drizzle schema defines all relational IDs (teamId, assigneeId, creatorId, taskId, authorId, userId) as plain int columns without .references() calls. Drizzle supports FK declarations natively but they were omitted, guaranteeing orphaned rows on any deletion. Always define .references() on every FK column in Drizzle schemas to enforce referential integrity at the DB layer.
Related
- drizzle-orm-fk-references-silently-omitted-causing-orphaned
- drizzle-fk-references-omitted-by-default-causes-orphans
- drizzle-orm-fk-references-commonly-omitted
- drizzle-orm-does-not-auto-enforce-foreign-keys
- drizzle-orm-schema-missing-foreign-keys-orphan-rows
- drizzle-orm-fk-references-commonly-omitted-causing-orphans
- drizzle-no-fk-enforcement-by-default
- drizzle-orm-fk-not-enforced-by-default-causes-orphans
- drizzle-orm-fk-omission-common-gotcha
- drizzle-fk-constraints-not-automatic-must-use-references