Validation: Broken Links

Detects orphaned or missing inheritance and relationship links across the vault.

Persona Instances with Missing Archetype

TABLE WITHOUT ID
  name AS "Instance",
  archetype_parent AS "Archetype Parent (broken)"
FROM "03-Market/2-Personas/Instances"
WHERE persona_type = "instance"
  AND (!archetype_parent OR archetype_parent = null)

Sub-Segments with Missing Parent

TABLE WITHOUT ID
  name AS "Sub-Segment",
  parent_segment AS "Parent (broken)"
FROM "03-Market/1-Segments"
WHERE segment_level = "sub"
  AND (!parent_segment OR parent_segment = null)

Insights with Missing Persona Link

TABLE WITHOUT ID
  name AS "Insight",
  persona AS "Persona (broken)"
FROM "05-PMF/1-Research/2-Insights"
WHERE !persona OR persona = null

Problems with Missing Affected Personas

TABLE WITHOUT ID
  name AS "Problem",
  affected_personas AS "Affected Personas (broken)"
FROM "03-Market/5-Problems"
WHERE !affected_personas OR length(affected_personas) = 0

Research Sessions with Missing Participants

TABLE WITHOUT ID
  name AS "Session",
  participants AS "Participants (broken)"
FROM "05-PMF/1-Research/1-Sessions"
WHERE !participants OR length(participants) = 0

Features with Missing Opportunity Link

TABLE WITHOUT ID
  name AS "Feature",
  opportunity AS "Opportunity (broken)"
FROM "04-Product/4-Solutions/Features"
WHERE !opportunity OR opportunity = null

If all tables above are empty, there are no broken links in the vault.