blog_critiques


Description

{“what”:“A single critique run over a set of blog posts, with metadata and results.”,“why”:“Without it, results from different runs would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:50.699225761+00:00”}

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

Relationships