axe_runs


Description

{“what”:“A record of an axe accessibility audit run for a specific input, mode, and WCAG tag set.”,“why”:“Without it, there is no history of accessibility audit results to compare or debug.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:02.893710078+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
input_hash text 2147483647 null

{“what”:“Hash of the input content that was audited; the unique identifier for that input.”,“why”:“Without it, audit results cannot be tied to a specific input, so comparisons across runs are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:02.957721677+00:00”}

mode text 2147483647 null

{“what”:“Audit mode such as ‘desktop’ or ‘mobile’ that affects which rules are applied.”,“why”:“Without it, runs with different modes would be conflated, hiding mode-specific failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:02.979844831+00:00”}

wcag_tags _text 2147483647 null

{“what”:“List of WCAG tag identifiers (e.g., ‘wcag2a’, ‘wcag21aa’) that define the rule set for this run.”,“why”:“Without it, runs with different rule sets would be indistinguishable, so pass/fail counts would be misleading.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:03.011668828+00:00”}

raw jsonb 2147483647 null

{“what”:“Full JSON output from the axe engine, including all violation details and node data.”,“why”:“Without it, you lose the detailed violation context needed to fix issues or debug rule mismatches.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:03.033402596+00:00”}

passes int4 10 0

{“what”:“Number of successful checks in this run; integer, defaults to 0.”,“why”:“Without it, you cannot quickly gauge overall accessibility health without parsing raw JSON.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:03.054311561+00:00”}

axe_version text 2147483647 null
axe_versions.axe_version Implied Constraint R

{“what”:“Version string of the axe library used (e.g., ‘4.4.1’); identifies the rule set.”,“why”:“Without it, results from different axe versions cannot be compared fairly, as rules change between versions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:03.073863715+00:00”}

source_service text 2147483647 √ null

{“what”:“Name of the service that triggered the run (e.g., ‘ci’, ‘cron’); optional provenance.”,“why”:“Without it, you cannot trace which pipeline or user initiated the run, making audit origin unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:03.091871270+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp (with time zone) when the run was recorded; defaults to current time.”,“why”:“Without it, you cannot order runs or know when an audit occurred, so time-based analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:03.107182400+00:00”}

Indexes

Constraint Name Type Sort Column(s)
axe_runs_pkey Primary key Asc/Asc/Asc input_hash + mode + wcag_tags

Relationships