schema.prisma

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

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

model User {
  id             String          @id @default(cuid()) @db.VarChar(32)
  username       String?         @unique
  email          String?         @unique
  fullname       String?
  password       String?
  active         Boolean         @default(true)
  sudo           Boolean         @default(false)
  createdAt      DateTime        @default(now("0")) @db.DateTime(0)
  updatedAt      DateTime        @default(now("0")) @updatedAt @db.DateTime(0)
  showEmail      Boolean         @default(false)
  showFullname   Boolean         @default(true)
  image          String?
  Tokens         Token[]
  Files          File[]
  Letters        Letter[]
  ResetPasswords ResetPassword[]
  Posts          Post[]
  Likes          Like[]
}

model Token {
  id        String    @id @default(cuid()) @db.VarChar(32)
  createdAt DateTime  @default(now("0")) @db.DateTime(0)
  expiredAt DateTime? @db.DateTime(0)
  userId    String?   @db.VarChar(32)

  // User - не обязательный объект, так как необходимость сформировать токен
  // может быть еще до существования объекта пользователя
  User User? @relation(fields: [userId], references: [id])

  @@index(createdAt)
}

model File {
  id        String   @id @default(cuid()) @db.VarChar(32)
  createdAt DateTime @default(now("0")) @db.DateTime(0)
  updatedAt DateTime @default(now("0")) @updatedAt @db.DateTime(0)
  path      String   @db.MediumText
  filename  String
  name      String?
  mimetype  String
  encoding  String
  size      Float
  rank      Int      @default(value: 0)

  createdById String? @db.VarChar(32)
  CreatedBy   User?   @relation(fields: [createdById], references: [id])

  postId      String? @db.VarChar(32)
  Post        Post?   @relation(fields: [postId], references: [id])
}

model Letter {
  id           String       @id @default(cuid()) @db.VarChar(32)
  createdAt    DateTime     @default(now("0")) @db.DateTime(0)
  updatedAt    DateTime     @default(now("0")) @updatedAt @db.DateTime(0)
  email        String       @db.MediumText
  subject      String       @db.MediumText
  message      String       @db.MediumText
  status       LetterStatus @default(value: Created)
  errorMessage String?      @db.Text
  rank         Int?
  deleteOnSend Boolean      @default(value: true)
  replyTo      String?      @db.MediumText
  returnTo     String?      @db.MediumText
  createdById  String?      @db.VarChar(32)
  CreatedBy    User?        @relation(fields: [createdById], references: [id])

  @@index([createdById], name: "User")
}

enum LetterStatus {
  Created
  Processing
  Sended
  Error
}

model Log {
  id         String   @id @default(cuid()) @db.VarChar(32)
  createdAt  DateTime @default(now("0")) @db.DateTime(0)
  updatedAt  DateTime @default(now("0")) @updatedAt @db.DateTime(0)
  level      LogLevel @default(value: Info)
  objectType String?  @db.VarChar(32)
  message    String   @db.MediumText
  stack      String?  @db.MediumText
}

enum LogLevel {
  Info
  Notice
  Warning
  Error
  Fatal
}

model ResetPassword {
  id                       String    @id @default(cuid()) @db.VarChar(32)
  createdAt                DateTime  @default(now("0")) @db.DateTime(0)
  updatedAt                DateTime  @default(now("0")) @updatedAt @db.DateTime(0)
  code                     String    @db.VarChar(32)
  password                 String
  validTill                DateTime?
  User                     String    @db.VarChar(32)
  User_ResetPasswordToUser User      @relation(fields: [User], references: [id])

  @@index([User], name: "User")
}

model Post {
  id          String    @id @default(cuid()) @db.VarChar(32)
  createdAt   DateTime  @default(now("0")) @db.DateTime(0)
  updatedAt   DateTime  @default(now("0")) @updatedAt @db.DateTime(0)
  Mashroom    Mashroom? @relation(fields: [mashroomId], references: [id])
  mashroomId  String?   @db.VarChar(32)
  title       String
  text        String?
  createdById String    @db.VarChar(32)
  CreatedBy   User      @relation(fields: [createdById], references: [id])
  Likes       Like[]
  Files       File[]

  @@index([createdById], name: "User")
}

model Mashroom {
  id    String @id @default(cuid()) @db.VarChar(32)
  name  String
  Posts Post[]
}

model Like {
  id          String @id @default(cuid()) @db.VarChar(32)
  postId      String @db.VarChar(32)
  Post        Post   @relation(fields: [postId], references: [id])
  createdById String @db.VarChar(32)
  CreatedBy   User   @relation(fields: [createdById], references: [id])
}