-
@ Marth
2024-08-22 22:06:00```js datasource db { provider = "postgresql" url = env("DATABASE_URL") } generator client { provider = "prisma-client-js" }
model User { id String @id @default(uuid()) pubkey String @unique username String? @unique avatar String? purchased Purchase[] courses Course[] resources Resource[] courseDrafts CourseDraft[] drafts Draft[] role Role? @relation(fields: [roleId], references: [id]) roleId String? createdAt DateTime @default(now()) updatedAt DateTime @updatedAt }
model Role { id String @id @default(uuid()) subscribed Boolean @default(false) users User[] }
model Purchase { id String @id @default(uuid()) user User @relation(fields: [userId], references: [id]) userId String course Course? @relation(fields: [courseId], references: [id]) courseId String? resource Resource? @relation(fields: [resourceId], references: [id]) resourceId String? amountPaid Int createdAt DateTime @default(now()) updatedAt DateTime @updatedAt }
model Course { id String @id userId String
user User @relation(fields: [userId], references: [id]) price Int @default(0) resources Resource[] purchases Purchase[] noteId String? @unique createdAt DateTime @default(now()) updatedAt DateTime @updatedAt courseDraft CourseDraft? }model Resource { id String @id // Client generates UUID userId String
user User @relation(fields: [userId], references: [id]) course Course? @relation(fields: [courseId], references: [id]) courseId String? courseDraft CourseDraft? @relation(fields: [courseDraftId], references: [id]) courseDraftId String? price Int @default(0) purchases Purchase[] noteId String? @unique createdAt DateTime @default(now()) updatedAt DateTime @updatedAt }model Draft { id String @id @default(uuid()) userId String user User @relation(fields: [userId], references: [id]) type String title String summary String content String image String? price Int? @default(0) topics String[] createdAt DateTime @default(now()) updatedAt DateTime @updatedAt courseDraft CourseDraft? @relation(fields: [courseDraftId], references: [id]) courseDraftId String? }
model CourseDraft { id String @id @default(uuid()) userId String user User @relation(fields: [userId], references: [id]) resources Resource[] drafts Draft[] title String summary String image String? price Int? @default(0) topics String[] createdAt DateTime @default(now()) updatedAt DateTime @updatedAt course Course? @relation(fields: [courseId], references: [id]) courseId String? @unique } ```