drizzle-orm-schema-missing-foreign-keys-orphan-rows
Drizzle ORM schemas can declare integer columns (teamId, assigneeId, creatorId, taskId) without .references() and will not enforce referential integrity at the ORM or DB level. Without FK constraints, any deletion creates orphaned rows silently. Always audit Drizzle schemas for .references() on all relational columns before extending or deploying.
Related
- drizzle-orm-fk-references-commonly-omitted
- drizzle-orm-fk-constraints-not-auto-enforced
- drizzle-orm-does-not-auto-enforce-foreign-keys
- drizzle-fk-references-omitted-by-default-causes-orphans
- drizzle-orm-foreign-keys-not-auto-enforced
- drizzle-orm-fk-references-silently-omitted-causing-orphaned
- drizzle-orm-missing-foreign-keys-orphaned-rows
- drizzle-no-fk-enforcement-by-default