Files
worldwideview/prisma/schema.prisma
Antigravity AI ded2d587e4 feat(auth): implement decentralized plugin auth and SSRF hardening
- Add PBKDF2 + AES-256-GCM encryption for credentials
- Update Prisma schema to include MarketplaceCredential
- Implement comprehensive SSRF utility with IP pinning
- Harden /api/camera/proxy and stream proxy with safeFetch
- Fix openid-client PKCE generator usage
- Update workspace configurations and ADRs
- Bump version to 2.10.0 (Minor)
2026-05-14 19:17:09 +12:00

105 lines
2.6 KiB
Plaintext

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")
}