Team Workspace

Overview

Team collaboration platform schema inspired by Slack and Notion. Supports organized channels, task management, file sharing, @mentions, and real-time presence tracking.

Key Design Decisions

• Channel Organization: Public, private, and direct message channels
• Task Management: Kanban-style tasks with assignments and due dates
• File Sharing: Attachments with access control
• Real-time Features: Presence indicators and typing notifications

Tables

14 tables covering workspaces, channels, messages, tasks, files, mentions, reactions, and presence. Designed for real-time collaboration with WebSocket support.