metabot_message

{“what”:“Integer primary key; unique per message.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:42.763863501+00:00”}

{“what”:“Timestamp with time zone of when the message was logged; defaults to current time.”,“why”:“Needed to sort messages chronologically and correlate with other events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:42.802374175+00:00”}

{“what”:“Text identifier of the user profile associated with the message.”,“why”:“Without it, messages cannot be attributed to a specific user or profile.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:42.843382271+00:00”}

{“what”:“Role of the message sender, such as ‘user’ or ‘assistant’.”,“why”:“Without it, the direction of the message (incoming vs. outgoing) is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:42.867768282+00:00”}

{“what”:“Full text content of the message, either user input or bot response.”,“why”:“Without it, the actual message content is missing, making conversation reconstruction impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:42.937159685+00:00”}

{“what”:“Text field with detailed token usage breakdown, often JSON; may be null.”,“why”:“Needed to break down token counts by category (e.g., prompt vs. completion) for cost analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:43.002003082+00:00”}

{“what”:“Total token count for the message, sum of all usage categories.”,“why”:“Without it, per-message token consumption and cumulative cost cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:43.120478710+00:00”}

{“what”:“String identifier grouping messages into a single conversation thread.”,“why”:“Without it, messages cannot be grouped into coherent conversations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:43.215337072+00:00”}