prisma/schema.prisma

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["fullTextSearch"]
  binaryTargets = ["native", "debian-openssl-3.0.x", "debian-openssl-1.1.x", "linux-arm64-openssl-1.1.x"]
}

datasource db {
  provider             = "postgres"
  url                  = env("DATABASE_URL")
  relationMode = "prisma"
}

model Bookmark {
  id          String       @id @default(cuid())
  title       String?
  url         String
  image       String?      @db.Text
  imageBlur   String?      @db.Text
  desc        String?      @db.Text
  category    Category?    @relation(fields: [categoryId], references: [id], onDelete: SetNull, onUpdate: Cascade)
  categoryId  String?
  tags        TagsOnBookmarks[]
  user        User?        @relation(fields: [userId], references: [id], onDelete: Cascade, onUpdate: Cascade)
  userId      String
  createdAt   DateTime     @default(now())
  updatedAt   DateTime     @updatedAt

  @@unique([url, userId])
  @@index([categoryId])
  @@index([userId])
}

model TagsOnBookmarks {
  bookmarkId   String
  bookmark     Bookmark      @relation(fields: [bookmarkId], references: [id], onDelete: Cascade, onUpdate: Cascade)
  tagId        String
  tag          Tag           @relation(fields: [tagId], references: [id], onDelete: Cascade, onUpdate: Cascade)

  @@id([bookmarkId, tagId])
  @@index([bookmarkId])
  @@index([tagId])
}

model Tag {
  id          String       @id @default(cuid())
  name        String
  emoji       String?
  bookmarks   TagsOnBookmarks[]
  user        User?        @relation(fields: [userId], references: [id], onDelete: Cascade, onUpdate: Cascade)
  userId      String
  createdAt   DateTime     @default(now())
  updatedAt   DateTime     @updatedAt

  @@unique([name, userId])
  @@index([userId])
}

model Category {
  id          String       @id @default(cuid())
  name        String
  description String?
  bookmarks   Bookmark[]
  user        User?        @relation(fields: [userId], references: [id], onDelete: Cascade, onUpdate: Cascade)
  userId      String
  createdAt   DateTime     @default(now())
  updatedAt   DateTime     @updatedAt

  @@unique([name, userId])
  @@index([userId])
}

// NextAuth
model Account {
  id                 String   @id @default(cuid())
  userId             String
  type               String
  provider           String
  providerAccountId  String
  refresh_token      String?  @db.Text
  access_token       String?  @db.Text
  expires_at         Int?
  expires_in         Int?
  ext_expires_in     Int?
  token_type         String?
  scope              String?
  id_token           String?  @db.Text
  session_state      String?
  user               User     @relation(fields: [userId], references: [id], onUpdate: Cascade)
  createdAt          DateTime @default(now())
  updatedAt          DateTime @updatedAt

  @@unique([provider, providerAccountId])
  @@index([userId])
}

model Session {
  id           String        @id @default(cuid())
  sessionToken String        @unique
  userId       String
  expires      DateTime
  user         User          @relation(fields: [userId], references: [id], onDelete: Cascade, onUpdate: Cascade)

  @@index([userId])
}

model User {
  id            String       @id @default(cuid())
  name          String?
  email         String?      @unique
  emailVerified DateTime?
  image         String?
  createdAt     DateTime     @default(now())
  accounts      Account[]
  sessions      Session[]
  bookmarks     Bookmark[]
  tags          Tag[]
  categories    Category[]
}

model VerificationToken {
  identifier String
  token      String          @unique
  expires    DateTime

  @@unique([identifier, token])
}