Tables


SchemaSpy Analysis of blindrhythm.public

Generated on Tue Sep 22 22:47 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 9
VIEWS 4
COLUMNS 148
Constraints 5
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
journey_barrier 0 1 22 Table

{“what”:“Records accessibility barriers encountered during a user journey.”,“why”:“Central table for tracking and triaging barriers across test runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.157382645+00:00”}

journey_narrative 0 1 7 Table

{“what”:“Generated narrative text for a journey run, tailored to an audience and format.”,“why”:“Without it, there is no persisted output of the journey narrative generation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:11.741327787+00:00”}

sitemap_reachability 0 0 12 Table
blindrhythm_calibration 0 0 8 Table

{“what”:“Defines expected accessibility outcomes for specific elements on specific pages.”,“why”:“Provides a reference set to validate the blindrhythm tool’s detection logic against known cases.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:40.362617704+00:00”}

journey_route 0 1 11 Table

{“what”:“A step in a journey route, linking a run to a sitemap node with expected and actual outcomes.”,“why”:“Without it, journey steps cannot be tracked individually or correlated to runs and sitemap nodes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.379888135+00:00”}

journey_run 5 0 13 Table

{“what”:“One attempt to complete a journey from start_url to goal with a given model.”,“why”:“Without it, individual journey attempts and their outcomes cannot be tracked or analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:06.648405885+00:00”}

journey_cache 0 0 7 Table
journey_page_a11y 0 1 18 Table
journey_step 0 1 23 Table

{“what”:“One recorded action in an automated journey run, ordered by step_index within a run_id.”,“why”:“Without it, the sequence of actions in a run cannot be stored, replayed, or analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.322413773+00:00”}

journey_class 0 0 14 View
journey_rollup_detail 0 0 4 View
journey_step_health 0 0 4 View
journey_rollup 0 0 5 View