Data Model

DD-first architecture · PostgreSQL / Supabase-compatible · provenance from day one

Prompt 02

Company Map

tree_nodes
Function tree + sibling maps (self-referencing)
10
people
Employees, managers, backups
9
ownerships
Person ↔ node (many-to-many)
9
permissions
Subtree-scoped grants
5

Workflow

dd_steps
Fundamental unit; preserves lineage
5
conversations
AI ↔ human sessions
1
artifacts
Interactive, confirmable outputs
1

Provenance

claims
Source statements (never overwritten)
8
evidence
Objective support w/ exact location
3
facts
Canonical value + truth level
3
findings
Loadpass interpretation
2
risks
Aggregated, tracked risk
1

Provenance Explorer

Every material conclusion is traceable: Source → Claim → Fact → Evidence → Finding → Risk. A source claim is never silently promoted to truth.

Structured Facts

1

Claims

What each source stated — preserved, never overwritten.
CEO
85
HR
87
Payroll
87
Evidence: Sheet 1 · summary row 88
87 active employees98%
provenance
2

Fact

The system's canonical value, with a truth level — not a silent promotion of any one claim.
Employee count
87
ContestedVERIFIED