Database Properties
Database Type: PostgreSQL - 18.4 (Ubuntu 18.4-1.pgdg24.04+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| replies | 0 | 2 | 10 | Table | {“what”:“One row per AI-generated reply to a visitor message.”,“why”:“Without it, no history of AI replies exists, so failures and content cannot be reviewed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:41.549894683+00:00”} |
| poller_state | 0 | 0 | 3 | Table | {“what”:“Persistent checkpoint for a poller’s position in a data source.”,“why”:“Without it, a poller cannot resume after restart and would reprocess or miss events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:31.805101270+00:00”} |
| webhook_events | 0 | 0 | 4 | Table | {“what”:“Log of webhook calls with event type, payload, and arrival time.”,“why”:“Without it, there is no audit trail for external events, making debugging and replay impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:03.009964223+00:00”} |
| handled_messages | 2 | 0 | 3 | Table | {“what”:“Records of messages that have been handled, including their conversation and receipt time.”,“why”:“Without it, there is no record of which messages were processed, risking duplicate handling and loss of audit trail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:32.508592089+00:00”} |