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 |
|---|---|---|---|---|---|
| tier_predictions | 0 | 0 | 7 | Table | {“what”:“Predicted or confirmed tier for a domain, with source and decision metadata.”,“why”:“Without it, tier assignments and their provenance are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.044015437+00:00”} |
| certifications | 0 | 0 | 14 | Table | {“what”:“One certification attempt per subject and type, with decision and audit trail.”,“why”:“Without it, certification status and history are unknown, preventing renewal and audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:08.820374492+00:00”} |
| discovery_runs | 0 | 0 | 4 | Table | {“what”:“A single execution of the discovery process for a domain.”,“why”:“Without it, there is no record of when and for which domain discovery was performed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.659048710+00:00”} |
| room_cert_state | 0 | 0 | 4 | Table | {“what”:“Tracks the current state of a certificate assigned to a room.”,“why”:“Without it, the validity of a room’s certificate is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:09.986060806+00:00”} |
| site_pages | 0 | 0 | 7 | Table | {“what”:“One row per unique page, identified by domain and representative URL.”,“why”:“Without it, there is no persistent record of scraped pages, so layout analysis cannot be reproduced or audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:30.462887977+00:00”} |
| room_render_verdicts | 0 | 0 | 6 | Table | {“what”:“Records pass/fail verdicts for room render checks.”,“why”:“Enables tracking which rooms need attention after rendering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:15.764632145+00:00”} |
| room_completion | 0 | 0 | 6 | Table | {“what”:“Aggregated completion snapshot for a room: percentage, attained and attainable counts.”,“why”:“Centralizes per-room completion metrics so they can be queried without scanning raw events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:52.919587858+00:00”} |
| tier_prediction_grades | 0 | 0 | 7 | View |