Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('diagram_writes_id_seq'::regclass) |
|
|
{“what”:“Auto-increment id.”,“why”:“Primary key.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:17.962593901+00:00”} |
|
| written_at | timestamptz | 35,6 | now() |
|
|
{“what”:“When the write was observed.”,“why”:“Time series for the pass-rate trend.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:18.083506995+00:00”} |
||
| file_path | text | 2147483647 | null |
|
|
{“what”:“Path of the .mmd that was written.”,“why”:“Locates the failing diagram.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:18.211974949+00:00”} |
||
| session_id | text | 2147483647 | √ | null |
|
|
{“what”:“Agent session that wrote it.”,“why”:“Groups writes per session for the clean-rate metric.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:18.376682782+00:00”} |
|
| agent | text | 2147483647 | √ | null |
|
|
{“what”:“Agent name that wrote it.”,“why”:“Attributes quality per agent.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:18.487797434+00:00”} |
|
| tool | text | 2147483647 | √ | null |
|
|
{“what”:“Tool used for the write.”,“why”:“Distinguishes Write from Edit, etc.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:18.646024446+00:00”} |
|
| valid | bool | 1 | null |
|
|
{“what”:“Whether the diagram parsed.”,“why”:“The core quality signal.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:18.777206574+00:00”} |
||
| error_line | int4 | 10 | √ | null |
|
|
{“what”:“Line the parse failed on.”,“why”:“Points at the offending token.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:18.884480973+00:00”} |
|
| error_text | text | 2147483647 | √ | null |
|
|
{“what”:“The parser error message.”,“why”:“Grouped to rank the most common agent mistakes.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:19.061516698+00:00”} |
|
| byte_size | int8 | 19 | √ | null |
|
|
{“what”:“Size of the written file.”,“why”:“Correlates diagram size with failure rate.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:19.220212619+00:00”} |
|
| device | text | 2147483647 | √ | null |
|
|
{“what”:“Device the write happened on.”,“why”:“Separates mac0/mac1/dante behaviour.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:19.326442651+00:00”} |
|
| warnings | text | 2147483647 | √ | null |
|
|
{“what”:“Layout warnings from lint.mjs.”,“why”:“The diagram parsed but reads wrong, e.g. step order.”,“by”:“jcode-builder”,“at”:“2026-09-22T21:50:19.455048521+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| diagram_writes_pkey | Primary key | Asc | id |
| idx_writes_at | Performance | Desc | written_at |
| idx_writes_session | Performance | Asc | session_id |
| idx_writes_valid | Performance | Asc | valid |