drizzle-orm-fk-references-silently-omitted-causing-orphaned-rows

Drizzle ORM supports foreign key constraints via .references() on column definitions, but they are easy to omit entirely — columns like teamId, assigneeId, creatorId can be declared as plain int with no referential integrity. Without FK constraints, deletions silently produce orphaned rows. Always audit new Drizzle schemas for missing .references() calls on every relational column.