vidreview/packages/api/prisma/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 = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id          String    @id @default(cuid())
  email       String    @unique
  name        String
  password    String
  avatarUrl   String?
  globalRole  GlobalRole @default(MEMBER)
  active      Boolean   @default(true)
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt

  memberships ProjectMember[]
  comments    Comment[]
  projects    Project[]    // projects where this user is the owner
}

model Project {
  id          String   @id @default(cuid())
  name        String
  description String?
  ownerId     String
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  assets      Asset[]
  members     ProjectMember[]
  invitations Invitation[]
  owner       User     @relation(fields: [ownerId], references: [id])
}

model ProjectMember {
  id         String @id @default(cuid())
  userId     String
  projectId  String
  role       Role   @default(REVIEWER)
  joinedAt   DateTime @default(now())
  invitedBy  String?    // userId who sent the invite

  user    User    @relation(fields: [userId], references: [id], onDelete: Cascade)
  project Project @relation(fields: [projectId], references: [id], onDelete: Cascade)

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

model Asset {
  id        String      @id @default(cuid())
  projectId String
  title     String
  filename  String
  filePath  String
  thumbnail String?
  hlsPath   String?
  duration  Float?
  fps       Float       @default(30)
  mimeType  String
  status    AssetStatus @default(PENDING_REVIEW)
  createdAt DateTime    @default(now())
  updatedAt DateTime    @updatedAt

  project  Project  @relation(fields: [projectId], references: [id], onDelete: Cascade)
  comments Comment[]
}

model Comment {
  id         String    @id @default(cuid())
  assetId    String
  userId     String
  content    String
  timestamp  Float?
  annotations Json?
  resolved   Boolean   @default(false)
  parentId   String?
  createdAt  DateTime  @default(now())
  updatedAt  DateTime  @updatedAt

  asset   Asset    @relation(fields: [assetId], references: [id], onDelete: Cascade)
  user    User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  parent  Comment? @relation("Replies", fields: [parentId], references: [id], onDelete: Cascade)
  replies Comment[] @relation("Replies")
}

enum Role {
  ADMIN
  EDITOR
  REVIEWER
  VIEWER
}

enum GlobalRole {
  ADMIN       // system-wide admin: manage users, all projects
  MEMBER      // regular user: create projects, join via invite
}

enum InvitationStatus {
  PENDING
  ACCEPTED
  EXPIRED
  REVOKED
}

model Invitation {
  id         String           @id @default(cuid())
  email     String            // invitee email
  projectId String
  role      Role              @default(REVIEWER)
  token     String            @unique
  status    InvitationStatus  @default(PENDING)
  invitedBy String?           // userId who sent the invite
  expiresAt DateTime
  createdAt DateTime         @default(now())

  project Project @relation(fields: [projectId], references: [id], onDelete: Cascade)

  @@index([projectId])
  @@index([email])
  @@index([token])
}

enum AssetStatus {
  PENDING_REVIEW
  CHANGES_REQUESTED
  APPROVED
  REJECTED
}