schema.prisma

generator client {
  provider        = "prisma-client-js"
  binaryTargets   = ["native", "linux-musl"]
  previewFeatures = ["interactiveTransactions"]
}

datasource db {
  provider          = "mysql"
  url               = env("DATABASE_URL")
  shadowDatabaseUrl = env("SHADOW_DATABASE_URL")
}

model Address {
  id                 String                    @id @default(dbgenerated("(uuid())"))
  address            String                    @unique @db.VarChar(255)
  createdAt          DateTime                  @default(now())
  updatedAt          DateTime                  @updatedAt
  networkId          Int
  network            Network                   @relation(fields: [networkId], references: [id], onUpdate: Restrict)
  userProfiles       AddressesOnUserProfiles[]
  lastSynced         DateTime?
  syncing            Boolean                   @default(false)
  paybuttons         AddressesOnButtons[]
  transactions       Transaction[]
  clientPayments     ClientPayment[]
  transactionInputs  TransactionInput[]
  transactionOutputs TransactionOutput[]

  @@index([networkId], map: "Address_networkId_fkey")
}

model Paybutton {
  id             String               @id @default(dbgenerated("(uuid())"))
  name           String               @db.VarChar(255)
  buttonData     String               @db.LongText
  description    String               @db.LongText @default("")
  url            String               @db.VarChar(255) @default("")
  providerUserId String               @db.VarChar(255)
  user           UserProfile          @relation(fields: [providerUserId], references: [id], onUpdate: Restrict)
  createdAt      DateTime             @default(now())
  updatedAt      DateTime             @updatedAt
  addresses      AddressesOnButtons[]
  triggers       PaybuttonTrigger[]

  @@unique([name, providerUserId], map: "Paybutton_name_providerUserId_unique_constraint")
}

model AddressesOnButtons {
  paybuttonId String
  addressId   String
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt
  address     Address   @relation(fields: [addressId], references: [id])
  paybutton   Paybutton @relation(fields: [paybuttonId], references: [id], onDelete: Cascade)

  @@id([paybuttonId, addressId])
  @@index([addressId], map: "AddressesOnButtons_addressId_fkey")
}

model Network {
  id        Int       @id @default(autoincrement())
  slug      String    @unique @db.VarChar(255)
  title     String    @db.VarChar(255)
  ticker    String    @db.VarChar(255)
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  addresses Address[]
  prices    Price[]
}

model Transaction {
  id        String                 @id @default(dbgenerated("(uuid())"))
  hash      String                 @db.VarChar(255)
  amount    Decimal                @db.Decimal(24, 8)
  confirmed Boolean                @default(false)
  orphaned  Boolean                @default(false)
  timestamp Int
  addressId String
  opReturn String                @db.LongText @default("")
  address   Address                @relation(fields: [addressId], references: [id], onDelete: Cascade, onUpdate: Cascade)
  prices    PricesOnTransactions[]
  invoices  Invoice[]
  inputs    TransactionInput[]
  outputs   TransactionOutput[]

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

  @@unique([hash, addressId], name: "Transaction_hash_addressId_unique_constraint")
  @@index([addressId, timestamp], map: "Transaction_addressId_timestamp_idx")
}

model TransactionInput {
  id            String      @id @default(dbgenerated("(uuid())"))
  transactionId String
  addressId     String
  index         Int
  transaction   Transaction @relation(fields: [transactionId], references: [id], onDelete: Cascade)
  address       Address     @relation(fields: [addressId], references: [id], onDelete: Cascade)
  amount        Decimal     @db.Decimal(24, 8)

  @@index([transactionId])
  @@index([addressId])
}

model TransactionOutput {
  id            String      @id @default(dbgenerated("(uuid())"))
  transactionId String
  addressId     String
  index         Int
  transaction   Transaction @relation(fields: [transactionId], references: [id], onDelete: Cascade)
  address       Address     @relation(fields: [addressId], references: [id], onDelete: Cascade)
  amount        Decimal     @db.Decimal(24, 8)

  @@index([transactionId])
  @@index([addressId])
}

model Wallet {
  id             String                    @id @default(dbgenerated("(uuid())"))
  createdAt      DateTime                  @default(now())
  updatedAt      DateTime                  @updatedAt
  name           String                    @db.VarChar(255)
  providerUserId String                    @db.VarChar(255)
  userAddresses  AddressesOnUserProfiles[]
  userProfile    WalletsOnUserProfile?

  @@unique([name, providerUserId], map: "Wallet_name_providerUserId_unique_constraint")
}

model Quote {
  id        Int      @id @default(autoincrement())
  slug      String   @unique @db.VarChar(255)
  title     String   @db.VarChar(255)
  ticker    String   @db.VarChar(255)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  prices    Price[]
}

model Price {
  id           Int                    @id @default(autoincrement())
  value        Decimal                @db.Decimal(36, 14)
  createdAt    DateTime               @default(now())
  updatedAt    DateTime               @updatedAt
  timestamp    Int
  network      Network                @relation(fields: [networkId], references: [id], onUpdate: Restrict)
  networkId    Int
  quote        Quote                  @relation(fields: [quoteId], references: [id], onUpdate: Restrict)
  quoteId      Int
  transactions PricesOnTransactions[]

  @@unique([timestamp, quoteId, networkId], name: "Price_timestamp_quoteId_networkId_unique_constraint")
}

model PricesOnTransactions {
  priceId       Int
  transactionId String
  createdAt     DateTime    @default(now())
  updatedAt     DateTime    @updatedAt
  price         Price       @relation(fields: [priceId], references: [id], onUpdate: Cascade, onDelete: Cascade)
  transaction   Transaction @relation(fields: [transactionId], references: [id], onUpdate: Cascade, onDelete: Cascade)

  @@id([priceId, transactionId])
}

model AddressesOnUserProfiles {
  addressId     String
  userId String
  walletId      String?
  createdAt     DateTime    @default(now())
  updatedAt     DateTime    @updatedAt
  address       Address     @relation(fields: [addressId], references: [id], onDelete: Cascade)
  userProfile   UserProfile @relation(fields: [userId], references: [id], onDelete: Cascade)
  wallet        Wallet?     @relation(fields: [walletId], references: [id], onDelete: SetNull)

  @@id([userId, addressId])
}

model WalletsOnUserProfile {
  walletId      String      @unique
  userId String
  isXECDefault  Boolean?
  isBCHDefault  Boolean?
  createdAt     DateTime    @default(now())
  updatedAt     DateTime    @updatedAt
  wallet        Wallet      @relation(fields: [walletId], references: [id], onUpdate: Cascade, onDelete: Cascade)
  userProfile   UserProfile @relation(fields: [userId], references: [id], onUpdate: Cascade, onDelete: Cascade)

  @@id([walletId, userId])
  @@unique([userId, isBCHDefault], name: "WalletsOnUserProfile_userId_isBCHDefault_unique_constraint")
  @@unique([userId, isXECDefault], name: "WalletsOnUserProfile_userId_isXECDefault_unique_constraint")
}

model UserProfile {
  id        String                    @id @db.VarChar(255)
  createdAt DateTime                  @default(now())
  updatedAt DateTime                  @updatedAt
  isAdmin   Boolean?
  publicKey String                    @db.VarChar(255)@default("")
  lastSentVerificationEmailAt DateTime?
  wallets   WalletsOnUserProfile[]
  addresses AddressesOnUserProfiles[]
  invoices Invoice[]
  preferredCurrencyId Int @default(1)
  preferredTimezone String    @db.VarChar(255)@default("")
  csvRowCollapsing Boolean @default(true)
  proUntil DateTime?
  paybuttons   Paybutton[]

  organizationId String?
  organization Organization?     @relation(fields: [organizationId], references: [id], onDelete: SetNull)

  emailCredits Int  @default(5)
  postCredits Int  @default(5)
  }

model PaybuttonTrigger {
  id             String                    @id @default(dbgenerated("(uuid())"))
  paybuttonId    String
  createdAt      DateTime                  @default(now())
  updatedAt      DateTime                  @updatedAt
  postData       String               @db.LongText
  postURL        String               @db.VarChar(255)
  logs           TriggerLog[]
  emails         String               @db.Text @default("")
  isEmailTrigger Boolean               @default(false)
  deletedAt      DateTime?

  paybutton      Paybutton @relation(fields: [paybuttonId], references: [id], onDelete: Cascade)
}

model TriggerLog {
  id        Int       @id @default(autoincrement())
  triggerId String?
  trigger   PaybuttonTrigger? @relation(fields: [triggerId], references: [id], onDelete: SetNull)
  createdAt      DateTime                  @default(now())
  updatedAt      DateTime                  @updatedAt
  isError   Boolean
  actionType   String
  data       String               @db.LongText
}

model SideshiftShift {
  id                  String @id
  createdAt           DateTime
  depositCoin         String
  settleCoin          String
  depositNetwork      String
  settleNetwork       String
  depositAddress      String
  settleAddress       String
  depositMin          String
  depositMax          String
  averageShiftSeconds String
  depositAmount       String
  expiresAt           DateTime
  quoteId             String
  rate                String
  settleAmount        String
  status              String
  type                String
}

model Organization {
  id                          String                 @id @default(dbgenerated("(uuid())"))
  name                        String               
  createdAt                   DateTime               @default(now())
  updatedAt                   DateTime               @updatedAt
  creatorId String                                   @unique
  address                    String 
  users                       UserProfile[]
  invites                     OrganizationInvite[]
}

model OrganizationInvite {
  id                          String                 @id @default(dbgenerated("(uuid())"))
  createdAt                   DateTime               @default(now())
  updatedAt                   DateTime               @updatedAt
  usedBy                      String
  token                       String @unique

  organizationId String
  organization Organization     @relation(fields: [organizationId], references: [id], onDelete: Cascade)
}

model Invoice {
  id            String      @id @default(uuid())
  userId        String
  invoiceNumber String
  transactionId String?
  transaction   Transaction? @relation(fields: [transactionId], references: [id], onUpdate: Cascade, onDelete: Restrict)
  userProfile   UserProfile @relation(fields: [userId], references: [id], onUpdate: Cascade, onDelete: Restrict)

  amount           Decimal
  description      String
  recipientName    String
  recipientAddress String
  customerName     String
  customerAddress  String

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

  @@unique([invoiceNumber, userId], map: "Invoice_invoiceNumber_userId_unique_constraint")
  @@unique([transactionId, userId], map: "Invoice_transactionId_userId_unique_constraint")
}

enum ClientPaymentStatus {
 PENDING
 ADDED_TO_MEMPOOL
 CONFIRMED
}

model ClientPayment {
  paymentId            String                 @id
  status               ClientPaymentStatus               
  addressString        String
  amount               Decimal?              
  address              Address   @relation(fields: [addressString], references: [address])
  createdAt            DateTime               @default(now())
  updatedAt            DateTime               @updatedAt
}