mono/packages/database/prisma/schema.prisma
2025-03-24 05:22:13 +01:00

60 lines
1.3 KiB
Plaintext

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
name String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
sessions Session[]
@@map("users")
}
model Session {
id String @id @default(cuid())
userId String
token String @unique
expiresAt DateTime
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id])
@@map("sessions")
}
model Feed {
id Int @id @default(autoincrement())
title String
description String
link String @unique
imageUrl String?
lastBuildDate String
items Item[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}
model Item {
id Int @id @default(autoincrement())
title String
description String
link String @unique
pubDate String
guid String @unique
categories String[]
authors String[]
feed Feed @relation(fields: [feedId], references: [id])
feedId Int
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}