Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| axe_version | text | 2147483647 | null |
|
|
{“what”:“Version string like ‘4.4.0’ that uniquely identifies a release.”,“why”:“Without it, releases cannot be uniquely identified or referenced by other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:15.061989924+00:00”} |
||||||||
| sha256 | text | 2147483647 | √ | null |
|
|
{“what”:“SHA-256 hash of the release artifact, hex-encoded.”,“why”:“Without it, artifact integrity cannot be verified after download.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:15.081819916+00:00”} |
|||||||
| promoted_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with time zone) when the version was promoted to current.”,“why”:“Without it, there is no record of when a version became current, so audit and rollback decisions lose context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:15.095522947+00:00”} |
||||||||
| is_current | bool | 1 | false |
|
|
{“what”:“Flag indicating whether this version is the currently promoted one.”,“why”:“Without it, the active version is ambiguous, and consumers cannot know which version to use.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:15.112640441+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| axe_versions_pkey | Primary key | Asc | axe_version |