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 |
|---|---|---|---|---|---|
| assignment_events | 0 | 1 | 7 | Table | {“what”:“Log of assignment status transitions, including failed attempts.”,“why”:“Without it, there is no audit trail to reconstruct assignment status history or diagnose failed transitions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.208444657+00:00”} |
| deliverables | 0 | 1 | 6 | Table | {“what”:“A submitted file or artifact for an assignment, with path and optional review.”,“why”:“Without it, assignment submissions cannot be tracked or reviewed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:21.912049733+00:00”} |
| assignments | 2 | 0 | 15 | Table | {“what”:“A unit of work tied to an application, with its own lifecycle and outcome.”,“why”:“Without it, the state and result of each application’s task would be untracked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:22.714934767+00:00”} |