post_tags


Description

{“what”:“One row per tag applied to a post, identified by post_slug.”,“why”:“Without it, tag assignments for posts are unknown, making tag-based queries and weighting impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:12.485539407+00:00”}

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
post_brief.post_slug Implied Constraint R

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

Relationships