mysql-schema.prisma

datasource db {
  provider = "mysql"
  url      = env("database")
}

generator client {
  provider             = "python -m prisma"
  interface            = "asyncio"
  recursive_type_depth = 5
}

model User {
  // When creating a user ALWAYS pass a id, this does not have a default
  id         BigInt   @id
  createdAt  DateTime @default(now())
  discordId  BigInt   @default(0)
  verifiedAt DateTime @default(now())
  purchases  Json
}

model Product {
  id          Int      @id @default(autoincrement())
  createdAt   DateTime @default(now())
  name        String
  description String
  imageId     String   @default("")
  price       Int
  productId   BigInt
  stock       Int?
  role        BigInt?
  attachments Json
  // Tags will be refered to by ID, we would use connectors if we werent supporting open cloud
  tags        Json
  purchases   Int      @default(0)
  owners      Int      @default(0)

  @@unique([name])
}

model Tag {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  name      String
  color     Json
  textColor Json

  @@unique([name])
}