schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

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

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

model User {
  id        Int      @id @default(autoincrement())
  address   String   @unique
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model VaultState {
  id          Int      @id @default(1)
  totalAssets String
  totalShares String
  updatedAt   DateTime @updatedAt
}

model SharePriceSnapshot {
  id          String   @id @default(uuid())
  sharePrice  String
  totalAssets String
  totalShares String
  source      String
  recordedAt  DateTime @default(now())
  createdAt   DateTime @default(now())

  @@index([recordedAt])
}

model Transaction {
  id           String   @id @default(uuid())
  user         String
  amount       String
  type         String
  status       String?
  referralCode String?
  timestamp    DateTime @default(now())
}

model Referral {
  id              Int       @id @default(autoincrement())
  referrerAddress String
  referredAddress String    @unique
  firstDepositAt  DateTime?
  createdAt       DateTime  @default(now())

  @@index([referrerAddress])
}

model ReferralCode {
  id           Int      @id @default(autoincrement())
  code         String   @unique
  ownerAddress String
  createdAt    DateTime @default(now())
}

model AdminAuditLog {
  id         String   @id
  action     String
  method     String
  path       String
  statusCode Int
  actor      String
  apiKeyHash String
  ipAddress  String
  userAgent  String
  metadata   String
  createdAt  DateTime @default(now())

  @@index([createdAt])
  @@index([action])
  @@index([actor])
}

model ApiKeyAuditEvent {
  id             String   @id @default(uuid())
  actor          String
  action         String
  keyFingerprint String
  createdAt      DateTime @default(now())

  @@index([action])
  @@index([createdAt])
  @@index([keyFingerprint])
}

model ExportJob {
  id                String   @id
  format            String
  fileName          String
  contentType       String
  checksum          String
  checksumAlgorithm String
  generatedBy       String
  walletAddress     String?
  rowCount          Int
  filters           String
  createdAt         DateTime @default(now())

  @@index([createdAt])
  @@index([checksum])
  @@index([generatedBy])
  @@index([walletAddress])
  @@index([format])
}

model BulkExportJob {
  id            String   @id
  status        String   @default("pending")
  format        String
  generatedBy   String
  filters       String
  totalRows     Int      @default(0)
  processedRows Int      @default(0)
  errorRows     Int      @default(0)
  artifactId    String?
  errorMessage  String?
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt
  completedAt   DateTime?

  @@index([status])
  @@index([createdAt])
  @@index([generatedBy])
}

model EventCursor {
  id                Int      @id @default(1)
  lastLedgerSeq     Int
  lastProcessedAt   DateTime @updatedAt
}

model ProcessedEvent {
  id              String   @id
  ledgerSeq       Int
  eventType       String
  contractId      String
  txHash          String
  processedAt     DateTime @default(now())

  @@index([ledgerSeq])
  @@index([txHash])
}

model WebhookEndpoint {
  id                    String    @id
  url                   String
  eventTypes            String    // JSON array
  enabled               Boolean   @default(true)
  secret                String?
  secretHash            String?
  verificationStatus    String    @default("pending")
  challengeTokenHash    String?
  challengeExpiresAt    DateTime?
  verifiedAt            DateTime?
  lastVerificationError String?
  createdAt             DateTime  @default(now())
  updatedAt             DateTime  @updatedAt
  deletedAt             DateTime?
  deletedBy             String?

  deliveries            WebhookDelivery[]

  @@index([createdAt])
  @@index([deletedAt])
  @@index([verificationStatus])
}

model WebhookDelivery {
  id          String    @id
  endpointId  String
  endpointUrl String
  eventType   String
  status      String
  attempts    Int
  deliveredAt DateTime?
  lastError   String?
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt

  endpoint    WebhookEndpoint @relation(fields: [endpointId], references: [id], onDelete: Cascade)

  @@index([createdAt])
  @@index([endpointId])
}

model AdminActionReceipt {
  id             String   @id @default(uuid())
  action         String
  actor          String
  timestamp      DateTime @default(now())
  inputHash      String
  resultingState String   // JSON string
  signature      String
  createdAt      DateTime @default(now())

  @@index([action])
  @@index([actor])
  @@index([timestamp])
}

model AdminImpersonationSession {
  id           String    @id @default(uuid())
  actor        String
  apiKeyHash   String
  targetWallet String
  reason       String
  startedAt    DateTime  @default(now())
  expiresAt    DateTime
  endedAt      DateTime?
  status       String    @default("active")
  ipAddress    String
  userAgent    String

  ledgerEntries AdminImpersonationLedgerEntry[]

  @@index([status])
  @@index([actor])
  @@index([targetWallet])
  @@index([startedAt])
  @@index([expiresAt])
}

model AdminImpersonationLedgerEntry {
  id        String   @id @default(uuid())
  sessionId String
  eventType String
  actor     String
  metadata  String
  createdAt DateTime @default(now())

  session AdminImpersonationSession @relation(fields: [sessionId], references: [id], onDelete: Cascade)

  @@index([sessionId])
  @@index([eventType])
  @@index([createdAt])
}

model EmailQueue {
  id          String    @id @default(uuid())
  to          String
  subject     String
  text        String?
  html        String?
  status      String    @default("pending")
  retryCount  Int       @default(0)
  maxRetries  Int       @default(5)
  nextRetryAt DateTime?
  lastError   String?
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt

  @@index([status])
  @@index([createdAt])
}

model WebhookDeadLetter {
  id                 String   @id @default(uuid())
  endpointId         String
  endpointUrl        String
  eventType          String
  payload            String
  attempts           Int
  lastError          String?
  originalDeliveryId String?
  createdAt          DateTime @default(now())
  updatedAt          DateTime @updatedAt
  retriedAt          DateTime?
  status             String   @default("dead-letter")

  @@index([endpointId])
  @@index([eventType])
  @@index([createdAt])
  @@index([status])
}

model AdminConfigChange {
  id                 String   @id @default(uuid())
  configType         String
  action             String
  actor              String
  ipAddress          String?
  userAgent          String?
  preChangeSnapshot  String
  postChangeSnapshot String
  metadata           String
  createdAt          DateTime @default(now())

  @@index([configType])
  @@index([createdAt])
  @@index([actor])
}

model FeatureFlagOverride {
  id        String   @id @default(uuid())
  flagName  String
  enabled   Boolean
  scopeType String   // "wallet" or "environment"
  scopeValue String?  // wallet address or environment name
  expiresAt DateTime
  actor     String
  createdAt DateTime @default(now())

  @@index([flagName])
  @@index([scopeType, scopeValue])
  @@index([expiresAt])
  @@index([actor])
}

model ExportManifest {
  id              String   @id
  requester       String
  reportType      String
  filters         String
  checksum        String
  generatedAt     DateTime
  fileName        String
  rowCount        Int
  bulkExportJobId String?
  artifactId      String?

  @@index([generatedAt])
  @@index([requester])
  @@index([reportType])
  @@index([checksum])
}

model ReconciliationSnapshot {
  id          String   @id
  generatedAt DateTime
  traceId     String?
  status      String
  windowFrom  DateTime
  windowTo    DateTime
  summaryJson String
  driftCount  Int

  @@index([generatedAt])
  @@index([status])
}

model TransactionBackfillJob {
  id                  String    @id
  jobKey              String    @unique
  startLedger         Int
  endLedger           Int
  batchSize           Int
  dryRun              Boolean
  status              String
  rpcUrl              String
  contractId          String
  lastProcessedLedger Int?
  progressJson        String
  errorMessage        String?
  createdAt           DateTime  @default(now())
  updatedAt           DateTime  @updatedAt
  completedAt         DateTime?

  @@index([status])
  @@index([createdAt])
  @@index([dryRun])
}