Platform Architecture

Entity Relationship Map

Every entity is owned by one product but referenced by many, so they validate independently but combine without migration.

19Entities
177Fields
29Foreign Keys
22Relationships
7Layers
Filter by product

Core Identity

3

Entities that exist independent of any product:the foundational objects everything else references.

Organization

6f

The user's company:an agency, consultancy, or studio. Top-level tenant.

ScoutCompassBlueprintBenchRelayRetroProof

User

6f

A person who uses the platform. May belong to one or more orgs.

ScoutCompassBlueprintBenchRelayRetroProof

Client

8f

An external company or individual you do work for. Central to revenue tracking.

BlueprintRelayRetroProofScout

People & Capabilities

3

The talent graph:who can do what, at what rate, and when they're available.

Person

11f

Anyone in your talent network: employees, contractors, referrals.

BenchBlueprintRetro

Skill

7f

A canonical capability. Used to match people to roles and identify gaps.

BenchBlueprint

PersonSkill

5f

Junction: maps a person to their skills with proficiency.

BenchBlueprint

Projects & Scoping

3

The work itself:from initial estimate through staffing and phase planning.

Project

14f

The central entity. Every product touches this.

BlueprintBenchRelayRetroProofCompass

Phase

9f

A distinct stage of a project (discovery, design, build, QA, launch).

BlueprintRelayRetro

RoleRequirement

8f

A staffing slot within a phase.

BlueprintBench

Intelligence & Decisions

4

Market signals, strategic decisions, and the audit data that informs both.

SignalItem

9f

A detected market event: competitor change, funding round, pricing shift.

ScoutCompass

SiteAudit

13f

Technical analysis of a website: performance, accessibility, tech stack.

BlueprintCompassProof

Decision

8f

A strategic decision modeled in Compass.

CompassBlueprint

DecisionOption

7f

One possible path within a decision, with scored criteria.

Compass

Communication & Documents

2

Everything generated, sent, and tracked across the client relationship.

Document

13f

Any generated artifact: SOW, proposal, case study, decision brief.

BlueprintRelayProofRetroCompass

CommunicationLog

11f

A record of client-facing communication with scope drift detection.

RelayRetro

Learning & Knowledge

3

The feedback loop:structured retrospective data that compounds over time.

Retrospective

12f

A structured post-mortem tied to a project.

RetroBlueprintProof

PhasePerformance

8f

Per-phase actuals vs. estimates.

RetroBlueprint

EstimationModel

11f

Learned coefficients that adjust future estimates from retro data.

BlueprintRetro

AI Orchestration

1

The shared conversational engine:intake sessions, tool calls, and generated outputs.

Conversation

11f

An AI interaction session. Same pattern, different schemas per product.

ScoutCompassBlueprintBenchRelayRetroProof