drizzle-no-fk-enforcement-by-default

Drizzle ORM schemas do not automatically enforce foreign key relationships. Without explicit .references() calls on integer columns like teamId, assigneeId, creatorId, orphaned rows accumulate silently on deletion. This is a schema integrity gap that violates data consistency and is a common omission in Drizzle projects where devs assume referential integrity is implied.