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 |
|
|
{“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 |