Validation: Schema

Detects notes missing required fields, depth violations, and structural issues.

Notes Missing Required ID

TABLE WITHOUT ID
  file.name AS "File",
  file.folder AS "Folder"
FROM "03-Market" OR "05-PMF/1-Research" OR "03-Market/5-Problems" OR "04-Product/3-Opportunities" OR "04-Product/4-Solutions"
WHERE !id AND !startswith(file.name, "_")

Notes Missing Required Name

TABLE WITHOUT ID
  file.name AS "File",
  file.folder AS "Folder"
FROM "03-Market" OR "05-PMF/1-Research" OR "03-Market/5-Problems" OR "04-Product/3-Opportunities" OR "04-Product/4-Solutions"
WHERE !name AND !startswith(file.name, "_")

Notes Missing Required Status

TABLE WITHOUT ID
  file.name AS "File",
  file.folder AS "Folder"
FROM "03-Market" OR "05-PMF/1-Research" OR "03-Market/5-Problems" OR "04-Product/3-Opportunities" OR "04-Product/4-Solutions"
WHERE !status AND !startswith(file.name, "_")

Segment Depth Violation (Sub-Segments with Children)

Sub-segments must not have children — the model allows only 2 levels.

TABLE WITHOUT ID
  name AS "Sub-Segment",
  child_segments AS "Children (violation)"
FROM "03-Market/1-Segments"
WHERE segment_level = "sub"
  AND child_segments AND length(child_segments) > 0

Persona Instances Missing Segment

TABLE WITHOUT ID
  name AS "Instance",
  segment AS "Segment (missing)"
FROM "03-Market/2-Personas/Instances"
WHERE persona_type = "instance"
  AND (!segment OR segment = null)
  AND !startswith(file.name, "_")

Persona Instances Missing Archetype Parent

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

If all tables above are empty, all notes conform to the required schema.