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 |
|
|
{“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 |
|
|
{“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 |