schema.prisma

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

generator client {
  provider = "prisma-client-js"
  // previewFeatures = []
}

generator dbml {
  provider = "prisma-dbml-generator"
}

model User {
  id                   Int                @id @default(autoincrement())
  createdAt            DateTime           @default(now())
  updatedAt            DateTime           @updatedAt
  deletedAt            DateTime?
  lastLogin            DateTime?
  username             String             @unique
  email                String             @unique
  password             String
  firstname            String?
  lastname             String?
  role                 Role               @default(USER)
  storyComment         StoryComment[]
  developerProjects    ProjectDeveloper[]
  tasks                Task[]
  timeLogs             TimeLog[]
  posts                Post[]
  projectOwnerProjects Project[]          @relation("UserProjectOwner")
  ScrumMasterProjects  Project[]          @relation("UserScrumMaster")
}

/// user type
enum Role {
  ADMIN /// allowed to do everything
  USER
}

model Sprint {
  id          Int         @id @default(autoincrement())
  createdAt   DateTime    @default(now())
  updatedAt   DateTime    @updatedAt
  deletedAt   DateTime?
  start       DateTime
  end         DateTime
  velocity    Float
  Project     Project?    @relation(fields: [projectId], references: [id])
  projectId   Int?
  UserStories UserStory[]
  name        String?
  tasks       Task[]
}

model StoryComment {
  id          Int       @id @default(autoincrement())
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt
  deletedAt   DateTime?
  userStoryId Int
  message     String
  User        User      @relation(fields: [userId], references: [id])
  userId      Int
  UserStory   UserStory @relation(fields: [userStoryId], references: [id])
}

model Task {
  id          Int        @id @default(autoincrement())
  createdAt   DateTime   @default(now())
  updatedAt   DateTime   @updatedAt
  deletedAt   DateTime?
  title       String
  description String
  estimate    Float
  status      TaskStatus @default(UNASSIGNED)
  assignedTo  User?      @relation(fields: [userId], references: [id])
  userId      Int?
  timeLogs    TimeLog[]
  UserStory   UserStory? @relation(fields: [userStoryId], references: [id])
  userStoryId Int?
  Sprint      Sprint?    @relation(fields: [sprintId], references: [id])
  sprintId    Int?
}

enum TaskStatus {
  UNASSIGNED
  ASSIGNED
  FINISHED
  ACCEPTED
}

model UserStory {
  id                 Int            @id @default(autoincrement())
  createdAt          DateTime       @default(now())
  updatedAt          DateTime       @updatedAt
  deletedAt          DateTime?
  title              String
  description        String
  priority           StoryPriority
  points             Float?
  acceptanceTest     Boolean        @default(false)
  projectId          Int
  project            Project        @relation(fields: [projectId], references: [id])
  sprintId           Int?
  acceptanceCriteria String
  comments           StoryComment[]
  Task               Task[]
  businessValue      Int?
  Sprint             Sprint?        @relation(fields: [sprintId], references: [id])
}

enum StoryPriority {
  MUST_HAVE
  COULD_HAVE
  SHOULD_HAVE
  WONT_HAVE
}

model TimeLog {
  id             Int       @id @default(autoincrement())
  createdAt      DateTime  @default(now())
  updatedAt      DateTime  @updatedAt
  deletedAt      DateTime?
  day            DateTime
  hours          Float
  User           User      @relation(fields: [userId], references: [id])
  userId         Int
  Task           Task      @relation(fields: [taskId], references: [id])
  taskId         Int
  remainingHours Float
  title          String
}

model Post {
  id        Int       @id @default(autoincrement())
  message   String
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  deletedAt DateTime?
  user      User?     @relation(fields: [userId], references: [id])
  userId    Int?
  Project   Project?  @relation(fields: [projectId], references: [id])
  projectId Int?
}

model ProjectDeveloper {
  id        Int       @id @default(autoincrement())
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  deletedAt DateTime?
  user      User      @relation(fields: [userId], references: [id])
  userId    Int
  project   Project   @relation(fields: [projectId], references: [id])
  projectId Int

  @@unique([userId, projectId])
}

model Project {
  id             Int                @id @default(autoincrement())
  createdAt      DateTime           @default(now())
  updatedAt      DateTime           @updatedAt
  deletedAt      DateTime?
  title          String
  documentation  String?
  description    String
  projectOwner   User               @relation(fields: [projectOwnerId], references: [id], name: "UserProjectOwner")
  scrumMaster    User               @relation(fields: [scrumMasterId], references: [id], name: "UserScrumMaster")
  developers     ProjectDeveloper[]
  sprints        Sprint[]
  posts          Post[]
  UserStory      UserStory[]
  projectOwnerId Int
  scrumMasterId  Int
}