sitemap_reachability


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

Relationships