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 |
|---|---|---|---|---|---|
| build_files | 0 | 0 | 8 | Table | {“what”:“One row per file discovered in a build, with content hash and scan metadata.”,“why”:“Without it, you cannot know which files were present in a build or verify their integrity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.035712972+00:00”} |
| preflight_transitions | 0 | 0 | 6 | Table | {“what”:“Chronological log of phase changes for preflight builds.”,“why”:“Without it, there is no record of how a build moved through preflight phases, so debugging and auditing become impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:15.844593907+00:00”} |
| builds | 0 | 1 | 21 | Table | {“what”:“A build attempt: one row per execution of a build pipeline.”,“why”:“Without it, there is no trace of build history or artifact provenance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.189428199+00:00”} |
| preflight_runs | 0 | 0 | 18 | Table | {“what”:“Records of preflight checks for service builds before deployment.”,“why”:“Without it, no audit trail of preflight attempts and outcomes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.754098584+00:00”} |
| _migrations | 2 | 0 | 2 | Table | {“what”:“Tracks applied database migrations for schema versioning.”,“why”:“Without it, migrations could be re-run or skipped, corrupting schema state.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:01.529375473+00:00”} |
| deployments | 0 | 1 | 15 | Table | |
| build_audit | 0 | 0 | 11 | Table | {“what”:“Audit trail of build steps, one row per step execution.”,“why”:“Without it, no record of build activity for debugging or compliance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.053489036+00:00”} |
| smoke_tests | 0 | 0 | 10 | Table | {“what”:“One row per smoke test run for a build.”,“why”:“Without it, there is no record of which builds passed basic smoke tests.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:27.928448673+00:00”} |