FM / client

/home/techb158/balavpn.abdallabala.com/node_modules/.prisma/client/

/home/techb158/balavpn.abdallabala.com/node_modules/.prisma/client

Name	Size	Mode	Actions
deno/	-	0777	rm
default.d.ts	23	0666	edit dl rm
default.js	36	0666	edit dl rm
edge.d.ts	25	0666	edit dl rm
edge.js	125666	0666	edit dl rm
index-browser.js	17686	0666	edit dl rm
index.d.ts	1836090	0666	edit dl rm
index.js	126335	0666	edit dl rm
package.json	2601	0666	edit dl rm
query_engine-windows.dll.node	19261952	0666	edit dl rm
schema.prisma	16783	0666	edit dl rm
wasm.d.ts	23	0666	edit dl rm
wasm.js	17686	0666	edit dl rm

Edit: /home/techb158/balavpn.abdallabala.com/node_modules/.prisma/client/schema.prisma (16783B)

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

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

enum OrganizationStatus {
  TRIAL
  ACTIVE
  SUSPENDED
  CANCELED
}

enum WorkspaceType {
  B2B_TEAM
  CONSULTANT_CLIENT
  ENTERPRISE
}

enum MembershipStatus {
  INVITED
  ACTIVE
  DISABLED
}

enum SubscriptionSource {
  MANUAL
  STRIPE
}

enum SubscriptionStatus {
  TRIALING
  ACTIVE
  PAST_DUE
  CANCELED
  SUSPENDED
}

enum RiskStatus {
  OPEN
  IN_MITIGATION
  ACCEPTED
  CLOSED
}

enum ApprovalStatus {
  PENDING
  APPROVED
  REJECTED
  ACCEPTED
}

enum MitigationStatus {
  NOT_STARTED
  IN_PROGRESS
  DONE
  REJECTED
}

enum GateStatus {
  READY
  WARNING
  BLOCKED
}

enum GateDecisionValue {
  APPROVED
  REJECTED
  ACCEPTED
  NEEDS_CHANGES
}

enum IntegrationProvider {
  TRELLO
  JIRA
  ASANA
  MICROSOFT_PLANNER
}

enum IntegrationStatus {
  CONNECTED
  NEEDS_CONFIGURATION
  DISABLED
}

model Organization {
  id                String             @id @default(cuid())
  name              String
  slug              String             @unique
  status            OrganizationStatus @default(TRIAL)
  planCode          String             @default("pilot")
  manualBilling     Boolean            @default(true)
  stripeCustomerId  String?
  ssoEnforced       Boolean            @default(false)
  allowedDomains    String[]           @default([])
  dataRetentionDays Int?
  createdAt         DateTime           @default(now())
  updatedAt         DateTime           @updatedAt
  workspaces        Workspace[]
  memberships       Membership[]
  subscriptions     Subscription[]
  auditEvents       AuditEvent[]
  usageEvents       UsageEvent[]
  invitations       Invitation[]
  oauthTokens       OAuthToken[]
}

model Workspace {
  id             String             @id @default(cuid())
  organizationId String
  name           String
  slug           String
  type           WorkspaceType      @default(B2B_TEAM)
  status         OrganizationStatus @default(TRIAL)
  createdAt      DateTime           @default(now())
  updatedAt      DateTime           @updatedAt
  organization   Organization       @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  projects       Project[]
  integrations   Integration[]
  reports        ReportExport[]
  auditEvents    AuditEvent[]

@@unique([organizationId, slug])
  @@index([organizationId])
}

model User {
  id              String       @id @default(cuid())
  email           String       @unique
  displayName     String
  passwordHash    String?
  emailVerifiedAt DateTime?
  lastLoginAt     DateTime?
  createdAt       DateTime     @default(now())
  updatedAt       DateTime     @updatedAt
  memberships     Membership[]
  invitationsSent Invitation[] @relation("InvitationSender")
  auditEvents     AuditEvent[]
  sessions        Session[]
}

model Session {
  id        String   @id @default(cuid())
  userId    String
  token     String   @unique
  expiresAt DateTime
  createdAt DateTime @default(now())
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)

@@index([token])
  @@index([userId])
}

model Role {
  id          String       @id @default(cuid())
  code        String       @unique
  name        String
  permissions String[]     @default([])
  system      Boolean      @default(true)
  createdAt   DateTime     @default(now())
  updatedAt   DateTime     @updatedAt
  memberships Membership[]
}

model Membership {
  id             String           @id @default(cuid())
  organizationId String
  userId         String
  roleId         String
  status         MembershipStatus @default(INVITED)
  workspaceScope String[]         @default([])
  createdAt      DateTime         @default(now())
  updatedAt      DateTime         @updatedAt
  organization   Organization     @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  user           User             @relation(fields: [userId], references: [id], onDelete: Cascade)
  role           Role             @relation(fields: [roleId], references: [id])

@@unique([organizationId, userId])
  @@index([userId])
}

model Invitation {
  id             String       @id @default(cuid())
  organizationId String
  email          String
  roleCode       String
  tokenHash      String       @unique
  expiresAt      DateTime
  acceptedAt     DateTime?
  invitedById    String?
  createdAt      DateTime     @default(now())
  organization   Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  invitedBy      User?        @relation("InvitationSender", fields: [invitedById], references: [id])

@@index([organizationId, email])
}

model Subscription {
  id                   String             @id @default(cuid())
  organizationId       String
  source               SubscriptionSource @default(MANUAL)
  status               SubscriptionStatus @default(TRIALING)
  planCode             String             @default("pilot")
  stripeSubscriptionId String?
  currentPeriodEnd     DateTime?
  userLimit            Int                @default(5)
  projectLimit         Int                @default(3)
  reportLimitMonthly   Int                @default(25)
  integrationLimit     Int                @default(2)
  storageMbLimit       Int                @default(1024)
  adminOverride        Boolean            @default(false)
  createdAt            DateTime           @default(now())
  updatedAt            DateTime           @updatedAt
  organization         Organization       @relation(fields: [organizationId], references: [id], onDelete: Cascade)

@@index([organizationId])
}

model Project {
  id                    String           @id @default(cuid())
  workspaceId           String
  name                  String
  subtitle              String?
  projectType           String           @default("AI-Enabler")
  currentLifecyclePhase String?
  riskAppetite          Int              @default(50)
  assessmentDate        DateTime?
  status                String           @default("Active")
  ownerDisplayName      String?
  description           String?
  thresholds            Json             @default("{}")
  reviews               Json             @default("{}")
  createdAt             DateTime         @default(now())
  updatedAt             DateTime         @updatedAt
  workspace             Workspace        @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  lifecyclePhases       LifecyclePhase[]
  risks                 Risk[]
  indicators            Indicator[]
  experiments           Experiment[]
  gateEvaluations       GateEvaluation[]
  auditEvents           AuditEvent[]
  reports               ReportExport[]

@@index([workspaceId])
}

model LifecyclePhase {
  id             String   @id @default(cuid())
  projectId      String
  name           String
  status         String
  readinessScore Int
  sequence       Int
  createdAt      DateTime @default(now())
  updatedAt      DateTime @updatedAt
  project        Project  @relation(fields: [projectId], references: [id], onDelete: Cascade)

@@index([projectId])
}

model Risk {
  id               String         @id @default(cuid())
  projectId        String
  ownerDisplayName String?
  title            String
  description      String?
  dimension        String
  domain           String
  lifecyclePhase   String
  probability      Int
  impact           Int
  detectability    Int
  status           RiskStatus     @default(OPEN)
  approvalStatus   ApprovalStatus @default(PENDING)
  dueDate          DateTime?
  evidenceSummary  String?
  createdAt        DateTime       @default(now())
  updatedAt        DateTime       @updatedAt
  project          Project        @relation(fields: [projectId], references: [id], onDelete: Cascade)
  mitigations      Mitigation[]
  evidence         Evidence[]

@@index([projectId])
}

model Mitigation {
  id                   String           @id @default(cuid())
  riskId               String
  ownerDisplayName     String?
  title                String
  description          String?
  status               MitigationStatus @default(NOT_STARTED)
  progressPercent      Int              @default(0)
  effectivenessPercent Int              @default(0)
  dueDate              DateTime?
  sequence             Int              @default(1)
  createdAt            DateTime         @default(now())
  updatedAt            DateTime         @updatedAt
  risk                 Risk             @relation(fields: [riskId], references: [id], onDelete: Cascade)
  evidence             Evidence[]

@@index([riskId])
}

model Evidence {
  id           String      @id @default(cuid())
  projectId    String
  riskId       String?
  mitigationId String?
  type         String      @default("Review")
  title        String
  uri          String?
  createdById  String?
  createdAt    DateTime    @default(now())
  updatedAt    DateTime    @updatedAt
  risk         Risk?       @relation(fields: [riskId], references: [id], onDelete: Cascade)
  mitigation   Mitigation? @relation(fields: [mitigationId], references: [id], onDelete: Cascade)

@@index([projectId])
  @@index([riskId])
  @@index([mitigationId])
}

model Indicator {
  id                 String   @id @default(cuid())
  projectId          String
  name               String
  dimension          String
  measurand          String
  unit               String
  target             String?
  interpretationRule String?
  createdAt          DateTime @default(now())
  updatedAt          DateTime @updatedAt
  project            Project  @relation(fields: [projectId], references: [id], onDelete: Cascade)

@@index([projectId])
}

model Experiment {
  id        String        @id @default(cuid())
  projectId String
  name      String
  modelName String?
  selected  Boolean       @default(false)
  createdAt DateTime      @default(now())
  updatedAt DateTime      @updatedAt
  project   Project       @relation(fields: [projectId], references: [id], onDelete: Cascade)
  metrics   ModelMetric[]

@@index([projectId])
}

model ModelMetric {
  id             String     @id @default(cuid())
  experimentId   String
  metricName     String
  metricValue    Float
  thresholdValue Float?
  status         String
  measuredAt     DateTime?
  createdAt      DateTime   @default(now())
  updatedAt      DateTime   @updatedAt
  experiment     Experiment @relation(fields: [experimentId], references: [id], onDelete: Cascade)

@@index([experimentId])
}

model GateEvaluation {
  id                String          @id @default(cuid())
  projectId         String
  status            GateStatus
  reviewStatus      String          @default("Pending review")
  summary           String
  evaluatedByUserId String?
  evaluatedAt       DateTime        @default(now())
  reviewedAt        DateTime?
  createdAt         DateTime        @default(now())
  updatedAt         DateTime        @updatedAt
  project           Project         @relation(fields: [projectId], references: [id], onDelete: Cascade)
  criteria          GateCriterion[]
  decisions         GateDecision[]

@@index([projectId])
}

model GateCriterion {
  id             String         @id @default(cuid())
  gateId         String
  name           String
  actualValue    String
  expectedRule   String
  status         String
  blocking       Boolean        @default(false)
  evidenceTitle  String?
  evidenceUri    String?
  reviewerStatus String         @default("Open")
  reviewerNote   String?
  createdAt      DateTime       @default(now())
  updatedAt      DateTime       @updatedAt
  gate           GateEvaluation @relation(fields: [gateId], references: [id], onDelete: Cascade)

@@index([gateId])
}

model GateDecision {
  id              String            @id @default(cuid())
  gateId          String
  decision        GateDecisionValue
  reviewerName    String
  reason          String?
  createdByUserId String?
  decidedAt       DateTime          @default(now())
  createdAt       DateTime          @default(now())
  gate            GateEvaluation    @relation(fields: [gateId], references: [id], onDelete: Cascade)

@@index([gateId])
}

model Integration {
  id                 String                    @id @default(cuid())
  workspaceId        String
  provider           IntegrationProvider
  workspaceName      String
  externalProjectKey String?
  baseUrl            String?
  authMode           String
  connectionStatus   IntegrationStatus         @default(NEEDS_CONFIGURATION)
  syncDirection      String                    @default("COSMIC to PM")
  liveEnabled        Boolean                   @default(false)
  liveConfig         Json                      @default("{}")
  lastSyncAt         DateTime?
  createdAt          DateTime                  @default(now())
  updatedAt          DateTime                  @updatedAt
  workspace          Workspace                 @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  mappings           ExternalWorkItemMapping[]
  syncRuns           IntegrationSyncRun[]

@@unique([workspaceId, provider])
  @@index([workspaceId])
}

model ExternalWorkItemMapping {
  id               String      @id @default(cuid())
  integrationId    String
  projectId        String
  localEntityType  String
  localEntityId    String
  localTitle       String
  externalItemType String
  externalItemId   String
  externalItemKey  String
  externalUrl      String?
  externalStatus   String
  syncStatus       String
  fieldMapping     Json        @default("{}")
  lastSyncedAt     DateTime?
  createdAt        DateTime    @default(now())
  updatedAt        DateTime    @updatedAt
  integration      Integration @relation(fields: [integrationId], references: [id], onDelete: Cascade)

@@index([integrationId])
  @@index([projectId])
}

model IntegrationSyncRun {
  id            String              @id @default(cuid())
  integrationId String
  projectId     String
  provider      IntegrationProvider
  status        String
  startedAt     DateTime
  finishedAt    DateTime?
  createdCount  Int                 @default(0)
  updatedCount  Int                 @default(0)
  failedCount   Int                 @default(0)
  summary       String?
  failureLog    Json                @default("[]")
  createdAt     DateTime            @default(now())
  integration   Integration         @relation(fields: [integrationId], references: [id], onDelete: Cascade)

@@index([integrationId])
  @@index([projectId])
}

model OAuthToken {
  id             String              @id @default(cuid())
  organizationId String
  provider       IntegrationProvider
  integrationId  String?
  encryptedToken Json
  redactedToken  String
  expiresAt      DateTime?
  createdAt      DateTime            @default(now())
  updatedAt      DateTime            @updatedAt
  organization   Organization        @relation(fields: [organizationId], references: [id], onDelete: Cascade)

@@index([organizationId, provider])
}

model ReportExport {
  id          String    @id @default(cuid())
  workspaceId String
  projectId   String
  reportType  String
  format      String
  status      String    @default("Generated")
  metadata    Json      @default("{}")
  createdById String?
  createdAt   DateTime  @default(now())
  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  project     Project   @relation(fields: [projectId], references: [id], onDelete: Cascade)

@@index([workspaceId])
  @@index([projectId])
}

model AuditEvent {
  id             String       @id @default(cuid())
  organizationId String
  workspaceId    String?
  projectId      String?
  actorUserId    String?
  entityType     String
  entityId       String
  action         String
  beforeJson     Json?
  afterJson      Json?
  ipAddress      String?
  userAgent      String?
  createdAt      DateTime     @default(now())
  organization   Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  workspace      Workspace?   @relation(fields: [workspaceId], references: [id], onDelete: SetNull)
  project        Project?     @relation(fields: [projectId], references: [id], onDelete: SetNull)
  actor          User?        @relation(fields: [actorUserId], references: [id], onDelete: SetNull)

@@index([organizationId])
  @@index([workspaceId])
  @@index([projectId])
}

model UsageEvent {
  id             String       @id @default(cuid())
  organizationId String
  metric         String
  quantity       Int          @default(1)
  metadata       Json         @default("{}")
  createdAt      DateTime     @default(now())
  organization   Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)

@@index([organizationId, metric])
}

generator client { provider = "prisma-client-js" } datasource db { provider = "postgresql" url = env("DATABASE_URL") } enum OrganizationStatus { TRIAL ACTIVE SUSPENDED CANCELED } enum WorkspaceType { B2B_TEAM CONSULTANT_CLIENT ENTERPRISE } enum MembershipStatus { INVITED ACTIVE DISABLED } enum SubscriptionSource { MANUAL STRIPE } enum SubscriptionStatus { TRIALING ACTIVE PAST_DUE CANCELED SUSPENDED } enum RiskStatus { OPEN IN_MITIGATION ACCEPTED CLOSED } enum ApprovalStatus { PENDING APPROVED REJECTED ACCEPTED } enum MitigationStatus { NOT_STARTED IN_PROGRESS DONE REJECTED } enum GateStatus { READY WARNING BLOCKED } enum GateDecisionValue { APPROVED REJECTED ACCEPTED NEEDS_CHANGES } enum IntegrationProvider { TRELLO JIRA ASANA MICROSOFT_PLANNER } enum IntegrationStatus { CONNECTED NEEDS_CONFIGURATION DISABLED } model Organization { id String @id @default(cuid()) name String slug String @unique status OrganizationStatus @default(TRIAL) planCode String @default("pilot") manualBilling Boolean @default(true) stripeCustomerId String? ssoEnforced Boolean @default(false) allowedDomains String[] @default([]) dataRetentionDays Int? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt workspaces Workspace[] memberships Membership[] subscriptions Subscription[] auditEvents AuditEvent[] usageEvents UsageEvent[] invitations Invitation[] oauthTokens OAuthToken[] } model Workspace { id String @id @default(cuid()) organizationId String name String slug String type WorkspaceType @default(B2B_TEAM) status OrganizationStatus @default(TRIAL) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade) projects Project[] integrations Integration[] reports ReportExport[] auditEvents AuditEvent[] @@unique([organizationId, slug]) @@index([organizationId]) } model User { id String @id @default(cuid()) email String @unique displayName String passwordHash String? emailVerifiedAt DateTime? lastLoginAt DateTime? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt memberships Membership[] invitationsSent Invitation[] @relation("InvitationSender") auditEvents AuditEvent[] sessions Session[] } model Session { id String @id @default(cuid()) userId String token String @unique expiresAt DateTime createdAt DateTime @default(now()) user User @relation(fields: [userId], references: [id], onDelete: Cascade) @@index([token]) @@index([userId]) } model Role { id String @id @default(cuid()) code String @unique name String permissions String[] @default([]) system Boolean @default(true) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt memberships Membership[] } model Membership { id String @id @default(cuid()) organizationId String userId String roleId String status MembershipStatus @default(INVITED) workspaceScope String[] @default([]) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade) user User @relation(fields: [userId], references: [id], onDelete: Cascade) role Role @relation(fields: [roleId], references: [id]) @@unique([organizationId, userId]) @@index([userId]) } model Invitation { id String @id @default(cuid()) organizationId String email String roleCode String tokenHash String @unique expiresAt DateTime acceptedAt DateTime? invitedById String? createdAt DateTime @default(now()) organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade) invitedBy User? @relation("InvitationSender", fields: [invitedById], references: [id]) @@index([organizationId, email]) } model Subscription { id String @id @default(cuid()) organizationId String source SubscriptionSource @default(MANUAL) status SubscriptionStatus @default(TRIALING) planCode String @default("pilot") stripeSubscriptionId String? currentPeriodEnd DateTime? userLimit Int @default(5) projectLimit Int @default(3) reportLimitMonthly Int @default(25) integrationLimit Int @default(2) storageMbLimit Int @default(1024) adminOverride Boolean @default(false) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade) @@index([organizationId]) } model Project { id String @id @default(cuid()) workspaceId String name String subtitle String? projectType String @default("AI-Enabler") currentLifecyclePhase String? riskAppetite Int @default(50) assessmentDate DateTime? status String @default("Active") ownerDisplayName String? description String? thresholds Json @default("{}") reviews Json @default("{}") createdAt DateTime @default(now()) updatedAt DateTime @updatedAt workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) lifecyclePhases LifecyclePhase[] risks Risk[] indicators Indicator[] experiments Experiment[] gateEvaluations GateEvaluation[] auditEvents AuditEvent[] reports ReportExport[] @@index([workspaceId]) } model LifecyclePhase { id String @id @default(cuid()) projectId String name String status String readinessScore Int sequence Int createdAt DateTime @default(now()) updatedAt DateTime @updatedAt project Project @relation(fields: [projectId], references: [id], onDelete: Cascade) @@index([projectId]) } model Risk { id String @id @default(cuid()) projectId String ownerDisplayName String? title String description String? dimension String domain String lifecyclePhase String probability Int impact Int detectability Int status RiskStatus @default(OPEN) approvalStatus ApprovalStatus @default(PENDING) dueDate DateTime? evidenceSummary String? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt project Project @relation(fields: [projectId], references: [id], onDelete: Cascade) mitigations Mitigation[] evidence Evidence[] @@index([projectId]) } model Mitigation { id String @id @default(cuid()) riskId String ownerDisplayName String? title String description String? status MitigationStatus @default(NOT_STARTED) progressPercent Int @default(0) effectivenessPercent Int @default(0) dueDate DateTime? sequence Int @default(1) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt risk Risk @relation(fields: [riskId], references: [id], onDelete: Cascade) evidence Evidence[] @@index([riskId]) } model Evidence { id String @id @default(cuid()) projectId String riskId String? mitigationId String? type String @default("Review") title String uri String? createdById String? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt risk Risk? @relation(fields: [riskId], references: [id], onDelete: Cascade) mitigation Mitigation? @relation(fields: [mitigationId], references: [id], onDelete: Cascade) @@index([projectId]) @@index([riskId]) @@index([mitigationId]) } model Indicator { id String @id @default(cuid()) projectId String name String dimension String measurand String unit String target String? interpretationRule String? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt project Project @relation(fields: [projectId], references: [id], onDelete: Cascade) @@index([projectId]) } model Experiment { id String @id @default(cuid()) projectId String name String modelName String? selected Boolean @default(false) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt project Project @relation(fields: [projectId], references: [id], onDelete: Cascade) metrics ModelMetric[] @@index([projectId]) } model ModelMetric { id String @id @default(cuid()) experimentId String metricName String metricValue Float thresholdValue Float? status String measuredAt DateTime? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt experiment Experiment @relation(fields: [experimentId], references: [id], onDelete: Cascade) @@index([experimentId]) } model GateEvaluation { id String @id @default(cuid()) projectId String status GateStatus reviewStatus String @default("Pending review") summary String evaluatedByUserId String? evaluatedAt DateTime @default(now()) reviewedAt DateTime? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt project Project @relation(fields: [projectId], references: [id], onDelete: Cascade) criteria GateCriterion[] decisions GateDecision[] @@index([projectId]) } model GateCriterion { id String @id @default(cuid()) gateId String name String actualValue String expectedRule String status String blocking Boolean @default(false) evidenceTitle String? evidenceUri String? reviewerStatus String @default("Open") reviewerNote String? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt gate GateEvaluation @relation(fields: [gateId], references: [id], onDelete: Cascade) @@index([gateId]) } model GateDecision { id String @id @default(cuid()) gateId String decision GateDecisionValue reviewerName String reason String? createdByUserId String? decidedAt DateTime @default(now()) createdAt DateTime @default(now()) gate GateEvaluation @relation(fields: [gateId], references: [id], onDelete: Cascade) @@index([gateId]) } model Integration { id String @id @default(cuid()) workspaceId String provider IntegrationProvider workspaceName String externalProjectKey String? baseUrl String? authMode String connectionStatus IntegrationStatus @default(NEEDS_CONFIGURATION) syncDirection String @default("COSMIC to PM") liveEnabled Boolean @default(false) liveConfig Json @default("{}") lastSyncAt DateTime? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) mappings ExternalWorkItemMapping[] syncRuns IntegrationSyncRun[] @@unique([workspaceId, provider]) @@index([workspaceId]) } model ExternalWorkItemMapping { id String @id @default(cuid()) integrationId String projectId String localEntityType String localEntityId String localTitle String externalItemType String externalItemId String externalItemKey String externalUrl String? externalStatus String syncStatus String fieldMapping Json @default("{}") lastSyncedAt DateTime? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt integration Integration @relation(fields: [integrationId], references: [id], onDelete: Cascade) @@index([integrationId]) @@index([projectId]) } model IntegrationSyncRun { id String @id @default(cuid()) integrationId String projectId String provider IntegrationProvider status String startedAt DateTime finishedAt DateTime? createdCount Int @default(0) updatedCount Int @default(0) failedCount Int @default(0) summary String? failureLog Json @default("[]") createdAt DateTime @default(now()) integration Integration @relation(fields: [integrationId], references: [id], onDelete: Cascade) @@index([integrationId]) @@index([projectId]) } model OAuthToken { id String @id @default(cuid()) organizationId String provider IntegrationProvider integrationId String? encryptedToken Json redactedToken String expiresAt DateTime? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade) @@index([organizationId, provider]) } model ReportExport { id String @id @default(cuid()) workspaceId String projectId String reportType String format String status String @default("Generated") metadata Json @default("{}") createdById String? createdAt DateTime @default(now()) workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) project Project @relation(fields: [projectId], references: [id], onDelete: Cascade) @@index([workspaceId]) @@index([projectId]) } model AuditEvent { id String @id @default(cuid()) organizationId String workspaceId String? projectId String? actorUserId String? entityType String entityId String action String beforeJson Json? afterJson Json? ipAddress String? userAgent String? createdAt DateTime @default(now()) organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade) workspace Workspace? @relation(fields: [workspaceId], references: [id], onDelete: SetNull) project Project? @relation(fields: [projectId], references: [id], onDelete: SetNull) actor User? @relation(fields: [actorUserId], references: [id], onDelete: SetNull) @@index([organizationId]) @@index([workspaceId]) @@index([projectId]) } model UsageEvent { id String @id @default(cuid()) organizationId String metric String quantity Int @default(1) metadata Json @default("{}") createdAt DateTime @default(now()) organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade) @@index([organizationId, metric]) }