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 |