schema.prisma

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

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

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

model Restaurant {
  id      Int        @id @default(autoincrement())
  name    String
  address String
  menu    MenuItem[]
  Order   Order[]
}

model MenuItem {
  id           Int         @id @default(autoincrement())
  restaurant   Restaurant  @relation(fields: [restaurantId], references: [id])
  restaurantId Int
  name         String
  price        Decimal     @db.Decimal(7, 2)
  available    Boolean     @default(true)
  OrderItem    OrderItem[]
}

model Order {
  id           Int         @id @default(autoincrement())
  user         User        @relation(fields: [userId], references: [id])
  userId       Int
  restaurant   Restaurant  @relation(fields: [restaurantId], references: [id])
  restaurantId Int
  items        OrderItem[]
  total        Decimal     @db.Decimal(9, 2)
  status       OrderStatus @default(PENDING)
  placedAt     DateTime    @default(now())
}

model OrderItem {
  id         Int      @id @default(autoincrement())
  order      Order    @relation(fields: [orderId], references: [id])
  orderId    Int
  menuItem   MenuItem @relation(fields: [menuItemId], references: [id])
  menuItemId Int
  quantity   Int      @default(1)
  unitPrice  Decimal  @db.Decimal(7, 2)
}

enum OrderStatus {
  PENDING
  CONFIRMED
  DELIVERED
  CANCELLED
}