Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('editorial_briefs_id_seq'::regclass) |
|
|
{“what”:“Unique integer identifier for each brief.”,“why”:“Needed to reference a brief from other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.291959740+00:00”} |
||||
| job_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the job this brief belongs to.”,“why”:“Links the brief to its parent job; without it, briefs are orphaned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.311753755+00:00”} |
|||||
| title | text | 2147483647 | null |
|
|
{“what”:“Human-readable title of the brief.”,“why”:“Identifies the brief in lists and reports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.330907389+00:00”} |
|||||
| slug | text | 2147483647 | null |
|
|
{“what”:“URL-friendly version of the title, used in paths.”,“why”:“Provides a stable, readable identifier for routing and lookups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.352947179+00:00”} |
|||||
| outline | jsonb | 2147483647 | null |
|
|
{“what”:“Structured outline of the content, e.g., sections and headings.”,“why”:“Defines the content structure that the model must follow.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.391701549+00:00”} |
|||||
| target_keywords | jsonb | 2147483647 | null |
|
|
{“what”:“List of keywords the content should target.”,“why”:“Guides SEO and ensures content covers required terms.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.440615246+00:00”} |
|||||
| target_word_count | int4 | 10 | null |
|
|
{“what”:“Desired length of the content in words.”,“why”:“Sets a length constraint for the generated content.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.470771769+00:00”} |
|||||
| content_gaps_to_fill | jsonb | 2147483647 | √ | null |
|
|
{“what”:“Specific gaps in existing content that this brief addresses.”,“why”:“Ensures the generated content covers missing information.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.504719927+00:00”} |
||||
| model | text | 2147483647 | 'gemma4-26b-a4b'::text |
|
|
{“what”:“Name of the language model used for generation.”,“why”:“Records which model produced the content; affects reproducibility.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.590683651+00:00”} |
|||||
| created_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp when the brief was created.”,“why”:“Tracks when the brief was added; useful for auditing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.651119606+00:00”} |
||||
| style_spec | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON object describing tone, voice, and formatting rules.”,“why”:“Ensures generated content matches the desired style.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:17.740695982+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| editorial_briefs_pkey | Primary key | Asc | id |