Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“Unique UUID for each check record.”,“why”:“Enables referencing, updating, or deleting a specific check without ambiguity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.699858771+00:00”} |
||
| domain | text | 2147483647 | null |
|
|
{“what”:“Website domain (e.g., example.com) the check belongs to.”,“why”:“Separates checks per site; without it, records from different domains mix.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.721946951+00:00”} |
||
| sitemap_page_id | int8 | 19 | √ | null |
|
|
{“what”:“Bigint ID of the page in the sitemap, if any.”,“why”:“Links back to the sitemap entry; null if page not from sitemap.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.744192557+00:00”} |
|
| url | text | 2147483647 | null |
|
|
{“what”:“Full URL of the checked page.”,“why”:“Identifies the page; without it, cannot know which page the check refers to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.754521938+00:00”} |
||
| page_type | text | 2147483647 | √ | null |
|
|
{“what”:“Page category (e.g., product, article) as classified.”,“why”:“Allows filtering checks by page type; null if unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.816614691+00:00”} |
|
| reachable | bool | 1 | √ | null |
|
|
{“what”:“Boolean: whether the page returned a successful HTTP response.”,“why”:“Indicates broken links; null if not checked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.836330041+00:00”} |
|
| operable | bool | 1 | √ | null |
|
|
{“what”:“Boolean: whether the page is functional beyond reachability (e.g., no JS errors).”,“why”:“Distinguishes reachable but broken pages; null if not evaluated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.854298044+00:00”} |
|
| bucket | text | 2147483647 | null |
|
|
{“what”:“Grouping label for the check (e.g., ‘critical’, ‘warning’).”,“why”:“Enables prioritization of fixes; without it, no severity grouping.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.886367467+00:00”} |
||
| a11y_score | int4 | 10 | √ | null |
|
|
{“what”:“Accessibility score (0-100) from automated audit.”,“why”:“Quantifies accessibility level; null if not audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.901691289+00:00”} |
|
| unlabeled_count | int4 | 10 | √ | null |
|
|
{“what”:“Number of form fields or images missing labels.”,“why”:“Indicates specific accessibility issue; null if not counted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.913434377+00:00”} |
|
| barrier | text | 2147483647 | √ | null |
|
|
{“what”:“Description of the main accessibility barrier found.”,“why”:“Provides actionable detail; null if none.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.935370292+00:00”} |
|
| checked_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the check was performed (timezone-aware).”,“why”:“Tracks freshness; without it, cannot know if data is stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:47.948690451+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| sitemap_reachability_pkey | Primary key | Asc | id |
| sitemap_reachability_domain_url_key | Must be unique | Asc/Asc | domain + url |