journey_barrier


Description

{“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”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null

{“what”:“Unique UUID for each barrier record.”,“why”:“Enables precise reference and updates to individual barriers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.195959468+00:00”}

run_id uuid 2147483647 null
journey_run.id journey_barrier_run_id_fkey C

{“what”:“UUID of the test run that detected this barrier.”,“why”:“Groups barriers by run for per-run analysis and comparison.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.209267595+00:00”}

step_index int4 10 null

{“what”:“Zero-based position of the journey step where barrier occurred.”,“why”:“Orders barriers within a run and maps to the specific step.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.226580786+00:00”}

wcag_sc text 2147483647 √ null

{“what”:“WCAG success criterion code (e.g., 1.1.1) related to the barrier.”,“why”:“Links barrier to the specific accessibility guideline for compliance reporting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.237521153+00:00”}

barrier_type text 2147483647 null

{“what”:“Category of barrier (e.g., missing alt, contrast).”,“why”:“Distinguishes barrier kinds for filtering and prioritization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.250498418+00:00”}

transcript_excerpt text 2147483647 √ null

{“what”:“Snippet of the spoken transcript around the barrier.”,“why”:“Provides context for manual review without opening full transcript.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.262377665+00:00”}

disability_group text 2147483647 'blind / screen-reader'::text

{“what”:“Target disability group (default ‘blind / screen-reader’).”,“why”:“Filters barriers by user group to tailor remediation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.274633472+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the barrier record was created.”,“why”:“Tracks when detection occurred for time-based analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.290008138+00:00”}

disposition text 2147483647 'site-barrier-suspected'::text

{“what”:“Current status (default ‘site-barrier-suspected’).”,“why”:“Tracks lifecycle state for triage and workflow.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.299683547+00:00”}

element_selector text 2147483647 √ null

{“what”:“CSS selector identifying the DOM element causing the barrier.”,“why”:“Allows automated re-location of the element for fixes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.323522317+00:00”}

ax_backend_node_id text 2147483647 √ null

{“what”:“Identifier of the node in the accessibility backend (e.g., axe-core).”,“why”:“Links to detailed accessibility tree data for deeper analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.334106953+00:00”}

bounding_box text 2147483647 √ null

{“what”:“Coordinates of the element’s bounding box (format unspecified).”,“why”:“Enables visual highlighting in screenshots or overlays.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.348041286+00:00”}

outer_html_excerpt text 2147483647 √ null

{“what”:“Snippet of the element’s outer HTML.”,“why”:“Provides raw markup for debugging and verification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.364529730+00:00”}

probe_result text 2147483647 √ null

{“what”:“Output from a probe test (e.g., success/failure).”,“why”:“Records the specific probe outcome for the barrier.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.381968462+00:00”}

confidence text 2147483647 'low'::text

{“what”:“Confidence level of detection (default ‘low’).”,“why”:“Prioritizes review effort based on detection certainty.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.396206647+00:00”}

captured bool 1 true

{“what”:“Whether the barrier was captured in the current run (default true).”,“why”:“Distinguishes captured vs. inferred barriers for accuracy.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.420083265+00:00”}

audit_result text 2147483647 √ null

{“what”:“Result of an audit step (e.g., pass/fail).”,“why”:“Records audit outcome for the barrier to guide next actions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.436173957+00:00”}

retry_attempts text 2147483647 √ null

{“what”:“Number of retry attempts (as text).”,“why”:“Indicates reliability of detection and potential flakiness.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.454070812+00:00”}

adarhythm_audit text 2147483647 √ null

{“what”:“Audit data from the Adarhythm tool.”,“why”:“Integrates external audit results for cross-validation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.467236500+00:00”}

spoken_corroboration text 2147483647 √ null

{“what”:“Spoken confirmation from user or system.”,“why”:“Validates barrier via speech evidence.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.485467492+00:00”}

spoken_quality_json text 2147483647 √ null

{“what”:“JSON with quality metrics of spoken output.”,“why”:“Stores structured quality data for analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.501315746+00:00”}

spoken_stats_json text 2147483647 √ null

{“what”:“JSON with statistics of spoken output.”,“why”:“Stores quantitative speech stats for performance tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:33.517720767+00:00”}

Indexes

Constraint Name Type Sort Column(s)
journey_barrier_pkey Primary key Asc id
idx_barrier_disposition Performance Asc disposition
idx_barrier_run Performance Asc run_id

Check Constraints

Constraint Name Constraint
journey_barrier_disposition_check (disposition = ANY (ARRAY['agent-navigation-error'::text, 'agent-model-error'::text, 'site-barrier-confirmed'::text, 'site-barrier-suspected'::text, 'ambiguous'::text]))
journey_barrier_confidence_check (confidence = ANY (ARRAY['high'::text, 'medium'::text, 'low'::text]))

Relationships