schema.prisma

generator client {
  provider = "prisma-client"
  output   = "../generated/prisma"
}

datasource db {
  provider = "postgresql"
}

model Account {
  id                Int    @id @default(autoincrement())
  userId            Int
  type              String @db.VarChar(255)
  provider          String @db.VarChar(255)
  providerAccountId String @db.VarChar(255)
  refresh_token     String?
  access_token      String?
  expires_at        BigInt?
  id_token          String?
  scope             String?
  session_state     String?
  token_type        String?
  user              User   @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([provider, providerAccountId])
  @@index([userId])
  @@map("accounts")
}

model doc_contributors {
  doc_id              String
  github_id           BigInt
  contributions       Int      @default(1)
  last_contributed_at DateTime @default(now()) @db.Timestamptz(6)
  created_at          DateTime @default(now()) @db.Timestamptz(6)
  updated_at          DateTime @updatedAt @db.Timestamptz(6)

  docs docs @relation(fields: [doc_id], references: [id], onDelete: Cascade)

  @@id([doc_id, github_id])
  @@index([doc_id])
  @@index([github_id]) // 便于反查某用户在哪些文档有贡献
}

model docs {
  id           String   @id
  path_current String?
  title        String?
  created_at   DateTime @default(now()) @db.Timestamptz(6)
  updated_at   DateTime @updatedAt @db.Timestamptz(6)

  doc_contributors doc_contributors[]

  /// 作为聚合缓存使用：{"github_id": contributions}
  /// 兼容性最好用 dbgenerated 设置 PG 端默认 '{}'
  contributor_stats Json?       @default(dbgenerated("'{}'::jsonb")) @db.JsonB
  doc_paths         doc_paths[]
}

model Session {
  id           Int      @id @default(autoincrement())
  userId       Int
  expires      DateTime @db.Timestamptz(6)
  sessionToken String   @unique @db.VarChar(255)
  user         User     @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@index([userId])
  @@map("sessions")
}

model User {
  id              Int              @id @default(autoincrement())
  name            String?          @db.VarChar(255)
  email           String?          @unique @db.VarChar(255)
  emailVerified   DateTime?        @db.Timestamptz(6)
  image           String?
  accounts        Account[]
  sessions        Session[]
  chats           Chat[]
  analyticsEvents AnalyticsEvent[]

  @@map("users")
}

model VerificationToken {
  identifier String
  expires    DateTime @db.Timestamptz(6)
  token      String

  @@id([identifier, token])
  @@map("verification_token")
}

model doc_paths {
  doc_id     String
  path       String
  created_at DateTime @default(now()) @db.Timestamptz(6)
  updated_at DateTime @updatedAt @db.Timestamptz(6)

  docs docs @relation(fields: [doc_id], references: [id], onDelete: Cascade)

  @@id([doc_id, path])
  @@index([path])
}

model Chat {
  id        String    @id @default(cuid())
  userId    Int?
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  messages  Message[]

  user User? @relation(fields: [userId], references: [id])

  @@index([userId])
}

model Message {
  id        String   @id @default(cuid())
  chatId    String
  role      String
  content   String
  createdAt DateTime @default(now())

  chat Chat @relation(fields: [chatId], references: [id], onDelete: Cascade)

  @@index([chatId])
}

model AnalyticsEvent {
  id        String   @id @default(cuid())
  userId    Int?
  eventType String
  eventData Json?
  createdAt DateTime @default(now())

  user User? @relation(fields: [userId], references: [id])

  @@index([eventType])
  @@index([userId])
}