schema.prisma

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

datasource db {
  provider  = "postgresql"
  url       = env("SUPABASE_DATABASE_URL")
  directUrl = env("DIRECT_URL")
}

enum GroupRole {
  OWNER
  MEMBER
}

enum ActivityType {
  expense_created
  expense_updated
  expense_deleted
  settlement_created
  settlement_reminder
  member_joined
  member_invited
}

enum PaymentStatus {
  pending
  succeeded
  failed
}

model User {
  id                        String                 @id @default(uuid())
  email                     String                 @unique
  passwordHash              String
  name                      String
  avatarUrl                 String?
  createdAt                 DateTime               @default(now())
  updatedAt                 DateTime               @updatedAt
  memberships               GroupMember[]
  createdGroups             Group[]                @relation("group_creator")
  expenses                  Expense[]              @relation("expense_payer")
  recurringExpensesPaid     RecurringExpense[]     @relation("recurring_expense_payer")
  recurringExpensesCreated  RecurringExpense[]     @relation("recurring_expense_creator")
  splits                    Split[]
  recurringExpenseSplits    RecurringExpenseSplit[]
  settlementsPaid           Settlement[]           @relation("settlement_payer")
  settlementsReceived       Settlement[]           @relation("settlement_receiver")
  balances                  Balance[]              @relation("balance_user")
  counterpartyBalances      Balance[]              @relation("balance_counterparty")
  refreshTokens             RefreshToken[]
  activities                Activity[]
  pushTokens                PushToken[]
  paymentsSent              Payment[]              @relation("payment_payer")
  paymentsReceived          Payment[]              @relation("payment_receiver")

  @@map("users")
}

model Group {
  id                 String            @id @default(uuid())
  name               String
  createdBy          String
  currency           String
  defaultSplitType   String?
  defaultSplitConfig String?
  shareToken         String?           @unique
  shareEnabled       Boolean           @default(false)
  createdAt          DateTime          @default(now())
  deletedAt          DateTime?
  creator            User              @relation("group_creator", fields: [createdBy], references: [id])
  members            GroupMember[]
  expenses           Expense[]
  recurringExpenses  RecurringExpense[]
  balances           Balance[]
  settlements        Settlement[]
  activities         Activity[]
  payments           Payment[]
  invites            GroupInvite[]

  @@index([createdBy])
  @@index([shareToken])
  @@map("groups")
}

model GroupMember {
  id       String    @id @default(uuid())
  groupId  String
  userId   String
  role     GroupRole @default(MEMBER)
  joinedAt DateTime  @default(now())
  group    Group     @relation(fields: [groupId], references: [id])
  user     User      @relation(fields: [userId], references: [id])

  @@unique([groupId, userId])
  @@index([groupId])
  @@index([userId])
  @@map("group_members")
}

model Expense {
  id               String   @id @default(uuid())
  groupId          String
  payerId          String
  description      String
  totalAmountCents BigInt
  currency         String
  category         String?
  idempotencyKey   String?  @unique
  createdAt        DateTime @default(now())
  group            Group    @relation(fields: [groupId], references: [id])
  payer            User     @relation("expense_payer", fields: [payerId], references: [id])
  splits           Split[]
  receipt          Receipt?

  @@index([groupId])
  @@index([payerId])
  @@index([createdAt])
  @@index([groupId, createdAt])
  @@map("expenses")
}

model RecurringExpense {
  id               String                 @id @default(uuid())
  groupId          String
  payerId          String
  createdBy        String
  description      String
  totalAmountCents BigInt
  currency         String
  category         String?
  frequency        String
  nextOccurrenceAt DateTime
  lastGeneratedAt  DateTime?
  active           Boolean                @default(true)
  createdAt        DateTime               @default(now())
  group            Group                  @relation(fields: [groupId], references: [id])
  payer            User                   @relation("recurring_expense_payer", fields: [payerId], references: [id])
  creator          User                   @relation("recurring_expense_creator", fields: [createdBy], references: [id])
  splits           RecurringExpenseSplit[]

  @@index([groupId])
  @@index([payerId])
  @@index([createdBy])
  @@index([active, nextOccurrenceAt])
  @@index([groupId, active])
  @@map("recurring_expenses")
}

model Split {
  id              String @id @default(uuid())
  expenseId       String
  userId          String
  owedAmountCents BigInt
  paidAmountCents BigInt
  expense         Expense @relation(fields: [expenseId], references: [id])
  user            User    @relation(fields: [userId], references: [id])

  @@index([expenseId])
  @@map("splits")
}

model RecurringExpenseSplit {
  id                 String           @id @default(uuid())
  recurringExpenseId String
  userId             String
  owedAmountCents    BigInt
  paidAmountCents    BigInt
  recurringExpense   RecurringExpense @relation(fields: [recurringExpenseId], references: [id])
  user               User             @relation(fields: [userId], references: [id])

  @@index([recurringExpenseId])
  @@map("recurring_expense_splits")
}

model Balance {
  id                 String @id @default(uuid())
  groupId            String
  userId             String
  counterpartyUserId String
  amountCents        BigInt
  group              Group  @relation(fields: [groupId], references: [id])
  user               User   @relation("balance_user", fields: [userId], references: [id])
  counterpartyUser   User   @relation("balance_counterparty", fields: [counterpartyUserId], references: [id])

  @@unique([groupId, userId, counterpartyUserId])
  @@index([groupId])
  @@index([userId])
  @@map("balances")
}

model Settlement {
  id             String   @id @default(uuid())
  groupId        String
  payerId        String
  receiverId     String
  amountCents    BigInt
  idempotencyKey String?  @unique
  createdAt      DateTime @default(now())
  group          Group    @relation(fields: [groupId], references: [id])
  payer          User     @relation("settlement_payer", fields: [payerId], references: [id])
  receiver       User     @relation("settlement_receiver", fields: [receiverId], references: [id])

  @@index([groupId])
  @@map("settlements")
}

model Receipt {
  id        String   @id @default(uuid())
  expenseId String   @unique
  fileKey   String
  createdAt DateTime @default(now())
  expense   Expense  @relation(fields: [expenseId], references: [id])

  @@map("receipts")
}

model RefreshToken {
  id        String   @id @default(uuid())
  userId    String
  tokenHash String
  expiresAt DateTime
  revokedAt DateTime?
  createdAt DateTime @default(now())
  user      User     @relation(fields: [userId], references: [id])

  @@index([userId])
  @@map("refresh_tokens")
}

model Activity {
  id          String       @id @default(uuid())
  groupId     String
  actorUserId String
  type        ActivityType
  entityId    String
  metadata    Json
  createdAt   DateTime     @default(now())
  group       Group        @relation(fields: [groupId], references: [id])
  actor       User         @relation(fields: [actorUserId], references: [id])

  @@index([groupId])
  @@index([createdAt])
  @@index([groupId, createdAt])
  @@map("activities")
}

model GroupInvite {
  id        String    @id @default(uuid())
  groupId   String
  email     String
  role      GroupRole @default(MEMBER)
  invitedBy String
  createdAt DateTime  @default(now())
  group     Group     @relation(fields: [groupId], references: [id])

  @@unique([groupId, email])
  @@index([email])
  @@map("group_invites")
}

model PushToken {
  id         String   @id @default(uuid())
  userId     String
  token      String   @unique
  deviceType String
  createdAt  DateTime @default(now())
  user       User     @relation(fields: [userId], references: [id])

  @@index([userId])
  @@map("push_tokens")
}

model Payment {
  id                    String        @id @default(uuid())
  groupId               String
  payerId               String
  receiverId            String
  amountCents           BigInt
  stripePaymentIntentId String        @unique
  idempotencyKey        String?       @unique
  status                PaymentStatus @default(pending)
  createdAt             DateTime      @default(now())
  group                 Group         @relation(fields: [groupId], references: [id])
  payer                 User          @relation("payment_payer", fields: [payerId], references: [id])
  receiver              User          @relation("payment_receiver", fields: [receiverId], references: [id])

  @@index([groupId])
  @@index([payerId])
  @@index([receiverId])
  @@map("payments")
}