drizzle-orm-fk-not-auto-enforced-requires-explicit-references

Drizzle ORM schema definitions do not automatically enforce foreign key relationships — all FK columns (teamId, assigneeId, creatorId, etc.) default to plain int with no referential integrity unless .references() is explicitly added. Without this, orphaned rows accumulate on deletion. This is a silent correctness failure that violates data integrity even though the ORM supports FKs.