Tables


SchemaSpy Analysis of assignrhythm.public

Generated on Tue Sep 22 22:42 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 3
VIEWS 0
COLUMNS 28
Constraints 2
Anomalies 0
Routines 0

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”}