Spaces:
Sleeping
Sleeping
File size: 2,403 Bytes
d53e5b4 239b4ae d53e5b4 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 | generator client {
provider = "prisma-client-js"
binaryTargets = ["native", "debian-openssl-3.0.x"]
}
datasource db {
provider = "sqlite"
url = "file:./dev.db"
}
model User {
id String @id @default(cuid())
email String @unique
password String
name String?
role String @default("VIEWER")
tokenVersion Int @default(0)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
inquiries Inquiry[]
blogPosts BlogPost[]
portfolioItems PortfolioItem[]
}
model PortfolioItem {
id String @id @default(cuid())
title String
slug String @unique
description String
technologies String?
imageUrl String?
clientName String?
industry String?
testimonials String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
authorId String?
author User? @relation(fields: [authorId], references: [id])
}
model BlogPost {
id String @id @default(cuid())
title String
slug String @unique
content String
excerpt String?
featuredImage String?
tags String?
status String @default("DRAFT")
publishedAt DateTime?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
authorId String
author User @relation(fields: [authorId], references: [id])
}
model Inquiry {
id String @id @default(cuid())
name String
email String
phone String?
company String?
projectType String?
budget String?
timeline String?
description String
attachments String?
status String @default("NEW")
notes String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
managedById String?
managedBy User? @relation(fields: [managedById], references: [id])
}
model Testimonial {
id String @id @default(cuid())
clientName String
company String?
content String
rating Int
imageUrl String?
approved Boolean @default(false)
createdAt DateTime @default(now())
}
model ServicePackage {
id String @id @default(cuid())
name String
description String
features String
startingPrice Float
sortOrder Int @default(0)
isActive Boolean @default(true)
}
|