schema.prisma

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

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

model transactions {
  id          String     @id @default(uuid())
  name        String
  notes       String?
  status      String?
  type        String?
  price       Decimal    @default(0) @db.Decimal(10, 2)
  category    String?
  date        DateTime?
  tellerTxnId String?    @unique @map("teller_txn_id")
  Account     accounts?  @relation(fields: [accountId], references: [id], onDelete: Cascade)
  accountId   String?    @map("account_id")
  dateCreated DateTime   @default(now()) @map("date_created")
  dateUpdated DateTime   @default(now()) @updatedAt @map("date_updated")
  userId      String?    @map("user_id")
  merchantId  String?    @map("merchant_id")
  Merchant    merchants? @relation(fields: [merchantId], references: [id], onDelete: Cascade)
}

model merchants {
  id           String         @id @default(uuid())
  name         String         @unique
  Transactions transactions[]
}

model accounts {
  id              String         @id @default(uuid())
  name            String?
  lastFour        String?        @map("last_four")
  institutionId   String?        @map("institution_id")
  institutionName String?        @map("institution_name")
  status          String?
  type            String?
  subtype         String?
  currency        String?
  enrollmentId    String?        @map("enrollment_id")
  tellerAccountId String?        @unique @map("teller_account_id")
  userId          String?        @map("user_id")
  Transactions    transactions[]
}

model rules {
  id           String   @id @default(uuid())
  dateCreated  DateTime @default(now()) @map("date_created")
  dateUpdated  DateTime @default(now()) @updatedAt @map("date_updated")
  name         String?
  matchType    String?  @map("match_type")
  fieldToCheck String?  @map("field_to_check")
  keywords     String?
  fieldToSet   String?  @map("field_to_set")
  valueToSet   String?  @map("value_to_set")
}