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 |