schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

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

datasource db {
  provider          = "postgres"
  url               = env("DATABASE_URL")
  shadowDatabaseUrl = env("SHADOW_DATABASE_URL")
  relationMode      = "foreignKeys"
}

enum GitProvider {
  GITHUB
}

enum InstallationTargetType {
  ORGANIZATION
  USER
}

enum PullRequestState {
  DRAFT
  OPEN
  CLOSED
  MERGED
}

enum PullRequestSize {
  TINY
  SMALL
  MEDIUM
  LARGE
  HUGE
}

enum CodeReviewState {
  APPROVED
  CHANGES_REQUESTED
  COMMENTED
}

enum TeamMemberRole {
  DESIGNER
  ENGINEER
  LEADER
  MANAGER
  PRODUCT
  QA
}

enum IntegrationApp {
  SLACK
}

enum AutomationType {
  PR_TITLE_CHECK
  PR_SIZE_LABELER
  INCIDENT_DETECTION
}

enum DigestType {
  TEAM_METRICS
  TEAM_WIP
}

enum AlertType {
  SLOW_REVIEW
  SLOW_MERGE
  MERGED_WITHOUT_APPROVAL
  HOT_PR
  UNRELEASED_CHANGES
}

enum DayOfTheWeek {
  SUNDAY
  MONDAY
  TUESDAY
  WEDNESDAY
  THURSDAY
  FRIDAY
  SATURDAY
}

enum Frequency {
  WEEKLY
  MONTHLY
}

enum ActivityEventType {
  CODE_REVIEW_SUBMITTED
  PULL_REQUEST_MERGED
  PULL_REQUEST_CREATED
}

enum DeploymentChangeType {
  FORWARD
  ROLLBACK
  BASELINE
  DIVERGED
  NO_CHANGE
}

// User git profiles. Public data. May not have an associated user. 
model GitProfile {
  id Int @id @default(autoincrement())

  gitProvider GitProvider
  gitUserId   String

  handle               String
  name                 String
  avatar               String?
  workspaceMemberships WorkspaceMembership[]

  user   User? @relation(fields: [userId], references: [id])
  userId Int?

  // A single user might have multiple git profiles, with multiple personal workspaces.
  workspace          Workspace?
  pullRequests       PullRequest[]
  teamMemberships    TeamMember[]
  codeReviews        CodeReview[]
  codeReviewRequests CodeReviewRequest[]
  activityEvents     ActivityEvent[]
  apiKeys            ApiKey[]

  createdAt  DateTime     @default(now())
  updatedAt  DateTime     @default(now()) @updatedAt
  Deployment Deployment[]
  Incident   Incident[]

  @@unique([gitProvider, gitUserId])
  @@unique([gitProvider, userId])
  @@index([userId])
}

// A person that has authorized GitHub OAuth
model User {
  id          Int          @id @default(autoincrement())
  slug        String       @unique
  email       String       @unique
  gitProfiles GitProfile[]

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

// An org that has authorized GitHub OAuth
model Organization {
  id Int @id @default(autoincrement())

  gitProvider       GitProvider
  gitOrganizationId String

  name      String
  handle    String
  avatar    String?
  workspace Workspace?

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

  @@unique([gitProvider, gitOrganizationId])
}

model Workspace {
  id Int @id @default(autoincrement())

  gitProvider GitProvider
  settings    Json        @default("{}")
  trialEndAt  DateTime?
  createdAt   DateTime    @default(now())
  updatedAt   DateTime    @default(now()) @updatedAt

  featureAdoption Json @default("{}")

  subscription Subscription?
  installation Installation?

  // A workspace can belong either to an Organization or an User
  organization   Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  organizationId Int?

  // A personal workspace can become orphan when an user revokes their OAuth
  // Re-authenticating creates a new user and reconnects 
  gitProfile   GitProfile? @relation(fields: [gitProfileId], references: [id], onDelete: SetNull)
  gitProfileId Int?

  memberships            WorkspaceMembership[]
  repositories           Repository[]
  teams                  Team[]
  automations            Automation[]
  codeReviews            CodeReview[]
  codeReviewRequests     CodeReviewRequest[]
  pullRequestTrackings   PullRequestTracking[]
  pullRequests           PullRequest[]
  teamMembers            TeamMember[]
  integrations           Integration[]
  digests                Digest[]
  alerts                 Alert[]
  alertEvents            AlertEvent[]
  activityEvents         ActivityEvent[]
  apiKeys                ApiKey[]
  syncTasks              SyncBatch[]
  applications           Application[]
  deployments            Deployment[]
  deploymentPullRequests DeploymentPullRequest[]
  Environment            Environment[]
  Incident               Incident[]

  @@unique([gitProfileId])
  @@unique([organizationId])
}

// ---------------------------------------------------------------------------------------
// Workspace Scope (RLS-Enabled)
// |- Add workspaceId in all tables below to ensure query performance and data isolation.
// |- When adding new models, create a migration to activate RLS for the new tables.
// ---------------------------------------------------------------------------------------

model Subscription {
  id Int @id @default(autoincrement())

  workspace          Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId        Int       @unique
  // Stripe data
  customerId         String
  subscriptionId     String    @unique
  priceId            String
  status             String
  interval           String
  quantity           Int
  currentPeriodStart DateTime
  currentPeriodEnd   DateTime
  startedAt          DateTime
  object             Json

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

model Installation {
  id Int @id @default(autoincrement())

  gitInstallationId String      @unique
  gitProvider       GitProvider

  targetId            String
  targetType          InstallationTargetType
  repositorySelection String
  permissions         Json
  events              Json
  suspendedAt         DateTime?

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

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

  @@unique([workspaceId])
}

model SyncBatch {
  id Int @id @default(autoincrement())

  sinceDaysAgo Int

  scheduledAt DateTime
  startedAt   DateTime?
  finishedAt  DateTime?
  metadata    Json

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

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  @@index([workspaceId])
}

model WorkspaceMembership {
  id Int @id @default(autoincrement())

  gitProfile   GitProfile @relation(fields: [gitProfileId], references: [id], onDelete: Cascade)
  gitProfileId Int

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  role String?

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

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

model Repository {
  id Int @id @default(autoincrement())

  gitProvider     GitProvider
  gitRepositoryId String

  name        String
  fullName    String
  description String?
  isPrivate   Boolean
  isFork      Boolean
  isMirror    Boolean
  archivedAt  DateTime?
  starCount   Int
  createdAt   DateTime

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  updatedAt DateTime @default(now()) @updatedAt

  pullRequests   PullRequest[]
  activityEvents ActivityEvent[]
  applications   Application[]

  @@unique([gitProvider, gitRepositoryId])
  @@index([workspaceId])
}

model ActivityEvent {
  id Int @id @default(autoincrement())

  type     ActivityEventType
  metadata Json
  eventId  String?
  eventAt  DateTime          @default(now())

  gitProfile   GitProfile @relation(fields: [gitProfileId], references: [id], onDelete: Cascade)
  gitProfileId Int

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  pullRequest   PullRequest? @relation(fields: [pullRequestId], references: [id], onDelete: Cascade)
  pullRequestId Int?

  repository   Repository? @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
  repositoryId Int?

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

  @@unique([workspaceId, eventId])
  @@index([workspaceId])
  @@index([gitProfileId])
  @@index([pullRequestId])
  @@index([repositoryId])
}

model PullRequest {
  id Int @id @default(autoincrement())

  gitProvider      GitProvider
  gitPullRequestId String
  gitUrl           String

  title        String
  number       String
  sourceBranch String @default("")
  targetBranch String @default("main")
  body         String @default("")

  labels            Json @default("[]")
  files             Json @default("[]")
  commentCount      Int
  changedFilesCount Int
  linesAddedCount   Int
  linesDeletedCount Int

  state PullRequestState

  mergeCommitSha String?
  mergedAt       DateTime?
  closedAt       DateTime?
  createdAt      DateTime
  updatedAt      DateTime

  repository   Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
  repositoryId Int

  author   GitProfile @relation(fields: [authorId], references: [id], onDelete: Cascade)
  authorId Int

  tracking PullRequestTracking?

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  codeReviews        CodeReview[]
  codeReviewRequests CodeReviewRequest[]
  alertEvents        AlertEvent[]
  activityEvents     ActivityEvent[]
  deploymentEvents   DeploymentPullRequest[]

  @@unique([gitProvider, gitPullRequestId])
  @@index([workspaceId])
  @@index([repositoryId])
  @@index([authorId])
}

model PullRequestTracking {
  id Int @id @default(autoincrement())

  // When tracking, we ignore files that doesn't matter for PR size (i.e. lock files)
  changedFilesCount Int             @default(0)
  linesAddedCount   Int             @default(0)
  linesDeletedCount Int             @default(0)
  size              PullRequestSize

  firstCommitAt            DateTime?
  firstDraftedAt           DateTime?
  firstReadyAt             DateTime? // Ready for review, i.e. open
  firstReviewerRequestedAt DateTime?
  firstReviewAt            DateTime?
  firstApprovalAt          DateTime?
  firstDeployedAt          DateTime?

  timeToCode          BigInt?
  timeToFirstReview   BigInt?
  timeToFirstApproval BigInt?
  timeToMerge         BigInt?
  timeToDeploy        BigInt?
  cycleTime           BigInt?

  pullRequest   PullRequest @relation(fields: [pullRequestId], references: [id], onDelete: Cascade)
  pullRequestId Int

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

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

  @@unique([pullRequestId])
  @@index([workspaceId])
}

model CodeReview {
  id Int @id @default(autoincrement())

  commentCount  Int
  state         CodeReviewState
  createdAt     DateTime
  pullRequest   PullRequest     @relation(fields: [pullRequestId], references: [id], onDelete: Cascade)
  pullRequestId Int

  author   GitProfile @relation(fields: [authorId], references: [id], onDelete: Cascade)
  authorId Int

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  updatedAt DateTime @default(now()) @updatedAt

  @@unique([pullRequestId, authorId])
  @@index([workspaceId])
  @@index([authorId])
}

model CodeReviewRequest {
  id Int @id @default(autoincrement())

  createdAt DateTime
  deletedAt DateTime?

  pullRequest   PullRequest @relation(fields: [pullRequestId], references: [id], onDelete: Cascade)
  pullRequestId Int

  reviewer   GitProfile @relation(fields: [reviewerId], references: [id], onDelete: Cascade)
  reviewerId Int

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  updatedAt DateTime @default(now()) @updatedAt

  @@unique([pullRequestId, reviewerId])
  @@index([workspaceId])
  @@index([reviewerId])
}

model Team {
  id          Int          @id @default(autoincrement())
  name        String
  description String?
  icon        String
  startColor  String
  endColor    String
  members     TeamMember[]
  archivedAt  DateTime?

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  createdAt   DateTime      @default(now())
  updatedAt   DateTime      @default(now()) @updatedAt
  Digest      Digest[]
  Alert       Alert[]
  Incident    Incident[]
  Application Application[]

  @@unique([workspaceId, name])
}

model TeamMember {
  id   Int            @id @default(autoincrement())
  role TeamMemberRole

  team   Team @relation(fields: [teamId], references: [id], onDelete: Cascade)
  teamId Int

  gitProfile   GitProfile @relation(fields: [gitProfileId], references: [id])
  gitProfileId Int

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

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

  @@index([workspaceId])
  @@index([gitProfileId])
  @@index([teamId])
}

model Digest {
  id      Int        @id @default(autoincrement())
  type    DigestType
  enabled Boolean

  channel String

  frequency    Frequency
  dayOfTheWeek DayOfTheWeek[]
  timeOfDay    String
  timezone     String

  settings Json

  teamId Int
  team   Team @relation(fields: [teamId], references: [id], onDelete: Cascade)

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

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

  @@unique([teamId, type])
  @@index([workspaceId])
}

model Alert {
  id       Int       @id @default(autoincrement())
  type     AlertType
  enabled  Boolean
  channel  String
  settings Json

  teamId Int
  team   Team @relation(fields: [teamId], references: [id], onDelete: Cascade)

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

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

  AlertEvent AlertEvent[]

  @@unique([teamId, type])
  @@index([workspaceId])
}

model AlertEvent {
  id Int @id @default(autoincrement())

  alertId Int
  alert   Alert @relation(fields: [alertId], references: [id], onDelete: Cascade)

  pullRequest   PullRequest @relation(fields: [pullRequestId], references: [id], onDelete: Cascade)
  pullRequestId Int

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

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

  @@index([workspaceId])
  @@index([pullRequestId])
  @@index([alertId])
}

model Automation {
  id       Int            @id @default(autoincrement())
  type     AutomationType
  enabled  Boolean
  settings Json

  workspaceId Int
  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)

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

  @@unique([workspaceId, type])
}

model Integration {
  id          Int            @id @default(autoincrement())
  workspaceId Int
  app         IntegrationApp
  data        Json

  workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)

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

  @@unique([workspaceId, app])
}

model ApiKey {
  id   Int    @id @default(autoincrement())
  key  String @unique
  name String

  lastUsedAt DateTime?

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

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  workspaceId Int

  creatorId Int
  creator   GitProfile @relation(fields: [creatorId], references: [id], onDelete: Cascade)

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

model Environment {
  id Int @id @default(autoincrement())

  name        String
  deployments Deployment[]

  isProduction Boolean

  workspaceId Int
  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)

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

  archivedAt DateTime?

  @@unique([workspaceId, name])
}

model Application {
  id Int @id @default(autoincrement())

  name        String
  description String?

  repositoryId Int
  repository   Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)

  teamId Int?
  team   Team? @relation(fields: [teamId], references: [id], onDelete: Cascade)

  deploymentSettings Json

  workspaceId Int
  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)

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

  deployments Deployment[]

  archivedAt DateTime?

  @@unique([workspaceId, name])
  @@index([repositoryId])
  @@index([teamId])
}

model Deployment {
  id Int @id @default(autoincrement())

  applicationId Int
  application   Application @relation(fields: [applicationId], references: [id], onDelete: Cascade)

  version     String
  commitHash  String
  description String?

  changeType DeploymentChangeType?

  environmentId Int
  environment   Environment @relation(fields: [environmentId], references: [id], onDelete: Cascade)

  author   GitProfile? @relation(fields: [authorId], references: [id], onDelete: Cascade)
  authorId Int?

  deployedAt DateTime

  pullRequests DeploymentPullRequest[]

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

  workspaceId     Int
  workspace       Workspace  @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  causedIncidents Incident[] @relation(name: "CauseDeployment")
  fixedIncidents  Incident[] @relation(name: "FixDeployment")

  archivedAt DateTime?

  @@unique([workspaceId, environmentId, applicationId, version, deployedAt])
  @@index([applicationId])
  @@index([environmentId])
  @@index([authorId])
  @@index([workspaceId, deployedAt])
}

model Incident {
  id Int @id @default(autoincrement())

  teamId Int?
  team   Team? @relation(fields: [teamId], references: [id], onDelete: SetNull)

  leaderId Int?
  leader   GitProfile? @relation(fields: [leaderId], references: [id], onDelete: SetNull)

  detectedAt DateTime
  resolvedAt DateTime?

  causeDeploymentId Int
  causeDeployment   Deployment @relation("CauseDeployment", fields: [causeDeploymentId], references: [id], onDelete: Cascade)

  fixDeploymentId Int?
  fixDeployment   Deployment? @relation("FixDeployment", fields: [fixDeploymentId], references: [id], onDelete: SetNull)

  postmortemUrl String?

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

  workspaceId Int
  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)

  archivedAt DateTime?

  @@unique([workspaceId, causeDeploymentId])
  @@index([causeDeploymentId])
  @@index([fixDeploymentId])
  @@index([teamId])
  @@index([leaderId])
  @@index([workspaceId, detectedAt])
}

model DeploymentPullRequest {
  id Int @id @default(autoincrement())

  deploymentId Int
  deployment   Deployment @relation(fields: [deploymentId], references: [id], onDelete: Cascade)

  pullRequestId Int
  pullRequest   PullRequest @relation(fields: [pullRequestId], references: [id], onDelete: Cascade)

  workspaceId Int
  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)

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

  @@unique([deploymentId, pullRequestId])
  @@index([pullRequestId])
  @@index([workspaceId])
}