Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('blog_critiques_id_seq'::regclass) |
|
|
{“what”:“Unique integer identifier for each critique run.”,“why”:“Without it, rows cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.725452807+00:00”} |
|
| run_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp when the critique run started; defaults to current time.”,“why”:“Without it, the recency or ordering of runs is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.743473653+00:00”} |
|
| post_count | int4 | 10 | √ | null |
|
|
{“what”:“Number of blog posts analyzed in this run.”,“why”:“Without it, the scale of the run is unknown, affecting result interpretation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.769983018+00:00”} |
|
| model | text | 2147483647 | √ | null |
|
|
{“what”:“Name or identifier of the model/algorithm used for critique.”,“why”:“Without it, results cannot be compared across different models.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.785574914+00:00”} |
|
| redundancies | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSONB structure holding redundancy analysis results (e.g., repeated phrases).”,“why”:“Without it, redundancy issues are not captured for review.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.817312041+00:00”} |
|
| quality | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSONB structure holding quality scores or assessments.”,“why”:“Without it, quality metrics are missing, making evaluation impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.835246113+00:00”} |
|
| diversity | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSONB structure holding diversity metrics across posts.”,“why”:“Without it, diversity of content cannot be measured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.856493276+00:00”} |
|
| report_md | text | 2147483647 | √ | null |
|
|
{“what”:“Markdown-formatted full report of the critique run.”,“why”:“Without it, there is no human-readable summary of findings.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.881660502+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| blog_critiques_pkey | Primary key | Asc | id |