Skip to main content

ER Diagram

Visual representation of the key entity relationships across UniPulse's 69+ Prisma models.

Core Domain Relationships​

Content & Publishing​

Conversations (ICE)​

E-Commerce & Revenue​

Audience & Segmentation​

Workflows​

Competitors & Intelligence​

AI & Analytics​

Billing​

Generating a Complete ER Diagram​

You can auto-generate a full ER diagram from the Prisma schema:

# Install the ERD generator
cd apps/api
npm install -D prisma-erd-generator @mermaid-js/mermaid-cli

# Add generator to schema.prisma:
# generator erd {
#   provider = "prisma-erd-generator"
#   output   = "./erd.svg"
# }

# Generate
npx prisma generate

This produces a complete SVG diagram of all 69+ models and their relationships.

Prisma Studio

For interactive exploration, use Prisma Studio:

cd apps/api && npx prisma studio

This opens a web UI at http://localhost:5555 where you can browse all tables, view relationships, and edit data.

Cross-Reference