Files
ExcaliDash/backend/prisma/schema.prisma
2025-11-24 14:32:48 -08:00

43 lines
1.3 KiB
Plaintext

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema
generator client {
provider = "prisma-client-js"
output = "../src/generated/client"
binaryTargets = ["native", "linux-musl-arm64-openssl-3.0.x", "linux-musl-openssl-3.0.x"]
}
datasource db {
provider = "sqlite"
url = env("DATABASE_URL")
}
model Collection {
id String @id @default(uuid())
name String
drawings Drawing[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}
model Drawing {
id String @id @default(uuid())
name String
elements String // Stored as JSON string
appState String // Stored as JSON string
files String @default("{}") // Stored as JSON string
preview String? // SVG string for thumbnail
version Int @default(1)
collectionId String?
collection Collection? @relation(fields: [collectionId], references: [id])
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}
model Library {
id String @id @default("default") // Singleton pattern - use "default" ID
items String @default("[]") // Stored as JSON string array of library items
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}