Browse Templates/Discord

Discord

Complete database schema for a Discord-like community platform featuring guild servers with role-based permissions, text and voice channels, thread messaging, emoji reactions, direct messaging, bot integrations, invite management, audit logs, and ban management.

PostgreSQL15 tablesWeb App

gamingcommunityvoicemessagingreal-time

10 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

12 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

8 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

10 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

5 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

11 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

11 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

6 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

7 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

6 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

5 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

9 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

9 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

7 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

8 cols

Num

PK

AI

FK

Null

Physical Name

Type

Default

Comment

IXUQ|💬

Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.

Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.

Created with ERD Studio

Tables in this template

usersUsers

10 cols

guildsGuilds

12 cols

guild_membersGuild Members

8 cols

rolesRoles

10 cols

member_rolesMember Roles

5 cols

channelsChannels

11 cols

messagesMessages

11 cols

message_reactionsMessage Reactions

6 cols

emojisEmojis

7 cols

direct_messagesDirect Messages

6 cols

dm_participantsDM Participants

5 cols

threadsThreads

9 cols

invitesInvites

9 cols

bansBans

7 cols

audit_logsAudit Logs

8 cols

Related Templates

View all templates →

GitHub

Code hosting platform with repositories, issues, pull requests, and CI/CD

PostgreSQL16 tables

developer-toolsgitcollaboration+2

Netflix

Video streaming platform with content catalog, profiles, subscriptions, and recommendations

PostgreSQL15 tables

streamingvideosubscription+2

Spotify

Music streaming platform with tracks, artists, albums, playlists, and social features

PostgreSQL18 tables

musicstreamingplaylist+2

Slack

Team messaging platform with workspaces, channels, threads, and integrations

PostgreSQL14 tables

messagingcollaborationteam+2

Discord Database Schema - ERD Template