schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
    provider        = "prisma-client-js"
    previewFeatures = ["jsonProtocol"]
}

datasource db {
    provider = "sqlite"
    // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below
    // Further reading:
    // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema
    // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string
    url      = env("DATABASE_URL")
}

model Meme {
    id          String    @id @default(cuid())
    userId      String
    image       String
    title       String
    description String
    createdAt   DateTime  @default(now())
    updatedAt   DateTime  @updatedAt
    user        User      @relation(fields: [userId], references: [id], onDelete: Cascade)
    votes       Vote[]
    Comment     Comment[]

    @@unique([createdAt, id])
}

model Vote {
    userId String
    memeId String
    type   Int // -1 => downvote, 1 => upvote
    user   User   @relation(fields: [userId], references: [id], onDelete: Cascade)
    meme   Meme   @relation(fields: [memeId], references: [id], onDelete: Cascade)

    @@id([userId, memeId])
}

// Necessary for Next auth
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?
    token_type        String?
    scope             String?
    id_token          String? // @db.Text
    session_state     String?
    user              User    @relation(fields: [userId], references: [id], onDelete: Cascade)

    @@unique([provider, providerAccountId])
}

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

model User {
    id            String    @id @default(cuid())
    name          String?
    email         String?   @unique
    emailVerified DateTime?
    image         String?
    accounts      Account[]
    sessions      Session[]

    memes        Meme[]
    votes        Vote[]
    followers    User[]        @relation("Followers")
    follows      User[]        @relation("Followers")
    comments     Comment[]
    commentVotes CommentVote[]
}

model VerificationToken {
    identifier String
    token      String   @unique
    expires    DateTime

    @@unique([identifier, token])
}

model Comment {
    id        String   @id @default(cuid())
    text      String
    createdAt DateTime @default(now())
    authorId  String
    memeId    String

    meme   Meme          @relation(fields: [memeId], references: [id], onDelete: Cascade)
    author User          @relation(fields: [authorId], references: [id], onDelete: Cascade)
    votes  CommentVote[]

    parent   Comment?  @relation("ParentChild", fields: [parentId], references: [id], onDelete: Cascade)
    replies  Comment[] @relation("ParentChild")
    parentId String?
}

model CommentVote {
    userId    String
    commentId String
    type      Int // -1 => downvote, 1 => upvote
    user      User    @relation(fields: [userId], references: [id], onDelete: Cascade)
    comment   Comment @relation(fields: [commentId], references: [id], onDelete: Cascade)

    @@id([userId, commentId])
}