diagrams

1 rows


Description

{“what”:“Current rendered Mermaid diagram for each repo, one row per repo.”,“why”:“Cache the LLM-generated diagram so a repeat request does not re-run the model.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:16.576776949+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
diagram_id text 2147483647 null

{“what”:“Unique id for this rendered diagram.”,“why”:“Identifies the artifact in logs and events.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:16.854724680+00:00”}

repo_name text 2147483647 null

{“what”:“Repository short name, e.g. DiagramRhythm.”,“why”:“The key agents look a cached diagram up by.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:17.081568523+00:00”}

repo_path text 2147483647 null

{“what”:“Absolute path to the repo on the device that generated it.”,“why”:“Prevents two same-named repos colliding in the cache.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:17.192587531+00:00”}

description text 2147483647 null

{“what”:“LLM-written prose describing the architecture.”,“why”:“Fed to the second LLM pass that draws the diagram.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:17.379127570+00:00”}

mermaid text 2147483647 null

{“what”:“The generated Mermaid source.”,“why”:“The deliverable; rendered by GitHub and DocRhythm.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:17.494368451+00:00”}

node_count int4 10 0

{“what”:“Number of nodes in the diagram.”,“why”:“Sanity check that a render produced real structure.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:17.647824794+00:00”}

created_at text 2147483647 null

{“what”:“When the diagram was first generated.”,“why”:“Audit.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:17.750154768+00:00”}

updated_at text 2147483647 null

{“what”:“When the diagram was last regenerated.”,“why”:“Orders the list view and drives cache freshness.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:17.844729479+00:00”}

Indexes

Constraint Name Type Sort Column(s)
diagrams_pkey Primary key Asc diagram_id
diagrams_repo_path_key Must be unique Asc repo_path
idx_diagrams_path Performance Asc repo_path
idx_diagrams_repo Performance Asc repo_name

Relationships