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 |
|
|
{“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])) |