prisma/schema.prisma - main - coffe/api

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id        String   @id @default(uuid()) @db.Uuid
  username  String   @unique
  hash      String
  email     String?
  role      String   @default("user")
  createdAt DateTime @default(now())

  hashedRt          String?
  hashedAccessToken String?

  orders Order[]
}

model Category {
  id       String    @id @default(uuid()) @db.Uuid
  name     String    @unique
  products Product[]
}

model Product {
  id          String  @id @default(uuid()) @db.Uuid
  name        String
  price       Int
  imageUrl    String?
  description String?

  categoryId String   @db.Uuid
  category   Category @relation(fields: [categoryId], references: [id], onDelete: Restrict)

  orderItems OrderItem[]
}

model Order {
  id        String      @id @default(uuid()) @db.Uuid
  createdAt DateTime    @default(now())
  status    OrderStatus @default(PENDING)

  userId String @db.Uuid
  user   User   @relation(fields: [userId], references: [id], onDelete: Cascade)

  items OrderItem[]
}

model OrderItem {
  id       String @id @default(uuid()) @db.Uuid
  quantity Int    @default(1)

  orderId String @db.Uuid
  order   Order  @relation(fields: [orderId], references: [id], onDelete: Cascade)

  productId String  @db.Uuid
  product   Product @relation(fields: [productId], references: [id], onDelete: Restrict)
}

model RequestStat {
  id        String   @id @default(uuid()) @db.Uuid
  endpoint  String
  method    String
  status    Int
  success   Boolean
  createdAt DateTime @default(now())
}

enum OrderStatus {
  PENDING
  CONFIRMED
  COMPLETED
  CANCELLED
}