generator client { provider = "prisma-client-js" output = "../src/generated/prisma" } datasource db { provider = "postgresql" } model User { id String @id @default(uuid()) tenantId String? email String name String hashedPassword String role String @default("user") createdAt DateTime @default(now()) favorites Favorite[] memberships WorkspaceMember[] @@unique([tenantId, email]) @@map("users") } model Favorite { id String @id @default(uuid()) tenantId String? entityId String pluginId String label String pluginName String lastSeen DateTime @default(now()) userId String user User @relation(fields: [userId], references: [id], onDelete: Cascade) @@unique([userId, entityId]) @@map("favorites") } model InstalledPlugin { id String @id @default(uuid()) tenantId String? pluginId String version String config String @default("{}") enabled Boolean @default(true) installedAt DateTime @default(now()) updatedAt DateTime @updatedAt @@unique([tenantId, pluginId]) @@map("installed_plugins") } model Setting { id String @id @default(uuid()) tenantId String? key String value String @@unique([tenantId, key]) @@map("settings") } model Workspace { id String @id @default(uuid()) name String subdomain String @unique status String @default("trialing") plan String @default("basic") stripeCustomerId String? stripeSubscriptionId String? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt members WorkspaceMember[] @@map("workspaces") } model WorkspaceMember { id String @id @default(uuid()) userId String workspaceId String role String @default("member") joinedAt DateTime @default(now()) user User @relation(fields: [userId], references: [id], onDelete: Cascade) workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) @@unique([userId, workspaceId]) @@map("workspace_members") } model MarketplaceCredential { id String @id @default(uuid()) tenantId String? version String salt String nonce String ciphertext String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt @@unique([tenantId]) @@map("marketplace_credentials") }