model Articles {
id String @id @default(cuid())
title String
content String
category String
featuredImage String
author User @relation(fields: [authorId], references: [id])
authorId String
comments Comment[]
likes Like[] // An article can have multiple likes
createdAt DateTime @default(now())
}
model Comment {
id String @id @default(cuid())
body String
articleId String
article Articles @relation(fields: [articleId], references: [id])
authorId String
author User @relation(fields: [authorId], references: [id])
createdAt DateTime @default(now())
}
model Like {
id String @id @default(cuid())
isLiked Boolean @default(false)
user User @relation(fields: [userId], references: [id])
userId String
article Articles @relation(fields: [articleId], references: [id])
articleId String
createdAt DateTime @default(now())
@@unique([userId, articleId]) // Ensures a user can like an article only once
}
Comments
Sign in to leave a comment or like this post