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 |
|---|---|---|---|---|---|
| compliance_findings | 0 | 0 | 7 | Table | {“what”:“Rows of compliance scan results for a repo-device pair.”,“why”:“Without it, scan results are lost and cannot be audited or acted on.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.828549410+00:00”} |
| status_changes | 0 | 0 | 7 | Table | {“what”:“Chronological log of status updates for birth records; each row is one change.”,“why”:“Without it, the history of status changes is lost, so audits and current status cannot be reconstructed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.827584534+00:00”} |
| birth_steps | 0 | 0 | 6 | Table | {“what”:“Steps of a birth process, each row one step.”,“why”:“Without it, no record of which steps were attempted or their outcomes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:10.913072985+00:00”} |
| births | 0 | 0 | 12 | Table |