quality_scores


Description

{“what”:“Per-draft quality metrics and analysis results from a scoring job.”,“why”:“Without it, there is no record linking drafts to their quality scores and job context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.052476990+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('quality_scores_id_seq'::regclass)

{“what”:“Unique row identifier, auto-incrementing integer.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.074228943+00:00”}

draft_id int4 10 null
drafts.id quality_scores_draft_id_fkey R

{“what”:“ID of the draft being scored.”,“why”:“Without it, scores cannot be tied to a specific draft.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.101538931+00:00”}

job_id int4 10 null
pipeline_jobs.id quality_scores_job_id_fkey R

{“what”:“ID of the scoring job that produced these scores.”,“why”:“Without it, cannot trace which job run generated the scores.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.138721676+00:00”}

readability_grade float4 8,8 √ null

{“what”:“Numeric readability grade from the scoring algorithm.”,“why”:“Without it, readability quality is unknown for this draft.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.150447111+00:00”}

keyword_density float4 8,8 √ null

{“what”:“Keyword density as a real number, likely a ratio.”,“why”:“Without it, keyword usage cannot be evaluated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.175541662+00:00”}

heading_structure_score float4 8,8 √ null

{“what”:“Score for heading hierarchy and structure.”,“why”:“Without it, heading quality is not measured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.198590719+00:00”}

content_coverage_score float4 8,8 √ null

{“what”:“Score for how well content covers expected topics.”,“why”:“Without it, content completeness is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.212928462+00:00”}

originality_score float4 8,8 √ null

{“what”:“Score for originality or uniqueness of the draft.”,“why”:“Without it, plagiarism risk cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.228093448+00:00”}

overall_score float4 8,8 null

{“what”:“Composite quality score, required for every record.”,“why”:“Without it, there is no single quality metric to compare drafts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.325053902+00:00”}

issues jsonb 2147483647 √ null

{“what”:“JSON array of issues found during scoring.”,“why”:“Without it, specific problems are not recorded for review.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.381592936+00:00”}

pass bool 1 null

{“what”:“Boolean indicating whether the draft passed quality threshold.”,“why”:“Without it, pass/fail status is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.436042234+00:00”}

scored_at timestamptz 35,6 √ now()

{“what”:“Timestamp when scoring was performed, default now.”,“why”:“Without it, timing of score generation is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.451584711+00:00”}

humanrhythm_score float4 8,8 √ null

{“what”:“Score from human rhythm analysis.”,“why”:“Without it, rhythm quality is not captured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.477243846+00:00”}

humanrhythm_flags jsonb 2147483647 √ null

{“what”:“JSON flags from human rhythm analysis.”,“why”:“Without it, specific rhythm issues are not recorded.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.512919975+00:00”}

tension_arc_type text 2147483647 √ null

{“what”:“Text label for narrative tension arc type.”,“why”:“Without it, arc type is unknown for analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.552880592+00:00”}

tension_arc_fit float4 8,8 √ null

{“what”:“Real number measuring fit of the tension arc.”,“why”:“Without it, arc quality cannot be quantified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.629027792+00:00”}

tension_inversions int4 10 √ null

{“what”:“Integer count of tension inversions.”,“why”:“Without it, inversion count is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.655726371+00:00”}

tension_rhythm_sync float4 8,8 √ null

{“what”:“Real number measuring sync between tension and rhythm.”,“why”:“Without it, rhythm-tension alignment is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.674425701+00:00”}

tension_range float4 8,8 √ null

{“what”:“Real number for tension range.”,“why”:“Without it, tension variability is not measured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.691650515+00:00”}

emotion_ratio float4 8,8 √ null

{“what”:“Real number ratio of emotional content.”,“why”:“Without it, emotional balance is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.703500666+00:00”}

news_coverage float4 8,8 √ null

{“what”:“Real number for news coverage score.”,“why”:“Without it, news coverage is not evaluated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.720311893+00:00”}

news_missing jsonb 2147483647 √ null

{“what”:“JSON list of missing news items.”,“why”:“Without it, gaps in news coverage are not recorded.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.748536864+00:00”}

deviation_report jsonb 2147483647 √ null

{“what”:“JSON report of deviations from expected content.”,“why”:“Without it, deviations are not documented.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:33.778729416+00:00”}

Indexes

Constraint Name Type Sort Column(s)
quality_scores_pkey Primary key Asc id

Relationships