drafts


Description

{“what”:“A single revision of generated content for a job, with markdown and HTML.”,“why”:“Without it, previous versions of job content cannot be compared or restored.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.797315855+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('drafts_id_seq'::regclass)
published_posts.draft_id published_posts_draft_id_fkey R
quality_scores.draft_id quality_scores_draft_id_fkey R

{“what”:“Unique integer identifier for this draft row.”,“why”:“Without it, rows cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.823781093+00:00”}

job_id int4 10 null
pipeline_jobs.id drafts_job_id_fkey R

{“what”:“Identifier of the job this draft belongs to.”,“why”:“Without it, drafts cannot be linked to their parent job.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.862101963+00:00”}

revision int4 10 1

{“what”:“Sequential version number for this draft within its job, starting at 1.”,“why”:“Without it, ordering and uniqueness of drafts per job is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.887905679+00:00”}

content_md text 2147483647 null

{“what”:“Full draft content in Markdown format.”,“why”:“Without it, the draft’s source text is unavailable for editing or re-rendering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.897274405+00:00”}

content_html text 2147483647 null

{“what”:“Full draft content rendered as HTML.”,“why”:“Without it, the rendered version cannot be displayed without re-rendering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.909493646+00:00”}

word_count int4 10 null

{“what”:“Number of words in the draft content.”,“why”:“Without it, length-based decisions (e.g., pricing, quotas) are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.922410340+00:00”}

model text 2147483647 'gemma4-26b-a4b'::text

{“what”:“Name of the language model that generated this draft, e.g., ‘gemma4-26b-a4b’.”,“why”:“Without it, the generation source is unknown, affecting reproducibility and cost analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.934517876+00:00”}

prompt_tokens int4 10 √ null

{“what”:“Number of tokens sent in the prompt to the model.”,“why”:“Without it, prompt cost and usage cannot be calculated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.958533893+00:00”}

completion_tokens int4 10 √ null

{“what”:“Number of tokens generated by the model in the completion.”,“why”:“Without it, generation cost and usage cannot be calculated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.984844494+00:00”}

created_at timestamptz 35,6 √ now()

{“what”:“Timestamp when this draft was created, in UTC.”,“why”:“Without it, the chronological order of drafts is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:02.013901294+00:00”}

Indexes

Constraint Name Type Sort Column(s)
drafts_pkey Primary key Asc id
idx_drafts_job Performance Asc job_id

Relationships