Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('drafts_id_seq'::regclass) |
|
|
{“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 |
|
|
{“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 |