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"
  output   = "./generated/client"
}

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

model Competition {
  id                String              @id
  name              String
  importedAt        DateTime            @default(now())
  country           String
  startDate         String
  endDate           String
  // if true, the server will automatically advance the competition to the next activity
  autoAdvance       Boolean             @default(false)
  // the delay in seconds before the server advances the competition to the next activity
  autoAdvanceDelay  Int                 @default(0)
  status            Status              @default(NOT_STARTED)
  competitionAccess CompetitionAccess[]
  activityHistory   ActivityHistory[]
  webhooks          Webhook[]
}

model CompetitionAccess {
  competitionId String      @db.VarChar(255)
  userId        Int
  roomId        Int
  competition   Competition @relation(fields: [competitionId], references: [id])

  @@unique([competitionId, userId])
}

model ActivityHistory {
  competitionId String      @db.VarChar(255)
  activityId    Int
  startTime     DateTime?
  endTime       DateTime?
  // For autoAdvance competitions, the server will advance to the next activity when the scheduledEnd is reached
  scheduledStartTime DateTime?
  scheduledEndTime   DateTime?

  competition   Competition @relation(fields: [competitionId], references: [id])

  @@unique([competitionId, activityId])
}

enum HTTPMethod {
  GET
  POST
  PATCH
  PUT
  DELETE

  @@map("Method")
}

model Webhook {
  id            Int        @id @default(autoincrement())
  competitionId String     @db.VarChar(255)
  url           String     @db.VarChar(255)
  method        HTTPMethod
  headers       Json?

  competition Competition @relation(fields: [competitionId], references: [id])

  @@unique([competitionId, url])
}

enum Status {
  NOT_STARTED
  IN_PROGRESS
  FINISHED
}