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

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

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

model Booking {
  id            Int      @id @default(autoincrement())
  reference     String   @unique
  type          String
  itemId        String
  itemName      String
  destination   String
  startDate     String
  endDate       String?
  travellers    Int
  totalPence    Int
  currency      String   @default("GBP")
  status        String   @default("PENDING")
  paymentStatus String   @default("UNPAID")
  createdAt     DateTime @default(now())
  userId        Int
  user          User     @relation(fields: [userId], references: [id], onDelete: Cascade)
}