Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| message_id | text | 2147483647 | null |
|
|
{“what”:“Unique identifier of the handled message; primary key.”,“why”:“Without it, messages cannot be uniquely referenced, making deduplication and updates impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:32.534617343+00:00”} |
||||||||
| conversation_id | text | 2147483647 | null |
|
|
{“what”:“Identifier of the conversation that the message belongs to.”,“why”:“Without it, messages cannot be grouped per conversation, breaking per-conversation workflows.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:32.552524319+00:00”} |
||||||||
| received_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone when the message was received; defaults to now.”,“why”:“Without it, there is no timing information for ordering, latency analysis, or retention policies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:32.564850925+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| handled_messages_pkey | Primary key | Asc | message_id |