supercosmic/prisma/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"
  binaryTargets = ["native", "debian-openssl-3.0.x"]
}

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

model User {
  id         String      @id @unique
  name       String
  platformId String
  platform   String
  Inventory  Inventory[]
  role       Role
}

model Inventory {
  id      Int    @id @unique @default(autoincrement())
  userId  String @unique
  user    User   @relation(fields: [userId], references: [id])
  items   Json
  balance Float  @default(0)
}

enum Role {
  NONE
  MODERATOR
  ADMINISTRATOR
  OWNER
}