taskflow-drizzle-missing-foreign-keys-data-integrity
The TaskFlow repo uses Drizzle ORM but defines all relational columns (teamId, assigneeId, creatorId, taskId, authorId, userId) as plain integers without .references() foreign key constraints. Drizzle fully supports FK declarations — their absence means orphaned rows are guaranteed on any deletion. Any new Drizzle schema must explicitly declare .references() on all relational columns from day one.