model User {  id      String   @id @default(uuid())  profile Profile?} model Profile {  id     String @id @default(uuid())  bio    String?  avatar String?  userId String @unique  user   User   @relation(fields: [userId], references: [id])}

// Criar com relacionamentoconst user = await prisma.user.create({  data: {    email: 'joao@email.com',    profile: {      create: { bio: 'Dev Backend' }    }  },  include: { profile: true }});

model User {  id     String  @id @default(uuid())  orders Order[]} model Order {  id     String @id @default(uuid())  userId String  user   User   @relation(fields: [userId], references: [id])}

// Buscar usuário com pedidosconst user = await prisma.user.findUnique({  where: { id },  include: {    orders: {      orderBy: { createdAt: 'desc' },      take: 10    }  }}); // Criar pedido para usuárioconst order = await prisma.order.create({  data: {    user: { connect: { id: userId } },    total: 199.99  }});

model Product {  id    String @id  tags  Tag[]} model Tag {  id       String    @id  products Product[]}

model Product {  id         String      @id  categories ProductCategory[]} model Category {  id       String            @id  products ProductCategory[]} model ProductCategory {  productId  String  categoryId String  featured   Boolean @default(false)  order      Int     @default(0)   product  Product  @relation(fields: [productId], references: [id])  category Category @relation(fields: [categoryId], references: [id])   @@id([productId, categoryId])}

const product = await prisma.product.findUnique({  where: { id },  include: {    category: true,    reviews: {      include: {        user: { select: { name: true } }      },      where: { rating: { gte: 4 } },      take: 5    }  }});

const products = await prisma.product.findMany({  select: {    id: true,    name: true,    price: true,    category: {      select: { name: true }    },    _count: {      select: { reviews: true }    }  }});

// Criar produto com categoria e reviewsconst product = await prisma.product.create({  data: {    name: 'Notebook Pro',    price: 4999.99,    category: {      connectOrCreate: {        where: { slug: 'eletronicos' },        create: { name: 'Eletrônicos', slug: 'eletronicos' }      }    },    reviews: {      create: [        { userId: 'user1', rating: 5, comment: 'Excelente!' }      ]    }  }});

model User {  orders Order[] // onDelete padrão: SetNull} model Order {  user User @relation(fields: [userId], references: [id], onDelete: Cascade)}

model Category {  id       String     @id  parentId String?  parent   Category?  @relation("CategoryHierarchy", fields: [parentId], references: [id])  children Category[] @relation("CategoryHierarchy")}

// Buscar categoria com subcategoriasconst categories = await prisma.category.findMany({  where: { parentId: null },  include: {    children: {      include: { children: true }    }  }});