TechShop — সম্পূর্ণ Prisma schema

enum Role {
  customer
  admin
}

model User {
  id        Int     @id @default(autoincrement())
  email     String  @unique
  name      String
  role      Role    @default(customer)
  orders    Order[]
  createdAt DateTime @default(now())
}

model Category {
  id       Int       @id @default(autoincrement())
  name     String    @unique
  products Product[]
}

model Product {
  id         Int       @id @default(autoincrement())
  name       String
  price      Decimal   @db.Decimal(10, 2)
  qty        Int       @default(0)
  spec       Json?
  active     Boolean   @default(true)
  category   Category? @relation(fields: [categoryId], references: [id], onDelete: SetNull)
  categoryId Int?
  items      OrderItem[]
}

model Order {
  id        Int         @id @default(autoincrement())
  total     Decimal     @default(0) @db.Decimal(10, 2)
  status    String      @default("pending")
  user      User        @relation(fields: [userId], references: [id])
  userId    Int
  items     OrderItem[]
  createdAt DateTime    @default(now())
}

model OrderItem {
  order     Order   @relation(fields: [orderId], references: [id], onDelete: Cascade)
  orderId   Int
  product   Product @relation(fields: [productId], references: [id])
  productId Int
  qty       Int
  price     Decimal @db.Decimal(10, 2)

  @@id([orderId, productId])
}