generator client {
  provider = "prisma-client-js"
  //output   = "../src/generated/prisma"
}

datasource db {
  provider = "postgresql"
}

model User {
  id                   Int       @id @default(autoincrement())
  firstName            String    @map("first_name")
  lastName             String?   @map("last_name")
  email                String    @unique
  encryptedPassword    String    @map("encrypted_password")
  passwordResetToken   String?   @map("password_reset_token")
  passwordResetExpires DateTime? @map("password_reset_expires")
  createdAt            DateTime  @default(now()) @map("created_at")
  updatedAt            DateTime  @updatedAt @map("updated_at")
  avatarKey            String?   @map("avatar_key")
  avatarURL            String?   @map("avatar_url")

  activationCode          String?   @map("activation_code")
  activationCodeExpiresAt DateTime? @map("activation_code_expires_at")
  active                  Boolean   @default(false) @map("active")

  moods         Mood[]
  interventions Intervention[]
  triggers      Trigger[]
  reminders     Reminder[]
  sleepRecords  SleepRecord[]
  insights      Insight[]

  @@map("users")
}

model Mood {
  id           Int            @id @default(autoincrement())
  annotation   String?        @db.Text
  moment       DateTime       @default(now())
  selectedMood BaseMoodOption @default(GOOD) @map("selected_mood")
  anxietyLevel Int            @map("anxiety_level")
  stressLevel  Int            @map("stress_level")
  energyLevel  Int            @map("energy_level")
  userId       Int            @map("user_id")
  user         User           @relation(fields: [userId], references: [id])

  moodComponents MoodComponent[]

  @@map("moods")
}

model MoodComponent {
  id        Int                 @id @default(autoincrement())
  component MoodComponentOption
  intensity IntensityLevel      @default(LIGHT)

  moodId Int  @map("mood_id")
  mood   Mood @relation(fields: [moodId], references: [id], onDelete: Cascade)

  @@map("mood_components")
}

model Intervention {
  id               Int              @id @default(autoincrement())
  comment          String?
  interventionType InterventionType @map("intervention_type")
  eficacy          Int
  startAt          DateTime         @map("start_at")
  endAt            DateTime         @map("end_at")

  userId Int  @map("user_id")
  user   User @relation(fields: [userId], references: [id])

  @@map("interventions")
}

model Trigger {
  id       Int         @id @default(autoincrement())
  comment  String?     @db.Text
  category TriggerType
  moment   DateTime    @default(now())

  userId Int  @map("user_id")
  user   User @relation(fields: [userId], references: [id])

  @@map("triggers")
}

model Reminder {
  id          Int     @id @default(autoincrement())
  hour        Int
  minute      Int
  description String?
  active      Boolean @default(false)

  userId Int  @map("user_id")
  user   User @relation(fields: [userId], references: [id])

  @@map("reminders")
}

model SleepRecord {
  id          Int      @id @default(autoincrement())
  average     Float
  date        DateTime @db.Date
  annotations String?  @db.Text

  userId Int  @map("user_id")
  user   User @relation(fields: [userId], references: [id])

  @@map("sleep_records")
}

model Insight {
  id     Int  @id @default(autoincrement())
  userId Int  @map("user_id")
  user   User @relation(fields: [userId], references: [id])

  type        InsightType
  period      InsightPeriod
  title       String
  body        String        @db.Text
  metadata    Json? // flexible payload: correlations, deltas, scores
  generatedAt DateTime      @default(now()) @map("generated_at")
  periodStart DateTime      @map("period_start")
  periodEnd   DateTime      @map("period_end")

  @@unique([userId, type, periodStart])
  @@map("insights")
}

enum InsightType {
  MOOD_TREND
  ENERGY_SLEEP_CORRELATION
  TRIGGER_PATTERN
  WEEKLY_SUMMARY
  STREAK
}

enum InsightPeriod {
  DAILY
  WEEKLY
  MONTHLY
}

enum IntensityLevel {
  LIGHT
  MODERATE
  HIGH
}

enum InterventionType {
  MEDICATION
  THERAPY
  MEDITATION
  EXERCISE
  CONVERSATION
}

enum TriggerType {
  SOCIAL
  WORK
  HEALTH
  PHYSICAL
  FAMILY
  OTHER
}

// XXX: Keep it in sync with constants/moods.ts
enum BaseMoodOption {
  SAD
  NEUTRAL
  GOOD
  GREAT
  ANGRY
}

enum MoodComponentOption {
  JOY
  NEUTRAL
  ANGER
  SADNESS
  ANXIETY
  GRATITUDE
  FOCUS
  TIREDNESS
}