Slack

Complete database schema for a Slack-like team communication platform featuring workspaces, channels, direct messages, threads, emoji reactions, file attachments, apps and integrations, user groups, and notification preferences.

PostgreSQL14 tablesWeb App

messagingcollaborationteamreal-timeworkspace

Tables in this template

usersUsers

10 cols

workspacesWorkspaces

9 cols

workspace_membersWorkspace Members

8 cols

channelsChannels

11 cols

channel_membersChannel Members

7 cols

messagesMessages

11 cols

message_reactionsMessage Reactions

7 cols

message_attachmentsMessage Attachments

9 cols

direct_messagesDirect Messages

7 cols

dm_membersDM Members

6 cols

user_groupsUser Groups

8 cols

user_group_membersUser Group Members

6 cols

appsApps

9 cols

app_installationsApp Installations

8 cols

Related Templates

View all templates →

GitHub

Clone

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

PostgreSQL16 tables

developer-toolsgitcollaboration+2

Web App

Netflix

Clone

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

PostgreSQL15 tables

streamingvideosubscription+2

Web App

Spotify

Clone

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

PostgreSQL18 tables

musicstreamingplaylist+2

Web App

Discord

Clone

Community platform with servers, channels, roles, voice, and bots

PostgreSQL15 tables

gamingcommunityvoice+2

Web App