schema.prisma

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

generator client {
  provider = "prisma-client-js"
  output   = "node_modules/.prisma/client"
}

model Task {
  id           Int               @id @default(autoincrement())
  label        String?
  priority     TaskPriorityEnum?
  isComplete   Boolean?
  finishBy     DateTime?
  assignedTo   Person?           @relation("TaskassignedTo", fields: [assignedToId], references: [id])
  assignedToId Int?              @map("assignedTo")

  @@index([assignedToId])
}

model Person {
  id       Int      @id @default(autoincrement())
  name     String?
  email    String?  @unique
  password String?
  isAdmin  Boolean?
  tasks    Task[]   @relation("TaskassignedTo")
}

enum TaskPriorityEnum {
  low
  medium
  high
}