schema.prisma

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

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

model Configuration {
  id                                     String  @id @default("default") @map("id")
  // Chains
  chainOverrides                         String? @map("chainOverrides")
  // Tx Processing
  minTxsToProcess                        Int     @map("minTxsToProcess")
  maxTxsToProcess                        Int     @map("maxTxsToProcess")
  // Tx Updates
  minedTxListenerCronSchedule            String? @map("minedTxsCronSchedule")
  maxTxsToUpdate                         Int     @map("maxTxsToUpdate")
  // Tx Retries
  retryTxListenerCronSchedule            String? @map("retryTxsCronSchedule")
  minEllapsedBlocksBeforeRetry           Int     @map("minEllapsedBlocksBeforeRetry")
  maxFeePerGasForRetries                 String  @map("maxFeePerGasForRetries")
  maxPriorityFeePerGasForRetries         String  @map("maxPriorityFeePerGasForRetries")
  maxRetriesPerTx                        Int     @map("maxRetriesPerTx")
  // Contract Indexer Updates
  indexerListenerCronSchedule            String? @map("indexerListenerCronSchedule")
  // cron to track balance of address 
  addressBalanceListenerCronSchedule     String? @map("addressBalanceListenerCronSchedule")
  maxBlocksToIndex                       Int     @default(25) @map("maxBlocksToIndex")
  cursorDelaySeconds                     Int     @default(2) @map("cursorDelaySeconds")
  contractSubscriptionsRetryDelaySeconds String  @default("10") @map("contractSubscriptionsRetryDelaySeconds")

  // AWS
  awsAccessKeyId                     String?  @map("awsAccessKeyId") /// global config, precedence goes to WalletDetails
  awsSecretAccessKey                 String?  @map("awsSecretAccessKey") /// global config, precedence goes to WalletDetails
  awsRegion                          String?  @map("awsRegion") /// global config, treat as "default", store in WalletDetails.awsKmsArn
  // GCP
  gcpApplicationProjectId            String?  @map("gcpApplicationProjectId") /// global config, treat as "default", store in WalletDetails.gcpKmsResourcePath
  gcpKmsLocationId                   String?  @map("gcpKmsLocationId") /// global config, treat as "default", store in WalletDetails.gcpKmsResourcePath
  gcpKmsKeyRingId                    String?  @map("gcpKmsKeyRingId") /// global config, treat as "default", store in WalletDetails.gcpKmsResourcePath
  gcpApplicationCredentialEmail      String?  @map("gcpApplicationCredentialEmail") /// global config, precedence goes to WalletDetails
  gcpApplicationCredentialPrivateKey String?  @map("gcpApplicationCredentialPrivateKey") /// global config, precedence goes to WalletDetails
  // Auth
  authDomain                         String   @default("") @map("authDomain") // TODO: Remove defaults on major
  authWalletEncryptedJson            String   @default("") @map("authWalletEncryptedJson") // TODO: Remove defaults on major
  // Webhook
  webhookUrl                         String?  @map("webhookUrl")
  webhookAuthBearerToken             String?  @map("webhookAuthBearerToken")
  // Wallet balance
  minWalletBalance                   String   @default("20000000000000000") @map("minWalletBalance")
  accessControlAllowOrigin           String   @default("https://thirdweb.com,https://embed.ipfscdn.io") @map("accessControlAllowOrigin")
  ipAllowlist                        String[] @default([]) @map("ipAllowlist")
  clearCacheCronSchedule             String   @default("*/30 * * * * *") @map("clearCacheCronSchedule")

  @@map("configuration")
}

model Permissions {
  walletAddress String  @id @map("walletAddress")
  permissions   String  @map("permissions")
  label         String? @map("label")

  @@map("permissions")
}

model Tokens {
  id            String    @id @map("id")
  tokenMask     String    @map("tokenMask")
  walletAddress String    @map("walletAddress")
  createdAt     DateTime  @default(now()) @map("createdAt")
  expiresAt     DateTime  @map("expiresAt")
  revokedAt     DateTime? @map("revokedAt")
  isAccessToken Boolean   @map("isAccessToken")
  label         String?   @map("label")

  @@map("tokens")
}

model WalletDetails {
  address                            String  @id @map("address")
  type                               String  @map("type")
  label                              String? @map("label")
  // Local
  encryptedJson                      String? @map("encryptedJson")
  // KMS
  awsKmsKeyId                        String? @map("awsKmsKeyId") /// deprecated and unused, todo: remove with next breaking change. Use awsKmsArn
  awsKmsArn                          String? @map("awsKmsArn")
  awsKmsSecretAccessKey              String? @map("awsKmsSecretAccessKey") /// if not available, default to: Configuration.awsSecretAccessKey
  awsKmsAccessKeyId                  String? @map("awsKmsAccessKeyId") /// if not available, default to: Configuration.awsAccessKeyId
  // GCP
  gcpKmsKeyRingId                    String? @map("gcpKmsKeyRingId") @db.VarChar(50) /// deprecated and unused. Use gcpKmsResourcePath instead, todo: remove with next breaking change
  gcpKmsKeyId                        String? @map("gcpKmsKeyId") @db.VarChar(50) /// deprecated and unused. Use gcpKmsResourcePath instead, todo: remove with next breaking change
  gcpKmsKeyVersionId                 String? @map("gcpKmsKeyVersionId") @db.VarChar(20) /// deprecated and unused. Use gcpKmsResourcePath instead, todo: remove with next breaking change
  gcpKmsLocationId                   String? @map("gcpKmsLocationId") @db.VarChar(20) /// deprecated and unused. Use gcpKmsResourcePath instead, todo: remove with next breaking change
  gcpKmsResourcePath                 String? @map("gcpKmsResourcePath") @db.Text
  gcpApplicationCredentialEmail      String? @map("gcpApplicationCredentialEmail") /// if not available, default to: Configuration.gcpApplicationCredentialEmail
  gcpApplicationCredentialPrivateKey String? @map("gcpApplicationCredentialPrivateKey") /// if not available, default to: Configuration.gcpApplicationCredentialPrivateKey
  // Smart Backend Wallet
  accountSignerAddress               String? @map("accountSignerAddress") /// this, and either local, aws or gcp encryptedJson, are required for smart wallet
  accountFactoryAddress              String? @map("accountFactoryAddress") /// optional even for smart wallet, if not available default factory will be used
  entrypointAddress                  String? @map("entrypointAddress") /// optional even for smart wallet, if not available SDK will use default entrypoint

  @@map("wallet_details")
}

model WalletNonce {
  address String @map("address")
  chainId String @map("chainId")
  nonce   Int    @default(0) @map("nonce")

  @@id([address, chainId])
  @@map("wallet_nonce")
}

model Transactions {
  id                        String    @id @default(uuid()) @map("id")
  // Backward compatibility: default to db-generated UUID.
  idempotencyKey            String    @unique @default(dbgenerated("gen_random_uuid()")) @map("idempotencyKey")
  groupId                   String?   @map("groupId")
  chainId                   String    @map("chainId")
  // Shared
  data                      String?   @map("data")
  value                     String?   @map("value")
  gasLimit                  String?   @map("gasLimit")
  nonce                     Int?      @map("nonce")
  maxFeePerGas              String?   @map("maxFeePerGas")
  maxPriorityFeePerGas      String?   @map("maxPriorityFeePerGas")
  // Transaction Details
  fromAddress               String?   @map("fromAddress")
  toAddress                 String?   @map("toAddress")
  gasPrice                  String?   @map("gasPrice")
  transactionType           Int?      @map("transactionType")
  transactionHash           String?   @map("transactionHash")
  onChainTxStatus           Int?      @map("onChainTxStatus")
  // User Operation
  signerAddress             String?   @map("signerAddress")
  accountAddress            String?   @map("accountAddress")
  target                    String?   @map("target")
  sender                    String?   @map("sender")
  initCode                  String?   @map("initCode")
  callData                  String?   @map("callData")
  callGasLimit              String?   @map("callGasLimit")
  verificationGasLimit      String?   @map("verificationGasLimit")
  preVerificationGas        String?   @map("preVerificationGas")
  paymasterAndData          String?   @map("paymasterAndData")
  userOpHash                String?   @map("userOpHash")
  // Enriched Data
  functionName              String?   @map("functionName")
  functionArgs              String?   @map("functionArgs")
  extension                 String?   @map("extension")
  // TODO: These shouldn't be in here...
  deployedContractAddress   String?   @map("deployedContractAddress")
  deployedContractType      String?   @map("deployedContractType")
  // Timestamps
  queuedAt                  DateTime  @default(now()) @map("queuedAt")
  // @deprecated
  processedAt               DateTime? @map("processedAt")
  sentAt                    DateTime? @map("sentAt")
  minedAt                   DateTime? @map("minedAt")
  cancelledAt               DateTime? @map("cancelledAt")
  // Retries
  retryCount                Int       @default(0) @map("retryCount")
  retryGasValues            Boolean?  @default(false) @map("retryGasValues")
  retryMaxPriorityFeePerGas String?   @map("retryMaxPriorityFeePerGas")
  retryMaxFeePerGas         String?   @map("retryMaxFeePerGas")
  // Error
  errorMessage              String?   @map("errorMessage")
  // Block Numbers
  sentAtBlockNumber         Int?      @map("sentAtBlockNumber")
  blockNumber               Int?      @map("blockNumber")

  @@index([sentAt, minedAt, cancelledAt, errorMessage, queuedAt])
  @@index([sentAt, accountAddress, userOpHash, minedAt, errorMessage, retryCount])
  @@index([sentAt, transactionHash, accountAddress, minedAt, errorMessage, nonce])
  @@index([queuedAt])
  @@map("transactions")
}

model Webhooks {
  id                    Int                     @id @default(autoincrement()) @map("id")
  name                  String?                 @map("name")
  url                   String                  @map("url")
  secret                String                  @map("secret")
  eventType             String                  @map("evenType")
  config                Json?                   @map("config")
  createdAt             DateTime                @default(now()) @map("createdAt")
  updatedAt             DateTime                @updatedAt @map("updatedAt")
  revokedAt             DateTime?               @map("revokedAt")
  ContractSubscriptions ContractSubscriptions[]

  @@map("webhooks")
}

model Relayers {
  id                   String  @id @default(uuid()) @map("id")
  name                 String? @map("name")
  chainId              String  @map("chainId")
  backendWalletAddress String  @map("backendWalletAddress")
  allowedContracts     String? @map("allowedContracts")
  allowedForwarders    String? @map("allowedForwarders")

  @@map("relayers")
}

model ContractSubscriptions {
  id                         String   @id @default(uuid()) @map("id")
  chainId                    String
  contractAddress            String
  webhookId                  Int?
  processEventLogs           Boolean  @default(true)
  filterEvents               String[] @default([]) // empty array = no filter
  processTransactionReceipts Boolean  @default(true)
  filterFunctions            String[] @default([]) // empty array = no filter

  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  deletedAt DateTime?

  webhook Webhooks? @relation(fields: [webhookId], references: [id], onDelete: SetNull)

  // optimize distinct lookups
  @@index([chainId])
  @@map("contract_subscriptions")
}

model ContractEventLogs {
  chainId          String
  blockNumber      Int
  contractAddress  String
  transactionHash  String
  topic0           String?
  topic1           String?
  topic2           String?
  topic3           String?
  data             String
  eventName        String?
  decodedLog       Json?
  timestamp        DateTime
  transactionIndex Int
  logIndex         Int
  createdAt        DateTime @default(now())
  updatedAt        DateTime @updatedAt

  @@id([transactionHash, logIndex])
  @@index([timestamp])
  @@index([blockNumber])
  @@index([contractAddress])
  @@index([topic0])
  @@index([topic1])
  @@index([topic2])
  @@index([topic3])
  @@map("contract_event_logs")
}

model ContractTransactionReceipts {
  chainId         String
  blockNumber     Int
  contractAddress String
  contractId      String // ${chainId}:${contractAddress}
  transactionHash String
  blockHash       String
  timestamp       DateTime
  data            String
  functionName    String?

  to               String
  from             String
  value            String
  transactionIndex Int

  gasUsed           String
  effectiveGasPrice String
  status            Int

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@unique([chainId, transactionHash])
  @@index([contractId, timestamp])
  @@index([contractId, blockNumber])
  @@map("contract_transaction_receipts")
}

model ChainIndexers {
  chainId          String @id
  lastIndexedBlock Int

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@map("chain_indexers")
}

model Keypairs {
  hash      String   @id
  publicKey String
  algorithm String
  label     String?
  createdAt DateTime @default(now())
  updatedAt DateTime @default(now())

  @@map("keypairs")
}