Fix constraint names

37 files changed, 391 insertions, 111 deletions

diff --git a/src/database/entities/Application.ts b/src/database/entities/Application.ts

index dc2b6111..558d6469 100644
--- a/src/database/entities/Application.ts
+++ b/src/database/entities/Application.ts
@@ -54,7 +54,7 @@ export class Application extends BaseClass {
     @Column()
     verify_key: string;
 
-    @JoinColumn({ name: "owner_id" })
+    @JoinColumn({ name: "owner_id", foreignKeyConstraintName: "FK_application_owner_id" })
     @ManyToOne(() => User, { onDelete: "CASCADE" })
     owner: User;
 
@@ -66,7 +66,7 @@ export class Application extends BaseClass {
     @Column()
     flags: number = 0;
 
-    @Column({ type: "varchar", nullable: true })
+    @Column({ type: "varchar", nullable: true, array: true })
     redirect_uris: string[] = [];
 
     @Column({ nullable: true })
@@ -93,7 +93,7 @@ export class Application extends BaseClass {
     @Column({ nullable: true })
     discovery_eligibility_flags: number = 2240;
 
-    @JoinColumn({ name: "bot_user_id" })
+    @JoinColumn({ name: "bot_user_id", foreignKeyConstraintName: "FK_application_bot_user_id" })
     @OneToOne(() => User, { onDelete: "CASCADE" })
     bot?: User;
 
@@ -116,7 +116,7 @@ export class Application extends BaseClass {
     @RelationId((application: Application) => application.guild)
     guild_id?: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_application_guild_id" })
     @ManyToOne(() => Guild)
     guild?: Guild; // guild to which the app is linked, e.g. a developer support server
 
@@ -134,7 +134,7 @@ export class Application extends BaseClass {
     //@Column({ nullable: true })
     //slug?: string; // if this application is a game sold, this field will be the URL slug that links to the store page
 
-    @JoinColumn({ name: "team_id" })
+    @JoinColumn({ name: "team_id", foreignKeyConstraintName: "FK_application_team_id" })
     @ManyToOne(() => Team, {
         onDelete: "CASCADE",
         nullable: true,
diff --git a/src/database/entities/Attachment.ts b/src/database/entities/Attachment.ts

index 08fb369a..3648696f 100644
--- a/src/database/entities/Attachment.ts
+++ b/src/database/entities/Attachment.ts
@@ -41,21 +41,21 @@ export class Attachment extends BaseClass {
     @Column({ nullable: true })
     content_type?: string;
 
-    @Column({ nullable: true })
+    @Column({ nullable: true, foreignKeyConstraintName: "FK_attachment_message_id" })
     @RelationId((attachment: Attachment) => attachment.message)
     message_id: string;
 
-    @Column({ nullable: true })
+    @Column({ nullable: true, foreignKeyConstraintName: "FK_attachment_channel_id" })
     @RelationId((attachment: Attachment) => attachment.channel)
     channel_id: string;
 
-    @JoinColumn({ name: "message_id" })
+    @JoinColumn({ name: "message_id", foreignKeyConstraintName: "FK_attachment_message_id" })
     @ManyToOne(() => require("./Message").Message, (message: import("./Message").Message) => message.attachments, {
         onDelete: "CASCADE",
     })
     message: import("./Message").Message;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_attachment_channel_id" })
     @ManyToOne(() => require("./Channel").Channel, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/AuditLog.ts b/src/database/entities/AuditLog.ts

index f47f6dc7..2cf40466 100644
--- a/src/database/entities/AuditLog.ts
+++ b/src/database/entities/AuditLog.ts
@@ -25,7 +25,7 @@ import { AuditLogChange, AuditLogEvents } from "@spacebar/schemas";
     name: "audit_logs",
 })
 export class AuditLog extends BaseClass {
-    @JoinColumn({ name: "target_id" })
+    @JoinColumn({ name: "target_id", foreignKeyConstraintName: "FK_audit_log_target_user_id" })
     @ManyToOne(() => User)
     target?: User;
 
@@ -33,7 +33,7 @@ export class AuditLog extends BaseClass {
     @RelationId((auditlog: AuditLog) => auditlog.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_audit_log_source_user_id" })
     @ManyToOne(() => User, (user: User) => user.id)
     user: User;
 
diff --git a/src/database/entities/AutomodRule.ts b/src/database/entities/AutomodRule.ts

index 97312984..5f74ee9b 100644
--- a/src/database/entities/AutomodRule.ts
+++ b/src/database/entities/AutomodRule.ts
@@ -25,7 +25,7 @@ import { AutomodAction, AutomodRuleEventType, AutomodRuleTriggerMetadata, Automo
     name: "automod_rules",
 })
 export class AutomodRule extends BaseClass {
-    @JoinColumn({ name: "creator_id" })
+    @JoinColumn({ name: "creator_id", foreignKeyConstraintName: "FK_automod_rule_creator_id" })
     @ManyToOne(() => User, { onDelete: "CASCADE" })
     creator: User;
 
@@ -41,7 +41,7 @@ export class AutomodRule extends BaseClass {
     @Column({ type: "int8", array: true })
     exempt_roles: string[];
 
-    @Column()
+    @Column({ type: "int8" })
     guild_id: string;
 
     @Column()
diff --git a/src/database/entities/BackupCodes.ts b/src/database/entities/BackupCodes.ts

index 47dfc454..1db7a112 100644
--- a/src/database/entities/BackupCodes.ts
+++ b/src/database/entities/BackupCodes.ts
@@ -26,7 +26,7 @@ import { Config } from "@spacebar/util/util";
     name: "backup_codes",
 })
 export class BackupCode extends BaseClass {
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_backup_code_user_id" })
     @ManyToOne(() => User, { onDelete: "CASCADE" })
     user: User;
 
diff --git a/src/database/entities/Ban.ts b/src/database/entities/Ban.ts

index 17121ace..e52acd63 100644
--- a/src/database/entities/Ban.ts
+++ b/src/database/entities/Ban.ts
@@ -29,7 +29,7 @@ export class Ban extends BaseClass {
     @RelationId((ban: Ban) => ban.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_ban_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
@@ -39,7 +39,7 @@ export class Ban extends BaseClass {
     @RelationId((ban: Ban) => ban.guild)
     guild_id: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_ban_guild_id" })
     @ManyToOne(() => Guild, {
         onDelete: "CASCADE",
     })
@@ -49,7 +49,7 @@ export class Ban extends BaseClass {
     @RelationId((ban: Ban) => ban.executor)
     executor_id: string;
 
-    @JoinColumn({ name: "executor_id" })
+    @JoinColumn({ name: "executor_id", foreignKeyConstraintName: "FK_ban_executor_id" })
     @ManyToOne(() => User)
     executor: User;
 
diff --git a/src/database/entities/Channel.ts b/src/database/entities/Channel.ts

index 85ffcd8a..0812dcf0 100644
--- a/src/database/entities/Channel.ts
+++ b/src/database/entities/Channel.ts
@@ -65,14 +65,14 @@ export class Channel extends BaseClass {
     })
     thread_members?: ThreadMember[];
 
-    @Column({ nullable: true })
+    @Column({ type: "int8", nullable: true })
     last_message_id?: string;
 
     @Column({ nullable: true })
     @RelationId((channel: Channel) => channel.guild)
     guild_id?: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_channel_guild_id" })
     @ManyToOne(() => Guild, (guild) => guild.channels, {
         onDelete: "CASCADE",
         nullable: true,
@@ -83,7 +83,7 @@ export class Channel extends BaseClass {
     @RelationId((channel: Channel) => channel.parent)
     parent_id: string | null;
 
-    @JoinColumn({ name: "parent_id" })
+    @JoinColumn({ name: "parent_id", foreignKeyConstraintName: "FK_channel_parent_id" })
     @ManyToOne(() => Channel)
     parent?: Channel;
 
@@ -92,7 +92,7 @@ export class Channel extends BaseClass {
     @RelationId((channel: Channel) => channel.owner)
     owner_id?: string;
 
-    @JoinColumn({ name: "owner_id" })
+    @JoinColumn({ name: "owner_id", foreignKeyConstraintName: "FK_channel_owner_id" })
     @ManyToOne(() => User)
     owner: User;
 
@@ -174,7 +174,7 @@ export class Channel extends BaseClass {
     @Column({ nullable: true })
     total_message_sent?: number;
 
-    @JoinColumn({ name: "available_tags_ids" })
+    @JoinColumn({ name: "available_tags_ids", foreignKeyConstraintName: "FK_channel_available_tag_ids" })
     @OneToMany(() => Tag, (tag: Tag) => tag.channel, {
         cascade: true,
         orphanedRowAction: "delete",
diff --git a/src/database/entities/CloudAttachment.ts b/src/database/entities/CloudAttachment.ts

index 408df024..7a9cefc4 100644
--- a/src/database/entities/CloudAttachment.ts
+++ b/src/database/entities/CloudAttachment.ts
@@ -30,7 +30,7 @@ export class CloudAttachment extends BaseClass {
     @RelationId((att: CloudAttachment) => att.user)
     userId: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_cloud_attachment_user_id" })
     @ManyToOne(() => User, { nullable: true, onDelete: "SET NULL" })
     user?: User;
 
@@ -38,7 +38,7 @@ export class CloudAttachment extends BaseClass {
     @RelationId((att: CloudAttachment) => att.channel)
     channelId?: string; // channel the file is uploaded to
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_cloud_attachment_channel_id" })
     @ManyToOne(() => Channel, { nullable: true, onDelete: "SET NULL" })
     channel?: Channel; // channel the file is uploaded to
 
diff --git a/src/database/entities/ConnectedAccount.ts b/src/database/entities/ConnectedAccount.ts

index d0ed8097..68782981 100644
--- a/src/database/entities/ConnectedAccount.ts
+++ b/src/database/entities/ConnectedAccount.ts
@@ -32,7 +32,7 @@ export class ConnectedAccount extends BaseClass {
     @RelationId((account: ConnectedAccount) => account.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_connected_account_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/EmbedCache.ts b/src/database/entities/EmbedCache.ts

index b34be18c..1effcb4c 100644
--- a/src/database/entities/EmbedCache.ts
+++ b/src/database/entities/EmbedCache.ts
@@ -17,7 +17,7 @@
 */
 
 import { BaseClass } from "./BaseClass";
-import { Entity, Column } from "typeorm";
+import { Entity, Column, CreateDateColumn } from "typeorm";
 import { Embed } from "@spacebar/schemas";
 
 @Entity({
@@ -33,6 +33,6 @@ export class EmbedCache extends BaseClass {
     @Column({ type: "jsonb", nullable: true })
     embeds?: Embed[];
 
-    @Column({ name: "created_at", type: "timestamp with time zone" })
+    @CreateDateColumn({ name: "created_at", type: "timestamp with time zone" })
     createdAt: Date;
 }
diff --git a/src/database/entities/Emoji.ts b/src/database/entities/Emoji.ts

index 51d00c18..973f40d0 100644
--- a/src/database/entities/Emoji.ts
+++ b/src/database/entities/Emoji.ts
@@ -55,7 +55,7 @@ export class Emoji extends BaseClass {
     @RelationId((emoji: Emoji) => emoji.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_emoji_user_id" })
     @ManyToOne(() => User)
     user: User;
 
diff --git a/src/database/entities/Encryption.ts b/src/database/entities/Encryption.ts

index 9c76701a..9a4ca083 100644
--- a/src/database/entities/Encryption.ts
+++ b/src/database/entities/Encryption.ts
@@ -23,10 +23,10 @@ import { BaseClass } from "./BaseClass";
     name: "security_settings",
 })
 export class SecuritySettings extends BaseClass {
-    @Column({ nullable: true })
+    @Column({ type: "int8", nullable: true })
     guild_id: string;
 
-    @Column({ nullable: true })
+    @Column({ type: "int8", nullable: true })
     channel_id: string;
 
     @Column()
diff --git a/src/database/entities/Guild.ts b/src/database/entities/Guild.ts

index ab56b76a..d466d9de 100644
--- a/src/database/entities/Guild.ts
+++ b/src/database/entities/Guild.ts
@@ -67,7 +67,7 @@ export class Guild extends BaseClass {
     @RelationId((guild: Guild) => guild.afk_channel)
     afk_channel_id?: string | null;
 
-    @JoinColumn({ name: "afk_channel_id" })
+    @JoinColumn({ name: "afk_channel_id", foreignKeyConstraintName: "FK_guild_afk_channel_id" })
     @ManyToOne(() => Channel)
     afk_channel?: Channel;
 
@@ -79,7 +79,7 @@ export class Guild extends BaseClass {
     // @Column({ nullable: true })
     // application?: string;
 
-    @JoinColumn({ name: "ban_ids" })
+    @JoinColumn({ name: "ban_ids", foreignKeyConstraintName: "FK_guild_ban_ids" })
     @OneToMany(() => Ban, (ban: Ban) => ban.guild, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -105,7 +105,7 @@ export class Guild extends BaseClass {
     features: string[] = []; //TODO use enum
     //TODO: https://discord.com/developers/docs/resources/guild#guild-object-guild-features
 
-    @Column({ nullable: true })
+    @Column({ type: "int8", nullable: true })
     primary_category_id?: string; // TODO: this was number?
 
     @Column({ nullable: true })
@@ -136,7 +136,7 @@ export class Guild extends BaseClass {
     })
     members: Member[];
 
-    @JoinColumn({ name: "role_ids" })
+    @JoinColumn({ name: "role_ids", foreignKeyConstraintName: "FK_guild_role_ids" })
     @OneToMany(() => Role, (role: Role) => role.guild, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -144,7 +144,7 @@ export class Guild extends BaseClass {
     })
     roles: Role[];
 
-    @JoinColumn({ name: "channel_ids" })
+    @JoinColumn({ name: "channel_ids", foreignKeyConstraintName: "FK_guild_channel_ids" })
     @OneToMany(() => Channel, (channel: Channel) => channel.guild, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -155,11 +155,11 @@ export class Guild extends BaseClass {
     @RelationId((guild: Guild) => guild.template)
     template_id?: string;
 
-    @JoinColumn({ name: "template_id", referencedColumnName: "id" })
+    @JoinColumn({ name: "template_id", referencedColumnName: "id", foreignKeyConstraintName: "FK_guild_template_id" })
     @ManyToOne(() => Template)
     template: Template;
 
-    @JoinColumn({ name: "emoji_ids" })
+    @JoinColumn({ name: "emoji_ids", foreignKeyConstraintName: "FK_guild_emoji_ids" })
     @OneToMany(() => Emoji, (emoji: Emoji) => emoji.guild, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -167,7 +167,7 @@ export class Guild extends BaseClass {
     })
     emojis: Emoji[];
 
-    @JoinColumn({ name: "sticker_ids" })
+    @JoinColumn({ name: "sticker_ids", foreignKeyConstraintName: "FK_guild_sticker_ids" })
     @OneToMany(() => Sticker, (sticker: Sticker) => sticker.guild, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -175,7 +175,7 @@ export class Guild extends BaseClass {
     })
     stickers: Sticker[];
 
-    @JoinColumn({ name: "invite_ids" })
+    @JoinColumn({ name: "invite_ids", foreignKeyConstraintName: "FK_guild_invite_ids" })
     @OneToMany(() => Invite, (invite: Invite) => invite.guild, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -183,7 +183,7 @@ export class Guild extends BaseClass {
     })
     invites: Invite[];
 
-    @JoinColumn({ name: "voice_state_ids" })
+    @JoinColumn({ name: "voice_state_ids", foreignKeyConstraintName: "FK_guild_voice_state_ids" })
     @OneToMany(() => VoiceState, (voicestate: VoiceState) => voicestate.guild, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -191,7 +191,7 @@ export class Guild extends BaseClass {
     })
     voice_states: VoiceState[];
 
-    @JoinColumn({ name: "webhook_ids" })
+    @JoinColumn({ name: "webhook_ids", foreignKeyConstraintName: "FK_guild_webhook_ids" })
     @OneToMany(() => Webhook, (webhook: Webhook) => webhook.guild, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -209,7 +209,7 @@ export class Guild extends BaseClass {
     @RelationId((guild: Guild) => guild.owner)
     owner_id?: string; // optional to allow for ownerless guilds
 
-    @JoinColumn({ name: "owner_id", referencedColumnName: "id" })
+    @JoinColumn({ name: "owner_id", referencedColumnName: "id", foreignKeyConstraintName: "FK_guild_owner_id" })
     @ManyToOne(() => User)
     owner?: User; // optional to allow for ownerless guilds
 
@@ -226,7 +226,7 @@ export class Guild extends BaseClass {
     @RelationId((guild: Guild) => guild.public_updates_channel)
     public_updates_channel_id: string | null;
 
-    @JoinColumn({ name: "public_updates_channel_id" })
+    @JoinColumn({ name: "public_updates_channel_id", foreignKeyConstraintName: "FK_guild_public_updates_channel_id" })
     @ManyToOne(() => Channel)
     public_updates_channel?: Channel;
 
@@ -234,7 +234,7 @@ export class Guild extends BaseClass {
     @RelationId((guild: Guild) => guild.rules_channel)
     rules_channel_id?: string | null;
 
-    @JoinColumn({ name: "rules_channel_id" })
+    @JoinColumn({ name: "rules_channel_id", foreignKeyConstraintName: "FK_guild_rules_channel_id" })
     @ManyToOne(() => Channel)
     rules_channel?: string;
 
@@ -248,7 +248,7 @@ export class Guild extends BaseClass {
     @RelationId((guild: Guild) => guild.system_channel)
     system_channel_id?: string | null;
 
-    @JoinColumn({ name: "system_channel_id" })
+    @JoinColumn({ name: "system_channel_id", foreignKeyConstraintName: "FK_guild_system_channel_id" })
     @ManyToOne(() => Channel)
     system_channel?: Channel;
 
@@ -271,7 +271,7 @@ export class Guild extends BaseClass {
     @RelationId((guild: Guild) => guild.widget_channel)
     widget_channel_id?: string;
 
-    @JoinColumn({ name: "widget_channel_id" })
+    @JoinColumn({ name: "widget_channel_id", foreignKeyConstraintName: "FK_guild_widget_channel_id" })
     @ManyToOne(() => Channel)
     widget_channel?: Channel;
 
@@ -298,10 +298,10 @@ export class Guild extends BaseClass {
     @Column({ select: false, type: "int8", array: true })
     channel_ordering: string[];
 
-    @Column()
+    @Column({ default: 0 })
     discovery_weight: number = 0;
 
-    @Column()
+    @Column({ default: false })
     discovery_excluded: boolean = false;
 
     async ToGuildSource() {
diff --git a/src/database/entities/Invite.ts b/src/database/entities/Invite.ts

index cc5374eb..15522449 100644
--- a/src/database/entities/Invite.ts
+++ b/src/database/entities/Invite.ts
@@ -54,7 +54,7 @@ export class Invite extends BaseClassWithoutId {
     @RelationId((invite: Invite) => invite.guild)
     guild_id: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_invite_guild_id" })
     @ManyToOne(() => Guild, (guild) => guild.invites, {
         onDelete: "CASCADE",
     })
@@ -64,7 +64,7 @@ export class Invite extends BaseClassWithoutId {
     @RelationId((invite: Invite) => invite.channel)
     channel_id: string;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_invite_channel_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
@@ -74,7 +74,7 @@ export class Invite extends BaseClassWithoutId {
     @RelationId((invite: Invite) => invite.inviter)
     inviter_id?: string;
 
-    @JoinColumn({ name: "inviter_id" })
+    @JoinColumn({ name: "inviter_id", foreignKeyConstraintName: "FK_invite_inviter_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
@@ -84,7 +84,7 @@ export class Invite extends BaseClassWithoutId {
     @RelationId((invite: Invite) => invite.target_user)
     target_user_id: string;
 
-    @JoinColumn({ name: "target_user_id" })
+    @JoinColumn({ name: "target_user_id", foreignKeyConstraintName: "FK_invite_target_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/Member.ts b/src/database/entities/Member.ts

index 75f38f88..717bd586 100644
--- a/src/database/entities/Member.ts
+++ b/src/database/entities/Member.ts
@@ -65,7 +65,7 @@ export class Member extends BaseClassWithoutId {
     @RelationId((member: Member) => member.user)
     id: string;
 
-    @JoinColumn({ name: "id" })
+    @JoinColumn({ name: "id", foreignKeyConstraintName: "FK_member_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
@@ -75,7 +75,7 @@ export class Member extends BaseClassWithoutId {
     @RelationId((member: Member) => member.guild)
     guild_id: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_member_guild_id" })
     @ManyToOne(() => Guild, {
         onDelete: "CASCADE",
     })
@@ -86,10 +86,15 @@ export class Member extends BaseClassWithoutId {
 
     @JoinTable({
         name: "member_roles",
-        joinColumn: { name: "index", referencedColumnName: "index" },
+        joinColumn: {
+            name: "index",
+            referencedColumnName: "index",
+            foreignKeyConstraintName: "FK_member_role_member_index",
+        },
         inverseJoinColumn: {
             name: "role_id",
             referencedColumnName: "id",
+            foreignKeyConstraintName: "FK_member_role_role_id",
         },
     })
     @ManyToMany(() => Role, { cascade: true })
@@ -113,7 +118,7 @@ export class Member extends BaseClassWithoutId {
     @Column({ type: "jsonb", select: false })
     settings: UserGuildSettings;
 
-    @Column({ nullable: true })
+    @Column({ type: "int8", nullable: true })
     last_message_id?: string;
 
     /**
diff --git a/src/database/entities/Message.ts b/src/database/entities/Message.ts

index 72d787b4..f84d22b4 100644
--- a/src/database/entities/Message.ts
+++ b/src/database/entities/Message.ts
@@ -56,7 +56,7 @@ export class Message extends BaseClass {
     @Index()
     channel_id?: string;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_message_channel_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
@@ -67,7 +67,7 @@ export class Message extends BaseClass {
     @JsonRemoveEmpty
     thread_id?: string;
 
-    @JoinColumn({ name: "thread_id" })
+    @JoinColumn({ name: "thread_id", foreignKeyConstraintName: "FK_message_thread_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
@@ -79,7 +79,7 @@ export class Message extends BaseClass {
     @JsonRemoveEmpty
     guild_id?: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_message_guild_id" })
     @ManyToOne(() => Guild, {
         onDelete: "CASCADE",
     })
@@ -90,7 +90,7 @@ export class Message extends BaseClass {
     @Index()
     author_id?: string;
 
-    @JoinColumn({ name: "author_id", referencedColumnName: "id" })
+    @JoinColumn({ name: "author_id", referencedColumnName: "id", foreignKeyConstraintName: "FK_message_author_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
@@ -100,7 +100,7 @@ export class Message extends BaseClass {
     @RelationId((message: Message) => message.member)
     member_id?: string;
 
-    @JoinColumn({ name: "member_id", referencedColumnName: "id" })
+    @JoinColumn({ name: "member_id", referencedColumnName: "id", foreignKeyConstraintName: "FK_message_member_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
@@ -111,7 +111,7 @@ export class Message extends BaseClass {
     @JsonRemoveEmpty
     webhook_id?: string;
 
-    @JoinColumn({ name: "webhook_id" })
+    @JoinColumn({ name: "webhook_id", foreignKeyConstraintName: "FK_message_webhook_id" })
     @ManyToOne(() => Webhook)
     webhook?: Webhook;
 
@@ -119,7 +119,7 @@ export class Message extends BaseClass {
     @RelationId((message: Message) => message.application)
     application_id?: string;
 
-    @JoinColumn({ name: "application_id" })
+    @JoinColumn({ name: "application_id", foreignKeyConstraintName: "FK_message_application_id" })
     @ManyToOne(() => Application)
     application?: Application;
 
@@ -251,7 +251,7 @@ export class Message extends BaseClass {
         type?: number; // 0 = DEFAULT, 1 = FORWARD
     };
 
-    @JoinColumn({ name: "message_reference_id" })
+    @JoinColumn({ name: "message_reference_id", foreignKeyConstraintName: "FK_message_message_reference_id" })
     @ManyToOne(() => Message, { onDelete: "SET NULL" })
     referenced_message?: Message | null;
 
diff --git a/src/database/entities/Note.ts b/src/database/entities/Note.ts

index e9f173ff..eea56924 100644
--- a/src/database/entities/Note.ts
+++ b/src/database/entities/Note.ts
@@ -25,11 +25,11 @@ import { User } from "./User";
 })
 @Unique(["owner", "target"])
 export class Note extends BaseClass {
-    @JoinColumn({ name: "owner_id" })
+    @JoinColumn({ name: "owner_id", foreignKeyConstraintName: "FK_note_owner_id" })
     @ManyToOne(() => User, { onDelete: "CASCADE" })
     owner: User;
 
-    @JoinColumn({ name: "target_id" })
+    @JoinColumn({ name: "target_id", foreignKeyConstraintName: "FK_note_target_id" })
     @ManyToOne(() => User, { onDelete: "CASCADE" })
     target: User;
 
diff --git a/src/database/entities/ReadState.ts b/src/database/entities/ReadState.ts

index 4d15c6cc..6a133693 100644
--- a/src/database/entities/ReadState.ts
+++ b/src/database/entities/ReadState.ts
@@ -31,30 +31,30 @@ import { ReadStateFlags, ReadStateType } from "@spacebar/schemas";
 })
 @Index(["channel_id", "user_id"], { unique: true })
 export class ReadState extends BaseClass {
-    @Column()
+    @Column({ type: "int8" })
     @RelationId((read_state: ReadState) => read_state.channel)
     channel_id: string;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_read_state_channel_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
     channel: Channel;
 
-    @Column()
+    @Column({ type: "int8" })
     @RelationId((read_state: ReadState) => read_state.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_read_state_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
     user: User;
 
-    @Column({ nullable: true })
+    @Column({ type: "int8", nullable: true })
     last_message_id?: string;
 
-    @Column({ nullable: true })
+    @Column({ type: "int8", nullable: true })
     last_acked_id?: string;
 
     @Column({ nullable: true })
diff --git a/src/database/entities/Recipient.ts b/src/database/entities/Recipient.ts

index 2dcff244..fce386d2 100644
--- a/src/database/entities/Recipient.ts
+++ b/src/database/entities/Recipient.ts
@@ -27,7 +27,7 @@ export class Recipient extends BaseClass {
     @RelationId((recipient: Recipient) => recipient.channel)
     channel_id: string;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_recipient_channel_id" })
     @ManyToOne(() => require("./Channel").Channel, {
         onDelete: "CASCADE",
     })
@@ -37,7 +37,7 @@ export class Recipient extends BaseClass {
     @RelationId((recipient: Recipient) => recipient.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_recipient_user_id" })
     @ManyToOne(() => require("./User").User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/Relationship.ts b/src/database/entities/Relationship.ts

index c2256ed3..1198b0e5 100644
--- a/src/database/entities/Relationship.ts
+++ b/src/database/entities/Relationship.ts
@@ -30,7 +30,7 @@ export class Relationship extends BaseClass {
     @RelationId((relationship: Relationship) => relationship.from)
     from_id: string;
 
-    @JoinColumn({ name: "from_id" })
+    @JoinColumn({ name: "from_id", foreignKeyConstraintName: "FK_relationship_from_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
@@ -40,7 +40,7 @@ export class Relationship extends BaseClass {
     @RelationId((relationship: Relationship) => relationship.to)
     to_id: string;
 
-    @JoinColumn({ name: "to_id" })
+    @JoinColumn({ name: "to_id", foreignKeyConstraintName: "FK_relationship_to_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/Role.ts b/src/database/entities/Role.ts

index e6b2e459..5e6a2eea 100644
--- a/src/database/entities/Role.ts
+++ b/src/database/entities/Role.ts
@@ -30,7 +30,7 @@ export class Role extends BaseClass {
     @RelationId((role: Role) => role.guild)
     guild_id: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_role_guild_id" })
     @ManyToOne(() => Guild, (guild) => guild.roles, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/SecurityKey.ts b/src/database/entities/SecurityKey.ts

index cbf80d3d..ad507d2e 100644
--- a/src/database/entities/SecurityKey.ts
+++ b/src/database/entities/SecurityKey.ts
@@ -28,7 +28,7 @@ export class SecurityKey extends BaseClass {
     @RelationId((key: SecurityKey) => key.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_security_key_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/Session.ts b/src/database/entities/Session.ts

index 57cd90d0..be84dc00 100644
--- a/src/database/entities/Session.ts
+++ b/src/database/entities/Session.ts
@@ -36,7 +36,7 @@ export class Session extends BaseClassWithoutId {
     @Index({})
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_session_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/Sticker.ts b/src/database/entities/Sticker.ts

index c88e0c29..98bf5bfe 100644
--- a/src/database/entities/Sticker.ts
+++ b/src/database/entities/Sticker.ts
@@ -42,7 +42,7 @@ export class Sticker extends BaseClass {
     @RelationId((sticker: Sticker) => sticker.pack)
     pack_id?: string;
 
-    @JoinColumn({ name: "pack_id" })
+    @JoinColumn({ name: "pack_id", foreignKeyConstraintName: "FK_sticker_pack_id" })
     @ManyToOne(() => require("./StickerPack").StickerPack, {
         onDelete: "CASCADE",
         nullable: true,
@@ -52,7 +52,7 @@ export class Sticker extends BaseClass {
     @Column({ nullable: true })
     guild_id?: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_sticker_guild_id" })
     @ManyToOne(() => Guild, (guild) => guild.stickers, {
         onDelete: "CASCADE",
     })
@@ -61,7 +61,7 @@ export class Sticker extends BaseClass {
     @Column({ nullable: true })
     user_id?: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_sticker_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/StickerPack.ts b/src/database/entities/StickerPack.ts

index 87112441..391cb5df 100644
--- a/src/database/entities/StickerPack.ts
+++ b/src/database/entities/StickerPack.ts
@@ -46,6 +46,6 @@ export class StickerPack extends BaseClass {
     cover_sticker_id?: string;
 
     @ManyToOne(() => Sticker, { nullable: true })
-    @JoinColumn()
+    @JoinColumn({ foreignKeyConstraintName: "FK_sticker_pack_cover_sticker_id" })
     cover_sticker?: Sticker;
 }
diff --git a/src/database/entities/Stream.ts b/src/database/entities/Stream.ts

index bf2f3a62..519a4fc6 100644
--- a/src/database/entities/Stream.ts
+++ b/src/database/entities/Stream.ts
@@ -11,7 +11,7 @@ export class Stream extends BaseClass {
     @RelationId((stream: Stream) => stream.owner)
     owner_id: string;
 
-    @JoinColumn({ name: "owner_id" })
+    @JoinColumn({ name: "owner_id", foreignKeyConstraintName: "FK_stream_owner_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
@@ -21,7 +21,7 @@ export class Stream extends BaseClass {
     @RelationId((stream: Stream) => stream.channel)
     channel_id: string;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_stream_channel_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/StreamSession.ts b/src/database/entities/StreamSession.ts

index 1dca2424..21e4b4ef 100644
--- a/src/database/entities/StreamSession.ts
+++ b/src/database/entities/StreamSession.ts
@@ -11,7 +11,7 @@ export class StreamSession extends BaseClass {
     @RelationId((session: StreamSession) => session.stream)
     stream_id: string;
 
-    @JoinColumn({ name: "stream_id" })
+    @JoinColumn({ name: "stream_id", foreignKeyConstraintName: "FK_stream_session_stream_id" })
     @ManyToOne(() => Stream, {
         onDelete: "CASCADE",
     })
@@ -21,7 +21,7 @@ export class StreamSession extends BaseClass {
     @RelationId((session: StreamSession) => session.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_stream_session_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/Tag.ts b/src/database/entities/Tag.ts

index 63ad4b86..611122a9 100644
--- a/src/database/entities/Tag.ts
+++ b/src/database/entities/Tag.ts
@@ -24,10 +24,10 @@ import { Channel } from "./Channel";
     name: "tags",
 })
 export class Tag extends BaseClass {
-    @Column()
+    @Column({ type: "int8" })
     channel_id: string;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_tag_channel_id" })
     @ManyToOne(() => Channel, (channel) => channel.available_tags, {
         onDelete: "CASCADE",
     })
@@ -39,7 +39,7 @@ export class Tag extends BaseClass {
     @Column()
     moderated: boolean = false;
 
-    @Column({ nullable: true })
+    @Column({ nullable: true, type: "int8" })
     emoji_id?: string;
 
     @Column({ nullable: true })
diff --git a/src/database/entities/Team.ts b/src/database/entities/Team.ts

index e440e965..63e20c85 100644
--- a/src/database/entities/Team.ts
+++ b/src/database/entities/Team.ts
@@ -28,7 +28,7 @@ export class Team extends BaseClass {
     @Column({ nullable: true })
     icon?: string;
 
-    @JoinColumn({ name: "member_ids" })
+    @JoinColumn({ name: "member_ids", foreignKeyConstraintName: "FK_team_member_ids" })
     @OneToMany(() => TeamMember, (member: TeamMember) => member.team, {
         orphanedRowAction: "delete",
     })
@@ -41,7 +41,7 @@ export class Team extends BaseClass {
     @RelationId((team: Team) => team.owner_user)
     owner_user_id: string;
 
-    @JoinColumn({ name: "owner_user_id" })
+    @JoinColumn({ name: "owner_user_id", foreignKeyConstraintName: "FK_team_owner_user_id" })
     @ManyToOne(() => User)
     owner_user: User;
 }
diff --git a/src/database/entities/TeamMember.ts b/src/database/entities/TeamMember.ts

index 72e23b76..903bccf2 100644
--- a/src/database/entities/TeamMember.ts
+++ b/src/database/entities/TeamMember.ts
@@ -38,7 +38,7 @@ export class TeamMember extends BaseClass {
     @RelationId((member: TeamMember) => member.team)
     team_id: string;
 
-    @JoinColumn({ name: "team_id" })
+    @JoinColumn({ name: "team_id", foreignKeyConstraintName: "FK_team_member_team_id" })
     @ManyToOne(() => require("./Team").Team, (team: import("./Team").Team) => team.members, {
         onDelete: "CASCADE",
     })
@@ -48,7 +48,7 @@ export class TeamMember extends BaseClass {
     @RelationId((member: TeamMember) => member.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_team_member_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/Template.ts b/src/database/entities/Template.ts

index 79804eed..301423f6 100644
--- a/src/database/entities/Template.ts
+++ b/src/database/entities/Template.ts
@@ -41,7 +41,7 @@ export class Template extends BaseClass {
     @RelationId((template: Template) => template.creator)
     creator_id: string;
 
-    @JoinColumn({ name: "creator_id" })
+    @JoinColumn({ name: "creator_id", foreignKeyConstraintName: "FK_template_creator_id" })
     @ManyToOne(() => User)
     creator: User;
 
@@ -55,7 +55,7 @@ export class Template extends BaseClass {
     @RelationId((template: Template) => template.source_guild)
     source_guild_id: string;
 
-    @JoinColumn({ name: "source_guild_id" })
+    @JoinColumn({ name: "source_guild_id", foreignKeyConstraintName: "FK_template_source_guild_id" })
     @ManyToOne(() => Guild, { onDelete: "CASCADE" })
     source_guild: Guild;
 
diff --git a/src/database/entities/ThreadMember.ts b/src/database/entities/ThreadMember.ts

index 52729dd9..de7e881c 100644
--- a/src/database/entities/ThreadMember.ts
+++ b/src/database/entities/ThreadMember.ts
@@ -49,7 +49,7 @@ export class ThreadMember extends BaseClassWithoutId {
     @RelationId((member: ThreadMember) => member.channel)
     id: string;
 
-    @JoinColumn({ name: "id" })
+    @JoinColumn({ name: "id", foreignKeyConstraintName: "FK_thread_member_channel_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
@@ -59,7 +59,7 @@ export class ThreadMember extends BaseClassWithoutId {
     @RelationId((member: ThreadMember) => member.member)
     member_idx: string;
 
-    @JoinColumn({ name: "member_idx" })
+    @JoinColumn({ name: "member_idx", foreignKeyConstraintName: "FK_thread_member_member_id" })
     @ManyToOne(() => Member, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/User.ts b/src/database/entities/User.ts

index 59128a35..d352cc79 100644
--- a/src/database/entities/User.ts
+++ b/src/database/entities/User.ts
@@ -147,14 +147,14 @@ export class User extends BaseClass {
     @OneToMany(() => Session, (session: Session) => session.user)
     sessions: Session[];
 
-    @JoinColumn({ name: "relationship_ids" })
+    @JoinColumn({ name: "relationship_ids", foreignKeyConstraintName: "FK_user_relationship_ids" })
     @OneToMany(() => Relationship, (relationship: Relationship) => relationship.from, {
         cascade: true,
         orphanedRowAction: "delete",
     })
     relationships: Relationship[];
 
-    @JoinColumn({ name: "connected_account_ids" })
+    @JoinColumn({ name: "connected_account_ids", foreignKeyConstraintName: "FK_user_connected_account_ids" })
     @OneToMany(() => ConnectedAccount, (account: ConnectedAccount) => account.user, {
         cascade: true,
         orphanedRowAction: "delete",
@@ -175,7 +175,7 @@ export class User extends BaseClass {
         orphanedRowAction: "delete",
         nullable: true,
     })
-    @JoinColumn()
+    @JoinColumn({ foreignKeyConstraintName: "FK_user_settings_index" })
     settings?: UserSettings;
 
     @OneToMany(() => SecurityKey, (key: SecurityKey) => key.user)
diff --git a/src/database/entities/UserSettingsProtos.ts b/src/database/entities/UserSettingsProtos.ts

index c8ee9d12..3d2f7c56 100644
--- a/src/database/entities/UserSettingsProtos.ts
+++ b/src/database/entities/UserSettingsProtos.ts
@@ -30,7 +30,7 @@ export class UserSettingsProtos extends BaseClassWithoutId {
         orphanedRowAction: "delete",
         eager: false,
     })
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_user_settings_proto_user_id" })
     user: User;
 
     @PrimaryColumn({ type: "text" })
diff --git a/src/database/entities/VoiceState.ts b/src/database/entities/VoiceState.ts

index 5abdb7da..1da29dd3 100644
--- a/src/database/entities/VoiceState.ts
+++ b/src/database/entities/VoiceState.ts
@@ -33,7 +33,7 @@ export class VoiceState extends BaseClass {
     @RelationId((voice_state: VoiceState) => voice_state.guild)
     guild_id: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_voice_state_guild_id" })
     @ManyToOne(() => Guild, (guild) => guild.voice_states, {
         onDelete: "CASCADE",
     })
@@ -43,7 +43,7 @@ export class VoiceState extends BaseClass {
     @RelationId((voice_state: VoiceState) => voice_state.channel)
     channel_id: string;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_voice_state_channel_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
@@ -53,7 +53,7 @@ export class VoiceState extends BaseClass {
     @RelationId((voice_state: VoiceState) => voice_state.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_voice_state_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/entities/Webhook.ts b/src/database/entities/Webhook.ts

index f631c393..26cf18aa 100644
--- a/src/database/entities/Webhook.ts
+++ b/src/database/entities/Webhook.ts
@@ -44,7 +44,7 @@ export class Webhook extends BaseClass {
     @RelationId((webhook: Webhook) => webhook.guild)
     guild_id?: string;
 
-    @JoinColumn({ name: "guild_id" })
+    @JoinColumn({ name: "guild_id", foreignKeyConstraintName: "FK_webhook_guild_id" })
     @ManyToOne(() => Guild, {
         onDelete: "CASCADE",
     })
@@ -54,7 +54,7 @@ export class Webhook extends BaseClass {
     @RelationId((webhook: Webhook) => webhook.channel)
     channel_id: string;
 
-    @JoinColumn({ name: "channel_id" })
+    @JoinColumn({ name: "channel_id", foreignKeyConstraintName: "FK_webhook_channel_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
@@ -64,7 +64,7 @@ export class Webhook extends BaseClass {
     @RelationId((webhook: Webhook) => webhook.application)
     application_id: string;
 
-    @JoinColumn({ name: "application_id" })
+    @JoinColumn({ name: "application_id", foreignKeyConstraintName: "FK_webhook_application_id" })
     @ManyToOne(() => Application, {
         onDelete: "CASCADE",
     })
@@ -74,7 +74,7 @@ export class Webhook extends BaseClass {
     @RelationId((webhook: Webhook) => webhook.user)
     user_id: string;
 
-    @JoinColumn({ name: "user_id" })
+    @JoinColumn({ name: "user_id", foreignKeyConstraintName: "FK_webhook_user_id" })
     @ManyToOne(() => User, {
         onDelete: "CASCADE",
     })
@@ -84,7 +84,7 @@ export class Webhook extends BaseClass {
     @RelationId((webhook: Webhook) => webhook.guild)
     source_guild_id?: string;
 
-    @JoinColumn({ name: "source_guild_id" })
+    @JoinColumn({ name: "source_guild_id", foreignKeyConstraintName: "FK_webhook_source_guild_id" })
     @ManyToOne(() => Guild, {
         onDelete: "CASCADE",
     })
@@ -94,7 +94,7 @@ export class Webhook extends BaseClass {
     @RelationId((webhook: Webhook) => webhook.channel)
     source_channel_id: string;
 
-    @JoinColumn({ name: "source_channel_id" })
+    @JoinColumn({ name: "source_channel_id", foreignKeyConstraintName: "FK_webhook_source_channel_id" })
     @ManyToOne(() => Channel, {
         onDelete: "CASCADE",
     })
diff --git a/src/database/migration/postgres/1782925307188-NameConstraints.ts b/src/database/migration/postgres/1782925307188-NameConstraints.ts
new file mode 100644

index 00000000..6ff6c851
--- /dev/null
+++ b/src/database/migration/postgres/1782925307188-NameConstraints.ts
@@ -0,0 +1,275 @@
+import { MigrationInterface, QueryRunner } from "typeorm";
+
+export class NameConstraints1782925307188 implements MigrationInterface {
+    name = "NameConstraints1782925307188";
+
+    public async up(queryRunner: QueryRunner): Promise<void> {
+        await queryRunner.query(`ALTER TABLE "instance_bans" RENAME CONSTRAINT "FK_0b02d18d0d830f160c921192a30" TO "FK_origin_instance_ban_id"`);
+
+        await queryRunner.query(`ALTER TABLE "applications" RENAME CONSTRAINT "FK_2ce5a55796fe4c2f77ece57a647" TO "FK_application_bot_user_id"`);
+        await queryRunner.query(`ALTER TABLE "applications" RENAME CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" TO "FK_application_team_id"`);
+        await queryRunner.query(`ALTER TABLE "applications" RENAME CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" TO "FK_application_owner_id"`);
+        await queryRunner.query(`ALTER TABLE "applications" RENAME CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba" TO "FK_application_guild_id"`);
+
+        await queryRunner.query(`ALTER TABLE "attachments" RENAME CONSTRAINT "FK_623e10eec51ada466c5038979e3" TO "FK_attachment_message_id"`);
+        await queryRunner.query(`ALTER TABLE "attachments" RENAME CONSTRAINT "attachments_channels_fk" TO "FK_attachment_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "audit_logs" RENAME CONSTRAINT "FK_3cd01cd3ae7aab010310d96ac8e" TO "FK_audit_log_target_user_id"`);
+        await queryRunner.query(`ALTER TABLE "audit_logs" RENAME CONSTRAINT "FK_bd2726fd31b35443f2245b93ba0" TO "FK_audit_log_source_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "automod_rules" RENAME CONSTRAINT "FK_12d3d60b961393d310429c062b7" TO "FK_automod_rule_creator_id"`);
+        await queryRunner.query(`ALTER TABLE "automod_rules" RENAME CONSTRAINT "automod_rules_guilds_fk" TO "FK_automod_rule_guild_id"`);
+
+        await queryRunner.query(`ALTER TABLE "bans" RENAME CONSTRAINT "FK_07ad88c86d1f290d46748410d58" TO "FK_ban_executor_id"`);
+        await queryRunner.query(`ALTER TABLE "bans" RENAME CONSTRAINT "FK_5999e8e449f80a236ff72023559" TO "FK_ban_user_id"`);
+        await queryRunner.query(`ALTER TABLE "bans" RENAME CONSTRAINT "FK_9d3ab7dd180ebdd245cdb66ecad" TO "FK_ban_guild_id"`);
+
+        await queryRunner.query(`ALTER TABLE "channels" RENAME CONSTRAINT "FK_3274522d14af40540b1a883fc80" TO "FK_channel_parent_id"`);
+        await queryRunner.query(`ALTER TABLE "channels" RENAME CONSTRAINT "FK_3873ed438575cce703ecff4fc7b" TO "FK_channel_owner_id"`);
+        await queryRunner.query(`ALTER TABLE "channels" RENAME CONSTRAINT "FK_c253dafe5f3a03ec00cd8fb4581" TO "FK_channel_guild_id"`);
+
+        await queryRunner.query(`ALTER TABLE "cloud_attachments" RENAME CONSTRAINT "FK_8bf8cc8767e48cb482ff644fce6" TO "FK_cloud_attachment_user_id"`);
+        await queryRunner.query(`ALTER TABLE "cloud_attachments" RENAME CONSTRAINT "FK_998d5fe91008ba5b09e1322104c" TO "FK_cloud_attachment_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "connected_accounts" RENAME CONSTRAINT "FK_f47244225a6a1eac04a3463dd90" TO "FK_connected_account_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "emojis" RENAME CONSTRAINT "FK_4b988e0db89d94cebcf07f598cc" TO "FK_emoji_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "emojis" RENAME CONSTRAINT "FK_fa7ddd5f9a214e28ce596548421" TO "FK_emoji_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_8d450b016dc8bec35f36729e4b0" TO "FK_guild_public_updates_channel_id"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_95828668aa333460582e0ca6396" TO "FK_guild_rules_channel_id"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_9d1d665379eefde7876a17afa99" TO "FK_guild_widget_channel_id"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_cfc3d3ad260f8121c95b31a1fce" TO "FK_guild_system_channel_id"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_e2a2f873a64a5cf62526de42325" TO "FK_guild_template_id"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_f591a66b8019d87b0fe6c12dad6" TO "FK_guild_afk_channel_id"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_fc1a451727e3643ca572a3bb394" TO "FK_guild_owner_id"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "guilds_categories_fk" TO "FK_guild_primary_category_id"`);
+
+        await queryRunner.query(`ALTER TABLE "invites" RENAME CONSTRAINT "FK_11a0d394f8fc649c19ce5f16b59" TO "FK_invite_target_user_id"`);
+        await queryRunner.query(`ALTER TABLE "invites" RENAME CONSTRAINT "FK_15c35422032e0b22b4ada95f48f" TO "FK_invite_inviter_id"`);
+        await queryRunner.query(`ALTER TABLE "invites" RENAME CONSTRAINT "FK_3f4939aa1461e8af57fea3fb05d" TO "FK_invite_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "invites" RENAME CONSTRAINT "FK_6a15b051fe5050aa00a4b9ff0f6" TO "FK_invite_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "member_roles" RENAME CONSTRAINT "FK_5d7ddc8a5f9c167f548625e772e" TO "FK_member_role_member_index"`);
+        await queryRunner.query(`ALTER TABLE "member_roles" RENAME CONSTRAINT "FK_e9080e7a7997a0170026d5139c1" TO "FK_member_role_role_id"`);
+
+        await queryRunner.query(`ALTER TABLE "members" RENAME CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" TO "FK_member_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "members" RENAME CONSTRAINT "FK_28b53062261b996d9c99fa12404" TO "FK_member_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "message_channel_mentions" RENAME CONSTRAINT "FK_2a27102ecd1d81b4582a4360921" TO "FK_message_channel_mention_message_id"`);
+        await queryRunner.query(`ALTER TABLE "message_channel_mentions" RENAME CONSTRAINT "FK_bdb8c09e1464cabf62105bf4b9d" TO "FK_message_channel_mention_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "message_role_mentions" RENAME CONSTRAINT "FK_a8242cf535337a490b0feaea0b4" TO "FK_message_role_mention_message_id"`);
+        await queryRunner.query(`ALTER TABLE "message_role_mentions" RENAME CONSTRAINT "FK_29d63eb1a458200851bc37d074b" TO "FK_message_role_mention_role_id"`);
+
+        await queryRunner.query(`ALTER TABLE "message_stickers" RENAME CONSTRAINT "FK_40bb6f23e7cc133292e92829d28" TO "FK_message_stickers_message_id"`);
+        await queryRunner.query(`ALTER TABLE "message_stickers" RENAME CONSTRAINT "FK_e22a70819d07659c7a71c112a1f" TO "FK_message_stickers_sticker_id"`);
+
+        await queryRunner.query(`ALTER TABLE "message_user_mentions" RENAME CONSTRAINT "FK_a343387fc560ef378760681c236" TO "FK_message_user_mentions_message_id"`);
+        await queryRunner.query(`ALTER TABLE "message_user_mentions" RENAME CONSTRAINT "FK_b831eb18ceebd28976239b1e2f8" TO "FK_message_user_mentions_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_05535bc695e9f7ee104616459d3" TO "FK_message_author_id"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_5d3ec1cb962de6488637fd779d6" TO "FK_message_application_id"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174" TO "FK_message_message_reference_id"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_86b9109b155eb70c0a2ca3b4b6d" TO "FK_message_channel_id"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_b0525304f2262b7014245351c76" TO "FK_message_member_id"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_b193588441b085352a4c0109423" TO "FK_message_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_bb3af7f695d50083e6523290d41" TO "FK_message_thread_id"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_f83c04bcf1df4e5c0e7a52ed348" TO "FK_message_webhook_id"`);
+
+        await queryRunner.query(`ALTER TABLE "notes" RENAME CONSTRAINT "FK_23e08e5b4481711d573e1abecdc" TO "FK_note_target_id"`);
+        await queryRunner.query(`ALTER TABLE "notes" RENAME CONSTRAINT "FK_f9e103f8ae67cb1787063597925" TO "FK_note_owner_id"`);
+
+        await queryRunner.query(`ALTER TABLE "read_states" RENAME CONSTRAINT "FK_195f92e4dd1254a4e348c043763" TO "FK_read_state_user_id"`);
+        await queryRunner.query(`ALTER TABLE "read_states" RENAME CONSTRAINT "FK_40da2fca4e0eaf7a23b5bfc5d34" TO "FK_read_state_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "recipients" RENAME CONSTRAINT "FK_2f18ee1ba667f233ae86c0ea60e" TO "FK_recipient_channel_id"`);
+        await queryRunner.query(`ALTER TABLE "recipients" RENAME CONSTRAINT "FK_6157e8b6ba4e6e3089616481fe2" TO "FK_recipient_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "relationships" RENAME CONSTRAINT "FK_9af4194bab1250b1c584ae4f1d7" TO "FK_relationship_from_id"`);
+        await queryRunner.query(`ALTER TABLE "relationships" RENAME CONSTRAINT "FK_9c7f6b98a9843b76dce1b0c878b" TO "FK_relationship_to_id"`);
+
+        await queryRunner.query(`ALTER TABLE "roles" RENAME CONSTRAINT "FK_c32c1ab1c4dc7dcb0278c4b1b8b" TO "FK_role_guild_id"`);
+
+        await queryRunner.query(`ALTER TABLE "security_keys" RENAME CONSTRAINT "FK_24c97d0771cafedce6d7163eaad" TO "FK_security_key_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "sessions" RENAME CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19" TO "FK_session_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "sticker_packs" RENAME CONSTRAINT "FK_448fafba4355ee1c837bbc865f1" TO "FK_sticker_pack_cover_sticker_id"`);
+
+        await queryRunner.query(`ALTER TABLE "stickers" RENAME CONSTRAINT "FK_193d551d852aca5347ef5c9f205" TO "FK_sticker_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "stickers" RENAME CONSTRAINT "FK_8f4ee73f2bb2325ff980502e158" TO "FK_sticker_user_id"`);
+        await queryRunner.query(`ALTER TABLE "stickers" RENAME CONSTRAINT "FK_e7cfa5cefa6661b3fb8fda8ce69" TO "FK_sticker_pack_id"`);
+
+        await queryRunner.query(`ALTER TABLE "stream_sessions" RENAME CONSTRAINT "FK_13ae5c29aff4d0890c54179511a" TO "FK_stream_session_user_id"`);
+        await queryRunner.query(`ALTER TABLE "stream_sessions" RENAME CONSTRAINT "FK_8b5a028a34dae9ee54af37c9c32" TO "FK_stream_session_stream_id"`);
+
+        await queryRunner.query(`ALTER TABLE "streams" RENAME CONSTRAINT "FK_1b566f9b54d1cda271da53ac82f" TO "FK_stream_owner_id"`);
+        await queryRunner.query(`ALTER TABLE "streams" RENAME CONSTRAINT "FK_5101f0cded27ff0aae78fc4eed7" TO "FK_stream_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "tags" RENAME CONSTRAINT "FK_2e2df07f6dacc12e1932b361fe4" TO "FK_tag_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "team_members" RENAME CONSTRAINT "FK_c2bf4967c8c2a6b845dadfbf3d4" TO "FK_team_member_user_id"`);
+        await queryRunner.query(`ALTER TABLE "team_members" RENAME CONSTRAINT "FK_fdad7d5768277e60c40e01cdcea" TO "FK_team_member_team_id"`);
+
+        await queryRunner.query(`ALTER TABLE "teams" RENAME CONSTRAINT "FK_13f00abf7cb6096c43ecaf8c108" TO "FK_team_owner_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "templates" RENAME CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11" TO "FK_template_source_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "templates" RENAME CONSTRAINT "FK_d7374b7f8f5fbfdececa4fb62e1" TO "FK_template_creator_id"`);
+
+        await queryRunner.query(`ALTER TABLE "thread_members" RENAME CONSTRAINT "FK_4721015b4e24ad29da55dbd2de0" TO "FK_thread_member_member_index"`);
+        await queryRunner.query(`ALTER TABLE "thread_members" RENAME CONSTRAINT "FK_cf20e37d71b0e1bf1ab633861c8" TO "FK_thread_member_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "user_settings_protos" RENAME CONSTRAINT "FK_8ff3d1961a48b693810c9f99853" TO "FK_user_settings_proto_user_id"`);
+
+        await queryRunner.query(`ALTER TABLE "users" RENAME CONSTRAINT "FK_0c14beb78d8c5ccba66072adbc7" TO "FK_user_settings_index"`);
+
+        await queryRunner.query(`ALTER TABLE "voice_states" RENAME CONSTRAINT "FK_03779ef216d4b0358470d9cb748" TO "FK_voice_state_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "voice_states" RENAME CONSTRAINT "FK_5fe1d5f931a67e85039c640001b" TO "FK_voice_state_user_id"`);
+        await queryRunner.query(`ALTER TABLE "voice_states" RENAME CONSTRAINT "FK_9f8d389866b40b6657edd026dd4" TO "FK_voice_state_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_0d523f6f997c86e052c49b1455f" TO "FK_webhook_user_id"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_3a285f4f49c40e0706d3018bc9f" TO "FK_webhook_source_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_4495b7032a33c6b8b605d030398" TO "FK_webhook_source_channel_id"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_487a7af59d189f744fe394368fc" TO "FK_webhook_guild_id"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_c3e5305461931763b56aa905f1c" TO "FK_webhook_application_id"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_df528cf77e82f8032230e7e37d8" TO "FK_webhook_channel_id"`);
+
+        await queryRunner.query(`ALTER TABLE "backup_codes" RENAME CONSTRAINT "FK_70066ea80d2f4b871beda32633b" TO "FK_backup_code_user_id"`);
+    }
+
+    public async down(queryRunner: QueryRunner): Promise<void> {
+        await queryRunner.query(`ALTER TABLE "instance_bans" RENAME CONSTRAINT "FK_origin_instance_ban_id" TO "FK_0b02d18d0d830f160c921192a30"`);
+
+        await queryRunner.query(`ALTER TABLE "applications" RENAME CONSTRAINT "FK_application_bot_user_id" TO "FK_2ce5a55796fe4c2f77ece57a647"`);
+        await queryRunner.query(`ALTER TABLE "applications" RENAME CONSTRAINT "FK_application_team_id" TO "FK_a36ed02953077f408d0f3ebc424"`);
+        await queryRunner.query(`ALTER TABLE "applications" RENAME CONSTRAINT "FK_application_owner_id" TO "FK_e57508958bf92b9d9d25231b5e8"`);
+        await queryRunner.query(`ALTER TABLE "applications" RENAME CONSTRAINT "FK_application_guild_id" TO "FK_e5bf78cdbbe9ba91062d74c5aba"`);
+
+        await queryRunner.query(`ALTER TABLE "attachments" RENAME CONSTRAINT "FK_attachment_message_id" TO "FK_623e10eec51ada466c5038979e3"`);
+        await queryRunner.query(`ALTER TABLE "attachments" RENAME CONSTRAINT "FK_attachment_channel_id" TO "attachments_channels_fk"`);
+
+        await queryRunner.query(`ALTER TABLE "audit_logs" RENAME CONSTRAINT "FK_audit_log_target_user_id" TO "FK_3cd01cd3ae7aab010310d96ac8e"`);
+        await queryRunner.query(`ALTER TABLE "audit_logs" RENAME CONSTRAINT "FK_audit_log_source_user_id" TO "FK_bd2726fd31b35443f2245b93ba0"`);
+
+        await queryRunner.query(`ALTER TABLE "automod_rules" RENAME CONSTRAINT "FK_automod_rule_creator_id" TO "FK_12d3d60b961393d310429c062b7"`);
+        await queryRunner.query(`ALTER TABLE "automod_rules" RENAME CONSTRAINT "FK_automod_rule_guild_id" TO "automod_rules_guilds_fk"`);
+
+        await queryRunner.query(`ALTER TABLE "bans" RENAME CONSTRAINT "FK_ban_executor_id" TO "FK_07ad88c86d1f290d46748410d58"`);
+        await queryRunner.query(`ALTER TABLE "bans" RENAME CONSTRAINT "FK_ban_user_id" TO "FK_5999e8e449f80a236ff72023559"`);
+        await queryRunner.query(`ALTER TABLE "bans" RENAME CONSTRAINT "FK_ban_guild_id" TO "FK_9d3ab7dd180ebdd245cdb66ecad"`);
+
+        await queryRunner.query(`ALTER TABLE "channels" RENAME CONSTRAINT "FK_channel_parent_id" TO "FK_3274522d14af40540b1a883fc80"`);
+        await queryRunner.query(`ALTER TABLE "channels" RENAME CONSTRAINT "FK_channel_owner_id" TO "FK_3873ed438575cce703ecff4fc7b"`);
+        await queryRunner.query(`ALTER TABLE "channels" RENAME CONSTRAINT "FK_channel_guild_id" TO "FK_c253dafe5f3a03ec00cd8fb4581"`);
+
+        await queryRunner.query(`ALTER TABLE "cloud_attachments" RENAME CONSTRAINT "FK_cloud_attachment_user_id" TO "FK_8bf8cc8767e48cb482ff644fce6"`);
+        await queryRunner.query(`ALTER TABLE "cloud_attachments" RENAME CONSTRAINT "FK_cloud_attachment_channel_id" TO "FK_998d5fe91008ba5b09e1322104c"`);
+
+        await queryRunner.query(`ALTER TABLE "connected_accounts" RENAME CONSTRAINT "FK_connected_account_user_id" TO "FK_f47244225a6a1eac04a3463dd90"`);
+
+        await queryRunner.query(`ALTER TABLE "emojis" RENAME CONSTRAINT "FK_emoji_guild_id" TO "FK_4b988e0db89d94cebcf07f598cc"`);
+        await queryRunner.query(`ALTER TABLE "emojis" RENAME CONSTRAINT "FK_emoji_user_id" TO "FK_fa7ddd5f9a214e28ce596548421"`);
+
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_guild_public_updates_channel_id" TO "FK_8d450b016dc8bec35f36729e4b0"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_guild_rules_channel_id" TO "FK_95828668aa333460582e0ca6396"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_guild_widget_channel_id" TO "FK_9d1d665379eefde7876a17afa99"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_guild_system_channel_id" TO "FK_cfc3d3ad260f8121c95b31a1fce"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_guild_template_id" TO "FK_e2a2f873a64a5cf62526de42325"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_guild_afk_channel_id" TO "FK_f591a66b8019d87b0fe6c12dad6"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_guild_owner_id" TO "FK_fc1a451727e3643ca572a3bb394"`);
+        await queryRunner.query(`ALTER TABLE "guilds" RENAME CONSTRAINT "FK_guild_primary_category_id" TO "guilds_categories_fk"`);
+
+        await queryRunner.query(`ALTER TABLE "invites" RENAME CONSTRAINT "FK_invite_target_user_id" TO "FK_11a0d394f8fc649c19ce5f16b59"`);
+        await queryRunner.query(`ALTER TABLE "invites" RENAME CONSTRAINT "FK_invite_inviter_id" TO "FK_15c35422032e0b22b4ada95f48f"`);
+        await queryRunner.query(`ALTER TABLE "invites" RENAME CONSTRAINT "FK_invite_guild_id" TO "FK_3f4939aa1461e8af57fea3fb05d"`);
+        await queryRunner.query(`ALTER TABLE "invites" RENAME CONSTRAINT "FK_invite_channel_id" TO "FK_6a15b051fe5050aa00a4b9ff0f6"`);
+
+        await queryRunner.query(`ALTER TABLE "member_roles" RENAME CONSTRAINT "FK_member_role_member_index" TO "FK_5d7ddc8a5f9c167f548625e772e"`);
+        await queryRunner.query(`ALTER TABLE "member_roles" RENAME CONSTRAINT "FK_member_role_role_id" TO "FK_e9080e7a7997a0170026d5139c1"`);
+
+        await queryRunner.query(`ALTER TABLE "members" RENAME CONSTRAINT "FK_member_guild_id" TO "FK_16aceddd5b89825b8ed6029ad1c"`);
+        await queryRunner.query(`ALTER TABLE "members" RENAME CONSTRAINT "FK_member_user_id" TO "FK_28b53062261b996d9c99fa12404"`);
+
+        await queryRunner.query(`ALTER TABLE "message_channel_mentions" RENAME CONSTRAINT "FK_message_channel_mention_message_id" TO "FK_2a27102ecd1d81b4582a4360921"`);
+        await queryRunner.query(`ALTER TABLE "message_channel_mentions" RENAME CONSTRAINT "FK_message_channel_mention_channel_id" TO "FK_bdb8c09e1464cabf62105bf4b9d"`);
+
+        await queryRunner.query(`ALTER TABLE "message_role_mentions" RENAME CONSTRAINT "FK_message_role_mention_message_id" TO "FK_a8242cf535337a490b0feaea0b4"`);
+        await queryRunner.query(`ALTER TABLE "message_role_mentions" RENAME CONSTRAINT "FK_message_role_mention_role_id" TO "FK_29d63eb1a458200851bc37d074b"`);
+
+        await queryRunner.query(`ALTER TABLE "message_stickers" RENAME CONSTRAINT "FK_message_stickers_message_id" TO "FK_40bb6f23e7cc133292e92829d28"`);
+        await queryRunner.query(`ALTER TABLE "message_stickers" RENAME CONSTRAINT "FK_message_stickers_sticker_id" TO "FK_e22a70819d07659c7a71c112a1f"`);
+
+        await queryRunner.query(`ALTER TABLE "message_user_mentions" RENAME CONSTRAINT "FK_message_user_mentions_message_id" TO "FK_a343387fc560ef378760681c236"`);
+        await queryRunner.query(`ALTER TABLE "message_user_mentions" RENAME CONSTRAINT "FK_message_user_mentions_user_id" TO "FK_b831eb18ceebd28976239b1e2f8"`);
+
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_message_author_id" TO "FK_05535bc695e9f7ee104616459d3"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_message_application_id" TO "FK_5d3ec1cb962de6488637fd779d6"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_message_message_reference_id" TO "FK_61a92bb65b302a76d9c1fcd3174"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_message_channel_id" TO "FK_86b9109b155eb70c0a2ca3b4b6d"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_message_member_id" TO "FK_b0525304f2262b7014245351c76"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_message_guild_id" TO "FK_b193588441b085352a4c0109423"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_message_thread_id" TO "FK_bb3af7f695d50083e6523290d41"`);
+        await queryRunner.query(`ALTER TABLE "messages" RENAME CONSTRAINT "FK_message_webhook_id" TO "FK_f83c04bcf1df4e5c0e7a52ed348"`);
+
+        await queryRunner.query(`ALTER TABLE "notes" RENAME CONSTRAINT "FK_note_target_id" TO "FK_23e08e5b4481711d573e1abecdc"`);
+        await queryRunner.query(`ALTER TABLE "notes" RENAME CONSTRAINT "FK_note_owner_id" TO "FK_f9e103f8ae67cb1787063597925"`);
+
+        await queryRunner.query(`ALTER TABLE "read_states" RENAME CONSTRAINT "FK_read_state_user_id" TO "FK_195f92e4dd1254a4e348c043763"`);
+        await queryRunner.query(`ALTER TABLE "read_states" RENAME CONSTRAINT "FK_read_state_channel_id" TO "FK_40da2fca4e0eaf7a23b5bfc5d34"`);
+
+        await queryRunner.query(`ALTER TABLE "recipients" RENAME CONSTRAINT "FK_recipient_channel_id" TO "FK_2f18ee1ba667f233ae86c0ea60e"`);
+        await queryRunner.query(`ALTER TABLE "recipients" RENAME CONSTRAINT "FK_recipient_user_id" TO "FK_6157e8b6ba4e6e3089616481fe2"`);
+
+        await queryRunner.query(`ALTER TABLE "relationships" RENAME CONSTRAINT "FK_relationship_from_id" TO "FK_9af4194bab1250b1c584ae4f1d7"`);
+        await queryRunner.query(`ALTER TABLE "relationships" RENAME CONSTRAINT "FK_relationship_to_id" TO "FK_9c7f6b98a9843b76dce1b0c878b"`);
+
+        await queryRunner.query(`ALTER TABLE "roles" RENAME CONSTRAINT "FK_role_guild_id" TO "FK_c32c1ab1c4dc7dcb0278c4b1b8b"`);
+
+        await queryRunner.query(`ALTER TABLE "security_keys" RENAME CONSTRAINT "FK_security_key_user_id" TO "FK_24c97d0771cafedce6d7163eaad"`);
+
+        await queryRunner.query(`ALTER TABLE "sessions" RENAME CONSTRAINT "FK_session_user_id" TO "FK_085d540d9f418cfbdc7bd55bb19"`);
+
+        await queryRunner.query(`ALTER TABLE "sticker_packs" RENAME CONSTRAINT "FK_sticker_pack_cover_sticker_id" TO "FK_448fafba4355ee1c837bbc865f1"`);
+
+        await queryRunner.query(`ALTER TABLE "stickers" RENAME CONSTRAINT "FK_sticker_guild_id" TO "FK_193d551d852aca5347ef5c9f205"`);
+        await queryRunner.query(`ALTER TABLE "stickers" RENAME CONSTRAINT "FK_sticker_user_id" TO "FK_8f4ee73f2bb2325ff980502e158"`);
+        await queryRunner.query(`ALTER TABLE "stickers" RENAME CONSTRAINT "FK_sticker_pack_id" TO "FK_e7cfa5cefa6661b3fb8fda8ce69"`);
+
+        await queryRunner.query(`ALTER TABLE "stream_sessions" RENAME CONSTRAINT "FK_stream_session_user_id" TO "FK_13ae5c29aff4d0890c54179511a"`);
+        await queryRunner.query(`ALTER TABLE "stream_sessions" RENAME CONSTRAINT "FK_stream_session_stream_id" TO "FK_8b5a028a34dae9ee54af37c9c32"`);
+
+        await queryRunner.query(`ALTER TABLE "streams" RENAME CONSTRAINT "FK_stream_owner_id" TO "FK_1b566f9b54d1cda271da53ac82f"`);
+        await queryRunner.query(`ALTER TABLE "streams" RENAME CONSTRAINT "FK_stream_channel_id" TO "FK_5101f0cded27ff0aae78fc4eed7"`);
+
+        await queryRunner.query(`ALTER TABLE "tags" RENAME CONSTRAINT "FK_tag_channel_id" TO "FK_2e2df07f6dacc12e1932b361fe4"`);
+
+        await queryRunner.query(`ALTER TABLE "team_members" RENAME CONSTRAINT "FK_team_member_user_id" TO "FK_c2bf4967c8c2a6b845dadfbf3d4"`);
+        await queryRunner.query(`ALTER TABLE "team_members" RENAME CONSTRAINT "FK_team_member_team_id" TO "FK_fdad7d5768277e60c40e01cdcea"`);
+
+        await queryRunner.query(`ALTER TABLE "teams" RENAME CONSTRAINT "FK_team_owner_user_id" TO "FK_13f00abf7cb6096c43ecaf8c108"`);
+
+        await queryRunner.query(`ALTER TABLE "templates" RENAME CONSTRAINT "FK_template_source_guild_id" TO "FK_445d00eaaea0e60a017a5ed0c11"`);
+        await queryRunner.query(`ALTER TABLE "templates" RENAME CONSTRAINT "FK_template_creator_id" TO "FK_d7374b7f8f5fbfdececa4fb62e1"`);
+
+        await queryRunner.query(`ALTER TABLE "thread_members" RENAME CONSTRAINT "FK_thread_member_member_index" TO "FK_4721015b4e24ad29da55dbd2de0"`);
+        await queryRunner.query(`ALTER TABLE "thread_members" RENAME CONSTRAINT "FK_thread_member_channel_id" TO "FK_cf20e37d71b0e1bf1ab633861c8"`);
+
+        await queryRunner.query(`ALTER TABLE "user_settings_protos" RENAME CONSTRAINT "FK_user_settings_proto_user_id" TO "FK_8ff3d1961a48b693810c9f99853"`);
+
+        await queryRunner.query(`ALTER TABLE "users" RENAME CONSTRAINT "FK_user_settings_index" TO "FK_0c14beb78d8c5ccba66072adbc7"`);
+
+        await queryRunner.query(`ALTER TABLE "voice_states" RENAME CONSTRAINT "FK_voice_state_guild_id" TO "FK_03779ef216d4b0358470d9cb748"`);
+        await queryRunner.query(`ALTER TABLE "voice_states" RENAME CONSTRAINT "FK_voice_state_user_id" TO "FK_5fe1d5f931a67e85039c640001b"`);
+        await queryRunner.query(`ALTER TABLE "voice_states" RENAME CONSTRAINT "FK_voice_state_channel_id" TO "FK_9f8d389866b40b6657edd026dd4"`);
+
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_webhook_user_id" TO "FK_0d523f6f997c86e052c49b1455f"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_webhook_source_guild_id" TO "FK_3a285f4f49c40e0706d3018bc9f"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_webhook_source_channel_id" TO "FK_4495b7032a33c6b8b605d030398"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_webhook_guild_id" TO "FK_487a7af59d189f744fe394368fc"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_webhook_application_id" TO "FK_c3e5305461931763b56aa905f1c"`);
+        await queryRunner.query(`ALTER TABLE "webhooks" RENAME CONSTRAINT "FK_webhook_channel_id" TO "FK_df528cf77e82f8032230e7e37d8"`);
+
+        await queryRunner.query(`ALTER TABLE "backup_codes" RENAME CONSTRAINT "FK_backup_code_user_id" TO "FK_70066ea80d2f4b871beda32633b"`);
+    }
+}