er/prisma/schema.prisma

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["postgresqlExtensions"]
}

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

model guild {
  id                 String  @id @unique
  name               String
  reports_channel_id String?
}

model member {
  id              String   @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
  name            String
  booster_role_id String?
  created_at      DateTime @default(now())
  /// Discord Guild ID
  dgid            String
  /// Discord User ID
  duid            String

  @@unique([dgid, duid])
}