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"
}

datasource db {
  provider = "postgresql"
  url      = env("POSTGRES_PRISMA_URL")
}

model User {
  id        Int       @id @default(autoincrement())
  createdAt DateTime  @default(now())
  name      String
  email     String    @unique
  password  String
  role      String
  projects  Project[]
}

model Project {
  id            Int           @id @default(autoincrement())
  createdAt     DateTime      @default(now())
  name          String        @unique
  owner         User          @relation(fields: [ownerId], references: [id])
  ownerId       Int
  domain        String
  pages         Page[]
  scrapes       Scrape[]
  parallelLimit Int           @default(10)
  script        String?
  pageContent   PageContent[]
}

model Page {
  id        Int           @id @default(autoincrement())
  createdAt DateTime      @default(now())
  project   Project       @relation(fields: [projectId], references: [id])
  projectId Int
  url       String
  content   PageContent[]

  @@unique([projectId, url])
}

model PageContent {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  page      Page     @relation(fields: [pageId], references: [id])
  pageId    Int
  project   Project  @relation(fields: [projectId], references: [id])
  projectId Int
  content   String
  status    Int?
}

model Scrape {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  project   Project  @relation(fields: [projectId], references: [id])
  projectId Int
  result    Json?
}