schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init

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

datasource db {
    provider = "postgresql"
    url      = env("DATABASE_URL") // postgresql://username:password@localhost:5432/namedatabase?schema=public
}

model DiscordUser {
    id            String  @id // ID do Discord
    username      String
    discriminator String
    avatar        String?
    wallet        Decimal @db.Decimal(12, 4)

    roles DiscordRole[] @relation("UserRoles")

    createdAt DateTime @default(now()) @map("created_at")
    updatedAt DateTime @updatedAt @map("updated_at")

    @@map("discord_users")
}

model DiscordRole {
    id   String @id // ID do cargo
    name String

    users DiscordUser[] @relation("UserRoles")

    createdAt DateTime @default(now()) @map("created_at")
    updatedAt DateTime @updatedAt @map("updated_at")

    @@map("discord_roles")
}

model DiscordGuild {
    id   String  @id // ID fixo do servidor do .env
    name String
    icon String?

    env DiscordGuildEnvironment?

    createdAt DateTime @default(now()) @map("created_at")
    updatedAt DateTime @updatedAt @map("updated_at")

    @@map("discord_guilds")
}

model DiscordGuildEnvironment {
    id String @id @default(uuid())

    guild   DiscordGuild @relation(fields: [guildId], references: [id])
    guildId String       @unique @map("guild_id")

    initialMoneyValue Decimal @map("initial_money_value") @db.Decimal(12, 4)

    createdAt DateTime @default(now()) @map("created_at")
    updatedAt DateTime @updatedAt @map("updated_at")

    @@map("discord_guild_enviroments")
}