Tables


SchemaSpy Analysis of certrhythm.public

Generated on Tue Sep 22 22:52 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 7
VIEWS 1
COLUMNS 55
Constraints 0
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
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