schema.prisma

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

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

model Guild {
    id             String           @id
    ttsEnabled     Boolean          @default(false)
    ttsRole        String?
    ttsLeave       Boolean          @default(true)
    logging        String?
    links          Link[]
    voiceGenerator VoiceGenerator[]
    premium        Boolean          @default(false)
    botMasterRoles String[]
    analytics      Boolean          @default(false)
    Premium        Premium?         @relation(fields: [premiumId], references: [id])
    premiumId      String?
}

model Premium {
    id         String  @id @default(cuid())
    licenseKey String  @unique
    maxGuilds  Int     @default(1)
    guilds     Guild[]
    userId     String
    strike     Int     @default(0)
}

enum LinkType {
    CATEGORY
    STAGE
    ALL
    PERMANENT
    REGULAR
}

model Link {
    dbId               String   @unique @default(cuid())
    id                 String
    type               LinkType @default(REGULAR)
    guild              Guild    @relation(fields: [guildId], references: [id], onDelete: Cascade)
    guildId            String
    linkedRoles        String[]
    reverseLinkedRoles String[]
    suffix             String?
    speakerRoles       String[]
    excludeChannels    String[]
    linkCriteria       Json     @default("{}")

    @@id([id, type])
}

enum VoiceGeneratorType {
    DEFAULT
    NUMBERED
    CLONED
    CUSTOM_NAME
}

enum VoiceGeneratorOption {
    LOCK
    HIDE
    TEXT
    EDITABLE
    OWNER
}

model VoiceGenerator {
    id               String                 @id @default(cuid())
    guild            Guild                  @relation(fields: [guildId], references: [id], onDelete: Cascade)
    guildId          String
    categoryId       String
    generatorId      String
    interfaceChannel String?
    interfaceMessage String?
    openChannels     GeneratedChannel[]
    type             VoiceGeneratorType     @default(DEFAULT)
    defaultOptions   VoiceGeneratorOption[]
    defaultUserLimit Int                    @default(0)
    channelLimit     Int                    @default(100)
    defaultRole      String?
    channelName      String?
    restrictRole     String?
    hideAtLimit      Boolean                @default(false)

    @@unique([guildId, generatorId])
}

model GeneratedChannel {
    id               String         @id @default(cuid())
    channelId        String         @unique
    ownerId          String
    textChannelId    String?
    VoiceGenerator   VoiceGenerator @relation(fields: [voiceGeneratorId], references: [id], onDelete: Cascade)
    voiceGeneratorId String
    userEditable     Boolean        @default(true)
}