> ## Documentation Index
> Fetch the complete documentation index at: https://doubtbot.eu/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Database

> Prisma schema, MongoDB models, and data layer for Doubt Discord Bot

Doubt uses **MongoDB** as its database, accessed through **Prisma v6**. The Prisma schema is defined in `prisma/schema.prisma`.

## Connection

The Prisma client is initialized in `src/handlers/prisma.js` as a singleton. It reads the MongoDB URI from `config.handler.mongodb.uri` (which resolves to `DEV_MONGODB_URI` or `MONGODB_URI` based on the `PRODUCTION` flag).

Connection is established during bot startup if `config.handler.mongodb.toggle` is `true`.

## Prisma CLI

For Prisma CLI tools (like `prisma db push` or `prisma studio`), set the `DATABASE_URL` environment variable in `.env` to your MongoDB connection string.

```bash theme={null}
# Sync indexes to the database
npx prisma db push

# Browse data interactively
npx prisma studio

# Regenerate the client after schema changes
npx prisma generate
```

<Note>
  MongoDB does not support migrations (`prisma migrate` commands will not work).
</Note>

## Models

### EcoSchema

Economy accounts — one per user per guild.

| Field    | Type     | Description                |
| -------- | -------- | -------------------------- |
| `id`     | ObjectId | Auto-generated primary key |
| `Guild`  | String?  | Discord guild ID           |
| `User`   | String?  | Discord user ID            |
| `Bank`   | Float?   | Bank balance               |
| `Wallet` | Float?   | Wallet balance             |

**Collection:** `ecoschemas`

**Used by:** `/economy`, `/bal`, `/deposit`, `/withdraw`, `/beg`, `/rob`

***

### Users

User configuration and badge assignments.

| Field    | Type      | Description                              |
| -------- | --------- | ---------------------------------------- |
| `id`     | ObjectId  | Auto-generated primary key               |
| `user`   | String?   | Discord user ID                          |
| `badges` | String\[] | Array of badge IDs assigned to this user |

**Collection:** `users`

**Used by:** `/user info`, `/badge give/take`, context menus (info, profile)

***

### Badge

Global badge definitions (not per-guild).

| Field       | Type     | Description                                           |
| ----------- | -------- | ----------------------------------------------------- |
| `id`        | ObjectId | Auto-generated primary key                            |
| `badgeId`   | String?  | Custom badge identifier (mapped from `id` in MongoDB) |
| `name`      | String?  | Display name                                          |
| `emoji`     | String?  | Emoji string or custom emoji reference                |
| `animated`  | Boolean? | Whether the emoji is animated                         |
| `emojiId`   | String?  | Discord emoji snowflake                               |
| `createdAt` | String?  | Creation timestamp                                    |

**Collection:** `badges`

**Used by:** `/badge` (create/edit/delete/give/take/list), user info displays

***

### Afk

AFK status entries — one per user per guild.

| Field      | Type     | Description                                   |
| ---------- | -------- | --------------------------------------------- |
| `id`       | ObjectId | Auto-generated primary key                    |
| `User`     | String?  | Discord user ID                               |
| `Guild`    | String?  | Discord guild ID                              |
| `Message`  | String?  | AFK reason message                            |
| `Nickname` | String?  | Original nickname (restored when AFK removed) |

**Collection:** `afks`

**Used by:** `/afk set/remove`, AFK check event handler

***

### Xp

Experience points and level data — one per user per guild.

| Field     | Type     | Description                    |
| --------- | -------- | ------------------------------ |
| `id`      | ObjectId | Auto-generated primary key     |
| `guildId` | String   | Discord guild ID (required)    |
| `userId`  | String   | Discord user ID (required)     |
| `xp`      | Float    | Experience points (default: 0) |
| `level`   | Float    | Current level (default: 1)     |

**Collection:** `xps`

**Used by:** `/rank info/reset/set`

***

### Welcome

Welcome system configuration — one per guild.

| Field        | Type     | Description                                                                      |
| ------------ | -------- | -------------------------------------------------------------------------------- |
| `id`         | ObjectId | Auto-generated primary key                                                       |
| `Guild`      | String?  | Discord guild ID                                                                 |
| `Channel`    | String?  | Welcome message channel ID                                                       |
| `Message`    | String?  | Welcome message template (supports `{user}`, `{rules}`, `{server}` placeholders) |
| `Rules`      | String?  | Rules channel ID                                                                 |
| `MemberRole` | String?  | Auto-role for human members                                                      |
| `BotRole`    | String?  | Auto-role for bot members                                                        |

**Collection:** `welcomes`

**Used by:** Setup wizard (welcomeSSM), `guildMemberAdd` event

***

### Ticket

Ticket system configuration — one per guild.

| Field      | Type     | Description                     |
| ---------- | -------- | ------------------------------- |
| `id`       | ObjectId | Auto-generated primary key      |
| `Guild`    | String?  | Discord guild ID                |
| `Channel`  | String?  | Ticket panel channel ID         |
| `Category` | String?  | Category for ticket channels    |
| `Ticket`   | String?  | Current ticket type/subject     |
| `Role`     | String?  | Support role with ticket access |

**Collection:** `tickets`

**Used by:** Setup wizard (ticketSSM), ticket menu, ticket modal

***

### GuildSchema

Per-guild settings (currently prefix only).

| Field    | Type     | Description                |
| -------- | -------- | -------------------------- |
| `id`     | ObjectId | Auto-generated primary key |
| `guild`  | String?  | Discord guild ID           |
| `prefix` | String?  | Custom command prefix      |

**Collection:** `guildschemas`

**Used by:** Prefix command routing, `?prefix set/reset`

***

### Chatbot

Chatbot channel configuration — one per guild.

| Field     | Type     | Description                   |
| --------- | -------- | ----------------------------- |
| `id`      | ObjectId | Auto-generated primary key    |
| `Guild`   | String?  | Discord guild ID              |
| `Channel` | String?  | Designated chatbot channel ID |

**Collection:** `chatbots`

**Used by:** Currently imported but not actively used in any command.

***

### JTCSetup

Join-to-Create voice channel configuration — one per guild.

| Field      | Type          | Description                                   |
| ---------- | ------------- | --------------------------------------------- |
| `id`       | ObjectId      | Auto-generated primary key                    |
| `GuildID`  | String        | Discord guild ID (required)                   |
| `Category` | String        | Parent category for voice channels (required) |
| `Channel`  | String        | Hub voice channel ID (required)               |
| `Channels` | JTCChannel\[] | Array of active temporary channels            |

**JTCChannel (embedded type):**

| Field              | Type    | Description                                    |
| ------------------ | ------- | ---------------------------------------------- |
| `ChannelID`        | String  | Temporary channel ID                           |
| `OwnerID`          | String  | Channel owner's user ID                        |
| `MessageID`        | String  | Dashboard message ID                           |
| `isLocked`         | Boolean | Whether the channel is locked (default: false) |
| `participantCount` | Int?    | Current participant count                      |
| `isInvisible`      | Boolean | Whether the channel is hidden (default: false) |

**Collection:** `jtcsetups`

**Used by:** `voiceStateUpdate` event handler

## Schema Files

The schema files in `src/schemas/` are thin re-exports of Prisma model delegates:

```js theme={null}
// Example: src/schemas/EcoSchema.js
const { prisma } = require("../handlers/prisma");
module.exports = prisma.ecoSchema;
```

This preserves backward-compatible import paths throughout the codebase while using Prisma under the hood.