post_topics

{“what”:“Unique integer assigned by sequence; primary key for this row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:54.389541134+00:00”}

{“what”:“Slug of the post this topic assignment belongs to; matches a post’s slug.”,“why”:“Without it, the assignment cannot be linked to a specific post, making the row meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:54.632671587+00:00”}

{“what”:“Main keyword or phrase that characterizes the topic for this post.”,“why”:“Without it, the main searchable term for this topic assignment is missing, breaking keyword-based lookups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:54.844136446+00:00”}

{“what”:“Slug identifying the specific angle or perspective of the topic.”,“why”:“Without it, the nuance of the topic is lost, making it impossible to distinguish different angles on the same keyword.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:55.053613897+00:00”}

{“what”:“JSON array of numeric values representing the topic embedding vector.”,“why”:“Without it, similarity calculations for recommendations or clustering cannot be performed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:55.320149784+00:00”}

{“what”:“Timestamp when this topic assignment was created, in UTC.”,“why”:“Without it, the age of the assignment is unknown, affecting time-based filtering or audits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:55.630096778+00:00”}