drizzle-orm-supports-fk-references-must-be-declared-explicitly
Drizzle ORM does not infer foreign key constraints from column naming conventions — plain int columns named teamId or assigneeId create no referential integrity at the database level. The .references() call must be added explicitly to each FK column in the schema definition. Omitting it guarantees orphaned rows on any deletion and silently violates ‘zero-ambiguity’ data integrity; the app compiles and runs without error until data corruption surfaces at runtime.
Related
- drizzle-orm-fk-not-auto-applied-must-use-references
- drizzle-orm-fk-references-must-be-explicit-no-auto-enforceme
- drizzle-orm-does-not-auto-enforce-foreign-keys
- drizzle-orm-fk-not-implicit-must-use-references
- drizzle-orm-fk-not-implicit-requires-references
- drizzle-orm-foreign-keys-not-added-automatically
- drizzle-orm-fk-omission-causes-orphaned-rows