🗃️ Database Schema

PulseHub uses 9 tables. All primary keys are UUID v4 strings (VARCHAR(36)). All tables use utf8mb4 charset for full Unicode support including emoji.

---

Table Overview

Table	Description
workspaces	Top-level tenant
users	Admin and agent accounts
channels	Connected channel integrations
contacts	Customers
conversations	Threads between contacts and workspace
messages	Individual messages
automations	Automation rules
automation_events	Automation trigger queue
webhook_events	Inbound webhook log
sse_events	Real-time event queue

---

Entity Relationships

workspaces
    │
    ├── users (workspace_id)
    ├── channels (workspace_id)
    ├── contacts (workspace_id)
    ├── automations (workspace_id)
    └── conversations (workspace_id)
              │
              ├── messages (conversation_id)
              ├── channels (channel_id)
              ├── contacts (contact_id)
              └── users (assigned_agent_id)

For full table definitions with all columns and types, see the schema.sql file included in the distribution.