redstone/packages/database/prisma/schema.prisma at main · dcoric/redstone · GitHub

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
// Prisma schema for Redstone knowledge management app
// Database: PostgreSQL

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id        String   @id @default(cuid())
  email     String   @unique
  password  String   // Hashed password
  name      String?
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  files     File[]
  folders   Folder[]
  tags      Tag[]

  @@map("users")
}

model Folder {
  id        String    @id @default(cuid())
  name      String
  parentId  String?   // For nested folders
  userId    String
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  deletedAt DateTime? // For soft deletes (sync)

  user      User      @relation(fields: [userId], references: [id], onDelete: Cascade)
  parent    Folder?   @relation("FolderTree", fields: [parentId], references: [id], onDelete: Cascade)
  children  Folder[]  @relation("FolderTree")
  files     File[]

  @@index([userId])
  @@index([userId, parentId])
  @@map("folders")
}

model File {
  id          String        @id @default(cuid())
  title       String
  content     String        @db.Text // Markdown content
  folderId    String?
  userId      String
  createdAt   DateTime      @default(now())
  updatedAt   DateTime      @updatedAt
  deletedAt   DateTime?     // For soft deletes (sync)
  lastSynced  DateTime      @default(now())

  user        User          @relation(fields: [userId], references: [id], onDelete: Cascade)
  folder      Folder?       @relation(fields: [folderId], references: [id], onDelete: SetNull)
  versions    FileVersion[]
  tags        FileTag[]

  @@index([userId, folderId])
  @@index([userId, updatedAt])
  @@map("files")
}

model FileVersion {
  id        String   @id @default(cuid())
  fileId    String
  content   String   @db.Text
  createdAt DateTime @default(now())

  file      File     @relation(fields: [fileId], references: [id], onDelete: Cascade)

  @@index([fileId, createdAt])
  @@map("file_versions")
}

model Tag {
  id        String    @id @default(cuid())
  name      String
  userId    String
  createdAt DateTime  @default(now())

  user      User      @relation(fields: [userId], references: [id], onDelete: Cascade)
  files     FileTag[]

  @@unique([name, userId])
  @@index([userId])
  @@map("tags")
}

model FileTag {
  fileId    String
  tagId     String
  createdAt DateTime @default(now())

  file      File     @relation(fields: [fileId], references: [id], onDelete: Cascade)
  tag       Tag      @relation(fields: [tagId], references: [id], onDelete: Cascade)

  @@id([fileId, tagId])
  @@map("file_tags")
}