logo
ExamplesEditorPricingDocs
37.1kSign in

Slack team chat database schema

How a team chat product models its data: workspaces and per-workspace identity, public private and shared channels, a read cursor per member instead of a read flag per message, thread replies, mentions, files, saved items and installed apps with granted scopes.

Slack ER diagram

Slack team chat database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 workspaces idBIGINT nameVARCHAR domainVARCHAR plan_tierVARCHAR default_channel_idBIGINT message_retention…INTEGER created_atTIMESTAMP users idBIGINT emailVARCHAR full_nameVARCHAR avatar_urlVARCHAR timezoneVARCHAR is_botBOOLEAN created_atTIMESTAMP workspace_members idBIGINT workspace_idBIGINT user_idBIGINT display_nameVARCHAR titleVARCHAR roleVARCHAR status_textVARCHAR status_expires_atTIMESTAMP is_deactivatedBOOLEAN joined_atTIMESTAMP channels idBIGINT workspace_idBIGINT nameVARCHAR kindVARCHAR topicVARCHAR purposeVARCHAR created_by_member…BIGINT is_archivedBOOLEAN external_workspac…SMALLINT last_message_atTIMESTAMP created_atTIMESTAMP channel_members idBIGINT channel_idBIGINT workspace_member_…BIGINT last_read_message…BIGINT last_read_atTIMESTAMP notification_levelVARCHAR is_mutedBOOLEAN joined_atTIMESTAMP messages idBIGINT channel_idBIGINT workspace_member_…BIGINT app_idBIGINT parent_message_idBIGINT bodyTEXT is_broadcastBOOLEAN reply_countINTEGER sent_atTIMESTAMP edited_atTIMESTAMP deleted_atTIMESTAMP mentions idBIGINT message_idBIGINT workspace_member_…BIGINT mention_typeVARCHAR created_atTIMESTAMP reactions message_idBIGINT workspace_member_…BIGINT emoji_nameVARCHAR reacted_atTIMESTAMP files idBIGINT workspace_idBIGINT uploaded_by_membe…BIGINT message_idBIGINT filenameVARCHAR object_urlVARCHAR content_typeVARCHAR size_bytesBIGINT is_externalBOOLEAN uploaded_atTIMESTAMP saved_items idBIGINT workspace_member_…BIGINT message_idBIGINT stateVARCHAR remind_atTIMESTAMP created_atTIMESTAMP completed_atTIMESTAMP apps idBIGINT nameVARCHAR slugVARCHAR developer_nameVARCHAR icon_urlVARCHAR is_directory_list…BOOLEAN created_atTIMESTAMP app_installations idBIGINT workspace_idBIGINT app_idBIGINT installed_by_memb…BIGINT bot_user_idBIGINT access_token_hashVARCHAR statusVARCHAR installed_atTIMESTAMP revoked_atTIMESTAMP app_installation_sc… installation_idBIGINT scopeVARCHAR granted_atTIMESTAMP

Related database schemas

MySQL
Communication

Discussion forum and community database schema

The phpBB and Discourse shape rather than the Reddit one: curated categories and boards, threads bumped by replies, flat numbered posts with quoting, reputation and badges, a report-driven moderation queue and private messages.

PostgreSQL
Communication

Discord chat platform database schema

How a community chat platform models its data: servers with nested channels, roles carrying permission bitfields, three-state per-channel overwrites, per-server nicknames, messages and threads, reactions, attachments, invites and voice sessions.

PostgreSQL
Communication

Email & mailbox service database schema

How a webmail service models its data: labels applied many-to-many instead of IMAP folders, one stored copy per message, conversation threading, attachments deduplicated by content hash, delivery filters, drafts, read state, spam scoring and quota.

PostgreSQL
Communication

WhatsApp messaging database schema

How a mobile messenger models its data: accounts keyed by phone number, linked devices, private contacts, direct and group chats as one entity, messages with media and replies, per-recipient delivery and read receipts, and disappearing messages with a TTL.