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"
  engineType = "binary"
}

model User {
  id       String @id @default(cuid())
  name     String @default("")
  email    String @unique @default("")
  password String
  posts    Post[] @relation("Post_author")
}

model Post {
  id          String    @id @default(cuid())
  title       String    @default("")
  status      String?   @default("draft")
  content     String    @default("[{\"type\":\"paragraph\",\"children\":[{\"text\":\"\"}]}]")
  publishDate DateTime?
  author      User?     @relation("Post_author", fields: [authorId], references: [id])
  authorId    String?   @map("author")
  tags        Tag[]     @relation("Post_tags_Tag_posts")

  @@index([authorId])
}

model Tag {
  id       String    @id @default(cuid())
  name     String    @default("")
  posts    Post[]    @relation("Post_tags_Tag_posts")
  projects Project[] @relation("Project_tags_Tag_projects")
}

model Image {
  id            String  @id @default(cuid())
  img_filesize  Int?
  img_extension String?
  img_width     Int?
  img_height    Int?
  img_mode      String?
  img_id        String?
}

model Project {
  id              String  @id @default(cuid())
  title           String  @default("")
  subtitle        String  @default("")
  description     String  @default("")
  content         String  @default("[{\"type\":\"paragraph\",\"children\":[{\"text\":\"\"}]}]")
  image_filesize  Int?
  image_extension String?
  image_width     Int?
  image_height    Int?
  image_mode      String?
  image_id        String?
  clientName      String  @default("")
  tags            Tag[]   @relation("Project_tags_Tag_projects")
}