Back to Details

database-changes

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese
See Database patterns for full reference.
Schema changes:
bash
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
如需完整参考，请查看数据库模式。
Schema修改:
bash
pnpm prisma migrate dev --name descriptive_name
pnpm check-types
查询规则:
  • 始终从
    @/lib/prisma
    中
    import { prisma }
  • 始终使用
    select
    指定特定字段
  • 始终使用
    take
    /
    skip
    进行分页
  • 避免N+1问题：使用
    include
    或通过
    where: { id: { in: ids } }
    进行批量查询
模型：User, Task, Submission, Assessment, Category, Tag, Bookmark