generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["views"]
}

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

model User {
  id                              String                     @id
  email                           String                     @unique
  firstName                       String
  lastName                        String
  role                            UserRole                   @default(applicant)
  createdAt                       DateTime                   @default(now())
  updatedAt                       DateTime                   @default(now()) @updatedAt
  devId                           String?                    @unique
  hashedPassword                  String?
  emailVerified                   DateTime?
  Account                         Account[]
  applications                    Application[]              @relation("ApplicationToUser")
  conversations                   Conversation[]
  conversationSessionLog          ConversationSessionLog[]
  ConversationsToUsers            ConversationsToUsers[]
  messages                        Message[]
  Session                         Session[]
  WorkflowSchema                  WorkflowSchema[]
  WorkflowSubmission              WorkflowSubmission[]
  authorizedOrganizationsStatuses OrganizationStatus[]       @relation("AuthorizedUsers")
  Chore                           Chore[]                    @relation("ChoreToUser")
  ChoreTrigger                    ChoreTrigger[]             @relation("ChoreTriggerToUser")
  organizations                   Organization[]             @relation("OrganizationToUser")
  comments                        ConversationComment[]
  UserAllowedOrganizations        UserAllowedOrganizations[]
}

model UserAllowedOrganizations {
  id             String       @id @default(cuid())
  createdAt      DateTime     @default(now())
  updatedAt      DateTime     @default(now()) @updatedAt
  userId         String
  organizationId String
  user           User         @relation(fields: [userId], references: [id])
  organization   Organization @relation(fields: [organizationId], references: [id])
}

model TempUserHashPassword {
  id             String   @id @default(cuid())
  createdAt      DateTime @default(now())
  updatedAt      DateTime @default(now())
  hashedPassword String
  userId         String
}

model Integration {
  id                  String               @id @default(cuid())
  createdAt           DateTime             @default(now())
  updatedAt           DateTime             @default(now()) @updatedAt
  name                String
  description         String?
  logoUrl             String?
  integrationProducts IntegrationProduct[]
}

model IntegrationProduct {
  id            String      @id @default(cuid())
  createdAt     DateTime    @default(now())
  updatedAt     DateTime    @default(now()) @updatedAt
  integrationId String
  productId     String
  integration   Integration @relation(fields: [integrationId], references: [id])
  product       Product     @relation(fields: [productId], references: [id])
}

model Endpoint {
  id          String @id @default(cuid())
  description String

  // inputEntities EntityView[]
  // outputEntities EntityField[]

  rpcEndpoint String
}

model Message {
  id                 String              @id @default(cuid())
  text               String
  timestamp          DateTime            @default(now())
  messageType        MessageType
  aiThoughtProcess   String?
  approvedById       String?
  approvedAt         DateTime?
  conversationId     String
  uploadRequired     Boolean             @default(false)
  systemMessage      String?
  subject            String?             @default("")
  attachments        String[]            @default([])
  source             Company?
  sourceId           String?
  contactId          String?
  sourceMetadata     Json?
  approvedBy         User?               @relation(fields: [approvedById], references: [id])
  contact            Contact?            @relation(fields: [contactId], references: [id])
  conversation       Conversation        @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  messageAttachments MessageAttachment[]
}

model MessageAttachment {
  id             String       @id @default(cuid())
  createdAt      DateTime     @default(now())
  updatedAt      DateTime     @default(now()) @updatedAt
  messageId      String
  conversationId String
  url            String
  name           String
  message        Message      @relation(fields: [messageId], references: [id], onDelete: Cascade)
  conversation   Conversation @relation(fields: [conversationId], references: [id], onDelete: Cascade)

  @@index([messageId])
  @@index([conversationId])
}

model ClientFile {
  id                 String             @id @default(cuid())
  createdAt          DateTime           @default(now())
  updatedAt          DateTime           @default(now()) @updatedAt
  requiredName       String
  uploadedName       String?
  conversationId     String
  url                String?
  previewUrl         String?
  status             ClientFileStatus   @default(pending)
  Description        String?
  RejectionReasoning String?
  Visibility         Visibility         @default(private)
  fileType           String?
  statusId           String?
  documentType       DocumentType       @default(OTHER)
  conversation       Conversation       @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  extractedValues    ExtractedValue[]
  triggerId          String?
  trigger            FileStatusTrigger? @relation(fields: [triggerId], references: [id])
}

model ExtractedValue {
  id           String     @id @default(cuid())
  name         String
  createdAt    DateTime   @default(now())
  updatedAt    DateTime   @default(now()) @updatedAt
  value        String
  clientFileId String
  displayName  String
  clientFile   ClientFile @relation(fields: [clientFileId], references: [id], onDelete: Cascade)
}

model Client {
  id              String         @id @default(cuid())
  createdAt       DateTime       @default(now())
  updatedAt       DateTime       @default(now()) @updatedAt
  firstName       String?
  lastName        String?
  name            String?
  organizationId  String
  activeContactId String?
  caseId          String?
  Case            Case?
  organization    Organization   @relation(fields: [organizationId], references: [id])
  contacts        Contact[]
  conversations   Conversation[] @relation("conversationToClient")
}

model Contact {
  id         String              @id @default(cuid())
  createdAt  DateTime            @default(now())
  updatedAt  DateTime            @default(now()) @updatedAt
  detail     String
  mode       CommunicationMedium
  clientId   String
  creationId String?
  Client     Client              @relation(fields: [clientId], references: [id], onDelete: Cascade)
  messages   Message[]
}

model Account {
  id                String  @id
  userId            String
  type              String
  provider          String
  providerAccountId String
  refresh_token     String?
  access_token      String?
  expires_at        Int
  token_type        String?
  scope             String?
  id_token          String?
  session_state     String?
  User              User    @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([provider, providerAccountId])
}

model LandingContactForm {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @default(now())
  email     String
  name      String?
  company   String?
  message   String?
}

model EmailVerification {
  id      String   @id
  expires DateTime
  code    String   @unique
  userId  String   @unique
}

model Session {
  id           String   @id
  sessionToken String   @unique
  userId       String
  expires      DateTime
  User         User     @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model Case {
  id                   String         @id @default(cuid())
  createdAt            DateTime       @default(now())
  updatedAt            DateTime       @default(now()) @updatedAt
  organizationId       String
  aiTimestampLock      DateTime       @default(now())
  creationId           String?
  activeConversationId String?
  clientId             String?        @unique
  role                 UserRole       @default(lead)
  client               Client?        @relation(fields: [clientId], references: [id])
  organization         Organization   @relation(fields: [organizationId], references: [id])
  FunctionTask         FunctionTask[]
  Memory               Memory[]
  conversations        Conversation[] @relation("CaseToConversation")
}

model Conversation {
  id                          String                      @id @default(cuid())
  createdAt                   DateTime                    @default(now())
  updatedAt                   DateTime                    @default(now()) @updatedAt
  purpose                     String                      @default("")
  organizationId              String
  humanOperatorId             String?
  productId                   String
  initial_delay               Int                         @default(30)
  actionStatus                ActionStatus                @default(PROCESSING)
  conversationStatusUpdatedAt DateTime?
  organizationStatusId        String?
  productStatusId             String?
  applicationId               String?
  aiTimestampLock             DateTime                    @default(now())
  conversationStateId         String?
  metadata                    Json?
  rating                      Int?
  application                 Application?
  attributeValues             AttributeValue[]
  chores                      Chore[]
  ClientFact                  ClientFact[]
  clientFiles                 ClientFile[]
  humanOperator               User?                       @relation(fields: [humanOperatorId], references: [id])
  organization                Organization                @relation(fields: [organizationId], references: [id])
  organizationStatus          OrganizationStatus?         @relation(fields: [organizationStatusId], references: [id])
  product                     Product                     @relation(fields: [productId], references: [id])
  ProductStatus               ProductStatus?              @relation(fields: [productStatusId], references: [id])
  ConversationCheck           ConversationCheck[]
  classifications             ConversationClassfication[]
  ConversationDisplay         ConversationDisplay[]
  conversationSessionLog      ConversationSessionLog[]
  ConversationsToUsers        ConversationsToUsers[]
  FunctionTask                FunctionTask[]
  Memory                      Memory[]
  messages                    Message[]
  Reminders                   Reminders[]
  workflowFieldValues         WorkflowFieldValues[]
  workflowSubmissions         WorkflowSubmission[]
  cases                       Case[]                      @relation("CaseToConversation")
  clients                     Client[]                    @relation("conversationToClient")
  comments                    ConversationComment[]
  ipInfo                      String?
  ipAddress                   String?
  unstructuredMessages        UnstructuredMessage[]
  messageAttachments          MessageAttachment[]
  viewEntities                EntityView[]

  businessAddressInfo Json?
}

model ConversationSessionLog {
  id             String       @id @default(cuid())
  createdAt      DateTime     @default(now())
  updatedAt      DateTime     @default(now()) @updatedAt
  userId         String
  conversationId String
  active         Boolean      @default(true)
  conversation   Conversation @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  user           User         @relation(fields: [userId], references: [id])
}

model ConversationsToUsers {
  id             String       @id @default(cuid())
  createdAt      DateTime     @default(now())
  updatedAt      DateTime     @default(now()) @updatedAt
  conversationId String
  userId         String
  conversation   Conversation @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  user           User         @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([conversationId, userId])
}

model ConversationCheck {
  id             String                    @id @default(cuid())
  createdAt      DateTime                  @default(now())
  updatedAt      DateTime                  @default(now()) @updatedAt
  conversationId String
  value          String?
  status         ConversationCheckStatus   @default(PENDING)
  description    String?
  fieldName      String
  formType       OrganizationCheckFormType @default(TEXTAREA)
  options        String?
  conversation   Conversation              @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  triggerId      String?
  trigger        CheckStatusTrigger?       @relation(fields: [triggerId], references: [id])

  @@unique([conversationId, fieldName])
}

model OrganizationDisplay {
  id                  String                @id @default(cuid())
  createdAt           DateTime              @default(now())
  updatedAt           DateTime              @default(now()) @updatedAt
  organizationId      String
  fieldName           String
  description         String?
  ConversationDisplay ConversationDisplay[]
  organization        Organization          @relation(fields: [organizationId], references: [id])
}

model ConversationDisplay {
  id                    String              @id @default(cuid())
  createdAt             DateTime            @default(now())
  updatedAt             DateTime            @default(now()) @updatedAt
  conversationId        String
  organizationDisplayId String
  value                 String?
  status                displayStatus       @default(unknown)
  conversation          Conversation        @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  organizationDisplay   OrganizationDisplay @relation(fields: [organizationDisplayId], references: [id], onDelete: Cascade)
}

model Organization {
  id                       String                                @id @default(cuid())
  name                     String
  apiKey                   String
  createdAt                DateTime                              @default(now())
  updatedAt                DateTime                              @default(now()) @updatedAt
  organizationEmail        String?
  organizationEmailToken   Json?
  organizationHistoryId    String?
  description              String?
  accentColor              String?
  bigLogoUrl               String?
  mainColor                String?
  smallLogoUrl             String?
  websiteUrl               String?
  defaultProductId         String?                               @unique
  applications             Application[]                         @relation("OrganizationToApplication")
  Case                     Case[]
  Chore                    Chore[]
  Client                   Client[]
  conversations            Conversation[]
  Document                 Document[]
  MetaDocument             MetaDocument[]
  defaultProduct           Product?                              @relation("DefaultProduct", fields: [defaultProductId], references: [id])
  OrganizationDisplay      OrganizationDisplay[]
  organizationStatuses     OrganizationStatus[]
  products                 Product[]                             @relation("OrganizationProducts")
  users                    User[]                                @relation("OrganizationToUser")
  unstructuredMessages     UnstructuredMessage[]
  incomingMailIntegrations OrganizationIncomingMailIntegration[]
  publicLogoUrl            String?
  baseUrl                  String?
  newlineAddress           String?
  UserAllowedOrganizations UserAllowedOrganizations[]
}

model OrganizationIncomingMailIntegration {
  id              String                      @id @default(cuid())
  createdAt       DateTime                    @default(now())
  updatedAt       DateTime                    @default(now()) @updatedAt
  organizationId  String
  integrationId   String
  integrationType IncomingMailIntegrationType
  organization    Organization                @relation(fields: [organizationId], references: [id])

  @@unique([organizationId, integrationId])
}

model Product {
  organizationId       String
  id                   String                  @id @default(cuid())
  name                 String
  description          String
  agentId              String
  createdAt            DateTime                @default(now())
  updatedAt            DateTime?               @updatedAt
  Attribute            Attribute[]
  conversations        Conversation[]
  Organization         Organization?           @relation("DefaultProduct")
  agent                Agent                   @relation(fields: [agentId], references: [id])
  organization         Organization            @relation("OrganizationProducts", fields: [organizationId], references: [id])
  classicications      ProductClassification[]
  productStatuses      ProductStatus[]
  WorkflowSchema       WorkflowSchema[]
  entities             Entity[]                @relation("EntityToProduct")
  metaDocuments        MetaDocument[]
  reactions            SystemOneReaction[]
  customTables         CustomTable[]
  integrationsProducts IntegrationProduct[]
}

model OrganizationStatus {
  id                String         @id @default(cuid())
  createdAt         DateTime       @default(now())
  updatedAt         DateTime       @default(now()) @updatedAt
  name              String
  description       String?
  organizationId    String
  isPublic          Boolean        @default(false)
  order             Int            @default(0)
  publicDescription String?
  Conversation      Conversation[]
  organization      Organization   @relation(fields: [organizationId], references: [id])
  authorizedUsers   User[]         @relation("AuthorizedUsers")
}

model FileStatusTrigger {
  id                     String        @id @default(cuid())
  createdAt              DateTime      @default(now())
  requiredFileName       String
  description            String?
  requiredFileVisibility Visibility
  productStatusId        String
  documentType           DocumentType  @default(OTHER)
  productStatus          ProductStatus @relation(fields: [productStatusId], references: [id])
  files                  ClientFile[]
}

model WorkflowTrigger {
  id              String         @id @default(cuid())
  createdAt       DateTime       @default(now())
  updatedAt       DateTime       @default(now()) @updatedAt
  workflowId      String
  productStatusId String
  productStatus   ProductStatus  @relation(fields: [productStatusId], references: [id])
  workflow        WorkflowSchema @relation(fields: [workflowId], references: [id])
}

model CheckStatusTrigger {
  id                 String                    @id @default(cuid())
  createdAt          DateTime                  @default(now())
  fieldName          String
  description        String?
  formType           OrganizationCheckFormType
  options            String?
  productStatusId    String
  productStatus      ProductStatus             @relation(fields: [productStatusId], references: [id])
  conversationChecks ConversationCheck[]
}

model ProductClassification {
  id                          String                      @id @default(cuid())
  createdAt                   DateTime                    @default(now())
  updatedAt                   DateTime                    @default(now()) @updatedAt
  name                        String
  description                 String?
  condition                   String?
  productId                   String
  color                       String                      @default("#3b82f7")
  icon                        String?
  conversationClassifications ConversationClassfication[]
  product                     Product                     @relation(fields: [productId], references: [id])
}

model ConversationClassfication {
  id              String                @id @default(cuid())
  createdAt       DateTime              @default(now())
  updatedAt       DateTime              @default(now()) @updatedAt
  conversationId  String
  classficationId String
  classfication   ProductClassification @relation(fields: [classficationId], references: [id], onDelete: Cascade)
  conversation    Conversation          @relation(fields: [conversationId], references: [id], onDelete: Cascade)
}

model ProductStatus {
  id                 String               @id @default(cuid())
  createdAt          DateTime             @default(now())
  updatedAt          DateTime             @updatedAt
  name               String
  description        String?
  isPublic           Boolean              @default(false)
  order              Int                  @default(0)
  publicDescription  String?
  productId          String
  aiInstructions     String?              @default("")
  initial            Boolean              @default(false)
  CheckStatusTrigger CheckStatusTrigger[]
  ChoreTrigger       ChoreTrigger[]
  factStatusTriggers ClientFactTrigger[]
  Conversation       Conversation[]
  fileStatusTriggers FileStatusTrigger[]
  Product            Product              @relation(fields: [productId], references: [id])
  workflowTriggers   WorkflowTrigger[]
  workflowSchemas    WorkflowSchema[]     @relation("ProductStatusToWorkflowSchema")
  workflowSchemaId   String?
}

model Agent {
  id           String    @id @default(cuid())
  name         String
  agentType    AgentType
  agentVersion String
  description  String
  createdAt    DateTime  @default(now())
  updatedAt    DateTime  @default(now()) @updatedAt
  imageUrl     String?
  products     Product[]
}

model SystemOneReaction {
  id                        String                     @id @default(cuid())
  createdAt                 DateTime                   @default(now())
  updatedAt                 DateTime                   @default(now()) @updatedAt
  trigger                   Json
  name                      String                     @default("")
  response                  SystemOneResponse?
  productId                 String
  product                   Product                    @relation(fields: [productId], references: [id])
  active                    Boolean                    @default(false)
  deleted                   DateTime?
  systemOneReactionLogItems SystemOneReactionLogItem[]

  @@index([trigger(ops: JsonbPathOps)], type: Gin)
}

model SystemOneReactionLogItem {
  id             String            @id @default(cuid())
  createdAt      DateTime          @default(now())
  updatedAt      DateTime          @default(now()) @updatedAt
  reactionId     String
  reaction       SystemOneReaction @relation(fields: [reactionId], references: [id])
  organizationId String
  reactionJson   Json
  stateJson      Json
}

model SystemOneResponse {
  id         String            @id @default(cuid())
  name       String
  createdAt  DateTime          @default(now())
  updatedAt  DateTime          @default(now()) @updatedAt
  reactionId String            @unique
  reaction   SystemOneReaction @relation(fields: [reactionId], references: [id])
  actions    SystemOneAction[]
}

model SystemOneAction {
  id                  String                           @id
  createdAt           DateTime                         @default(now())
  updatedAt           DateTime                         @default(now()) @updatedAt
  systemOneResponseId String
  systemOneResponse   SystemOneResponse                @relation(fields: [systemOneResponseId], references: [id])
  arguments           SystemOneFunctionArgumentValue[]
  functionId          String
  function            Function                         @relation(fields: [functionId], references: [id], onDelete: Cascade)
}

model SystemOneFunctionArgumentValue {
  id         String           @id
  createdAt  DateTime         @default(now())
  updatedAt  DateTime         @default(now()) @updatedAt
  value      String?
  argumentId String
  actionId   String
  action     SystemOneAction  @relation(fields: [actionId], references: [id])
  argument   FunctionArgument @relation(fields: [argumentId], references: [id])
}

model Application {
  id                           String        @id @default(cuid())
  createdAt                    DateTime      @default(now())
  updatedAt                    DateTime      @default(now()) @updatedAt
  businessName                 String
  industry                     String
  creditAmount                 Float
  loanPurpose                  String
  businessAddress              String
  businessCity                 String?
  businessState                String?
  businessZipCode              String?
  ownerMaritalStatus           String?
  ssn                          String
  phoneNo                      String
  ownershipPercentage          Float
  numberOfOwners               Int?
  ownerAddress                 String
  ownerCity                    String?
  ownerState                   String?
  ownerZipCode                 String?
  organizationId               String?
  userId                       String?
  businessWebsite              String?
  ownerIsActiveInMilitary      Boolean?
  taxPayerIdentificationNumber String?
  conversationId               String?       @unique
  emailAddress                 String?
  fullYearsIncorporated        Int           @default(0)
  lastYearRevenue              Float         @default(0)
  ownerFirstName               String
  ownerLastName                String
  pastBankruptcy               Boolean?
  womenOwned                   Boolean?
  yearBeforeRevenue            Float         @default(0)
  incorporationDate            DateTime?
  businessType                 String?
  conversation                 Conversation? @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  organization                 Organization? @relation("OrganizationToApplication", fields: [organizationId], references: [id])
  user                         User?         @relation("ApplicationToUser", fields: [userId], references: [id])
}

model Reminders {
  id                String       @id
  createdAt         DateTime     @default(now())
  updatedAt         DateTime?    @default(now()) @updatedAt
  conversationId    String
  duration          Int          @default(0)
  lastLeadEventDate DateTime     @default(now())
  triggerDate       DateTime
  type              ReminderType @default(automatic)
  Conversation      Conversation @relation(fields: [conversationId], references: [id], onDelete: Cascade)
}

model FunctionReminder {
  id          String   @id
  triggerDate DateTime
}

model ClientFact {
  id                 String             @id @default(cuid())
  createdAt          DateTime           @default(now())
  updatedAt          DateTime           @default(now()) @updatedAt
  question           String
  conversationId     String
  RejectionReasoning String?
  Description        String?
  fact               String?
  statusId           String?
  clientFactStatus   ClientFileStatus   @default(pending)
  Conversation       Conversation       @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  triggerId          String?
  trigger            ClientFactTrigger? @relation(fields: [triggerId], references: [id])
}

model ClientFactTrigger {
  id              String        @id @default(cuid())
  createdAt       DateTime      @default(now())
  updatedAt       DateTime      @default(now()) @updatedAt
  question        String
  description     String        @default("")
  productStatusId String
  productStatus   ProductStatus @relation(fields: [productStatusId], references: [id])
  clientFacts     ClientFact[]
}

model WorkflowFields {
  id                String                @id(map: "WWorkflowField_pkey") @default(cuid())
  createdAt         DateTime              @default(now())
  updatedAt         DateTime              @default(now()) @updatedAt
  name              String
  description       String?
  order             Int
  dataType          FormFieldType
  required          Boolean               @default(true)
  isInput           Boolean               @default(false)
  workflowSchemaId  String
  options           String?
  codeName          String?
  entityFieldId     String?
  defaultValue      String?
  workflowCardId    String?
  orderWithinCard   Int                   @default(0)
  caseInitiation    Boolean               @default(false)
  validation        String?
  values            WorkflowFieldValues[]
  tenantEntityField EntityField?          @relation(fields: [entityFieldId], references: [id], map: "WWorkflowField_entityFieldId_fkey")
  workflowCard      WorkflowCard?         @relation(fields: [workflowCardId], references: [id], map: "WWorkflowField_workflowCardId_fkey")
  workflowSchema    WorkflowSchema        @relation(fields: [workflowSchemaId], references: [id], onDelete: Cascade, map: "WWorkflowField_workflowSchemaId_fkey")
  metadata          String?

  @@unique([workflowSchemaId, codeName], map: "WWorkflowField_workflowSchemaId_codeName_key")
}

model WorkflowFieldValues {
  id              String         @id @default(cuid())
  createdAt       DateTime       @default(now())
  updatedAt       DateTime       @default(now()) @updatedAt
  value           String?
  workflowFieldId String
  conversationId  String
  pinned          Boolean        @default(false)
  status          displayStatus  @default(unknown)
  Conversation    Conversation   @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  WorkflowField   WorkflowFields @relation(fields: [workflowFieldId], references: [id], onDelete: Cascade)
}

model Attribute {
  id          String           @id @default(uuid())
  createdAt   DateTime         @default(now())
  updatedAt   DateTime         @default(now()) @updatedAt
  name        String
  type        String
  description String?
  enumOptions String[]
  dataType    String
  optional    Boolean          @default(false)
  placeholder String?
  displayName String?
  productId   String?
  product     Product?         @relation(fields: [productId], references: [id])
  values      AttributeValue[]
}

model AttributeValue {
  id             String        @id @default(uuid())
  createdAt      DateTime      @default(now())
  updatedAt      DateTime      @default(now()) @updatedAt
  value          String?
  attributeId    String
  conversationId String
  status         displayStatus @default(unknown)
  pinned         Boolean       @default(false)
  attribute      Attribute     @relation(fields: [attributeId], references: [id])
  conversation   Conversation  @relation(fields: [conversationId], references: [id], onDelete: Cascade)

  @@unique([attributeId, conversationId])
}

model Function {
  id              String             @id @default(cuid())
  createdAt       DateTime           @default(now())
  updatedAt       DateTime           @default(now()) @updatedAt
  name            String
  description     String
  type            FunctionType       @default(query)
  ActiveFunction  ActiveFunction[]
  arguments       FunctionArgument[]
  FunctionAction  FunctionAction[]   @relation("PossibleFollowingFunctions")
  systemOneAction SystemOneAction[]
}

model FunctionArgument {
  id                             String                           @id @default(cuid())
  createdAt                      DateTime                         @default(now())
  updatedAt                      DateTime                         @default(now()) @updatedAt
  name                           String
  description                    String
  dataType                       String
  optional                       Boolean                          @default(false)
  enumOptions                    String[]                         @default([])
  functionId                     String
  Function                       Function                         @relation(fields: [functionId], references: [id], onDelete: Cascade)
  FunctionArgumentValue          FunctionArgumentValue[]
  systemOneFunctionArgumentValue SystemOneFunctionArgumentValue[]
}

model ActiveFunction {
  id             String           @id @default(cuid())
  createdAt      DateTime         @default(now())
  updatedAt      DateTime         @default(now())
  functionId     String
  Function       Function         @relation(fields: [functionId], references: [id])
  FunctionAction FunctionAction[]
}

model FunctionAction {
  id                         String                  @id @default(cuid())
  createdAt                  DateTime                @default(now())
  updatedAt                  DateTime                @default(now())
  thought                    String                  @default("")
  HILDecision                HILDecision             @default(PENDING)
  order                      Int                     @default(0)
  taskId                     String
  activeFunctionId           String
  systemMessage              String                  @default("")
  status                     FunctionActionStatus    @default(pending)
  metadata                   Json?
  ActiveFunction             ActiveFunction          @relation(fields: [activeFunctionId], references: [id])
  FunctionTask               FunctionTask            @relation(fields: [taskId], references: [id])
  FunctionArgumentValue      FunctionArgumentValue[]
  possibleFollowingFunctions Function[]              @relation("PossibleFollowingFunctions")
}

model FunctionArgumentValue {
  id               String           @id @default(cuid())
  createdAt        DateTime         @default(now())
  updatedAt        DateTime         @default(now())
  value            String?
  actionId         String
  argumentId       String
  FunctionAction   FunctionAction   @relation(fields: [actionId], references: [id], onDelete: Cascade)
  FunctionArgument FunctionArgument @relation(fields: [argumentId], references: [id])

  @@unique([actionId, argumentId])
}

model FunctionTask {
  id             String           @id @default(cuid())
  createdAt      DateTime         @default(now())
  updatedAt      DateTime         @default(now())
  completed      Boolean          @default(false)
  conversationId String?
  caseId         String?
  typeMetadata   Json?
  type           TaskType         @default(action)
  FunctionAction FunctionAction[]
  Case           Case?            @relation(fields: [caseId], references: [id])
  Conversation   Conversation?    @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  memories       Memory[]         @relation("FunctionTaskToMemory")
}

model Memory {
  id             String         @id @default(cuid())
  createdAt      DateTime       @default(now())
  updatedAt      DateTime       @default(now())
  type           MemoryType
  value          String
  conversationId String?
  hierarchy      Hierarchy
  role           UserRole       @default(lead)
  caseId         String?
  Case           Case?          @relation(fields: [caseId], references: [id])
  Conversation   Conversation?  @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  tasks          FunctionTask[] @relation("FunctionTaskToMemory")
}

model Log {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @default(now())
  message   String
}

model Chore {
  id             String        @id @default(cuid())
  createdAt      DateTime      @default(now())
  updatedAt      DateTime      @default(now())
  description    String
  organizationId String
  conversationId String
  isComplete     Boolean       @default(false)
  completedAt    DateTime?
  triggerId      String?
  trigger        ChoreTrigger? @relation(fields: [triggerId], references: [id])
  conversation   Conversation  @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  Organization   Organization  @relation(fields: [organizationId], references: [id])
  users          User[]        @relation("ChoreToUser")

  @@index([isComplete, conversationId])
}

model MetaDocument {
  id             Int             @id @default(autoincrement())
  updatedAt      DateTime        @default(now())
  organizationId String
  title          String
  status         DocumentStatus  @default(DRAFT)
  createdAt      DateTime        @default(now())
  s3url          String
  Organization   Organization    @relation(fields: [organizationId], references: [id])
  MetaField      MetaField[]
  MetaRecipient  MetaRecipient[]
  productId      String?
  product        Product?        @relation(fields: [productId], references: [id])
  entityFields   EntityField[]   @relation("MetaDocumentToEntityField")
}

model MetaField {
  id             Int          @id @default(autoincrement())
  type           FieldType
  page           Int
  positionX      Decimal      @default(0)
  positionY      Decimal      @default(0)
  width          Decimal      @default(-1)
  height         Decimal      @default(-1)
  customText     String?
  metaDocumentId Int
  MetaDocument   MetaDocument @relation(fields: [metaDocumentId], references: [id], onDelete: Cascade)

  @@index([metaDocumentId])
}

model Document {
  id             Int            @id @default(autoincrement())
  updatedAt      DateTime       @default(now())
  organizationId String
  title          String
  status         DocumentStatus @default(DRAFT)
  createdAt      DateTime       @default(now())
  s3url          String
  completedAt    DateTime?
  deletedAt      DateTime?
  Organization   Organization   @relation(fields: [organizationId], references: [id])
  Field          Field[]
  Recipient      Recipient[]
}

model Field {
  id          Int        @id @default(autoincrement())
  documentId  Int?
  type        FieldType
  page        Int
  positionX   Decimal    @default(0)
  positionY   Decimal    @default(0)
  width       Decimal    @default(-1)
  height      Decimal    @default(-1)
  customText  String?
  recipientId Int?
  inserted    Boolean
  Document    Document?  @relation(fields: [documentId], references: [id], onDelete: Cascade)
  Signature   Signature?
  Recipient   Recipient? @relation(fields: [recipientId], references: [id])

  @@index([documentId])
}

model ChoreTrigger {
  id              String        @id(map: "choretrigger_pk") @default(cuid())
  createdAt       DateTime      @default(now())
  productStatusId String
  description     String
  triggerId       String?
  productStatus   ProductStatus @relation(fields: [productStatusId], references: [id], onDelete: NoAction, onUpdate: NoAction, map: "choretrigger_productstatus_id_fk")
  users           User[]        @relation("ChoreTriggerToUser")
  chores          Chore[]
}

model WorkflowCard {
  id                  String             @id @default(cuid())
  createdAt           DateTime           @default(now())
  updatedAt           DateTime           @default(now())
  order               Int                @default(0)
  workflowSchemaId    String
  name                String
  getNextCard         String?
  codeName            String?
  isFirstCard         Boolean            @default(false)
  workflowContainerId String?
  workflowContainer   WorkflowContainer? @relation(fields: [workflowContainerId], references: [id])
  workflowSchema      WorkflowSchema     @relation(fields: [workflowSchemaId], references: [id], onDelete: Cascade)
  workflowFields      WorkflowFields[]

  @@unique([workflowSchemaId, codeName])
}

model WorkflowContainer {
  id               String         @id @default(cuid())
  createdAt        DateTime       @default(now())
  updatedAt        DateTime       @default(now())
  order            Int            @default(0)
  workflowSchemaId String
  name             String
  codeName         String?
  workflowCards    WorkflowCard[]
  workflowSchema   WorkflowSchema @relation(fields: [workflowSchemaId], references: [id], onDelete: Cascade)
}

model WorkflowSchema {
  id                  String               @id @default(cuid())
  createdAt           DateTime             @default(now())
  updatedAt           DateTime             @default(now())
  description         String?
  url                 String?
  internal            Boolean              @default(false)
  name                String
  productId           String
  slug                String?
  type                WorkflowType
  createdById         String
  published           Boolean              @default(false)
  workflowCards       WorkflowCard[]
  workflowContainers  WorkflowContainer[]
  workflowFields      WorkflowFields[]
  user                User                 @relation(fields: [createdById], references: [id])
  product             Product              @relation(fields: [productId], references: [id])
  workflowSubmissions WorkflowSubmission[]
  workflowTriggers    WorkflowTrigger[]
  statuses            ProductStatus[]      @relation("ProductStatusToWorkflowSchema")
}

model WorkflowSubmission {
  id               String         @id @default(cuid())
  createdAt        DateTime       @default(now())
  updatedAt        DateTime       @default(now())
  workflowSchemaId String
  conversationId   String
  payload          Json
  userId           String?
  Conversation     Conversation   @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  User             User?          @relation(fields: [userId], references: [id])
  workflowSchema   WorkflowSchema @relation(fields: [workflowSchemaId], references: [id])
}

model Entity {
  id           String        @id @default(cuid())
  createdAt    DateTime      @default(now())
  updatedAt    DateTime      @default(now())
  name         String
  displayName  String?
  description  String?
  entityFields EntityField[]
  products     Product[]     @relation("EntityToProduct")
}

model EntityField {
  id            String     @id @default(cuid())
  name          String
  type          FieldTypes
  recordHistory Boolean    @default(false)
  displayName   String?
  exampleValue  String?
  description   String?
  required      Boolean    @default(false)
  defaultValue  String?
  createdAt     DateTime   @default(now())
  updatedAt     DateTime   @default(now())
  entityId      String

  entity Entity @relation(fields: [entityId], references: [id], onDelete: Cascade)

  values         EntityFieldValue[]
  WorkflowFields WorkflowFields[]
  metaDocuments  MetaDocument[]     @relation("MetaDocumentToEntityField")
  automation     Automation[]

  @@unique([entityId, name], name: "entityId_name")
}

model EntityFieldValue {
  id             String         @id @default(cuid())
  createdAt      DateTime       @default(now())
  updatedAt      DateTime       @default(now())
  value          String?
  entityFieldId  String
  conversationId String?
  organizationId String?
  entityField    EntityField    @relation(fields: [entityFieldId], references: [id])
  history        FieldHistory[]

  @@unique([entityFieldId, conversationId])
}

model FieldHistory {
  id                 String           @id @default(cuid())
  createdAt          DateTime         @default(now())
  oldValue           String
  newValue           String
  entityFieldValueId String
  cause              String?
  entityFieldValue   EntityFieldValue @relation(fields: [entityFieldValueId], references: [id])
}

model Action {
  id           String   @id @default(cuid())
  createdAt    DateTime @default(now())
  updatedAt    DateTime @default(now())
  description  String?
  ctxExecution String?
}

model Recipient {
  id            Int           @id @default(autoincrement())
  createdAt     DateTime      @default(now())
  updatedAt     DateTime      @default(now())
  documentId    Int?
  templateId    Int?
  email         String        @db.VarChar(255)
  name          String        @default("") @db.VarChar(255)
  token         String
  expired       DateTime?
  signedAt      DateTime?
  readStatus    ReadStatus    @default(NOT_OPENED)
  signingStatus SigningStatus @default(NOT_SIGNED)
  sendStatus    SendStatus    @default(NOT_SENT)
  Field         Field[]
  Document      Document?     @relation(fields: [documentId], references: [id], onDelete: Cascade)
  Signature     Signature[]

  @@unique([documentId, email])
  @@unique([templateId, email])
  @@index([documentId])
  @@index([templateId])
  @@index([token])
}

model MetaRecipient {
  id             Int           @id @default(autoincrement())
  createdAt      DateTime      @default(now())
  updatedAt      DateTime      @default(now())
  metaDocumentId Int
  email          String        @default("john.doe@example.com") @db.VarChar(255)
  name           String        @default("John Doe") @db.VarChar(255)
  token          String        @default("0000")
  expired        DateTime?
  signedAt       DateTime?
  readStatus     ReadStatus    @default(NOT_OPENED)
  signingStatus  SigningStatus @default(NOT_SIGNED)
  sendStatus     SendStatus    @default(NOT_SENT)
  metaDocument   MetaDocument  @relation(fields: [metaDocumentId], references: [id], onDelete: Cascade)

  @@index([metaDocumentId])
}

model Signature {
  id                     Int      @id @default(autoincrement())
  created                DateTime @default(now())
  recipientId            Int
  fieldId                Int      @unique
  signatureImageAsBase64 String?
  typedSignature         String?

  Recipient Recipient @relation(fields: [recipientId], references: [id], onDelete: Cascade)
  Field     Field     @relation(fields: [fieldId], references: [id], onDelete: Restrict)

  @@index([recipientId])
}

model Automation {
  id            String      @id @default(cuid())
  createdAt     DateTime    @default(now())
  updatedAt     DateTime    @default(now())
  name          String?
  description   String?
  active        Boolean     @default(true)
  code          String
  objects       Object[]
  entityField   EntityField @relation(fields: [entityFieldId], references: [id], onDelete: Cascade)
  entityFieldId String
}

model Object {
  id           String     @id
  sourceId     String
  type         ObjectType
  role         ObjectRole
  automationId String
  name         String?
  key          String?
  automation   Automation @relation(fields: [automationId], references: [id], onDelete: Cascade)

  @@index([automationId])
}

model CustomColumn {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @default(now())
  sortable  Boolean  @default(false)
  sortOn    String?
  name      String

  hidden Boolean @default(false)
  order  Int     @default(0)

  tableId String
  table   CustomTable @relation(fields: [tableId], references: [id])

  content String @db.Text
}

model CustomTable {
  id        String         @id @default(cuid())
  createdAt DateTime       @default(now())
  updatedAt DateTime       @default(now())
  name      String
  productId String
  product   Product        @relation(fields: [productId], references: [id])
  content   String         @db.Text
  columns   CustomColumn[]

  classificationEnabled Boolean @default(false)
  statusEnabled         Boolean @default(false)
}

enum ObjectType {
  Check
  Fact
  ClientFile
  Workflow
  Entity
  Conversation
  Organization
  User
}

enum ObjectRole {
  SOURCE
  TARGET
}

enum ReadStatus {
  NOT_OPENED
  OPENED
}

enum SendStatus {
  NOT_SENT
  SENT
}

enum SigningStatus {
  NOT_SIGNED
  SIGNED
}

model ConversationComment {
  id             String       @id @default(cuid())
  createdAt      DateTime     @default(now())
  updatedAt      DateTime     @default(now())
  message        String
  userId         String
  conversationId String
  isDeleted      Boolean      @default(false)
  isEdited       Boolean      @default(false)
  Conversation   Conversation @relation(fields: [conversationId], references: [id], onDelete: Cascade)
  User           User         @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model UnstructuredMessage {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @default(now())

  organizationId String?
  conversationId String?

  organization Organization? @relation(fields: [organizationId], references: [id])
  conversation Conversation? @relation(fields: [conversationId], references: [id], onDelete: Cascade)

  JSON String?
}

view EntityView {
  id             String        @id
  createdAt      DateTime
  updatedAt      DateTime
  field          String
  value          String
  conversationId String
  status         displayStatus
  conversation   Conversation  @relation(fields: [conversationId], references: [id])
}

enum FormFieldType {
  TEXT
  TEXTAREA
  SELECT
  BIG_SELECT
  HEADING
  PARAGRAPH
  SPACER
  CHECKBOX
  NUMBER
  PERCENTAGE
  ZIPCODE
  PHONE_NUMBER
  SSN
  DATE
  CURRENCY
  TIN
  LOCATION
}

enum FieldTypes {
  string
  number
  boolean
  date
  time
  dateTime
  email
  phone
  url
  image
  color
  password
  currency
  geolocation
  address
}

enum FunctionType {
  query
  mutation
}

enum FunctionActionStatus {
  executed
  approved
  rejected
  pending
  executing
}

enum HILDecision {
  APPROVED
  REJECTED
  PENDING
  EXECUTED
}

enum MemoryType {
  observation
  reflection
}

enum Hierarchy {
  local
  global
}

enum WorkflowType {
  applicationForm
}

enum MessageType {
  client
  agent
}

enum ClientFileStatus {
  pending
  processing
  approved
  rejected
  private
}

enum Visibility {
  private
  public
}

enum CommunicationMedium {
  EMAIL
  PHONE
  SMS
  WHATSAPP
}

enum displayStatus {
  confirmed
  mismatch
  unknown
}

enum UserRole {
  organizationAdmin
  humanOperator
  admin
  applicant
  lead
  You
  reminder
  systemOne
}

enum AgentType {
  LOAN
  CREDIT_CARD
}

enum ActionStatus {
  REVIEW_REQUIRED
  PROCESSING
  APPROVED
  ORGANIZATION_REVIEW_REQUIRED
  REMINDER_REVIEW_REQUIRE
}

enum OrganizationCheckFormType {
  TEXTAREA
  TEXT
  SELECT
  MULTI_SELECT
}

enum DocumentType {
  BANK_STATEMENT
  PERSONAL_TAX_RETURN
  BUSINESS_TAX_RETURN
  W2_TAX_FORM
  INCOME_STATEMENT
  OTHER
}

enum ConversationCheckStatus {
  APPROVED
  REJECTED
  PENDING
}

enum Company {
  Microsoft
  Google
}

enum TaskType {
  action
  reminder
}

enum ReminderType {
  automatic
  heartbeat
}

enum DocumentStatus {
  DRAFT
  PENDING
  COMPLETED
}

enum FieldType {
  SIGNATURE
  FREE_SIGNATURE
  NAME
  EMAIL
  DATE
  TEXT
}

enum IncomingMailIntegrationType {
  GMAIL
  OUTLOOK
}