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 Product {
  id                    String         @id @default(cuid())
  name                  String         @default("")
  subtitle              String         @default("")
  description           String         @default("")
  photo                 ProductImage[] @relation("ProductImage_product")
  status                String?        @default("DRAFT")
  price                 Int?
  user                  User?          @relation("Product_user", fields: [userId], references: [id])
  userId                String?        @map("user")
  from_CartItem_product CartItem[]     @relation("CartItem_product")

  @@index([userId])
}

model ProductImage {
  id                   String      @id @default(cuid())
  image                String?
  altText              String      @default("")
  product              Product?    @relation("ProductImage_product", fields: [productId], references: [id])
  productId            String?     @map("product")
  from_OrderItem_photo OrderItem[] @relation("OrderItem_photo")

  @@index([productId])
}

model User {
  id        String     @id @default(cuid())
  name      String     @default("")
  email     String     @unique @default("")
  password  String
  orders    Order[]    @relation("Order_user")
  products  Product[]  @relation("Product_user")
  cart      CartItem[] @relation("CartItem_user")
  role      Role?      @relation("User_role", fields: [roleId], references: [id])
  roleId    String?    @map("role")
  createdAt DateTime?  @default(now())

  @@index([roleId])
}

model CartItem {
  id        String   @id @default(cuid())
  quantity  Int      @default(1)
  product   Product? @relation("CartItem_product", fields: [productId], references: [id])
  productId String?  @map("product")
  user      User?    @relation("CartItem_user", fields: [userId], references: [id])
  userId    String?  @map("user")

  @@index([productId])
  @@index([userId])
}

model OrderItem {
  id          String        @id @default(cuid())
  name        String        @default("")
  description String        @default("")
  photo       ProductImage? @relation("OrderItem_photo", fields: [photoId], references: [id])
  photoId     String?       @map("photo")
  price       Int?
  quantity    Int?
  productId   String        @default("")
  order       Order?        @relation("OrderItem_order", fields: [orderId], references: [id])
  orderId     String?       @map("order")

  @@index([photoId])
  @@index([orderId])
}

model Order {
  id        String      @id @default(cuid())
  total     Int?
  items     OrderItem[] @relation("OrderItem_order")
  user      User?       @relation("Order_user", fields: [userId], references: [id])
  userId    String?     @map("user")
  charge    String      @default("")
  createdAt DateTime?

  @@index([userId])
}

model Role {
  id                String  @id @default(cuid())
  name              String  @default("")
  canManageProducts Boolean @default(false)
  canSeeOtherUsers  Boolean @default(false)
  canManageUsers    Boolean @default(false)
  canManageRoles    Boolean @default(false)
  canManageCart     Boolean @default(false)
  canManageOrders   Boolean @default(false)
  assignedTo        User[]  @relation("User_role")
}