drizzle-orm-fk-references-commonly-omitted-causing-orphans
Drizzle ORM supports foreign key constraints via .references() on column definitions, but developers routinely define relational columns (teamId, assigneeId, creatorId) as plain int without references, silently allowing orphaned rows on parent deletion. Absence of FK constraints in Drizzle is not a framework limitation — it is a deliberate omission that must be caught in schema review. Every relational int column should have .references(() => parentTable.id) with an explicit onDelete strategy.