drizzle-schema-fk-omission-causes-orphaned-rows

Drizzle ORM supports foreign keys via .references() on column definitions, but developers commonly omit them and use plain int columns for relation fields (teamId, assigneeId, creatorId etc.). This guarantees orphaned rows on any delete operation. Always audit every relation column in a Drizzle schema for explicit .references() calls — Drizzle will not warn at runtime when FKs are missing.