9.x-dev/prisma/schema.prisma

generator client {
    provider = "prisma-client-js"
}

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

enum InfractionType {
    BAN
    KICK
    MUTE
    WARNING
    MASSBAN
    MASSKICK
    UNBAN
    UNMUTE
    BULK_DELETE_MESSAGE
    TIMEOUT
    TIMEOUT_REMOVE
    BEAN
    NOTE
    ROLE
    MOD_MESSAGE
    SHOT
}

enum InfractionDeliveryStatus {
    SUCCESS
    FALLBACK
    FAILED
    NOT_DELIVERED
}

model Infraction {
    id             Int                      @id @default(autoincrement())
    type           InfractionType
    userId         String
    guildId        String
    reason         String?
    moderatorId    String
    expiresAt      DateTime?
    metadata       Json?
    deliveryStatus InfractionDeliveryStatus @default(SUCCESS)
    createdAt      DateTime                 @default(now())
    updatedAt      DateTime                 @default(now()) @updatedAt
    queueId        Int?

    @@map("infractions")
}

model PermissionOverwrite {
    id                        Int      @id @default(autoincrement())
    name                      String?
    guildId                   String
    roles                     String[] @default([])
    users                     String[] @default([])
    grantedDiscordPermissions String[] @default([])
    grantedSystemPermissions  String[] @default([])
    priority                  Int      @default(0)
    merge                     Boolean  @default(true)
    disabled                  Boolean  @default(false)
    createdAt                 DateTime @default(now())
    updatedAt                 DateTime @default(now()) @updatedAt

    @@map("permission_overwrites")
}

model PermissionLevel {
    id                        Int      @id @default(autoincrement())
    guildId                   String
    level                     Int
    disabled                  Boolean  @default(false)
    grantedDiscordPermissions String[] @default([])
    grantedSystemPermissions  String[] @default([])
    roles                     String[] @default([])
    users                     String[] @default([])
    createdAt                 DateTime @default(now())
    updatedAt                 DateTime @default(now()) @updatedAt

    @@map("permission_levels")
}

enum CommandPermissionOverwriteAction {
    ALLOW
    DENY
}

model CommandPermissionOverwrite {
    id                         Int                              @id @default(autoincrement())
    guildId                    String
    commands                   String[]
    requiredDiscordPermissions Json                             @default("null")
    requiredSystemPermissions  Json                             @default("null")
    requiredRoles              Json                             @default("null")
    requiredUsers              Json                             @default("null")
    requiredChannels           Json                             @default("null")
    requiredLevel              Int?
    disabled                   Boolean                          @default(false)
    onMatch                    CommandPermissionOverwriteAction @default(ALLOW)
    createdAt                  DateTime                         @default(now())
    updatedAt                  DateTime                         @default(now()) @updatedAt

    @@map("command_permission_overwrites")
}

model Queue {
    id        Int       @id @default(autoincrement())
    userId    String
    guildId   String
    channelId String?
    messageId String?
    name      String
    repeat    Boolean   @default(false)
    data      Json      @default("{}")
    createdAt DateTime  @default(now())
    updatedAt DateTime  @default(now()) @updatedAt
    runsAt    DateTime?

    @@map("queues")
}

model MuteRecord {
    id        Int      @id @default(autoincrement())
    memberId  String
    guildId   String
    roles     String[]
    createdAt DateTime @default(now())
    updatedAt DateTime @default(now()) @updatedAt

    @@map("mute_records")
}

model ChannelLock {
    id          Int      @id @default(autoincrement())
    guildId     String
    channelId   String
    permissions Json
    createdAt   DateTime @default(now())
    updatedAt   DateTime @default(now()) @updatedAt

    @@map("channel_locks")
}

model AfkEntry {
    id           Int      @id @default(autoincrement())
    reason       String?
    userId       String
    guildId      String
    mentions     String[] @default([])
    mentionCount Int      @default(0)
    global       Boolean  @default(false)
    createdAt    DateTime @default(now())
    updatedAt    DateTime @default(now()) @updatedAt

    @@map("afk_entries")
}

model User {
    id                     Int       @id @default(autoincrement())
    name                   String?
    username               String
    discordId              String
    githubId               String?
    guilds                 String[]  @default([])
    password               String
    token                  String?
    recoveryToken          String?
    recoveryCode           String?
    recoveryAttempts       Int       @default(0)
    recoveryTokenExpiresAt DateTime?
    createdAt              DateTime  @default(now())
    tokenExpiresAt         DateTime?
    updatedAt              DateTime  @default(now()) @updatedAt

    @@map("users")
}

model Snippet {
    id             Int                 @id @default(autoincrement())
    name           String
    userId         String
    guildId        String
    aliases        String[]            @default([])
    roles          String[]            @default([])
    channels       String[]            @default([])
    users          String[]            @default([])
    attachments    String[]            @default([])
    content        String[]            @default([])
    randomize      Boolean             @default(false)
    permissions    String[]            @default([])
    permissionMode PermissionLogicMode @default(AND)
    level          Int?
    createdAt      DateTime            @default(now())
    updatedAt      DateTime            @default(now()) @updatedAt

    @@map("snippets")
}

model ReactionRole {
    id                  Int      @id @default(autoincrement())
    emoji               String
    isBuiltInEmoji      Boolean
    guildId             String
    channelId           String
    messageId           String
    roles               String[]
    requiredRoles       String[] @default([])
    blacklistedUsers    String[] @default([])
    requiredPermissions String[] @default([])
    level               Int?
    single              Boolean  @default(false)
    createdAt           DateTime @default(now())
    updatedAt           DateTime @default(now()) @updatedAt

    @@map("reaction_roles")
}

enum PermissionLogicMode {
    OR
    AND
}

model VerificationEntry {
    id        Int      @id @default(autoincrement())
    userId    String
    guildId   String
    code      String   @unique
    attempts  Int      @default(0)
    metadata  Json?
    expiresAt DateTime
    createdAt DateTime @default(now())
    updatedAt DateTime @default(now()) @updatedAt

    @@unique([userId, guildId])
    @@map("verification_entries")
}

model VerificationRecord {
    id        Int                @id @default(autoincrement())
    guildId   String
    userId    String
    discordId String?
    githubId  String?
    googleId  String?
    email     String?
    method    VerificationMethod
    createdAt DateTime           @default(now())
    updatedAt DateTime           @default(now()) @updatedAt

    @@map("verification_records")
}

enum VerificationMethod {
    DISCORD
    GITHUB
    GOOGLE
    EMAIL
}
1	generator client {
2	provider = "prisma-client-js"
3	}
4
5	datasource db {
6	provider = "postgresql"
7	url = env("DB_URL")
8	}
9
10	enum InfractionType {
11	BAN
12	KICK
13	MUTE
14	WARNING
15	MASSBAN
16	MASSKICK
17	UNBAN
18	UNMUTE
19	BULK_DELETE_MESSAGE
20	TIMEOUT
21	TIMEOUT_REMOVE
22	BEAN
23	NOTE
24	ROLE
25	MOD_MESSAGE
26	SHOT
27	}
28
29	enum InfractionDeliveryStatus {
30	SUCCESS
31	FALLBACK
32	FAILED
33	NOT_DELIVERED
34	}
35
36	model Infraction {
37	id Int @id @default(autoincrement())
38	type InfractionType
39	userId String
40	guildId String
41	reason String?
42	moderatorId String
43	expiresAt DateTime?
44	metadata Json?
45	deliveryStatus InfractionDeliveryStatus @default(SUCCESS)
46	createdAt DateTime @default(now())
47	updatedAt DateTime @default(now()) @updatedAt
48	queueId Int?
49
50	@@map("infractions")
51	}
52
53	model PermissionOverwrite {
54	id Int @id @default(autoincrement())
55	name String?
56	guildId String
57	roles String[] @default([])
58	users String[] @default([])
59	grantedDiscordPermissions String[] @default([])
60	grantedSystemPermissions String[] @default([])
61	priority Int @default(0)
62	merge Boolean @default(true)
63	disabled Boolean @default(false)
64	createdAt DateTime @default(now())
65	updatedAt DateTime @default(now()) @updatedAt
66
67	@@map("permission_overwrites")
68	}
69
70	model PermissionLevel {
71	id Int @id @default(autoincrement())
72	guildId String
73	level Int
74	disabled Boolean @default(false)
75	grantedDiscordPermissions String[] @default([])
76	grantedSystemPermissions String[] @default([])
77	roles String[] @default([])
78	users String[] @default([])
79	createdAt DateTime @default(now())
80	updatedAt DateTime @default(now()) @updatedAt
81
82	@@map("permission_levels")
83	}
84
85	enum CommandPermissionOverwriteAction {
86	ALLOW
87	DENY
88	}
89
90	model CommandPermissionOverwrite {
91	id Int @id @default(autoincrement())
92	guildId String
93	commands String[]
94	requiredDiscordPermissions Json @default("null")
95	requiredSystemPermissions Json @default("null")
96	requiredRoles Json @default("null")
97	requiredUsers Json @default("null")
98	requiredChannels Json @default("null")
99	requiredLevel Int?
100	disabled Boolean @default(false)
101	onMatch CommandPermissionOverwriteAction @default(ALLOW)
102	createdAt DateTime @default(now())
103	updatedAt DateTime @default(now()) @updatedAt
104
105	@@map("command_permission_overwrites")
106	}
107
108	model Queue {
109	id Int @id @default(autoincrement())
110	userId String
111	guildId String
112	channelId String?
113	messageId String?
114	name String
115	repeat Boolean @default(false)
116	data Json @default("{}")
117	createdAt DateTime @default(now())
118	updatedAt DateTime @default(now()) @updatedAt
119	runsAt DateTime?
120
121	@@map("queues")
122	}
123
124	model MuteRecord {
125	id Int @id @default(autoincrement())
126	memberId String
127	guildId String
128	roles String[]
129	createdAt DateTime @default(now())
130	updatedAt DateTime @default(now()) @updatedAt
131
132	@@map("mute_records")
133	}
134
135	model ChannelLock {
136	id Int @id @default(autoincrement())
137	guildId String
138	channelId String
139	permissions Json
140	createdAt DateTime @default(now())
141	updatedAt DateTime @default(now()) @updatedAt
142
143	@@map("channel_locks")
144	}
145
146	model AfkEntry {
147	id Int @id @default(autoincrement())
148	reason String?
149	userId String
150	guildId String
151	mentions String[] @default([])
152	mentionCount Int @default(0)
153	global Boolean @default(false)
154	createdAt DateTime @default(now())
155	updatedAt DateTime @default(now()) @updatedAt
156
157	@@map("afk_entries")
158	}
159
160	model User {
161	id Int @id @default(autoincrement())
162	name String?
163	username String
164	discordId String
165	githubId String?
166	guilds String[] @default([])
167	password String
168	token String?
169	recoveryToken String?
170	recoveryCode String?
171	recoveryAttempts Int @default(0)
172	recoveryTokenExpiresAt DateTime?
173	createdAt DateTime @default(now())
174	tokenExpiresAt DateTime?
175	updatedAt DateTime @default(now()) @updatedAt
176
177	@@map("users")
178	}
179
180	model Snippet {
181	id Int @id @default(autoincrement())
182	name String
183	userId String
184	guildId String
185	aliases String[] @default([])
186	roles String[] @default([])
187	channels String[] @default([])
188	users String[] @default([])
189	attachments String[] @default([])
190	content String[] @default([])
191	randomize Boolean @default(false)
192	permissions String[] @default([])
193	permissionMode PermissionLogicMode @default(AND)
194	level Int?
195	createdAt DateTime @default(now())
196	updatedAt DateTime @default(now()) @updatedAt
197
198	@@map("snippets")
199	}
200
201	model ReactionRole {
202	id Int @id @default(autoincrement())
203	emoji String
204	isBuiltInEmoji Boolean
205	guildId String
206	channelId String
207	messageId String
208	roles String[]
209	requiredRoles String[] @default([])
210	blacklistedUsers String[] @default([])
211	requiredPermissions String[] @default([])
212	level Int?
213	single Boolean @default(false)
214	createdAt DateTime @default(now())
215	updatedAt DateTime @default(now()) @updatedAt
216
217	@@map("reaction_roles")
218	}
219
220	enum PermissionLogicMode {
221	OR
222	AND
223	}
224
225	model VerificationEntry {
226	id Int @id @default(autoincrement())
227	userId String
228	guildId String
229	code String @unique
230	attempts Int @default(0)
231	metadata Json?
232	expiresAt DateTime
233	createdAt DateTime @default(now())
234	updatedAt DateTime @default(now()) @updatedAt
235
236	@@unique([userId, guildId])
237	@@map("verification_entries")
238	}
239
240	model VerificationRecord {
241	id Int @id @default(autoincrement())
242	guildId String
243	userId String
244	discordId String?
245	githubId String?
246	googleId String?
247	email String?
248	method VerificationMethod
249	createdAt DateTime @default(now())
250	updatedAt DateTime @default(now()) @updatedAt
251
252	@@map("verification_records")
253	}
254
255	enum VerificationMethod {
256	DISCORD
257	GITHUB
258	GOOGLE
259	EMAIL
260	}