schema.prisma

model OAuthAccount {
  id       String
  type     OAuthProvider
  username String
  photoURL String?
  email    String

  accessToken  String
  refreshToken String
  expiresBy    DateTime

  sessionId String?
  session   Session? @relation(fields: [sessionId], references: [id])

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

  @@id([id, type])
}

enum UserType {
  ADMINISTRATOR
  CLIENT
  DEVELOPER
}

model User {
  id       String         @id @default(uuid())
  name     String
  type     UserType
  photoURL String?
  accounts OAuthAccount[]
}

model Session {
  id String @id

  redirectUser String?
  accounts     OAuthAccount[]
}