drizzle-orm-fk-omission-causes-orphaned-rows

Drizzle ORM schemas that declare relationship columns as plain int without .references() FK constraints will accumulate orphaned rows on any deletion. Drizzle fully supports foreign keys via .references() — their absence is always a deliberate omission or oversight, not a framework limitation. Any schema review should check every *Id column for a corresponding .references() call.