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

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

model User {
  id            String    @id @default(cuid())
  name          String?
  email         String?   @unique
  emailVerified DateTime?
  image         String?
  
  // Stripe / Billing
  stripeCustomerId       String?   @unique
  stripeSubscriptionId   String?   @unique
  stripePriceId          String?
  stripeCurrentPeriodEnd DateTime?
  
  // Relations
  accounts      Account[]
  sessions      Session[]
  teams         TeamMember[]
  leads         Lead[]
}

model Team {
  id        String       @id @default(cuid())
  name      String
  members   TeamMember[]
  createdAt DateTime     @default(now())
}

model TeamMember {
  id      String @id @default(cuid())
  role    Role   @default(MEMBER)
  teamId  String
  userId  String
  team    Team   @relation(fields: [teamId], references: [id], onDelete: Cascade)
  user    User   @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([teamId, userId])
}

model Lead {
  id          String   @id @default(cuid())
  name        String
  email       String
  status      Status   @default(NEW)
  userId      String
  user        User     @relation(fields: [userId], references: [id])
  createdAt   DateTime @default(now())
}

enum Role {
  OWNER
  ADMIN
  MEMBER
}

enum Status {
  NEW
  CONTACTED
  CONVERTED
  LOST
}