schema.prisma

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

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

model User {
  id Int @id @default(autoincrement())
  companyId String @default("dummy")
  firstName String
  lastName String
  email String @unique
  password String
  bio String?
  sessionIds String[]
  role UserRole
  tickets Ticket[]
  projects Project[]
  comments Comment[]
  company Company @relation(fields: [companyId], references: [id])
}

model Ticket {
  id String @id @default(uuid())
  projectId String
  companyId String @default("dummy")
  title String
  priority Priority
  createdDate DateTime
  dueDate DateTime?
  closedDate DateTime?
  content String?
  status TicketStatus @default(new)
  history Json[]
  isClosed Boolean @default(false)
  project Project @relation(fields: [projectId], references: [id])
  assignedUsers User[]
  comments Comment[]
}

model Project {
  id String @id @default(uuid())
  companyId String @default("dummy")
  title String
  description String?
  createdDate DateTime
  dueDate DateTime?
  isArchived Boolean @default(false)
  priority Priority
  tickets Ticket[]
  assignedUsers User[]
}

model Comment {
  id String @id @default(uuid())
  userId Int
  ticketId String
  message String
  dateSent DateTime
  user User @relation(fields: [userId], references: [id])
  ticket Ticket @relation(fields: [ticketId], references: [id])
}

model Company {
  id String @id @default(uuid())
  name String
  users User[]
}

enum UserRole {
  admin
  projectManager
  developer
  submitter
}

enum Priority {
  low
  medium
  high
}

enum TicketStatus {
  new
  testing
  reviewed
  development
}