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 User {
  id       String    @id @default(cuid())
  name     String    @default("")
  email    String    @unique @default("")
  admin    Boolean   @default(false)
  password String
  projects Project[] @relation("Project_author")
}

model Project {
  id              String  @id @default(cuid())
  teamName        String  @default("")
  teamSize        Int?    @default(1)
  teamMembers     String  @default("")
  title           String  @default("")
  description     String  @default("[{\"type\":\"paragraph\",\"children\":[{\"text\":\"\"}]}]")
  image_filesize  Int?
  image_extension String?
  image_width     Int?
  image_height    Int?
  image_id        String?
  safe            Boolean @default(true)
  author          User?   @relation("Project_author", fields: [authorId], references: [id])
  authorId        String? @map("author")
  urls            String  @default("")
  video           String  @default("")

  @@index([authorId])
}