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