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"
  binaryTargets = ["native", "linux-musl-arm64-openssl-3.0.x"]
}

datasource db {
  provider  = "postgresql"
  url       = env("POSTGRES_PRISMA_URL") // uses connection pooling
  directUrl = env("POSTGRES_URL_NON_POOLING") // uses a direct connection
}

model User {
  id           String    @id @default(cuid())
  username     String    @unique
  auth_session Session[]
  key          Key[]
}

model Session {
  id             String @id @unique
  user_id        String
  active_expires BigInt
  idle_expires   BigInt
  user           User   @relation(references: [id], fields: [user_id], onDelete: Cascade)

  @@index([user_id])
}

model Key {
  id              String  @id @unique
  hashed_password String?
  user_id         String
  user            User    @relation(references: [id], fields: [user_id], onDelete: Cascade)

  @@index([user_id])
}

model Protocol {
  id            String      @id @default(cuid())
  hash          String      @unique
  name          String
  schemaVersion Int
  description   String?
  importedAt    DateTime    @default(now())
  lastModified  DateTime
  stages        Json
  codebook      Json
  assets        Asset[]
  interviews    Interview[]
}

model Asset {
  key       String     @id
  assetId   String     @unique
  name      String
  type      String
  url       String
  size      Int
  protocols Protocol[]

  @@index(fields: [assetId, key])
}

model Interview {
  id            String      @id @default(cuid()) // Cannot be bigint because we want to obfuscate the id
  startTime     DateTime    @default(now())
  finishTime    DateTime?
  exportTime    DateTime?
  lastUpdated   DateTime    @updatedAt
  network       Json
  participant   Participant @relation(fields: [participantId], references: [id], onDelete: Cascade)
  participantId String
  protocol      Protocol    @relation(fields: [protocolId], references: [id], onDelete: Cascade)
  protocolId    String      @map("protocolId")
  currentStep   Int         @default(0)
  stageMetadata Json? // Used to store negative responses in tiestrength census and dyadcensus

  @@index(fields: [protocolId])
  @@index([participantId])
}

model Participant {
  id         String      @id @unique @default(cuid())
  identifier String      @unique
  label      String?
  interviews Interview[]
}

// Cant be shared with TS, unfortunately. Ensure `./schemas/appSettings.ts` is in sync
enum AppSetting {
  configured
  allowAnonymousRecruitment
  limitInterviews
  initializedAt
  installationId
  disableAnalytics
  uploadThingToken
}

model AppSettings {
  key   AppSetting @unique
  value String
}

model Events {
  id        String   @id @default(cuid())
  timestamp DateTime @default(now())
  type      String
  message   String
}