File size: 3,749 Bytes
8f9c4ef | 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 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 | generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
model User {
id String @id @default(uuid())
email String @unique
name String
avatar String?
password String?
provider String @default("LOCAL")
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
ownedRooms Room[] @relation("RoomOwner")
memberships RoomMembership[]
messages Message[]
executions Execution[]
snippets Snippet[]
activities Activity[]
@@map("users")
}
model Room {
id String @id @default(uuid())
name String
ownerId String
language String @default("javascript")
isPublic Boolean @default(false)
inviteCode String @unique
maxMembers Int @default(10)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
owner User @relation("RoomOwner", fields: [ownerId], references: [id], onDelete: Cascade)
members RoomMembership[]
files RoomFile[]
messages Message[]
executions Execution[]
@@index([ownerId])
@@map("rooms")
}
model RoomMembership {
id String @id @default(uuid())
userId String
roomId String
role String @default("EDITOR")
joinedAt DateTime @default(now())
lastActive DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
room Room @relation(fields: [roomId], references: [id], onDelete: Cascade)
@@unique([userId, roomId])
@@map("room_memberships")
}
model RoomFile {
id String @id @default(uuid())
roomId String
name String
path String
content String @default("")
language String @default("javascript")
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
room Room @relation(fields: [roomId], references: [id], onDelete: Cascade)
@@unique([roomId, path])
@@map("room_files")
}
model Message {
id String @id @default(uuid())
content String
type String @default("TEXT")
metadata Json?
userId String
roomId String
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
room Room @relation(fields: [roomId], references: [id], onDelete: Cascade)
@@index([roomId, createdAt])
@@map("messages")
}
model Execution {
id String @id @default(uuid())
userId String
roomId String
language String
code String
stdout String @default("")
stderr String @default("")
exitCode Int @default(0)
duration Int @default(0)
memoryUsed Int @default(0)
timedOut Boolean @default(false)
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
room Room @relation(fields: [roomId], references: [id], onDelete: Cascade)
@@index([userId, createdAt])
@@map("executions")
}
model Snippet {
id String @id @default(uuid())
userId String
title String
description String?
code String
language String
isPublic Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([userId])
@@map("snippets")
}
model Activity {
id String @id @default(uuid())
userId String
type String
description String
roomId String?
roomName String?
metadata Json?
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([userId, createdAt])
@@map("activities")
}
|