// prisma/schema.prisma
generator client {
  provider = "prisma-client-js"
}

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

model User {
  id        String   @id @default(uuid())
  name      String
  email     String   @unique
  createdAt DateTime @default(now())
  jobs      JobPosting[]
}

model JobPosting {
  id          String   @id @default(uuid())
  title       String
  company     String
  description String
  location    String
  salary      Int?
  status      String   @default("draft")
  postedAt    DateTime @default(now())
  postedBy    User     @relation(fields: [postedById], references: [id])
  postedById  String

  @@index([status, postedAt])
}
