Database Patterns Skill (Prisma/PostgreSQL)

The Single Source of Truth for Database Interactions in Eridu Services.

For detailed code examples for each section, read the corresponding file from references/ as needed.

1. Soft Delete

Rule: NEVER permanently delete logical data. Use deletedAt timestamps.

• Every query MUST filter deletedAt: null unless intentionally listing history.
• Use BaseRepository.softDelete() — never raw prisma.model.delete().
• Add @@index([deletedAt]) to every soft-deletable model schema.

📖 See references/01-soft-delete.md for schema and query examples.