Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('post_tags_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each tag assignment.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:12.513933252+00:00”} |
||||
| post_slug | text | 2147483647 | null |
|
|
{“what”:“Slug of the post this tag is attached to.”,“why”:“Without it, the tag cannot be linked to a specific post, making the assignment meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:12.531705637+00:00”} |
|||||
| tag | text | 2147483647 | null |
|
|
{“what”:“Tag text applied to the post; e.g., ‘database’.”,“why”:“Without it, the actual tag value is missing, so no tag-based filtering or grouping is possible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:12.565243848+00:00”} |
|||||
| source | text | 2147483647 | 'llm'::text |
|
|
{“what”:“Origin of the tag assignment; default ‘llm’ for machine-generated.”,“why”:“Without it, you cannot distinguish human-curated tags from automated ones, affecting trust or filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:12.578706822+00:00”} |
|||||
| weight | float4 | 8,8 | √ | 1.0 |
|
|
{“what”:“Numeric weight of the tag assignment; default 1.0, higher means stronger association.”,“why”:“Without it, all tags are equally important, so ranking or scoring of tags is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:12.603157331+00:00”} |
||||
| created_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp when the tag assignment was created, in UTC.”,“why”:“Without it, the age of the assignment is unknown, so time-based decay or auditing is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:12.621624284+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| post_tags_pkey | Primary key | Asc | id |
| post_tags_post_slug_tag_key | Must be unique | Asc/Asc | post_slug + tag |