database-changes

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