schema.prisma

generator client {
  provider      = "prisma-client-js"
  binaryTargets = ["native", "linux-musl-openssl-3.0.x", "rhel-openssl-1.0.x"]
}

datasource db {
  provider     = "postgresql"
  relationMode = "prisma"
}

model User {
  id             String        @id @default(uuid()) @db.Uuid
  createdAt      DateTime      @default(now())
  updatedAt      DateTime      @updatedAt
  email          String        @unique
  hashedPassword String
  firstName      String?
  lastName       String?
  isActive       Boolean       @default(true)
  mediaAssets    MediaAsset[]
  activityLogs   ActivityLog[]

  @@map("users")
}

model ContactSubmission {
  id              String                @id @default(cuid())
  name            String
  email           String
  message         String
  isRead          Boolean               @default(false)
  status          InquiryStatus         @default(NEW)
  internalNotes   String?
  source          String                @default("contact")
  estimatorLeadId String?               @unique
  createdAt       DateTime              @default(now())
  updatedAt       DateTime              @updatedAt
  estimatorLead   EstimatorLead?        @relation(fields: [estimatorLeadId], references: [id], onDelete: SetNull)
  feedback        ConsultationFeedback?

  @@index([status])
  @@index([source])
  @@map("contact_submissions")
}

model ConsultationFeedback {
  id                  String            @id @default(cuid())
  contactSubmissionId String            @unique
  rating              Int
  comment             String?
  isRead              Boolean           @default(false)
  createdAt           DateTime          @default(now())
  contactSubmission   ContactSubmission @relation(fields: [contactSubmissionId], references: [id], onDelete: Cascade)

  @@index([isRead])
  @@index([createdAt])
  @@map("consultation_feedback")
}

model EstimatorLead {
  id                    String              @id @default(cuid())
  projectType           String
  designApproach        String?
  platform              String?
  scope                 String
  complexity            String
  timeline              String
  budgetUsd             Decimal  @db.Decimal(19, 2)
  budgetDisplay         String
  excludedDeliverables  Json?
  deliverableSavingsUsd Decimal? @db.Decimal(19, 2)
  currency              String              @default("USD")
  status                EstimatorLeadStatus @default(NEW)
  createdAt             DateTime            @default(now())
  updatedAt             DateTime            @updatedAt
  shareToken            String              @unique @default(cuid())
  contactSubmission     ContactSubmission?

  @@index([status])
  @@map("estimator_leads")
}

model Testimonial {
  id         String   @id @default(cuid())
  clientName String
  clientRole String
  company    String
  content    String
  avatarUrl  String?
  isVisible  Boolean  @default(true)
  order      Int      @default(0)
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt

  @@index([isVisible])
  @@map("testimonials")
}

model Project {
  id            String             @id @default(cuid())
  title         String
  slug          String             @unique
  description   String
  content       String?
  category      String
  imageUrl      String
  liveUrl       String?
  githubUrl     String?
  isFeatured    Boolean            @default(false)
  isVisible     Boolean            @default(true)
  featuredOrder Int                @default(0)
  completedAt   DateTime?
  createdAt     DateTime           @default(now())
  updatedAt     DateTime           @updatedAt
  techStacks    ProjectTechStack[]
  developers    ProjectDeveloper[]

  @@index([isVisible])
  @@index([isFeatured])
  @@index([featuredOrder])
  @@map("projects")
}

model ProjectTechStack {
  id        String  @id @default(cuid())
  name      String
  projectId String
  project   Project @relation(fields: [projectId], references: [id], onDelete: Cascade)

  @@unique([projectId, name])
  @@index([projectId])
  @@map("project_tech_stacks")
}

model ProjectDeveloper {
  id        String  @id @default(cuid())
  name      String
  role      String?
  projectId String
  project   Project @relation(fields: [projectId], references: [id], onDelete: Cascade)

  @@unique([projectId, name])
  @@index([projectId])
  @@map("project_developers")
}

model SiteSettings {
  id                 String   @id @default("default")
  notificationEmail  String?
  siteName           String?
  siteUrl            String?
  metaDescription    String?
  socialLinks        Json?
  maintenanceMode    Boolean  @default(false)
  maintenanceMessage String?
  updatedAt          DateTime @updatedAt
  paymentProvider    String   @default("stripe")

  @@map("site_settings")
}

model FaqItem {
  id        String   @id @default(cuid())
  question  String
  answer    String
  order     Int      @default(0)
  isVisible Boolean  @default(true)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@index([isVisible])
  @@map("faq_items")
}

model ServiceItem {
  id          String   @id @default(cuid())
  title       String
  description String
  order       Int      @default(0)
  isVisible   Boolean  @default(true)
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  @@index([isVisible])
  @@map("service_items")
}

model TeamMember {
  id          String   @id @default(cuid())
  name        String
  title       String
  description String
  imageUrl    String
  socialLinks Json?
  order       Int      @default(0)
  isVisible   Boolean  @default(true)
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  @@index([isVisible])
  @@map("team_members")
}

model SiteSection {
  id        String         @id @default(cuid())
  key       SiteSectionKey @unique
  content   Json
  updatedAt DateTime       @updatedAt

  @@map("site_sections")
}

model MediaAsset {
  id           String   @id @default(cuid())
  bucket       String
  path         String
  publicUrl    String
  filename     String
  mimeType     String
  sizeBytes    Int
  alt          String?
  uploadedById String?  @db.Uuid
  createdAt    DateTime @default(now())
  uploadedBy   User?    @relation(fields: [uploadedById], references: [id], onDelete: SetNull)

  @@index([createdAt])
  @@index([bucket])
  @@index([uploadedById])
  @@map("media_assets")
}

model ActivityLog {
  id         String   @id @default(cuid())
  actorId    String?  @db.Uuid
  actorEmail String
  action     String
  entityType String
  entityId   String?
  metadata   Json?
  createdAt  DateTime @default(now())
  actor      User?    @relation(fields: [actorId], references: [id], onDelete: SetNull)

  @@index([createdAt])
  @@index([entityType, entityId])
  @@index([actorId])
  @@map("activity_logs")
}

model Product {
  id                    String     @id @default(cuid())
  name                  String
  slug                  String     @unique
  description           String
  price                 Decimal    @db.Decimal(19, 4)
  fileKey               String
  previewUrl            String?
  isVisible             Boolean    @default(true)
  order                 Int        @default(0)
  createdAt             DateTime   @default(now())
  updatedAt             DateTime   @updatedAt
  priceMinor            Decimal?   @db.Decimal(19, 0)
  currency              String     @default("usd")
  lemonSqueezyVariantId String?
  purchases             Purchase[]

  @@map("products")
}

model Purchase {
  id                    String    @id @default(cuid())
  productId             String
  buyerName             String
  buyerEmail            String
  downloadToken         String    @unique
  tokenUsed             Boolean   @default(false)
  tokenExpiresAt        DateTime
  createdAt             DateTime  @default(now())
  stripeSessionId       String?   @unique
  downloadCount         Int       @default(0)
  maxDownloads          Int       @default(3)
  firstDownloadedAt     DateTime?
  downloadedAt          DateTime?
  stripePaymentIntentId String?   @unique
  stripeChargeId        String?
  currency              String    @default("usd")
  amountMinor           Decimal?   @db.Decimal(19, 0)
  emailSentAt           DateTime?
  revokedAt             DateTime?
  disputeStatus         String?
  buyerIp               String?
  userAgent             String?
  deliveredFileKey      String?
  provider              String    @default("stripe")
  lemonSqueezyOrderId   String?   @unique
  product               Product   @relation(fields: [productId], references: [id])
  couponCode            String?
  coupon                Coupon?   @relation(fields: [couponCode], references: [code])

  @@index([productId])
  @@index([couponCode])
  @@map("purchases")
}

model ProcessedPaymentEvent {
  id        String   @id
  type      String
  createdAt DateTime @default(now())
  provider  String   @default("stripe")

  @@map("processed_payment_events")
}

enum InquiryStatus {
  NEW
  IN_PROGRESS
  CLOSED
}

enum EstimatorLeadStatus {
  NEW
  CONTACTED
  CONVERTED
  CLOSED
}

enum SiteSectionKey {
  HERO
  ABOUT
  SERVICES_INTRO
  TEAM_INTRO
  PORTFOLIO_INTRO
  TESTIMONIALS_INTRO
  CTA
  CONTACT
  FOOTER
  SEO
}

model Coupon {
  code          String     @id
  discountType  String     // "PERCENTAGE" | "FIXED"
  discountValue Decimal    @db.Decimal(19, 4)
  active        Boolean    @default(true)
  maxUses       Int?
  useCount      Int        @default(0)
  expiresAt     DateTime?
  createdAt     DateTime   @default(now())
  purchases     Purchase[]

  @@map("coupons")
}