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")
  provider = "sqlite"
}

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

model Post {
  id          String    @id @default(cuid())
  title       String    @default("")
  subtitle    String    @default("")
  slug        String    @unique @default("")
  publishDate DateTime?
  isPublished Boolean   @default(false)
  content     String    @default("[{\"type\":\"paragraph\",\"children\":[{\"text\":\"\"}]}]")
}

model Project {
  id              String  @id @default(cuid())
  title           String  @default("")
  subtitle        String  @default("")
  projectType     String? @default("work")
  timeline        String  @default("")
  company         String  @default("")
  slug            String  @unique @default("")
  isPublished     Boolean @default(false)
  bgColor         String  @default("")
  hasDarkBg       Boolean @default(true)
  featuredImage   Image?  @relation("Project_featuredImage", fields: [featuredImageId], references: [id])
  featuredImageId String? @map("featuredImage")
  content         String  @default("[{\"type\":\"paragraph\",\"children\":[{\"text\":\"\"}]}]")

  @@index([featuredImageId])
}

model Image {
  id                         String    @id @default(cuid())
  name                       String    @default("")
  alt                        String    @default("")
  image_filesize             Int?
  image_extension            String?
  image_width                Int?
  image_height               Int?
  image_mode                 String?
  image_id                   String?
  publishDate                DateTime?
  from_Project_featuredImage Project[] @relation("Project_featuredImage")
}