See Database patterns for full reference.
Schema changes:
pnpm prisma migrate dev --name descriptive_name
pnpm check-types
Query rules:
- Always
import { prisma } from '@/lib/prisma'
- Always use
select for specific fields
- Always paginate with
take/skip
- Avoid N+1: use
include or batch with where: { id: { in: ids } }
Models: User, Task, Submission, Assessment, Category, Tag, Bookmark
