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