image_asset


Description

{“what”:“Each row is one unique image content, identified by its SHA-256 hash.”,“why”:“Provides a single source of truth for image metadata, enabling alt-text coverage audits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:53.677611483+00:00”}

Columns

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

{“what”:“SHA-256 hash of the image bytes; primary key.”,“why”:“Uniquely identifies image content, preventing duplicate rows for identical images.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:53.692985039+00:00”}

domain text 2147483647 null
domain_brief.domain Implied Constraint R

{“what”:“Hostname of the site where the image was found.”,“why”:“Enables per-domain analysis of alt-text compliance and image sourcing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:53.719571820+00:00”}

url text 2147483647 √ null

{“what”:“Full HTTP(S) URL pointing to the image file.”,“why”:“Allows fetching the image for verification or re-processing; nullable when URL is unavailable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:53.822247331+00:00”}

alt_text text 2147483647 √ null

{“what”:“Accessibility text describing the image content.”,“why”:“Provides screen-reader description; missing when null, which is the core accessibility gap.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:53.846464164+00:00”}

alt_source text 2147483647 √ null

{“what”:“Origin of alt_text, e.g., ‘manual’, ‘generated’, or ‘page’.”,“why”:“Indicates reliability of alt text; without it, trust in alt_text quality is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:53.862610503+00:00”}

has_alt bool 1 false

{“what”:“Boolean flag true when alt_text is non-empty.”,“why”:“Enables fast filtering of images lacking alt text without null checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:53.881011666+00:00”}

Indexes

Constraint Name Type Sort Column(s)
image_asset_pkey Primary key Asc image_sha
idx_image_asset_domain Performance Asc domain

Relationships