schema.prisma

// This file is automatically generated by Keystone, do not modify it manually.
// Modify your Keystone config when you want to change this.

datasource sqlite {
  url               = env("DATABASE_URL")
  shadowDatabaseUrl = env("SHADOW_DATABASE_URL")
  provider          = "sqlite"
}

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

model Todo {
  id           String  @id @default(cuid())
  label        String  @default("")
  isComplete   Boolean @default(false)
  isPrivate    Boolean @default(false)
  assignedTo   Person? @relation("Todo_assignedTo", fields: [assignedToId], references: [id])
  assignedToId String? @map("assignedTo")

  @@index([assignedToId])
}

model Person {
  id       String  @id @default(cuid())
  name     String  @default("")
  email    String  @unique @default("")
  password String
  role     Role?   @relation("Person_role", fields: [roleId], references: [id])
  roleId   String? @map("role")
  tasks    Todo[]  @relation("Todo_assignedTo")

  @@index([roleId])
}

model Role {
  id                 String   @id @default(cuid())
  name               String   @default("")
  canCreateTodos     Boolean  @default(false)
  canManageAllTodos  Boolean  @default(false)
  canSeeOtherPeople  Boolean  @default(false)
  canEditOtherPeople Boolean  @default(false)
  canManagePeople    Boolean  @default(false)
  canManageRoles     Boolean  @default(false)
  assignedTo         Person[] @relation("Person_role")
}